# Insert Null value into index column error

**URL:** <https://forum.inductiveautomation.com/t/insert-null-value-into-index-column-error/4251>\
**Category:** Ignition\
**Created:** [April 5, 2012, 2:03pm UTC](https://forum.inductiveautomation.com/t/insert-null-value-into-index-column-error/4251 "2012-04-05T14:03:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MiddleC](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MiddleC](https://forum.inductiveautomation.com/u/MiddleC)\
**Post date:** [April 5, 2012, 2:03pm UTC](https://forum.inductiveautomation.com/t/insert-null-value-into-index-column-error/4251/1 "2012-04-05T14:03:07Z")

</div>

Copied table using sql import/export wizard. Then modified column names as well as index column name.

I then started a new transaction group hoping to insert records beginning at last record of imported table.

But when triggered I recieved error that null value can’t be inserted into index column.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 5, 2012, 3:34pm UTC](https://forum.inductiveautomation.com/t/insert-null-value-into-index-column-error/4251/2 "2012-04-05T15:34:27Z")

</div>

You have to make sure the index column is set to auto-increment or uncheck the “Use custom index column” on the Action tab.

---

<div class="post-metadata">

**Author:** ![MiddleC](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MiddleC](https://forum.inductiveautomation.com/u/MiddleC)\
**Post date:** [April 5, 2012, 3:53pm UTC](https://forum.inductiveautomation.com/t/insert-null-value-into-index-column-error/4251/3 "2012-04-05T15:53:55Z")

</div>

The use custom index box is unchecked. I’ll look into the auto-increment suggestion.