#392 - Better CSV import
-
By Chris Graham
- Added
- 9 views
| Identifier | #392 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Better CSV import |
| Status | Completed |
| Handling member | Chris Graham |
| Addon | catalogues |
| Description | Selection of 'Key' field on import screen.
Matched entries as handled as *edits* rather than *adds*. Option on import screen to *delete* unmatched entries. |
| Steps to reproduce | |
| Additional information | Asks 4 questions...
What is your key field? What would you like to do with entries in the CSV file that aren't in the catalogue? Add [the default] Skip What would you like to do with entries in the catalogue that aren't in the CSV file? Delete Leave alone [the default] What would you like to do with entries that are in the CSV file and already in the catalogue? Overwrite all fields even if blank/missing in the CSV [the default] Overwrite only fields which aren't blank/missing in the CSV [the default] Skip Delete |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
CSV import: Meta keywords may be filled if we choose which field to use and make an import with new records
CSV import: If specified keywords field does not exist in CSV, error given
CSV import: Meta description may be filled if we choose which field to use and make an import with new records
CSV import: If specified meta description field does not exist in CSV, error given
CSV import: Notes may be filled if we choose which field to use and make an import with new records
CSV import: If specified notes field does not exist in CSV, error given
CSV import: Imports all records if no meta keywords, no meta description, no notes, no key field given
CSV import: The 'allow comments' setting transfers over correctly if ticked (checked)
CSV import: The 'allow comments' setting transfers over correctly if not ticked (checked)
CSV import: Key-specific settings are locked unless a key field is entered
CSV import: If specified key field does not exist in CSV, error given
CSV import: Exporting a CSV from a catalogue then reimporting, with the ID field as 'ID', makes no change to the number of entries in the catalogue
CSV import: With the key field set to 'ID' and 'Handling of new records' set to 'Skip', a blank catalogue will stay blank
CSV import: With the key field set to 'ID' and 'Handling of new records' set to 'Add', the number of records in a blank catalogue will then be equal to one less than the number of rows in the CSV
CSV import: With the key field set to 'ID' and 'Handling of unmatched existing records' set to 'Leave alone', an empty CSV imported into a non-blank catalogue will make no change to the contents of the catalogue
CSV import: With the key field set to 'ID' and 'Handling of unmatched existing records' set to 'Delete', an empty CSV imported into a non-blank catalogue will erase the contents of the catalogue
CSV import: With the key field set to 'ID' and 'Handing of matched records' set to 'Skip', an imported exported CSV with a column blanked out, will result in no changes
CSV import: With the key field set to 'ID' and 'Handing of matched records' set to 'Overwrite only fields which aren't blank/missing in the CSV', an imported exported CSV with a column blanked out, will result in no changes
CSV import: With the key field set to 'ID' and 'Handing of matched records' set to 'Delete', an imported exported CSV, will result in an empty catalogue
CSV import: the key field set to some non-ID column title, a CSV will import correctly binding according to that as a key field