Import problem

Hi, I am trying to import and am getting this error. I have around 700 members but am just trying to get the csv file good for importing with one person’s info. One thing i have noticed – I am using open office. When I opened the member list which is in a csv file, I do not see any quotation marks around any fields. I added them to this test import of one person but will that affect the importation? How would i possibly add quotation marks in all the fields? Is it the way the csv is saved? Here is the error and csv:
The following errors were encountered during importation:
Line #1. User ID# ‘”ID”‘ does NOT belong to an existing User.
Line #2. User ID# ‘””‘ does NOT belong to an existing User.

"ID","Username","Password",“First Name”,“Last Name”,“street_address”	“Alternate-address”,“City”,“county”,“State”	“Zip”,“phone”,“member”,“Member-level”,“role”,“Membership-term”,“Expire-date”,“Member-since”,“Last-revised”,“comments”,“nagc-member”,“Affiliate-chapter”,“profession”,“School-organization-name”,“School-district”,“Email”,“Alternate-email”,“Payment-info”,“Payment-history”

"","",“password”,“Joe”,“Shmo”,“1 Mainstreet”,“”,“Town”,“”,“PA”,“18000”,“”,“yes”,“Family”,“Family 1 year member”,“1yr”,“1/30/2013”,“2/10/08”,“1/31/12”,"2012 Conference Platinum Sponsor”,“”,“”,“Parent”,“”,“”,“email@gmail.com”,“anotheremail@gmail.com”,“”,“”

Also, notice that the quotation marks are different. The first ones for ID and user were copied from the text in your directions on the user panel. The others (sort of look more stylized) were written using open office – added by hand. I have read that by default open office puts quotes around it’ fields but I do not see any.
Any help would be greatly appreciated! thanks,
Lisa

Hello Lisa,

Have you followed the instructions on how to import/export found in this article?:
Knowledge Base » Importing existing subscriptions

Hope this helps. :)

these are not existing subscriptions through paypal. I am using a csv of members that was generated in microsoft access and then I opened in open office. Because all of the members have payed in different ways throughout the years, my client wants to “start fresh” and import all of the members with their existing info. Once the time comes for them to renew, they will use the new s2 member buttons and then they will get into the new system. Because they are already members, I will give them all the same password and they can go in and change it and update their info. Or that’s the plan! Any other ideas???

One thing i have noticed – I am using open office. When I opened the member list which is in a csv file, I do not see any quotation marks around any fields. I added them to this test import of one person but will that affect the importation? How would i possibly add quotation marks in all the fields? Is it the way the csv is saved?

I think that’s a setting in OpenOffice Calc.

Yup, just checked it. When you “save as”, make sure the format is “Text CSV” and if you check the “edit filter settings” box you’ll be asked what the field and text separators should be.

I hope that helps. :)