Developer forum

Forum » CMS - Standard features » User import
Jonas Mersholm
Reply

I'm trying to import users into the mail management user group, but it fails. Do you see whats happening?

 

This is my CSV

"AccessUserUserName","AccessUserName","AccessUserEmail","AccessUserGroups","AccessUserType","AccessUserValidFrom","AccessUserValidTo"
"test","Jones","jonas@mersholm.dk","@258@@1262@@1257@","5","31-01-2014 10:00:00:000","31-12-2999 23:59:00:000"

 

And heres the error

 

Error reading CSV file: lol.csv. Check field delimiter, it must be the same as in the provider settings: ','. Error message: The CSV appears to be corrupt near record '0' field '0 at position '2'. Current raw data : '"""AccessUserUserName"",""AccessUserName"",""AccessUserEmail"",""AccessUserGroups"",""AccessUserType"",""AccessUserValidFrom"",""AccessUserValidTo""" """test"",""Jones"",""test@test.dk"",""@258@@1262@@1257@"",""5"",""31-01-2014 10:00:00:000"",""31-12-2999 23:59:00:000"""'.

 


Replies

 
Jonas Mersholm
Reply

Bump?

 
Mikkel Ricky
Reply

When I copy and paste your csv and put in an import file it works fine. Can you check if you have some weird (invisible) character at position 2 on the first line? Previously, I've seen files containg weird characters without anybody really knowing how they got there.

Best regards,
Mikkel

 
Jonas Mersholm
Reply

Will try next time i face this kind of problem. I resolved this by making a custom ashx helper, parsing the CSV and inserting through the UserManagement API.

 

You must be logged in to post in the forum