Download & Extend

"There are no new nodes" message when import file has Mac EOL format [solved]

Project:Feeds
Version:7.x-2.0-alpha4
Component:Code
Category:support request
Priority:minor
Assigned:Unassigned
Status:active

Issue Summary

I cannot even get the most basic csv to import (title,body,published,guid). I'm using a fresh install of drupal 7.2, no other modules but job scheduler 7.x-2.0-alpha2, Ctools 7.x-1.0-beta1, and Feeds 7.x-2.x-dev.

No errors, just the message "there are no new nodes"

Are there new issues I'm not aware of? I've searched, with no luck. is there a know working combination of those modules that work? Thanks for any help with this.

[Edit by wusel on May 3, 2012]
Please look at http://drupal.org/node/622710#csv
[/Edit]

Comments

#1

I'm seeing the same behavior. I even downloaded the template produced by the input form and added one line of content and tried to import. I don't get any errors, just the same "There are no new nodes".

#2

I did finally get some basic nodes imported when i exported my csv without a text qualified and set it to LF unix. but I can't get any tags into a term reference field or image names into a image field. If anyone can help me get that done, I should be good. Thanks for any help.

#3

Subscribing.

@dotman - Ever find the solution to your problem?

#4

Poieo: I had the same problem, and as dotman noted, changing the line break settings of the file to "Unix (LF)" seemed to solve my problem. I'm not sure if this always has to be LF or if the line break type has to match that of the server's system.

More info on Wikipedia: Conversion utilities

Also, most GUI-based text-editors will give you some kind of line-break setting option in the "Save as..." dialog. I used Text Wrangler.

#5

Version:7.x-2.x-dev» 7.x-2.0-alpha4

I want to import some "pages" als Nodes from a csv-file. In the body of the resulting pages, there must be some commas in the german sentences.
So i think, i need the sign " for text separation.

Please tell me, how i can import a CSV-file like:

title,body,guid
"Welcome","<p>Hello,</p><p>nice to meet you, here on our homepage.</p><p>You want more Info?<br>klick on: <a href='about'>About</a> or <a href='we'>We</a>.</p>",1001
"About","<p>We, <strong>Name1</strong> and <strong>Name2</strong>, want to do something.</p>",1002
"We","<p>Our company 'Ourname Ltd.' will ....</p>",1003

Please help me.

Thanks

[Update]
The solution is:
I must activate the option "Import on submission".
[/Update]

#6

@wusel - I believe that should work, but if you're having trouble you need to create a new issue, as your problem does not relate to the original issue in this thread. Thanks.

#7

Subscribing, having the same on Mac, when I try it on Wordpad (Windows) I got some results..will investigate more..
greetings, Martijn

#8

Status:active» closed (works as designed)

please look at my update in comment #5

#9

I had the same issue. I opened up the CSV file that was saved in Excel in BBEdit, changed the File Options to "Unix", saved and uploaded-- done.

#10

sub

#11

Title:Nodes do not import» "There are no new nodes" message when import file has Mac EOL format
Priority:major» minor
Status:closed (works as designed)» active

I had the same "no new nodes" error on import, and changing the line endings to UNIX (I used Notepad++ in Windows) fixed the problem. The import csv was originally created on a Mac.

Should this be a feature request/bug report to "Support Mac EOL Format"? Or at least give a better error message; without this issue page I could have spent hours debugging the import.

Setting this back to active for now, since @wusel closed it based on a separate issue.

#12

@goodeit Thanks for saving me a headache! #11 worked for me as well.

#13

It is like http://drupal.org/node/1285276#note2 for the Migrate module:

The line-ending-char(s) depend on the type of the operating system of the www-server:
If you are using a Linux-Server, please use only LF at the line-end of the CSV-file.
If you are using a Windows-Server, please use CR+LF at the line-end of the CSV-file.
If you are using a Mac-Server, please use CR at the line-end of the CSV-file.

When the CSV-file is in "UTF8 with BOM"-format, then the import of special characters (letters like ß, ö ,ü, ä, Ö, Ä and Ü, non-ASCII-signs) is without problems.

I think: this should be dokumented in the drupal.org-Online-Documentation of Feeds and in the help-page of the feeds-import-dialog on the help-sub-page.

Note: a patch-file also needs the same line-ending-char(s), depending on the type of the operating system of the www-server.

#14

Another solution for fellow mac users

File to "save as" windows format .csv

That fixed the problem for me.

#15

The "save as windows CSV" worked for me. Thanks!

#16

"save as windows CSV" worked for me as well. muito obrigado!

#17

*bangs head against table*
I spent hours to find that the line endings were wrong!

#18

Title:"There are no new nodes" message when import file has Mac EOL format» "There are no new nodes" message when import file has Mac EOL format [solved]

Please look at http://drupal.org/node/622710#csv

nobody click here