I am trying to use node import to import a lot of data from a csv file. However i can't seem to get it to work. When i get to the last step and it shows me the preview it just has records 1 to 5 with no data in any of them. I don't really understand where i'm going wrong.

Can anyone help me?

Thanks

Comments

petarb’s picture

I'm having exactly the same issue. Previews all look good until the last step with no data in any of them.
Note: I've installed and used this module on several other sites previously. So I don't think it's my process.
I'm going to
1) review the csv file - could be an issue there of course, but I'm doubtful because I can see and map the data correctly in the previous pages
2) uninstall the module and try a previously installed version which I have had proven success with.

Will update in a couple of days. Yay it's the weekend!

petarb’s picture

Sorry, it's been awhile on this one.

There were multiple issues for me, and although I can't be sure whether they are related to the above issue, I think it's worth putting them down here.

1) The CSV file MUST be in UTF-8 format. Although everything looked good for me in another default format, exported from XL, it wasn't until I actually changed the format using TextWrangler (for OSX) that I was able to successfully do a node import. Because it 'half way' did it originally, I didn't realise this was an issue until I investigated the UTF-8 format properly

2) The fields logic must be correct. For example, if you have a field for your node type that you have defined must have content in it, be sure you have content in it! I found it just as easy to make sure that the the field content was listed as optional, even if it was not, and change it later.

Once I sorted out these two issues, I was able to successfully Node Import. Good luck!

Q2U’s picture

+1 on what PetarB says. Also: check your Content Type settings for the Content Type you are trying to import: Node Import seems to be VERY picky about settings. Also: disable the module "Node Form Settings" (if you have it installed). Node Import is VERY fussy about settings: veeerrrrrrryyyy fussy. Keep trying: it will work eventually :-P

sridharpandu’s picture

StatusFileSize
new5.57 KB

I have the same issue. Let me explain what I did and at what point it doesn't seem to work. Any help would be appreciated.

1. Created a CSV file of 9 records using OO Calc. (attached to this post)
2. Clicked Administer|Content Management|import Content. The import content page was displayed
3. Clicked "new import". Clicked "Next" and choose "comic content type" (the content type I created using CCK)
4. Uploaded the CSV file and Clicked "Next"
5. In Step 3 I choose "First row contains column names" and "Comma Separated Values". Clicked "Next".
6. I get a WSOD instead of the "Map File Columns"

The preview in step is shown correctly. I have an image field in the CCK the corresponding field is empty in the CSV file.

Would appreciate any help. Thanks in advance

Best regards

Sridhar

sridharpandu’s picture

StatusFileSize
new5.43 KB

An addendum to my previous post. I discovered that there were some commas and double quotes in the data and removed them. (I have attached the new file to this post). I still have the same problem.

Subsequently I removed the single quotes as well and still face the same problem.

Corbula’s picture

Just to let you know, i had to go the long way round and just input all of the data. It turns out a lot of the data wasn't needed any more, but there was still a lot to input.

It seems others have the same problem with this, so keep this issue open.

petarb’s picture

FYI, if I had an import linked to an image field, the image had to exist in the host file directory, otherwise the import did not run successfully, even when I made this optional in the CCK settings.

itserich’s picture

StatusFileSize
new22.82 KB

Weird problem.

It appeared to import properly, I thought I was watching the nodes as they were created, and attached is the final confirmation page, showing success, I think - this is my first time using the module.

However, there are no new nodes.

I saved in .csv with Open Office, don't have Node Form, so not sure what the problem is. Will look around.

ron_sparks’s picture

I am having the same issue as itserich for the last week...

fender-dupe’s picture

same issue here, cant import, tried everything

itserich’s picture

I had success with Feeds.

http://drupal.org/node/989950