Description
Our import job currently does not change database structure, it does not create missing tables/fields, it only transfers rows. Export job creates missing sheets/fields(headers) in Excel file/Google spreadsheet, but import job does not.
To transfer new tables/fields to the database, you can use interactive "Data Extraction Wizard" if you have the proper data layout (i.e. the first row is the fields names, as described in Data layout section)
- Save database before running the wizard
- Select your data source and click on "Data extraction wizard"
- Click on "Read data", review the result, edit names/types if needed and click on "Import"
- Close the wizard and review the results under "Database" or "Configuration" tab to make sure tables/fields were properly created. Save database if modifications were correctly applied or revert the changes (by pressing on "Reload" button in the top left) if something went wrong.
What to read next: