EasyPopulate 4.0 Support Thread

[chadderuski]

I can download "Full" and turn right around and import it back. But if I open with Calc and save file unedited I get this error msg.

No model field in record. This line was not imported

When you first save a CSV in Open Office, you have to do a SAVE AS, Select TEXT CSV, and be sure to CHECK "Edit filter Settings"....

Click Keep Current Format, Set your Field Delimiter to the COMMA, and Text Delimiter to DOUBLE QUOTE

I believe the defaults are TAB, which is why your import failed.

[su35]

When the SQL mode was set to strict. There would have a SQL error --> "Incorrect integer value". In most case, the database setting is out of our control. So, suggest chadderuski to modify the code.

[chadderuski]

When the SQL mode was set to strict. There would have a SQL error --> "Incorrect integer value". In most case, the database setting is out of our control. So, suggest chadderuski to modify the code.

Su35,

Thanks for the feed back. But could you elaborate more and perhaps give a specific example of this problem?

Thanks,
chadd

[su35]

version: Easy Populate 4.0.22 - Beta 6-10-2012

if sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" (my.ini)
on the EP4 working page, export a completed products file, and then import it. you will get a error message in the log file as
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
.....
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
....
I think the problem is that some default values for integer had not been set correctly(have not been set, set to empty...).

if sql-mode=
everything is OK.

[chadderuski]

version: Easy Populate 4.0.22 - Beta 6-10-2012

if sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" (my.ini)
on the EP4 working page, export a completed products file, and then import it. you will get a error message in the log file as
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
.....
product_is_always_free_shipping = '0',
products_tax_class_id = '',
products_date_available = NULL,
....
I think the problem is that some default values for integer had not been set correctly(have not been set, set to empty...).

if sql-mode=
everything is OK.

I've seen something similar to this with IIS ... didsn't know it was because sql mode was strict.

Thanks.

-chadd

[su35]

Could you set the default values in the code?

[chadderuski]

Could you set the default values in the code?

Next release will address this issue.

[kobra]

chadderuski,

Why isn't this in the plugins area??

[chadderuski]

chadderuski,

Why isn't this in the plugins area??

Hey Kobra,

Actually, I'm in the process of putting everything together now, creating a detailed readme file, and some additional work on the code. Hopefully I can submit this within a couple weeks.

-chadd

[kobra]

Just wondering....