Author Topic: I have a clean CSV file, but import not reading correctly  (Read 2360 times)

carlyn

  • Posts: 10
    • View Profile
I have a clean CSV file, but import not reading correctly
« on: April 01, 2008, 03:40:19 pm »
I am trying to import a list of just 2000 leads. I have edited the list in Excel, and "Save As.." as a .CVS file.

My list is a single-variable list, with only email address, 1 per line. However, when I try to import and I am taken to the page where I am supposed to match my import fields to LMP fields. Instead of displaying my first line of the cvs file as a single email address, it displays them all run together, like this:

email1@domain.comemail2@domain.comemail3@domain.com....

So obviously, import doesn't work.

I have even tried the recommended settings for Importing from Aweber (some of my leads are from aweber) (http://listmailpro.com/forum/index.php?topic=1884.0

I've done this many times before with other systems with no trouble.. can't see what the problem may be here.

Any advice?


[/list][/list]

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
I have a clean CSV file, but import not reading correctly
« Reply #1 on: April 01, 2008, 08:51:39 pm »
Greetings,

Could you be administering ListMail from a Mac?  There is a known configuration option that helps PHP read Mac line breaks.

A line like this can be added to config.php anywhere between the opening and closing <?php and ?> tags.
Code: [Select]
ini_set('auto_detect_line_endings', true);
If you are not on a Mac please upload your file via FTP to your ListMail folder and create a trouble ticket for an investigation (using a test list).

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

carlyn

  • Posts: 10
    • View Profile
I have a clean CSV file, but import not reading correctly
« Reply #2 on: April 02, 2008, 04:38:55 am »
Yes I am using a Mac, and that line of code works perfectly. Never would have thought of that. Thank you!