-
Notifications
You must be signed in to change notification settings - Fork 1
excel2airtable.py
This page details how to run excel2airtable.py
To upload every row of every sheet, use
python excel2airtable.py -i /path/to/excel.xslx
To upload a single sheet, in this case Physical Assets, use
python excel2airtable.py -i /path/to/excel.xlsx --sheet "Physical Assets"
To upload a single row of a single sheet, in this case row 8, use
python excel2airtable.py -i /path/to/excel.xlsx --sheet Assets-Unit-Provided-template --row 8
To run without validation of the required fields in the sheet, use
python excel2airtable.py -i /path/to/excel.py --sheet "Digital Assets" --no_validation
This error occurs because a cell value is mapped to linked field and that field itself is from a syncd table. For various reasons, we're not creating those records automatically, so you'll need to look at the specifics of the error to determine the value to add to which table in which syncd base.
If you use the --row option but the row doesn't have any values, or it's out of range of the sheet, this is the error you'll get
If you try to upload a record with a value in a single or multi-select field, and that value isn't in the list of approved values (e.g. 'A/D instead of 'A-D Transfer') - this is the error you'll get