Spectacular import fail

Project:	Scratchpads
Version:	7.x-2.0
Component:	User interface
Category:	bug report
Priority:	normal
Assigned:	Simon Rycroft
Status:	active

I just tried to import a small CSV-spreadsheet with data for my own custom "Sample" content type. It links with locations and bibliographies using NIDs and looks just fine on the import preview. The import however pretty much just creates empty nodes with nothing more than a title. The site reported no errors while importing.

I attach some screenshots below.

This is a showstopper for me so please please look into it!

Attachment	Size
failed_import.png	78.78 KB
failed_import1.png	58.51 KB
failed_import2.png	65.73 KB

By Andreas Wallberg at 2011-01-13 15:15
Login to post comments

#1

Assigned to:

Anonymous

» Simon Rycroft

By Irina Brake at 2011-01-13 16:06
Login to post comments

#2

Have you tried importing the file without the NID fields? It might be just the NID import that is not working.

By Irina Brake at 2011-01-13 16:09
Login to post comments

#3

I've traced the problem. It was actually the Date field that caused the import to malfunction. This field is not possible to match with a column in the CSV-file when configuring the import and instead suggests a default date of "Sat, 2011-01-01" for all my samples in the preview. After I remove the Date field, everything imports fine, including the NIDs :-)

So for now, I will use a text field for my dates but maybe the devs can share some light on all this.

By Andreas Wallberg at 2011-01-13 18:35
Login to post comments

#4

For my specimen imports I use the format "6/20/2007" for dates. Try importing with this format, Andreas.

By Irina Brake at 2011-01-14 09:25
Login to post comments

#5

How did you first configure the date field?

By Andreas Wallberg at 2011-01-14 10:02
Login to post comments

#6

I don't think that matters. The format when I edit or view the specimen is different. It is probably just a number that is saved anyhow.

By Irina Brake at 2011-01-14 11:23
Login to post comments

#7

Status:

active

» postponed (will be included in Scratchpad 2.0)

I'm afraid there is an issue with importing content into a Date field - it's something that I've not had working (although I've not tried that many times to be honest). I'll mark this as an issue that will be fixed in the new version of the Scratchpads, as we will likely have an improved import workflow for that.