2

I'm using the feeds module to try to import several thousand nodes, but I'm getting mixed results: sometimes it seems to work, sometimes it doesn't.
I understand there are some sort of issues related with the line endings in the CSV files when they are created on a Mac. I tried saving my CSV for Unix (LF) and Windows (CRLF), but that doesn't seem to fix the problem entirely either.

Does anyone else have this problem? Is there a definitive solution or workaround for this?

7

I've had the most success importing CSV files by importing them into Google Docs (spreadsheet) first and then exporting from Google Docs as a CSV file. It might seem like a silly workaround but Google spreadsheets seems to handle inconsistencies in CSV files a little better than Excel or Numbers.

Give it a shot. I've just used the same method for a Feeds CSV import.

protected by kiamlaluno Sep 10 '12 at 19:51

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.