Below are some of the common issues you may encounter when Bulk Importing Database Records, or Bulk Updating Database Records.
Drop-down selections mapping
Example: You have a Region field in your Database with a drop-down selection of Australian States and Territories: VIC, NSW, TAS, ACT, etc.
In your spreadsheet however you have this information filled in for every record however you have listed them 'Victoria', 'New South Wales', 'Tasmania', etc.
This info will not map to the database because it does not exactly match the pre-set drop-down options for that field.
Ensure that when you have drop-down selections that the info you import matches these options exactly to avoid this error.
Example: You have free-text State field in your database and have set the character limit for '3' for this field, such as 'VIC'.
If importing a record which has spelled out the full State, such as 'Victoria', this will however result in an error as it is over the character limit.
To resolve, relax the character limits against that field and ensure that these limits are not set up unless you really require them.
If your database has specific fax and/or phone fields, note that these will only allow numbers to be entered against them.
Example: If you are importing records with any letters (such as "Ph: 03 8618-7800") this will result in an error.
To fix this change the fax/phone field type to a general text field to allow both numbers and letters, and retry your import.
Invalid date format
For Date fields, please make sure that they are in the default Date format set on your platform (you may need to check with your Administrator what the default is):
Records with the same name
If you have records with the same main name info keep in mind that when importing in bulk the system does not know which record to map the other record info against.
To resolve this, some editing might need to be made to 'Name' information of your records to make sure they are different, then retry your import attempt. Alternatively, switch to a Title field that will be unique for each record in the Form Builder.
When re-importing existing records, export the data first, and then map to the UUID column, which is always unique for each record.
Use of commas in multi-select field values
When importing into a select field that allows for multiple values (such as a 'Multiple Select Dropdown' or a 'Select - Checkbox / Checkbox Group' field) it is advised to ensue that the values for these fields do not include any commas (",").
This is because the import processing will look to a comma a delineation point for splitting up multiple values. This is useful when wanting to import multiple values at once (where no commas exist in those values) such as this example field:
Having a spreadsheet field formatted using commas to separate these values allows for more than one to be added at once (assuming the field has been configured to allow for multi values):
Because the system will try to parse these separate values from the inclusion of a comma, it can cause issues where commas may exist in the values themselves. For example it will think the value "This is some text before a comma, this is text after a comma" are two values it is trying to match against, not one.
It is therefore recommended not to include commas in values for these fields if importing will likely occur for this database, or to use alternative characters to break up a sentence/text instead (see last example below):
You will need to ensure that the values in the spreadsheet match the values in the field exactly for the import to be successful.
Please sign in to leave a comment.