# Translation List

**URL:** <https://forum.inductiveautomation.com/t/translation-list/2489>\
**Category:** Ignition\
**Created:** [January 6, 2011, 8:22pm UTC](https://forum.inductiveautomation.com/t/translation-list/2489 "2011-01-06T20:22:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\
**Post date:** [January 6, 2011, 8:22pm UTC](https://forum.inductiveautomation.com/t/translation-list/2489/1 "2011-01-06T20:22:59Z")

</div>

Hello,

Today i noticed that when I use the translation list, the client don’t save this changes. In fact, the “Column Attributes Data” DataSet show the XML structure with my mapping list but the table doesn’t show the mapped data (shows the number values of data). If i open again the table customizer, the mapping list is empty despite the XML structure that i mention before.

For this project I’m using ORACLE DB and Ignitio 7.1.8.

Thanks in advance.

---

<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:** [January 6, 2011, 8:41pm UTC](https://forum.inductiveautomation.com/t/translation-list/2489/2 "2011-01-06T20:41:19Z")

</div>

Well, something must be wrong with the XML structure. Take a look at your console in the designer or client to see if any error messages pop up.

---

<div class="post-metadata">

**Author:** ![apimente](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/apimente/32/4030_2.png) [@apimente](https://forum.inductiveautomation.com/u/apimente)\
**Post date:** [January 6, 2011, 9:05pm UTC](https://forum.inductiveautomation.com/t/translation-list/2489/3 "2011-01-06T21:05:30Z")

</div>

There is nothing wrong with the XML because it was generated by the table customizer.

But i made a test with another SQL table but this time from MySQL. Then, the mapping works fine.

Maybe is something with the datatype (I’m using numeric in ORACLE and INTEGER in MySQL).

Greetings.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [January 13, 2011, 12:44am UTC](https://forum.inductiveautomation.com/t/translation-list/2489/4 "2011-01-13T00:44:52Z")

</div>

My guess is that it is a number translation list, but your number is being converted into a string in an unexpected way. For example, 1 becomes 1.00 or something like that. When you open the dataset in the dataset viewer on the table, what is the type of the column in question?

In general, we should probably have the translation list use the formatted version of any numeric column so the formatting is predictable.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [January 18, 2011, 12:44am UTC](https://forum.inductiveautomation.com/t/translation-list/2489/5 "2011-01-18T00:44:21Z")

</div>

This has been improved for 7.2.0