wallkraft Posted August 24, 2015 Share Posted August 24, 2015 I'm having problems exporting the newsletter csv and uploading it on my mailchimp account. I keep getting this error message during upload: "No emails in columnYou must have an email address column to import a list" When I open the file in excel I can see that the all the users details are in one line and there are no seperate fields for e-mail Link to comment Share on other sites More sharing options...
ZiZuu Posted August 24, 2015 Share Posted August 24, 2015 CVS.php was buggy before PS 1.6.1.1 ... can be this issueTry editing classes/CSV.php and replace Tools::str_replace with str_replace Link to comment Share on other sites More sharing options...
wallkraft Posted August 25, 2015 Author Share Posted August 25, 2015 Unfortunately my PS doesn't have that line of code. Anything else I can do? Link to comment Share on other sites More sharing options...
ZiZuu Posted August 25, 2015 Share Posted August 25, 2015 Yes: say what PS version you have Link to comment Share on other sites More sharing options...
wallkraft Posted August 25, 2015 Author Share Posted August 25, 2015 Hi, my version is 1.6.0.14 Link to comment Share on other sites More sharing options...
ZiZuu Posted August 26, 2015 Share Posted August 26, 2015 (edited) sorry can't help you I can only argue it can be a file format issue .. as you say you see a one line file in excel Just open the file in a simple editor (wordpad or similar) and check if it is well formatted .. CSV is a comma separated value file it should be made of 1 line per record, fields delimited by " and separated by , Edited August 26, 2015 by ZiZuu (see edit history) Link to comment Share on other sites More sharing options...
subaru4wd Posted March 23, 2016 Share Posted March 23, 2016 I too am having this problem. My .csv file looks good, but mailchimp says there is no email column. Link to comment Share on other sites More sharing options...
franzdolegeal Posted May 29, 2016 Share Posted May 29, 2016 Hi, This is crazy i have the same problem. and i'm pulling my hair off may head. does anybody has the solution ? Link to comment Share on other sites More sharing options...
RuthMoore Posted May 30, 2016 Share Posted May 30, 2016 I have the same problem . Looking for help from Pro! Link to comment Share on other sites More sharing options...
franzdolegeal Posted May 30, 2016 Share Posted May 30, 2016 Ok so i found a free and very simple module that imports your clients lists in one clic in mailchimp : http://module.minic.ro/minicmailchimp/#more-213 I juste tried it and it works. Link to comment Share on other sites More sharing options...
subaru4wd Posted May 30, 2016 Share Posted May 30, 2016 To get around this issue, I opened the .csv file in MS Office. Once the file was open I then saved it as a new .CSV and was able to edit the columns. Once the new .csv was saved using Office, mailchip was able to import it and use my data. Link to comment Share on other sites More sharing options...
edouardgarneau Posted June 7, 2016 Share Posted June 7, 2016 Hi, I have the same issue (this is so annoying) My way of resolving this was to copy all the MS Excel cells (by dragging from column A to the end of my fields) and paste it to a Google Drive Spreadsheet (place your cursor on A1 and cmd-v). Then, I go File > Downlad as > Comma separated values And as Google does it right for everything, and Excel bad for everything, it worked for the import on Mailchimp! Link to comment Share on other sites More sharing options...
shopme Posted June 9, 2016 Share Posted June 9, 2016 Hello, It's because it's exporting with ";" instead of "," . Probably a little bug. You can open your CSV and launch a find/replace all, and resave it Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now