This module looks very promising and hope that it eventually gets some of the bugs sorted out because it is certainly a very powerful tool.

Tried it out and i get about 10% of my records dumped due to "data too long" warnings such as these:

# user warning: Data too long for column 'title' at row 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (208, 208, 'Agent immobilier affili� R. La Salle', '', '', 1180330088, 1, 0, '') in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_contact_value' at row 1 query: INSERT INTO content_type_contact (field_contact_value, vid, nid) VALUES ('Ren� La Salle', 208, 208) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_contact_value' at row 1 query: INSERT INTO content_type_contact (field_contact_value, vid, nid) VALUES ('Rose M. D�silets', 209, 209) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'field_rue_value' at row 1 query: UPDATE content_type_contact SET field_rue_value = '137, mont�e de la Source' WHERE vid = 212 AND nid = 212 in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.
# user warning: Data too long for column 'title' at row 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (213, 213, 'A Toute S�curit�', 'contact', 1, 1, 1180330088, 1180330088, 0, 0, 0) in C:\Inetpub\websites\drupal-5.1\includes\database.mysql.inc on line 172.

of course the data fields being filled are long enough to hold the contents being dumped; so perhaps this is a core issue ???

also, when the import is done is suggested that 101 nodes were created... which does match the number of records i was trying to create; but this isnt actually the number that were created.. i suspect it is out by the number of errors such as those above that i received.

Comments

liquidcms’s picture

ok, i have figured out the issue.. but not the solution.

in the sample test import data above there are numerous "?" - these are actually accented e's since the data has french names in it. I guess when imported this screws up along the way and mysql/drupal sees things as a data too long issue.

not sure if this is an issue with table character set definition or something missing from this module... anyone have any ideas?

i'll do a little character set digging

liquidcms’s picture

ok, found the issue here: http://drupal.org/node/84902

i guess fgetcsv php function isnt unicode compliant.. and this is what node import uses as well.

looking around for a solution...

Robrecht Jacques’s picture

Status: Active » Fixed

The code in node_import 5.x-1.8 (released shortly) has been rewritten not to use fgetcsv. UTF8 characters should no longer be an issue.

Reopen this issue if after you have tried 5.x-1.8 you still get the same error.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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