EasyPopulate 4.0 Support Thread

[mc12345678]

No problem. If the products_price_w field is in fact in the products table (appears like it should be based on the name), then with EP4 installed, goto configuration->Easy Populate then locate the the listing for User identified fields. In the right side of the screen, add products_price_w and update the field.

Now where products are exported (mainly the full export) the field will appear, and will also be "read" for import.

The caveat to this method is that anyone having admin access to those settings could modify the list of additional fields to import/export to/from the products table.

[Tile Mural Store UK]

Easy Populate 4.0.35.ZC - 04-29-2016
Zen Cart 1.5.5a
Database Patch Level: 1.5.5
v1.5.5a [2015-01-01 05:44:52] (New Installation-v155a)
v1.5.5a [2015-01-01 05:44:52] (New Installation-v155a)

Im can not get my attributes to show on my products.
uploaded Complete products OK
uploaded Basic products attributes OK and showing in attributes conntrol
when i upload the detailed product attributes vie the Browes button i get File uploaded successfully:
But the attributes dont show on product.
if i upload via the import button i get File Import Completed with issues. & SKIPPED! - Attribute Entry on : - Not Found!

please help.

[mc12345678]

Easy Populate 4.0.35.ZC - 04-29-2016
Zen Cart 1.5.5a
Database Patch Level: 1.5.5
v1.5.5a [2015-01-01 05:44:52] (New Installation-v155a)
v1.5.5a [2015-01-01 05:44:52] (New Installation-v155a)

Im can not get my attributes to show on my products.
uploaded Complete products OK
uploaded Basic products attributes OK and showing in attributes conntrol
when i upload the detailed product attributes vie the Browes button i get File uploaded successfully:
But the attributes dont show on product.
if i upload via the import button i get File Import Completed with issues. & SKIPPED! - Attribute Entry on : - Not Found!

please help.

First, hopefully you have applied the various patches/modifications identified over the last 7ish pages (a lot of other conversations intermixed).

Secondly, upload places the files on the server. Import is what tries to push the product to the database.

In a default install, product_model is the primary key used to match the import record to the product. If the selected primary key is not found in the import file for the specific row, then the row is not imported unless the selected primary key option supports that type of import.

More to follow in a moment.

[mc12345678]

Sorry, had to reread the post to be sure that I was going to provide information that would help, but didn't want to delay you getting started with the above.

So after upload of the products file (file to appear in the section regarding full uploads), that file needs to be imported if it adds or modifies products. Provided a row has a matching primary key in it (settings of primary key are in the configuration menu for EP4), then the row will be imported.

Then once a product is present in the database with the desired primary key, the attributes basic file can be imported.

Import of the detailed attributes can then be performed after that. Again the primary key is important.

[allmart]

Thank you so much. Worked like a charm.

[mc12345678]

Thank you so much. Worked like a charm.

No problem, glad that helped. EP4 was designed with the intention of not "interfering" with any other EP variant, so the constant that was attempted was not picked up because it was for a different variant. For what it's worth and as it appears that you have just started using ZC, I might suggest transitioning to a newer application that reportedly performs the same actions as this code. Reason being is that at least I don't intend on continuing to modify this plugin to address anything other than errors within its described/intended use/operation and to cause two different variants of the same application to exist. This one tends to be "easier" to modify, but perhaps is not as informative (requires reading and understanding the instructions) while the other is easier to use as a store owner, but more intricate for making changes.

I had plans to take this to a more robust state, but have other things to which I can devote my time/interest because that effort has been done independent of EP4.

[Tile Mural Store UK]

Im now getting
File Import Completed.
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.

and multiple variants of the same attribues
19 10.8cm x 10.8cm Tiles 12 Tile Mural Size: 43.2cm x 32.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm

[mc12345678]

Im now getting
File Import Completed.
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.

and multiple variants of the same attribues
19 10.8cm x 10.8cm Tiles 12 Tile Mural Size: 43.2cm x 32.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm
20 10.8cm x 10.8cm Tiles 6 Tile Mural 45.6cm x 30.4cm

Where are the multiple variants being displayed/presented?

What is the format of the import file? Is it comma separated for all of the data? (ie used Open Office as suggested in the early post(s) of this thread?) what was the filename? Complete content of the first couple of lines (obscure any specific business sensitive information if there is any and identify that it was obscured).

[SPython]

Just an update. The problem I had was - as you suggested - to do with configuration errors elsewhere on the server and not with Easy Populate 4.0. Principally it had to do with PHP with which I had missed a final step of linking libraries when I reinstalled it. The circuitous route to realizing that led me to discover and fix other things which were not quite right on the server. So, though it was a frustrating experience, I finally managed to upload a csv of over a thousand entries with Easy Populate 4.0. Thank you for your work on this program and for your advice.

[SPython]

Just an update. The problem I had was - as you suggested - to do with configuration errors elsewhere on the server and not with Easy Populate 4.0. Principally it had to do with PHP with which I had missed a final step of linking libraries when I reinstalled it. The circuitous route to realizing that led me to discover and fix other things which were not quite right on the server. So, though it was a frustrating experience, I finally managed to upload a csv of over a thousand entries with Easy Populate 4.0. Thank you for your work on this program and for your advice.

Typical permissions upon install are 644 for the admin/includes/configure.php file, with suggestion to set to 444 to prevent writing/rewriting. EP4 doesn't modify this file and is only pulled for use by including application_top.php which loads the admin configure.php file. Perhaps something is amiss with the file? But this also further doesn't exactly make sense if this plugin is the only admin tool that is causing this issue. :/

One of the suggestions I came across was to tie to the parent process that appears to be causing the issue and as part of that tie to include a back trace logged error to identify where in execution the error is truly occurring. :/