Hi, I have noticed that Node Import breaks line when a special character is present (like èéàáìíòóùú).

It does not break the import of the file, but if a line contains one of the above characters, the Node Import module will shift to the next tab or comma. I am trying to import the data into the body so no cck is involved. I also tried to convert one of the imported node filter to full html, but as I have seen the data is not imported on the database. I hope these information is enough.

Thanks a lot for the development!

Here the data about my system:
Drupal 5.14
Database schema Up to date
MySQL database 5.0.68
PHP 5.2.6
PHP register globals Disabled
Unicode library PHP Mbstring Extension
Web server Apache/2.0.63 (CentOS)

Comments

Robrecht Jacques’s picture

Robrecht Jacques commented

Have you saved your file in UTF8 ?

alex72rm’s picture

alex72rm commented
Status: Active » Fixed

Yeah!!!

Using Notepad++ is simple to save the tab/csv file in UTF8 format, and this approach solves the issue.

Alessandro

frank ralf’s picture

frank ralf commented

Just a hint:

As much as I like Notepad++, for encoding conversions, Windows' built in Notepad editor is far more reliable in my experience.

Frank

alex72rm’s picture

alex72rm commented
Status: Fixed » Closed (fixed)
jsims281’s picture

jsims281 commented

Thank you Frank! I've been wrestling with this for hours.

Excel UTF (my version at least) encoding breaks the import, but doing the following works:

1) save the file as a CSV in Excel
2) open it in Notepad
3) re-save it as UTF-8 from Notepad
4) run the import

giorgosk’s picture

giorgosk
Location Chios, Greece 🇬🇷
commented

UTF-8 formatting is required for the csv file

I was trying with a ANSI formatted file and I was getting crazy results

maybe this requirements should be Documented somewhere prominently

giorgosk’s picture

giorgosk
Location Chios, Greece 🇬🇷
commented
Status: Closed (fixed) » Active

reopening to get the maintainers attention
maybe it needs to be included in the front page

it will save lots of people headaches

Robrecht Jacques’s picture

Robrecht Jacques commented
Status: Active » Fixed

Fixed by putting it on the project page.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

rvb’s picture

rvb commented

I made the steps mentioned in #5 by jsims281 a little more detailed:

1/ Save the file as a CSV in Excel
2/ Open Notepad ++
3/ In Notepad ++ , select "Encoding > Convert to UTF-8"
4/ Save the file as a .txt file
5/ Rename the .txt file to .csv file
6/ Upload your file and you should be all good

alex.p’s picture

alex.p commented
Issue summary: View changes

Works for feeds module as well. You provided universal solution. Thanks a lot!