EasyPopulate 4.0 Support Thread

[mc12345678]

Huh? That must have been the problem!




Because of what you just said, I typically remove any column I do not want modified, leaving only what I am changing, plus the control (model# being EP4 default). Since I wasn't changing product_name, I removed it.

But I just uploaded with product_name included (all fields, really) and it went in exactly as expected, removing the foul links.

Thanks, MC! You da man!

I'll take another look at that section of code. I think in the addition of languages/an extended field if found present in the database that the test for that sql to be run or not didn't get updated... It looks like originally that code section was intended only to address the products_name field and to be run only if a name was to be inserted or updated... Then along came some other fields... I expect to revise it to still do a test, but 1) only call the code section if something within is to be acted on and 2) only to include the field(s) with data to optimize the query as able.

[Feznizzle]

1) only call the code section if something within is to be acted on and 2) only to include the field(s) with data to optimize the query as able.

That seems so much more logical to me! First hit the index (model# being default), then check field. If the index supplies point of reference, no need to act on anything other than supplied fields.

Wait, maybe that's backwards? First check fields to find out what needs action (code needs calling), then apply only to indexed entry.

Having to supply the product name when all I wanted to do is alter product_url seemed illogical.

Anyway, glad your on it! Thanks again!

[mc12345678]

Glad you like it. :)

[marcopolo]

I need to modify products_ordered in the products table, I downloaded in Easy Populate 4: Complete Products (with Metatags) but that table column is not in the CSV file, is there another way for it to be download that I'm not seeing?

[mc12345678]

I need to modify products_ordered in the products table, I downloaded in Easy Populate 4: Complete Products (with Metatags) but that table column is not in the CSV file, is there another way for it to be download that I'm not seeing?

While I won't leave you with the one liner that would answer this (read the instructions), but if you add the products table field(s) desired in the custom fields section of the admin-configuration then it will appear in the export and be modifiable on the import. Do not include v_ before the field name. Just the field name as it appears in the database for the (YOUR_PREFIX)products table.

[marcopolo]

That was easy, worked perfect! Thanks for quick reply and not giving me the one liner

[marcopolo]

Ok so I just tested a single line import worked fine, I figured I better try a couple lines to make sure that works and it gave me the following error:

UPDATED! - Model: 10 | 737 |
UPDATE PRODUCT FAILED! - Model: 20 - SQL error. Check Easy Populate error log in uploads directory
UPDATE PRODUCT FAILED! - Model: 30 - SQL error. Check Easy Populate error log in uploads directory

in the error log I have:

MySQLi error 1292: Incorrect datetime value: '-0001-11-30 00:00:00' for column 'products_date_available' at row 1
When executing:
UPDATE products SET
products_price = '15.1000',products_upc = '',products_ordered = '258',products_image = 'test.gif',
products_weight = '1.2',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '0',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '2',
products_date_available = '-0001-11-30 00:00:00',
products_date_added = '2000-05-01 22:08:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '786',
manufacturers_id = '1',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '4')

[marcopolo]

In the CSV I have the following only:

v_products_model,v_products_ordered
10,737
20,258
30,304

[marcopolo]

Ok nevermind, the error above was on my test site. I just tried it on my main site and it worked.

[mc12345678]

Glad to hear that it works, but I am curious about why it happened... What's different between the two? Does one have a differrent php version than the other? Are the versions of EP4 the same or different?

Recently corrected or tried to anyways an issue with those dates to make sure they work. I wonder if the sign is backwards for the more recent version(s) of php although I didn't test with as few columns as you did. (Not necessarily the intended use at the moment). Further since I'm working on publishing a new version I'd like to have ths addressed if it needs to be.