Community
Showing results for 
Search instead for 
Do you mean 
Reply

Import Drop-Down List Items Not Working

Tuned Listener
Posts: 113
Country: USA

Import Drop-Down List Items Not Working

Hello:
 
I'm trying to import drop-down list items, so I don't have to enter them manually.  I'm using the Define Fields/Lists Tasks/Import Drop-Down List Items.
 
I've tried using a Excel file and a text file.  In both cases, the descriptions are not included.  I click import, and nothing happens.  There are no error messages, the file is not imported, and the screen is not locked.
 
Any suggestions?
 
Thanks.
Nickel Contributor m4y
Nickel Contributor
Posts: 511
Country: Belgium

Re: Import Drop-Down List Items Not Working

[ Edited ]
Be sure that your text file is in this format:
"picklist1","desc1"
"picklist2","desc2"

Then, when you import, don't forget to check "Includes descriptions" after selecting your file.

Message Edited by m4y on 02-26-2008 11:33 PM

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }
Tuned Listener
Posts: 113
Country: USA

Re: Import Drop-Down List Items Not Working

As a follow up, I resaved the file in Excel, tried again, and this time received the message:
 
"Import failed.  Numeric fields can only accept numeric data."
 
In the data type field on the Define Fields form, "character" is selected.  I then changed the type in Excel from general to text, but the import failed again with the same message.
 
If I try a text import, nothing happens.  The import doesn't work, but no messages are displayed.
 
Thanks  for any suggestions..
Tuned Listener
Posts: 113
Country: USA

Re: Import Drop-Down List Items Not Working

Aaah, the fields have to be enclosed in quotes.  I didn't realize that.  Thanks for the tip.
Nickel Contributor m4y
Nickel Contributor
Posts: 511
Country: Belgium

Re: Import Drop-Down List Items Not Working



sunnydd wrote:
Aaah, the fields have to be enclosed in quotes. I didn't realize that. Thanks for the tip.



Yes, I've edited my post to be more readable than without carriage returns Smiley Wink

Xavier Nyssen

ACT! Certified Consultant @ Intuitis | Belgium
{ +32 64 45 08 00 | xavier@intuitis.be | http://intuitis.be }