plugin:struct:csvimport
This is an old revision of the document!
Struct Plugin: CSV Import
The Schema Editor has a Import/Export tab offering support for importing raw data into a schema (either page or lookup) using a CSV file. Some general rules:
- The first row has to contain headers matching the field names of the lookup schema you're importing into
- Columns with headers not matching any field name are ignored
- Only commas are supported as separator
- Column contents should be enclosed with double quotes
- Double quotes can be escaped with a backslash (
\
) or using standard doubling of the double quotes (""
) - For multi fields, the column content will be split at commas (no support for any escaping)
- Content has to be in UTF-8 encoding
Additionally in page schemas import:
- The column labeled 'pid' must exist. It's used to bind the scheme data to a proper page.
- If the page with given 'pid' doesn't exists the entire row is omitted(with the proper error message) but the import continues.
- If there are many rows with identical pids only the first one is imported and the others are omitted with the proper error message.
In the lookup schema the imported data is added to whatever data is already stored.
In the page schema every imported row creates a new revision of the page.
You can use the CSV Export on the same tab to get an example CSV file.
plugin/struct/csvimport.1531119873.txt.gz · Last modified: 2018-07-09 09:04 by grosse