Problem Definition
The new CSV Importer on Confluence Databases will create new columns to allow for comparing imported data side-by-side.
Currently it is not possible to append newly imported data into existing columns, which adds manual labor.
Suggested Solution
Add an option from the CSV Importer dialogue to add new data either side-by-side or append to existing columns.
Example
Existing Database:
| Text field | Tag field | User field |
|---|---|---|
| Value 1 | Value 2 | Value 3 |
CSV file being imported:
| Text field | Tag field | User field |
|---|---|---|
| Value 4 | Value 5 | Value 6 |
Result after "side-by-side" Import (current behavior):
| Text field | Tag field | User field | Text field 1 | Tag field 1 | User field 1 |
|---|---|---|---|---|---|
| Value 1 | Value 2 | Value 3 | |||
| Value 4 | Value 5 | Value 6 |
Result after Append Import (Suggested):
| Text field | Tag field | User field |
|---|---|---|
| Value 1 | Value 2 | Value 3 |
| Value 4 | Value 5 | Value 6 |
Screenshots:
Workaround
Manually adjust the imported data:
- Review the imported data
- Manually Cut or Copy the imported data
- Paste it in the desired location
- Delete the new columns
