I'm using Webform import 7.x-1.3 with Webform 7.x-3.20 in a Drupal 7.24 instance.

I've created a form for ordering items from our library and am having diffculty importing data from our old system into the new Webform-based system.

I'm downloading the template using the field form keys, then importing text data into that template. So far so good. I save the file in Excel as tab-delimited text. For reasons unknown, Webform Imports cannot recognize the header row in the tab-delimited file, even though I use the drop down to set the value to form field keys.

I then used a text editor to convert the tab-delimited to pipe-delimited. That gets it to recognize the header row except for the first column. The first column is a date field called date_ordered. I've tried both mm/dd/yyyy and yyyy-mm-dd date formats, but still no joy.

For each record in the import, I get the following message:

Notice: Undefined index: date_ordered in _webform_import_import() (line 343 of /var/www/html/libstaff7/sites/all/modules/webform_import/webform_import.module).
Notice: Undefined index: date_ordered in _webform_import_import() (line 383 of /var/www/html/libstaff7/sites/all/modules/webform_import/webform_import.module).
Notice: Undefined variable: submitted_key in _webform_import_import() (line 415 of /var/www/html/libstaff7/sites/all/modules/webform_import/webform_import.module).

The date_ordered field seems to behave normally for records entered interactively and can be searched/sorted in webform reports.

Just looking for what's going on with the import failures here I guess.

Thanks for your help.

Bobb Menk

Comments

bmenk’s picture

bmenk commented

Just noticed on a retry that I also see this message:

"Can not find column date_ordered in components list, skipping."
in the messages from the module rather than in the php warnings.

date_ordered is the first column in the delimited file and also in the form as defined.

I'm starting to suspect line endings in this as I'm uploading from Windows to Linux. Need to investigate that I guess.

bmenk’s picture

bmenk commented

So line endings was my biggest trouble. Pushing the import file to a linux host took care of that, so that the record fields are all getting read during the import and going in apparently normally.

However I'm still seeing a php error for each record in the import which looks like this:

"Notice: Undefined variable: submitted_key in _webform_import_import() (line 415 of /var/www/html/libstaff7/sites/all/modules/webform_import/webform_import.module)."

'Fraid I don't have the expertise to understand what that means or how to fix it.

Anyone translate for me?

Thanks