Community Support Forums

Re: Import failed

2011-04-25T14:16:34-05:00

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!

Statistics: Posted by Cristián Lávaque — April 25th, 2011, 2:16 pm

Re: Import failed

2011-04-24T21:17:33-05:00

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

Statistics: Posted by sixagency — April 24th, 2011, 9:17 pm

Re: Import failed

2011-04-24T21:09:53-05:00

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.

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 9:09 pm

Re: Import failed

2011-04-24T20:53:26-05:00

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

Statistics: Posted by sixagency — April 24th, 2011, 8:53 pm

Re: Import failed

2011-04-24T20:33:07-05:00

Try this one.

s2member-import.csv

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 8:33 pm

Re: Import failed

2011-04-24T16:33:11-05:00

NO luck
Can you send me a file that works for you and I will try to use it?

Statistics: Posted by sixagency — April 24th, 2011, 4:33 pm

Re: Import failed

2011-04-24T16:01:44-05:00

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.

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 4:01 pm

Re: Import failed

2011-04-24T15:35:07-05:00

sure, here it is:

Statistics: Posted by sixagency — April 24th, 2011, 3:35 pm

Re: Import failed

2011-04-24T15:23:06-05:00

I see. Could you please post the CSV file to see it? (xxxx out any private info, please)

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 3:23 pm

Re: Import failed

2011-04-24T15:18:22-05:00

No it dosnt, it's says 0 users has been added.

Statistics: Posted by sixagency — April 24th, 2011, 3:18 pm

Re: Import failed

2011-04-24T15:09:51-05:00

No, you seem to have done fine. And the new user you imported doesn't show up in WP Admin -> Users?

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 3:09 pm

Re: Import failed

2011-04-24T14:46:53-05:00

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?

Statistics: Posted by sixagency — April 24th, 2011, 2:46 pm

Re: Import failed

2011-04-24T14:32:51-05:00

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.

Statistics: Posted by Cristián Lávaque — April 24th, 2011, 2:32 pm

Import failed

2011-04-24T13:18:33-05:00

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?

Statistics: Posted by sixagency — April 24th, 2011, 1:18 pm