Unable to change the Name column in Data logger

[AnudeepYenduri]

In the data logger feature, by default "Name" column is being considered as "Item ID" making difficult in database. How can i change this to "Log item Name" instead of default "Item ID"

[SlidingDownhill]

Disable the log group

Change as needed in 'Column Mapping'

Enable the log group

[AnudeepYenduri]

Hey @SlidingDownhill Thanks for response

i am able to change the mappings, but in the place of Name i want Log item name instead of Item ID. So this is my requirement

[SlidingDownhill]

ItemID is a primary key and must remain unique (no duplicates) to each entry in the SQL database table

. 

I get the idea but I'm not sure exactly what you are asking here:

---

but in the place of Name i want Log item name instead of Item ID. So this is my requirement

---

Can you show a screenshot of the column mapping and the SQL table that results from it. Then show what you want changed.

[AA_13978059]

Hello @SlidingDownhill, I think I understand what @AnudeepYenduri meant.

It looks like the column name (the name field) is being populated/inserted with the ItemID value (from logItem) instead of the actual name (we want at logItem name). This makes the stored value unnecessarily long and difficult to work with. Please see the screenshot below.

I also included an example of the expected data format I want to store in the database (shown in the last image), which is much more concise.

Current Datalogger resultlogItem setting where data name column inserted in DB is taken from ItemID not Name.Setting of column mapping, where _Name (or Tagname) is taken from "ItemID" setting at logItem not "Name" identification at logItem.Expected result