CSV Import unable to import to synced table, even when no new records would be created

[Alyssa_Buchthal]

I'm attempting to make a csv import into a synced table. I've curated the data to import and I'm 100% sure that it would only be updating existing records, not creating any new ones, but as soon as I set up the field to map by, I get this:

Like I said, I have 100% verified that no records would be created with this import, I am 100% confident, yet this still pops up. Is this just a built-in constraint disallowing imports to synced tables, or is there something I can toggle to allow it?

If push comes to shove I can create a helper table, import the data, then use automations/linking to get the data from the helper table into the synced table, that just seems like such a pain in the butt for what could be a simple import.

[Pascal_Gallais-]

Hello Alyssa,

It seems that Enterprise plan is required to edit a sync table:

Nevertheless, I have a naive question: why don't you import the data in to the source table an let synchronisation do the job?

Regards,

Pascal

[Alyssa_Buchthal]

We have enterprise, so that isn't the issue here.

As for your question, some of the fields we want to import to only exist in the destination table, so we aren't able to import to the source for them.

[Pascal_Gallais-]

Hello Alyssa,

I just did the test:

- I synced a table A into table B

- I added a "new info" field into table B with no values

- I exported table B view into a csv file that I modified to insert values in field "new info"

- I used the "CSV import" extension using the "merge with existing records" option to import the modified CSV

It worked fine, all fields in table B have been updated and no new records were created.

Then, I modified the csv file by adding a new row that does not exists in Table B and I did get the same error message that you get when trying to import it.

regards,

Pascal

[Alexswerdlow]

Hey! I've had this same exact issue. I am thinking it's an issue with the extension. We also use an Enterprise Plan, so that's not the constraint. Here's a link to the post: https://community.airtable.com/t5/base-design/import-csv-extension-doesn-t-work-on-synced-base/td-p/...

[laurenCTCL]

I was having this same issue but I believe I figured it out! My primary field in both the synced base and the CSV I'm importing is state name. I figured that the values in both were identical because there's a fixed name and number of states 🙂 However, Washington, D.C. was written differently in the CSV than in the base, so the importer thought I was trying to make a new record. I copied the values from the base into my CSV and was able to import.