Easy Populate 1.2.5.7.csv not Importing items due to MySQL error 1292: Incorrect date

Hello!

I am currently using v1.3.9h ( I am currently working on upgrading on a test Data base but still keeping main one alive and new items just arrived!)

I didn't have problems with this before... so I don't know why I suddenly am now.

ERROR MESSAGE

Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

checking the debug log, it said

MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO zen_products SET
						products_model					=	'251193_blue' ,
						products_price					=	'49.99' ,
						products_image					=	'newArrivals/251193_blue.jpg' ,
						products_weight					=	'0.8' ,
						products_weight_type			=	'lbs' ,
						products_dim_type				=	'in' ,
						products_length					=	'10' ,
						products_width					=	'10' ,
						products_height					=	'8' ,
						products_ready_to_ship			=	'0' ,
						products_tax_class_id			=	'2' ,
						products_date_available			=	'' ,
						products_date_added				=	CURRENT_TIMESTAMP ,
						products_last_modified			=	CURRENT_TIMESTAMP ,
						products_quantity				=	'1' ,
						master_categories_id			=	'121' ,
						manufacturers_id				=	'NULL',
						products_status					=	'1',
						metatags_title_status			=	'1',
						metatags_products_name_status	=	'1',
						metatags_model_status			=	'1',
						metatags_price_status			=	'1',
						metatags_title_tagline_status	=	'1' 

SO then I added a new column called v_date_avail

and added 10/26/2016 23:45

still import problems with same error message

So then I replaced v_date_avail with v_date_available

10/26/2016 23:45

STILL doesn't work.... same error message

Warning An SQL error has occurred. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

I have troubled shoot as many angles as I can. I changed date formats

2016/10/26 23:45
10/26/2016 23:45
26/10/2016 23:45

I tried to set 1 item with a date available so I can export it and see how easy populate shows the date format... but it doesn't show up in the excel for me to take a look...

Any suggestions would be great! Thanks so much

Besides suggesting one or more other related bulk import plugins that work with ZC 1.3.9, the date format would most likely be with dashes instead of slashes in the format of YYYY-MM-DD. And I thought that field was a date only not a date time field.

The other thing is that the field probably should be called v_products_date_available, but that's a guess as well. Haven't looked at the code to see what it is expecting.

mc12345678:

Besides suggesting one or more other related bulk import plugins that work with ZC 1.3.9, the date format would most likely be with dashes instead of slashes in the format of YYYY-MM-DD. And I thought that field was a date only not a date time field.

The other thing is that the field probably should be called v_products_date_available, but that's a guess as well. Haven't looked at the code to see what it is expecting.

Thanks so much for your reply and ideas! I tried reuploading it again and it works now. Though it is also now asking for fields like "v_manufacturers_name" as I have never entered those fields before.. but seems that now it's being more picky and won't allow blank fields.. =/

I didn't update this version on anything... it's as if I uploaded fine as before, then suddenly now it's wants more specific entries.