https://bugs.documentfoundation.org/show_bug.cgi?id=100368
Bug ID: 100368
Summary: modify import to allow bulk updates
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Right now Base allows to bulk import data into tables by the use of copy/paste
between Calc and Base.
This, however, limits to *adding* new records. It doesn't allow to *update*
records (if you try it, it would result in SQL errors, since you'll be trying
to INSERT records that already exists)
It would be nice to add options to the "import wizard" (the dialog that appears
when you paste data from Calc in some table) to allow the user to specify that
the data being imported shoud be treated as UPDATES, and make Base issue INSERT
or UPDATE (or INSERT... ON DUPLICATE UPDATE),etc. depending on the specific
Database backend.
Right now, the only workaround I've found to allow this (without the need to
delete/reimport all data in database, which can be undoable with lots of
data/relationships) is to define temporary tables to host the initial import of
the update data and combine it with SQL Tools -> update (or with a stored
procedure) in order to copy all that values to the destination -real- table.
This workaround, however, is not recommended for users not having specific
SQL/Database knowledge. The ideal solution would be to allow end-users
(business users, using only forms/predefined queries/reports) to be able to
perform those bulk updates independently in the same way bulk imports can be
done
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
