By sphopkins on

I have been working on importing large volumes of data into Drupal nodes using CSV extracts and the Node_Import module. I have managed to get the data inserted into the proper places in the Drupal database (verified using phpMyAdmin). However when you look at the node that the data is inserted into, there is nothing displayed.

The main data type I am having a problem with is dates, but I do see some problems with simple text.

Here is my setup. CCK Node is set up as a type Date, widget type Select list. I have it set to a granularity of Year/Month/Day as these tend to be dates of events and time is not important. I have no time zone conversion as well due to the granularity.

A manually entered date using create new content inserts a date like this: 2008-03-27T00:00:00 and it displays in the node. Node_Import inserts a date that appears like this: 2008-03-27T00:00:00 but it does not display in the node. If I go into the drupal database and directly edit the data to 2008-03-27 it now displays.

I have a similar problem with text fields. Does not display when imported yet it is in the database and it is indexed by the search engine - I can see the results of the search coming back positive for the content yet when I browse to that node via the search link, it does not display any content.

Any ideas where to start ? I am a bit stumped here and Node_Import looks like it would solve my problems but for some reason the content is not displaying.

⋅ Categories: Drupal 6.x

Comments

sphopkins’s picture

sphopkins commented

User-keyboard interaction error. Seems to be fine.

k8’s picture

k8 commented

Can you explain what fixed your problem. I can get one or 2 fields to import but not more - import mapping is correct, permissions checked, no content shown.

sphopkins’s picture

sphopkins commented

What types of data are you having problems importing ?

I found dates are a challenge and they need the right widget type (select list) and none of the fancy date popups.

I have so far imported thousands of rows and it seems fine.

dcarr’s picture

dcarr commented

I too am having the same problem. I have a .csv with into and only the first 2 cck types get loaded, then the rest of it doesn't display??

sphopkins’s picture

sphopkins commented

I have found blank cells to be a challenge, and the CCK type can make a difference. If there is validation (allowed values, etc) it can reject things. Look in the drupal error log to see if there are any messages.