|
|
| (11 intermediate revisions by 2 users not shown) |
| Line 1: |
Line 1: |
| __TOC__
| | Data Migration And Sharing. |
| ==Add support for inserting CSV data into an existing table==
| |
| *Status: TODO
| |
| *{{wish|305505}}
| |
|
| |
|
| ===Rationale===
| | {{Note|TODO: Move content from [http://kexi-project. org/wiki/wikiview/[email protected]]}} |
| Inserting (or rather appending) CSV data into an existing table gives a simple means for merging CSV data chunks in one step.
| |
|
| |
|
| ===Assumptions & Requirements===
| | *[[/General/]] |
| *The data should be appended to the existing table, without changes made to the
| | *[[Kexi/Junior_Jobs#Migration|Junior Jobs]] |
| *Data is in largely the same format (regarding column or data types) as the data used to create the original table, to achieve this: | |
| **Data types for columns should be taken from the schema of the destination table | |
| **Column names stay untouched in the destination table, however autodetection should be still used to figure out value of the "First row contains column names" option; the option can be changed in the
| |
|
| |
|
| *Conflicts resolutions: | | ==File formats== |
| **Data type violations (for example when importing string when numeric value is expected): TODO - for 2.6 we need to have friendly error message at least | | *[[/CSV/]] |
| ***Future: propose skipping conflicting values | | *[[/MDB/]] |
| **Primary key violations: TODO - for 2.6 we need to have friendly error message at least | | *[[/ODB/]] |
| ***Future: propose skipping records with conflicting values or replacing the old records with new ones | | *[[/Spreadsheet/]] |
| **Future: unique key violations: TODO | | *[[/SQLite/]] |
| | *[[/Fixed Width Text/]] |
|
| |
|
| ===GUI Design=== | | ==Servers== |
| Existing GUI is based on single dialog. Switching to KAssistantDialog is needed.
| | *[[/MySQL/]] |
| | | *[[/PostgreSQL/]] |
| ==Porting to non-modal assistants==
| |
| *Status: TODO | |
| | |
| '''What is involved in porting to the new gui?''' <jstaniek>: We sit and design the given assistant and I am helping with using the API and possibly extending/fixing it. The difference is that many imports can be started concurrently so some extra checking may be needed but this is a side note. Also e.g. user could try to edit/remove a source table during export. So this is fun. But after the change the GUI would be a lot more natural I think.
| |
