- October 31, 2012 at 9:41 pm #1289
I am trying to add a very extensive list of data into the List under the Account Resources. The only way I have found is to copy and paste the information, add commas where needed, and hit enter after every item. I now there is an import function but every time I use this feature it will have one enter with the first caption and the value is set as the rest of the data list. The data I have has the caption in column 1 and the value in column 2, the file is a CSV, comma separated. Please help so I do not have to enter in over 200 items by hand!November 1, 2012 at 4:26 pm #6291
Dennis @ PerfectFormsBlocked
I just ran another test and confirmed that it does work as expected. I think your source file is not properly saved as a comma delimited CSV. If you are using Excel do a “save as” and choose CSV (Comma Delimited). Save the file as filename.csv. Excel will then give you two separate warning messages because a CSV doesn’t have full functionality in Excel. Acknowledge them but keep the type as CSV. You should then be able to import the file as a list.November 2, 2012 at 4:32 pm #6292
I found out the issue was partly due to the fact that I am using a Mac and you have to save the CSV file in the windows version. After discovering that I was able to get the import to work. Thank you for your help!
You must be logged in to reply to this topic.