Check Your Matching: Columns to Fields
The first thing you want to check if some of your fields aren't importing is whether you're matching the right fields for those columns when importing.
For example, in the import below you'll see that the Colors column in the import file was incorrectly matched to the Cost field within the object when first uploaded:
That can be fixed by selecting the correct field from the options list next to "Map to" for that column.
So review your import at this step in the process to ensure that all the columns are matched up with the correct fields.
Check Your Matching: Multiple Columns to One Field
You also need to make sure that you don't have multiple columns in your file being matched to the same field. Otherwise, the data in the last column matched to a field will overwrite any of the data imported from previous columns in your file.
For example, in the import below both the Quantity and Cost columns in the import file were matched to the Quantity field in the object:
If the import continued with these settings, the values in the Quantity column would be imported first into the Quantity field. Then the values in the Cost column would be imported in the Quantity field overwriting the values that were imported before.
So review your import at this step in the process to ensure that none of the columns are matched to the same field.
Check Your Matching: Updating Existing Records
When updating existing records, you need to match one of the columns in your import file to one of the fields in your object. That's how the system knows which record in your app to update based on the rows in your import file.
You need to match on a unique field when updating records using an import. Auto Increment fields are perfect for matching because they are always unique, though there are several field types that can be set to "Must be unique":
Note: We don’t recommend matching on a Name or Address field because they can’t be set to unique and we’ve seen users run into issues with them. We’re working on improving this for those field types.
Fields Still Not Importing
If you went through the items above and your fields still aren't being imported correctly, then we are happy to help troubleshoot this for you! To get started we will need the following information:
- A link to the object where you're importing the file
- A sample copy of the file you're importing
- The estimated date/time of your last import