EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by Razzinator

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.

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.

Quote:

---

Originally Posted by 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.

---

Su35,

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

Thanks,
chadd

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.

Quote:

---

Originally Posted by 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.

---

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

Thanks.

-chadd

Could you set the default values in the code?

Quote:

---

Originally Posted by su35

Could you set the default values in the code?

---

Next release will address this issue.

chadderuski,

Why isn't this in the plugins area??

Quote:

---

Originally Posted by kobra

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

Just wondering....