topic Re: Unable to change the Name column in Data logger in Kepware

Unable to change the Name column in Data logger

AnudeepYenduri — Mon, 17 Jun 2024 12:12:41 GMT

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"

Re: Unable to change the Name column in Data logger

SlidingDownhill — Mon, 17 Jun 2024 13:49:57 GMT

Disable the log group

Change as needed in 'Column Mapping'

Enable the log group

Re: Unable to change the Name column in Data logger

AnudeepYenduri — Tue, 18 Jun 2024 04:35:28 GMT

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

Re: Unable to change the Name column in Data logger

SlidingDownhill — Tue, 18 Jun 2024 13:53:43 GMT

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.

Re: Unable to change the Name column in Data logger

AA_13978059 — Wed, 17 Dec 2025 04:26:43 GMT

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