Bulk upload tool error: Column 'date_create' cannot be null

[amazingfinds]

I simply exported a sample auction I had started, then purged, then uploaded the file without making any changes. I received the following error:

WordPress database error: [Column 'date_create' cannot be null]
insert into wp_wpa_auctions(id, date_create, date_start, date_end, name, description, image_url, start_price, reserve_price, variable_shipping, shipping_price, shipping_to, shipping_from, BIN_price, extraimage1, extraimage2, extraimage3, staticpage, paymentmethod, terms, engine) values("",str_to_date('2012-03-18 23:38:22','%d/%m/%Y %H:%i'),str_to_date('2012-03-18 23:38:22','%d/%m/%Y %H:%i'),str_to_date('2012-03-25 00:00:00','%d/%m/%Y %H:%i'),"new","new","http://www.amazingfindsauction.com/wp-content/uploads/2012/03/mirror-brown-rustic.jpeg","5.00","0.00","","0.00","Local pickup only","","0.00","","","","","mailingaddress","","1");

I have tried experimenting by uploading multiple other modifications to the CSV file. The only one I could get to work was your original sample. However, it resulted in no current auction, since the dates were in the past. As soon as I changed the date, I received the same error as above.

[Owen]

Hi there,

The specification for the import file can be found at the bottom of the page on the Bulk Uploader.

I've looked at the data you're submitting and the dates seem to be in the wrong format. From the spec: The start date/time (in GMT) of the auction. This must be in the format DD/MM/YYYY HH:MM

Looking at one of your dates: str_to_date('2012-03-25 00:00:00','%d/%m/%Y %H:%i')

You seem to be supplying these in YYYY/MM/DD format instead. Can you adjust these to be DD/MM/YYYY?

Regards

Owen

[amazingfinds]

Yes, and it appears with the same error no matter what I try.

WordPress database error: [Column 'date_create' cannot be null]
insert into wp_wpa_auctions(id, date_create, date_start, date_end, name, description, image_url, start_price, reserve_price, variable_shipping, shipping_price, shipping_to, shipping_from, BIN_price, extraimage1, extraimage2, extraimage3, staticpage, paymentmethod, terms, engine) values("",str_to_date('3/18/2012 18:06:00','%d/%m/%Y %H:%i'),str_to_date('3/18/2012 18:06:00','%d/%m/%Y %H:%i'),str_to_date('3/25/2012 18:06:00','%d/%m/%Y %H:%i'),"Sample Auction","This is a sample auction that we're going to use in the sample import file","http://www.wpauctions.com/wp-content/uploads/2010/06/1322039.jpg","5","500","Could vary","0","","","0","","","","","paypal","Books","2");

[Hyder]

I've linked a sample file here, can you save it to your desktop and upload it as it is and let me know how it goes.

http://www.wpauctions.com/downloads/sample.csv

[amazingfinds]

Thank you, that worked! It helped me to see that it had been my mistake all along. Despite my reading and re-reading your instructions many times, I always interpreted the date as MM-DD-YYYY (American mindset, I suppose) vs. your actual DD-MM-YYYY, a format I was not used to. Thanks again, I'm really excited to start our auctions.

[Hyder]

Best of luck!