04-09-2010 06:59 AM
I have created a new field and would like to import the drop down list data that I would like to attach to that field rather than type the 55 item list in or put the info in as I go. I did a search for the problem and saw several generic import postings but not this specific one. Have never had problem importing data before and have done a lot of contact data importing. Read the instructions about creating the csv or txt files but when I import nothing gets imported. I could be just stupidly missing something but am not clear. The instructions don't make clear what you should use for column headers in the file but someplace I saw a comment about calling the the main field you are importing "Value" so I used that at the top of my column in a tab delimited text file.
Any help appreciated. Let me know if I left out any info you need to help.
TIA
JTB
04-09-2010 07:39 AM
Importing a Drop Down List is done through the Tools > Define Fields > Manage Drop Down Lists option.
You can create a new list or edit an existing one > on the 2nd screen for editing the list is the option for Importing a file.
Although there are several file types you can import, if you have any trouble with your current file I recommend you save your file as a TXT format (copy and paste into a Notepad document) and surround your values with double quotes - then import the TXT file.
For example your values will appear in the file:
"value1"
"value2"
"value3"
04-09-2010 07:39 AM
Importing a Drop Down List is done through the Tools > Define Fields > Manage Drop Down Lists option.
You can create a new list or edit an existing one > on the 2nd screen for editing the list is the option for Importing a file.
Although there are several file types you can import, if you have any trouble with your current file I recommend you save your file as a TXT format (copy and paste into a Notepad document) and surround your values with double quotes - then import the TXT file.
For example your values will appear in the file:
"value1"
"value2"
"value3"
04-09-2010 08:50 AM - edited 04-09-2010 09:13 AM
PERFECT SOLUTION !! My text files that I saved from Excel "Save as" did not have the quotation marks in the file. I tried several ways but no deal. Saved into Notepad, put in the quotation marks and worked perfectly. Thanks much.
JTB