Page 1 of 1
Import failed
Posted:
April 24th, 2011, 1:18 pmby sixagency
Hi,
I tried to import a list of members in a csv file, it says import successful but no user has been added.
I exported the list to use the same csv file. am I doing something wrong?
Re: Import failed
Posted:
April 24th, 2011, 2:32 pmby Cristián Lávaque
Are you using s2Member Pro's import feature?
Did you format the CSV to import the proper way? Here's the documentation WP Admin -> s2Member -> Import/Export -> Import.
Let me know if that helps.
Re: Import failed
Posted:
April 24th, 2011, 2:46 pmby sixagency
Yes, I am using s2Member Pro, and used the same document I exported, just added a new test member and deleted the existing data on the form (I kept the header) and saved it as CSV.
Did I miss something?
Re: Import failed
Posted:
April 24th, 2011, 3:09 pmby Cristián Lávaque
No, you seem to have done fine. And the new user you imported doesn't show up in WP Admin -> Users?
Re: Import failed
Posted:
April 24th, 2011, 3:18 pmby sixagency
No it dosnt, it's says 0 users has been added.
Re: Import failed
Posted:
April 24th, 2011, 3:23 pmby Cristián Lávaque
I see. Could you please post the CSV file to see it? (xxxx out any private info, please)
Re: Import failed
Posted:
April 24th, 2011, 3:35 pmby sixagency
sure, here it is:
Re: Import failed
Posted:
April 24th, 2011, 4:01 pmby Cristián Lávaque
Thanks.
OK, try enclosing the values between double-quotes:
"value","value"; instead of:
value,value.
Also, pay attention to any errors/messages you get at the top of the import page after importing. If you're adding a new user, don't give it an ID or use an exisiting username/email address, if you want to edit an exisiting one use the correct ID for him.
Let me know if that helps.
Re: Import failed
Posted:
April 24th, 2011, 4:33 pmby sixagency
NO luck
Can you send me a file that works for you and I will try to use it?
Re: Import failed
Posted:
April 24th, 2011, 8:33 pmby Cristián Lávaque
Re: Import failed
Posted:
April 24th, 2011, 8:53 pmby sixagency
Cool it worked, however when I opened it and added more info and saved it (as .csv) it didnt work.... but yours indeed worked... is there a specific way you are saving it?
I am using Office Excel
Re: Import failed
Posted:
April 24th, 2011, 9:09 pmby Cristián Lávaque
I'm glad it worked.
I'm using OpenOffice. Open it with a text editor to see the format it has and try to achieve that when you save with Office Excel.
Re: Import failed
Posted:
April 24th, 2011, 9:17 pmby sixagency
I must be doing something wrong... I didn't quite understand your last instructions.
by the way... I love your Blog Im a bog fan
Re: Import failed
Posted:
April 25th, 2011, 2:16 pmby Cristián Lávaque
Open the s2member-import.csv I posted above in a text editor like NotePad and see how it's formatted. Try to achieve that formatting when you export your CSV file with Excel. Run some tests so you get familiar with the import tool and see what errors you get, what works, etc. Let me know if I can help you further.
sixagency wrote:by the way... I love your Blog Im a bog fan
Thank you!
