# Import mapping

**URL:** <https://forums.knack.com/t/import-mapping/18546>\
**Category:** Get Answers\
**Created:** [January 13, 2025, 6:25pm UTC](https://forums.knack.com/t/import-mapping/18546 "2025-01-13T18:25:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/laurent/32/2855_2.png) [@Laurent](https://forums.knack.com/u/Laurent)\
**Post date:** [January 13, 2025, 6:25pm UTC](https://forums.knack.com/t/import-mapping/18546/1 "2025-01-13T18:25:28Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [January 13, 2025, 8:37pm UTC](https://forums.knack.com/t/import-mapping/18546/2 "2025-01-13T20:37:08Z")

</div>

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](https://learn.knack.com/article/ejdb2toq4i-import-records#importing_a_data_file_to_update_an_existing_table)

---

<div class="post-metadata">

**Author:** ![Laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/laurent/32/2855_2.png) [@Laurent](https://forums.knack.com/u/Laurent)\
**Post date:** [January 13, 2025, 9:39pm UTC](https://forums.knack.com/t/import-mapping/18546/3 "2025-01-13T21:39:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [January 13, 2025, 11:27pm UTC](https://forums.knack.com/t/import-mapping/18546/4 "2025-01-13T23:27:53Z")

</div>

Sorry, I only wanted to confirm your suspicion that you questioned. 🙂

If you haven’t already, you can [reach out to our support team](https://learn.knack.com/article/kb-tickets/new) 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. 🤔

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [January 14, 2025, 4:01am UTC](https://forums.knack.com/t/import-mapping/18546/5 "2025-01-14T04:01:03Z")

</div>

@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.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/2a77c2175c6e217ceb3ba886e3384181f38411bb.png)

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!

---

<div class="post-metadata">

**Author:** ![Laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/laurent/32/2855_2.png) [@Laurent](https://forums.knack.com/u/Laurent)\
**Post date:** [January 14, 2025, 1:53pm UTC](https://forums.knack.com/t/import-mapping/18546/6 "2025-01-14T13:53:25Z")

</div>

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.
