Bug 154805 - TABLEIMPORT: Warning doesn't show enough information to find reason for error
Summary: TABLEIMPORT: Warning doesn't show enough information to find reason for error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.5.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
 
Reported: 2023-04-14 08:59 UTC by Robert Großkopf
Modified: 2024-12-20 06:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot with waringing in HSQLDB and Firebird (54.43 KB, application/pdf)
2023-04-14 08:59 UTC, Robert Großkopf
Details
Databases and Calc-file to try the import and see the error message (15.63 KB, application/zip)
2023-04-14 09:04 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2023-04-14 08:59:09 UTC
Created attachment 186655 [details]
Screenshot with waringing in HSQLDB and Firebird

Have a look at the attached screenshot.
I have tried to import a Calc-table into HSQLDB and Firebird.
One field in Calc table contains too much characters for importing into the database.
Error in HSQLDB only says: "Value too long"
Error in Firebird says: "Field could only save 20 characters, you try to import 27 characters."

No Problem in a table like attached in second attachment. There are only 2 fields. But had a table with more than 80 fields…

It would be better to inform also about the field name, which will throw this error. For normal users this warning is filled with too much informations he/she doesn't know anything about.
Have a look at this thread: https://ask.libreoffice.org/t/problems-after-appending-data-into-tables/90225

Better: Add a button "Details", as it is added also in other places of the database, to see this detailed information. Give a clear information about the field, which is too long, and how long this field has to be for save the data.
Comment 1 Robert Großkopf 2023-04-14 09:04:00 UTC
Created attachment 186656 [details]
Databases and Calc-file to try the import and see the error message
Comment 2 Buovjaga 2023-04-19 14:22:41 UTC
Setting to NEW as this is based on an AskLibO topic by another person