Here you can import data into JEM tables.
Here you can import data into JEM tables.
Tip
First make an export of the desired table in JEM (using the 'Export Data' function in the Main menu). Then use this table layout as a reference by opening the exported CSV in a spreadsheet program.
To access this screen use: Components → JEM → Import Data
CSV-Import: Choose this tab, to import CSV files.
Attention
The order in which you import data in JEM is relevant for its correct working. Advised and tested is: First Venues, then Categories, then Events and then last Cat_Events.
Choose CSV file: Click the file button to choose a local file to import.
Replace if ID exists (otherwise create): Choose yes if you want to overwrite events with already existing IDs want. When no, every event is recreated with a new ID.
Import Events: With this button you can import Events from a CSV-formatted file. Please make sure you have prepared the file according the JEM file format (see info under 'Export Data').
Import Categories: With this button you can import Categories from a CSV-formatted file. Please make sure you have prepared the file according the JEM file format (see info under 'Export Data').
Import Venues: With this button you can import Venues from a CSV-formatted file. Please make sure you have prepared the file according the JEM file format (see info under 'Export Data').
Import Cat_Events: With this button you can import Cat_Events from a CSV-formatted file. Please make sure you have prepared the file according the JEM file format (see info under 'Export Data').
External CSV, JSON, XML, ICS and XLSX sources are validated before import. Text sources may contain up to 10 MiB and an import may contain up to 10,000 records and 512 fields per record. Structured formats also have fixed depth and node limits. Files exceeding a limit are rejected completely and are not truncated.
Large event, venue and Special Days previews show 100 records per page. The remaining validated records are stored temporarily in private, user-bound files and are processed in batches when the import is confirmed. The preview notice reports the visible page and complete record count. Temporary data is removed after import or cancellation and expires automatically.