I am trying to import user records that may have a cell that contains multiple items or descriptions. As an example, the user may have Books, CDs, Tapes and MP3s. These are all listed in one cell of the Excel CSV file and I have attempted to separate them with commas, Pipe, spaces and quotation marks. Each delimiter type is set up in a separate Excel file and after attempting to import each type, all of them give me the same results

When I set the Field property Widget to Text Field, Rows:1 ,then run the import, all of the descriptions actually do show up on one line in the User Edit Profile tab, but with the delimiters showing like this:

Books,CDs,Tapes,MP3s
Books|CDs|Tapes|MP3s
"Books"|"CDs"|"Tapes"|"MP3s"

But when I go into the Profile, the items do not show up on the user record.

When I change the Field property Widget to Text Field, Rows:4, then run the import, all of the items again show up with the delimiters showing.. still on one line, with blank boxes below it. I can then enter each item manually, submit, and the items then do show in the profile...and a listing of one item per line is exactly what I want. But I do not want to manually enter the records for hundreds of users.

Changing the Field property Widget to Select List, and populating the Allowed Values List, then importing, results in none of the items showing in the User Edit tab and an error message telling me that the values are not recognized.

So it looks like the data gets imported when I use the Text Field setting...but I can not get it to display properly on separate lines in the Profile.

I have installed the latest version of the module, and have run the php update as well as cron after importing.

Any suggestions?

Comments

robert castelo’s picture

Status: Active » Postponed (maintainer needs more info)

Are you importing into a Profile module 'freeform list' or 'list selection' field, or is it a NodeProfile field set to 'Select list'?

jtAx’s picture

Robert..

Thanks for the reply. Just by your asking the question I remembered that I actually did set up the field in Profiles and also in categories. By clearing out the set up in Categories, the problem was resolved.

Thanks!

robert castelo’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)