I have an event enabled CCK content type. When I go to map the fields, there is no way to map the start and end dates. They exist as columns in the import file, but it seems there is no event fields to map them to. I'm running Drupal 5.2 and up to date event module. Any idea why the event fields are not showing up as choices in the drop down list to map to?

CommentFileSizeAuthor
#7 event.inc_.txt1.78 KBbkat
#4 nodeimport-noeventdata.jpg66.49 KBjcamfield
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

nhales’s picture

nhales CreditAttribution: nhales commented

I had a similar problem, though not with the event module, dates were not being imported into CCK 'Date' fields. I am also experiencing the problem with 'node reference' fields.

A workaround: Add another field to your content type e.g. temp_field_start_date, temp_field_end_date or temporary_field_referenced_type_nid and set the type to text box.

Import into the new fields (I have not had a problem with plain old text boxes) then run an SQL query to update the table. Something like this:

UPDATE {content_type_mytype}
SET field_start_date = temp_field_start_date
WHERE field_start_date = '' AND temp_field_start_date != '';

Be careful running queries like this though... it's a good idea to check your WHERE clause with the corresponding select statement to see that only the correct nodes will be changed:

SELECT * FROM {content_type_mytype}
WHERE field_start_date = '' AND temp_field_start_date != '';

nhales’s picture

nhales CreditAttribution: nhales commented

Sorry, think I may have misunderstood your problem...

You can't see the date in the configuration page - I can't see them in the preview page.

Double check the field names, somethines they appear in the lis tnot exactly as you are expecting - they take on the given name not the field name, if you view source you can see the field names and may have more luck.

lunas’s picture

lunas CreditAttribution: lunas commented

I've double checked. There is nothing relating to event start times or end times showing up in the select drop down lists during the field mapping stage of the import. This problem has been stumping me for a couple of weeks now. Any more ideas would be greatly appreciated.

jcamfield’s picture

jcamfield CreditAttribution: jcamfield commented
FileSize
nodeimport-noeventdata.jpg66.49 KB

Has this bug ever been fixed? I am encountering the same problems (even without CCK involved in the loop)

kscott22’s picture

kscott22 CreditAttribution: kscott22 commented
Version: 5.x-1.2 » 6.x-1.0-rc4

Same problem here. On "Map file columns (step 4 of 8)," other CCK fields appear fine, but not the date fields. Do I need to format the CSV file differently?

I'm using Drupal 6.15 and just installed Node Import 6.x-1.0-rc4. Also, I've got Date API 6.x-2.4.

Any help is much appreciated.

kscott22’s picture

kscott22 CreditAttribution: kscott22 commented

Looks like this issue is being tackled here: http://drupal.org/node/374346

bkat’s picture

bkat CreditAttribution: bkat commented
FileSize
event.inc_.txt1.78 KB

The event module is not based on CCK. I have nodes that are event enabled and could not import the event times via node import. I solved this for start time but haven't looked at end time because our events don't use the end time. It should be easy to add but my concern is making the end time optional. Anyways, I'm attaching the file I whipped up. Just save it as modules/node_import/supported/event.inc