Importing

This page is part of the AgileBase documentation

agileBase allows data to be imported from CSV file in two ways. You'll need MANAGE privileges on the table you wish to import into. Select that table from the 'Tables' module and click the 'import' button in the toolbar to start.

• insert all new records
• update existing records

Inserting new records will create a new record in the database for every line in the CSV file. Updating existing records will attempt to match each line in the file with an existing record and update all field values from the CSV. This can be useful when merging in data from an external source, or exporting, altering with a third party system and re-importing. Another use can be updating one field based on another - you can export, update the fields as necessary and re-import.

Updating existing records is particularly useful when records in other tables depend on the data in the table being imported into, so you can't delete the data.

In either case, the CSV file must contain fields in the same order as they are in the table being imported into.

When updating records, a key field must be selected to match records up. This can be any field that has the 'unique' property set. Alternatively the internal agileBase rowID can be used. This field is included as the first field in any data export.