I finally got an import for a CCK content type to work with no errors. However, when I check the actual content, all the Titles are there, but 3 of my fields are missing data - they are just blank. I have 6 fields in my CCK type, 5 are text and one is date. The date works fine, but and 2 of the text fields. But the other 3 text fields are blank.

I also tested a user import and that worked OK. Nothing missing there.

Is it something in my data or CCK definition?

CommentFileSizeAuthor
#8 incrept-1.zip547 bytesjcl324
#8 FireIncidents.zip1.33 KBjcl324
#3 node_import-node_incrept-1_02-24-09.txt32.43 KBjcl324
#2 node_import-node_incrept-1.txt33.2 KBjcl324

Comments

Robrecht Jacques’s picture

Robrecht Jacques commented
Status: Active » Postponed (maintainer needs more info)

Could you attach the "Node import debug report" from the task? It will tell me how the text fields are configured.

Go to admin/content/node_import and then view the task. In the yellow box there is a link to a textfile with debugging information.

Thanks.

BTW: strange that the date CCK field does not give problems as this has not been implemented yet...

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented
StatusFileSize
new node_import-node_incrept-1.txt33.2 KB

Thanks RJ for being so quick to respond. Attached is the report you have requested.

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented
StatusFileSize
new node_import-node_incrept-1_02-24-09.txt32.43 KB

RJ, I'm getting the same results, even with the latest Dev version of 2/23.

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented
Status: Postponed (maintainer needs more info) » Active
Robrecht Jacques’s picture

Robrecht Jacques commented

Which ones of the text fields gives an error? Or rather, is not imported?

I see you have:

  • field_inc_stname (Street Name),
  • field_inc_stno (Street #),
  • field_sf_desc (Situation),
  • field_r_time (Time),
  • field_r_idno (Idno).

They all seem to be configured the same (except for the max_length mostly), so I'm not sure what is going on.

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented

The 3 fields that end up empty are: Time, Street#, and Street Name. The others, Idno, date, and situation have their data correctly. Again, I get no errors, everything seems to work, I just end up with nodes with missing data.

Robrecht Jacques’s picture

Robrecht Jacques commented

Could you also maybe attach the CSV file (sites/default/files/imports/incrept-1.csv) ?
Or at least 5 rows or so (that exhibit the buggy behaviour)?

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented
StatusFileSize
new FireIncidents.zip1.33 KB
new incrept-1.zip547 bytes

Sure, here it is. Just 10 rows. I've also included the CCK definition.

Robrecht Jacques’s picture

Robrecht Jacques commented

I've created your CCK type and tried to import it with the latest -dev (2/23). I have no errors but also no data missing. Eg:

Incident Report: 01/01/92 (413 ORISKANY W-UPD)
Wed, 02/25/2009 - 21:33 — webmaster
Idno:
1992010116185536
Date:
01/01/1992
Time:
16:18
Street #:
413
Street Name:
ORISKANY W
Situation:
EMS ONLY

This means there is probably some other module interfering that I have not enabled or not configured the same.

Looking through the list you have enabled these might provide a problem.

cck_blocks 6.x-1.1 (cck_blocks)
content_permissions 6.x-2.1 (cck)
date_popup 6.x-2.0-rc6 (date)
fieldgroup 6.x-2.1 (cck)
optionwidgets 6.x-2.1 (cck)

Also, have you configured panels to do something with the 'node/%/edit' page?

panels 6.x-2.0-alpha3 (panels)
panels_export 6.x-2.0-alpha3 (panels)
panels_mini 6.x-2.0-alpha3 (panels)
panels_node 6.x-2.0-alpha3 (panels)
panels_node_content 6.x-2.0-alpha3 (panels)
panels_page 6.x-2.0-alpha3 (panels)
panels_simple_cache 6.x-2.0-alpha3 (panels)
panels_views 6.x-2.0-alpha3 (panels)

I could install all modules myself and try to find out which one is giving a problem, but I probably will have to know how you configured all of them as well. Could you try to debug this problem a bit further by disabling the modules above one by one? If you find a module that gives trouble then I could dig into this a bit further.

And just to make sure there is nothing else that interferes, could you do a clean install of Drupal 6 + CCK + Text + CCK Copy + Date + Node import? Then do what I just did: create the content type with Content copy and import the sample data. Report if this already gives an error (or rather, data not showing up) even without all of the other modules you have enabled. This would mean there is something else wrong (and not another module interfering)...

Thanks.

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented

OK, here's what I've found so far. I did a complete new Drupal install with 6.10 and just date, cck, adv help, and node_import. First thing I noticed was on the mapping page of node_import, my CCK date filed is not listed! I think this has been true from the start. On the preview page, I will see the Date field, but it will have some false date (not the system date or the data in the CSV file). And the data that's missing after import are all the fields after the date field.

So I deleted the date field in the CCK, and then everything worked fine. So I tried adding back the date filed back in, and the same missing data as before. Obviously there is something wrong with my date module or API? So what version of that module are you using? The 6.x-2.0.rc6 from 12/08? SHould I use the dev version?

Also, I tried the new rc4 first but then went to your dev version. I'm assuming right now that they are the same?

Robrecht Jacques’s picture

Robrecht Jacques commented

Interesting feedback.

I'm using Date 6.x-2.0-rc6, so same as you.

Yes -rc4 and -dev are currently the same (well, I just committed something).

To be honest, I had some support file for CCK Date in my -dev branch which I was working on, but was not finished yet. Now that I rename that file (so it doesn't load), I indeed have also missing data (not in preview) without errors... So now I know where to look.

I'll investigate this further, but in the meantime, you could place the date.inc from CVS in sites/all/modules/node_import/supported/date/date.inc (creating a new directory). I don't think it is finished yet, but at least it will help your import.

Thanks for the debugging help! I'll leave this open because I'd like to see why this behaviour is happening (it may fix a bug in node_import or date somewhere).

jcl324’s picture

jcl324
he/him
Primary language English
Location Portland, OR
commented

So far so good! Adding that file in now allows me to map the CCK field to the CSV data. The only thing now that I don't understand - but can find out I'm sure - is that my import date data is just a date with no time, so I have to change the custom data format to just "m/d/Y" otherwise I get errors and nothing will import.

I did notice on the RC4 page, nothing is mentioned about dates, other than the requirement for the Date API. What is the future of dates for Node_Import?

p.s. Are you coming to DrupalCon DC next week?

Robrecht Jacques’s picture

Robrecht Jacques commented

Yes, you only store the date in the datetime field so you would need to set it to m/d/Y to import properly. I need to streamline date.inc a bit so it provides a more sane default (eg using the way you want them to display or whether the field includes time or not). That's why I didn't release it yet and it is not in -rc4 yet. But it will be in -rc5.

I'm not going to DrupalCon.

Anonymous’s picture

Anonymous (not verified) commented

fwiw I had similar/same problem (CCK date field not listed with content types on p. 4), drupal 6.9, date 6.x-2.0, node import 6.x-1.0-rc4. date.inc seems to fix for me as well, though I just need date at the moment not time.

Thanks for this.

Robrecht Jacques’s picture

Robrecht Jacques commented
Status: Active » Closed (duplicate)

Not all options of Date CCK fields are supported yet. See http://drupal.org/node/374346. I think this issue is related to the unfinished date support so I'm setting it as duplicate.