I am using Drupal 6 with the Feeds Module. I have a content type with some fields that are importing correctly and others that don't work. The excel file which is used to enter the nodes and import them using feeds is done and uses excel validation.
Part 1 - Fields that need to be fixed:
--------------------------------------------------
- 4-5 of them are time values (MM:SS or HH:MM). In the database it's in this format: "2011-01-01T00:00:00". I need the MM:SS to properly convert into this format: "2011-01-01T00:00:00".
- Another is text field that accepts one of 3 options. For some reason the options in the cvs file don't work when I import.
- The author field of the nodes should be the current logged when the user uploads a cvs file. Any logged-in user will be able to upload a cvs file.
- I have a node reference field. The user should be able to select this node from the excel file (using validation with a select list). The problem is that the database accepts the nodeid, but I want the user to be able to select the node title from the select list in excel. The select list should always be up to date in the excel file (dynamic).
Part 2 - Modify the Feeds import page
-----------------------------------------------------
See attachment. Basically all I want is some text as a intro, the browse button and the upload button.
Part 3 - Validation
-----------------------------------------------------
This is most likely already done with the Feeds module, and my excel file has validation as well, but I want to make sure that if both of those fail or if someone doesn't provide the proper info that it doesn't create a node and gives the user an error explaining why the import didn't work.
Only experienced Drupal developers please.
Thanks