Bonjour
I’m having a small issue. I am trying to import a file (which I usually do without issues) except I cannot map to the proper field. The field I want to map to simply isn’t offered as an option.
I suspect that this may be because the field in question is an auto-increment, could that be the case?
(our client number# is set as auto-increment, and I’m trying to relate the imported data with the proper clients)
Hi @Laurent,
Yes, you are correct. The option to map to an auto-increment field is unavailable due to it being non-mutable: Importing into an Existing Table
Well ok but that doesn’t help me 
I don’t want to change the auto-increment field, just use it as a reference to change the other fields of that client.
Thank you anyway
Sorry, I only wanted to confirm your suspicion that you questioned. 
If you haven’t already, you can reach out to our support team and they will be happy to take a look at your table’s structure to provide you with a way to accomplish this. Without looking at your table’s structure, it can be a bit difficult to provide a solution.
Possible solution:
You could export all of the values from your auto-increment field, then add a short text/number field to the same table with those values to then use when mapping columns during importing. 
@Laurent, I think what you’re looking for is in step 3 of the importer.
Set Do you want to update existing X records to Yes, and then do the mapping for your auto inc. field here.
If you can’t see your auto inc. field in this step, then I’d reach out to support, because it should be available.
In the old importer, I think this step came before the rest of the field mappings, which is why its confusing.
Hope that’s what you meant!
Oh deer god you’re right. It was that easy. How have I never seen that before?
Thank you sir, and sorry for my trivial question.
