In this article, you will find helpful information on how to troubleshoot the issue of fields not importing values correctly into your Knack tables.
Check Your Matching: Columns to Fields
The initial step you should take is to verify whether you have correctly matched the appropriate fields for the columns during the import process, especially if some of your fields are not being imported.
Check Your Matching: Updating Existing Records
To update existing records, you must match one of the columns in your import file with one of the fields in your table. This allows the system to identify the specific record in your app that needs updating based on the rows in your import file.
When updating records using an import, it is essential to match on a unique field. Auto Increment fields are highly suitable for this purpose since they are always guaranteed to be unique.
However, various other field types can be configured to have the "Must be unique" setting.
Note: It is not advisable to match on a Person or Address field because they cannot be set to unique, which can lead to issues for users. We are actively working on improving this for those field types.
Fields Still Not Importing
If you have followed the steps above and are still experiencing issues with importing your fields correctly, we are more than happy to assist you in troubleshooting. We would require the following information to get started:
-
A link to the table where you are importing the file
-
A sample copy of the file you are importing
-
The estimated date and time of your last import
Please send this information to our support team via the chat widget in the Builder or by submitting this form, and we will gladly look into it for you!