D-list item renames

[Pedro]

Hello

I have about 30 d-lists which link to a single excel spreadsheet via an ODBC link. Adding / deleting d-list items works fine (via a macro which runs a sequence of d-list updates) but if I rename an item in the s/sheet I have to go into each affected d-list and manually rename them otherwise Analyst regards this as a deletion and addition (this then deletes all history assigned to that item).

Any help would be much appreciated it's driving me mad!

P

[Pawel]

I presume you have set import options to update and remove obsolete.
If you just rename the item on the spreadsheet to something completely different CP won't know it is a new name for an existing item, it will thus delete the old one (no more present in the source) and enter the "new", i.e. amended item.
The only way you could change a name would be to use unique names settings (if the old and new item names share a common code, index, etc...)

hope it helps.

[Pedro]

Thanks for taking the time to respond Ludi

This works great. Much appreciated.

P