Hello.

I'm trying to import a 300 users database with custom profile fields, but those fields are stored in the database as s:(number):"value";

User Import only insert in these field de "value", but not the s:x" "; so the import is not working !! Nothing appear in the profile fields !!!

I have tried to add the s:2:" and the closing "; but only a few fields are visible that way, not all of them, and it seems to be a random behaivour... (What are these numbers?)

Please, help !!

Comments

underwearninja’s picture

underwearninja commented

This sounds like it may be an issue with the format of your .csv file. Various spreadsheet programs handle quoted data differently. Excel is what I'm most familiar with, so that will be my example. Your data has quotes, and excel escapes those quotes by using triple quotes.

So your data in excel looks like:
"""s:(number):"value";"""

Which is probably freaking out the module. As a work around, perhaps you can replace the " in your data with something else?

platypus media’s picture

platypus media commented

I had this issue with importing dates for profiles. It's tricky, but it works if you carefully map your fields in a formula for excel. I had 3 separate fields for my date- day, month, and year, and I concatenated them into a serialized string. It should look something like this as an end result for the date 1/1/1980: 

a:3:{s:5:"month";s:1:"1";s:3:"day";s:1:"1";s:4:"year";s:4:"1980";}

Just be careful for two digit days and months. That would look something like this for the date 10/20/1980:

a:3:{s:5:"month";s:2:"10";s:3:"day";s:2:"20";s:4:"year";s:4:"1980";}

Mike

robert castelo’s picture

robert castelo commented
Status: Active » Closed (won't fix)