cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Picklist changing based on a CSV import?

Highlighted
Regular Member

Picklist changing based on a CSV import?

If we use the CSV loader to import a picklist field and the value doesn't match one of the existing picklist options, it is automatically creating new options. I'd like to prevent this from happening. Anyone else experience this and is there a way to set the editability so that it does not happen but still allows users to choose from the existing options?

Thank you,

Adrian

2 REPLIES 2

Re: Picklist changing based on a CSV import?

I think I found the answer to my question. I found some documentation on the CSV loader in this discussion forum (thank you Kael) and it includes the following note:

NOTE:  User and Pick Field Lists are automatically updated, if the data contains a missing user and/or pick value respectively!  However this feature does not work if the user does not have ‘Admin’ permissions or if the server is locked by a Staging Server.

I confirmed that this issue does not occur on our locked production server so that is the most important.

Highlighted

Re: Picklist changing based on a CSV import?

you can  control the source documents  by not allowing users to add new items to the pick list in Excel.  I lock the source templates so only a small group of Integrity admins can alter the source documents columns and lists.  The users  request the addition of a new pick list item or field from the admin. 

Announcements