Yes this is possible. I will assume as you have a pick list you have created a validation object to store your options.
- Create a csv file with the option in you wish to upload.
- Use the data import tools to import your csv file against your validation object.
Here is a link to the data import help its really simple to setup.
Hi Thank you for the information and quick response, I got so far but ran into some issues. I had created the validation object and pick list and managed to upload the file following teh guid eyou attached but the items in the file are not linking up to the validation object. I had a phone call with IVANTI about this but still no wiser and still waiting for someone to get back to me after a week and numerous phone calls.
So the data imported is not showing in your validation table or pick list? Can you show me either your import wizard routine or the pick list configuration.
Sorry I am not very technical
But yes it isnt showing in my validation or pick list. I can see it in the validation list like below but when I choose it there is no data. I followed the routine to import a manual CSV file.
The file has shown as uploaded successfully.
Im not sure if it something to do with the mapping as I was confused what I would map this to so I just chose C4CTerritory which is the object I created. Do I need to do something else in the object for the mapping?