EasyPopulate 4.0 Support Thread

[mc12345678]

UPDATE:

So I ran the test purchase and everything "looks" like it is there, t shows me the attributes attached to the product, but there is no actual zip file t download at the end of the checkout.

It only takes me to a page that says: "Please notify me of updates to these products" if I go into My Account, it does not show the download button there either.

I feel that I am so close to getting this, I am just not there yet and not sure what I am missing.

If you want to take a look, the site is: http://studiorockcreek.com/shop/ and it's the product marked FREE.

Thanks. :)

What were the results of downloading the detailed attributes file? It seemed that there were more fields in there that would accomplish what you are trying to do, and the way the code appears to be written it includes download (and subsequent upload) of the information needed to populate/activate the download. Perhaps another question is, the file that is "linked" to the product, does it exist where it is supposed to be and named the way it is supposed to be on the server?

[JNR345]

I'm having a strange issue that I've been working on for days and I just cannot figure out. I've been using EasyPopulate with no problems until I recently tried to import some new products. I've never had this issue before, but this time when I imported new items everything is perfect except all the new items' images are distorted.

And when you you click on the "large image" link on the product page of one of the new items the same small distorted image is shown (it doesn't enlarge). But if you right-click on the small image and select "view image" the whole large image is shown.

So for some bizarre reason it is shrinking and distorted the images of any newly imported items (but for the other items that are already in the database the images are not distorted, only the new items). I have the Configuration/images settings the same as I've always had them, and as I said, the old products are still displaying the correct image sizes and nothing is wrong there (only new items are affected). This is the only issue with importing new items -- everything works perfectly except it is messing up my images.

I've even tried to zero in on the problem by removing most entries in the CSV file (such as v_manufacturers_name, v_metatags_description_1, etc), leaving just the bare minimum (v_products_model, v_products_image, v_products_name_1, etc). I even removed most products in the file except for five (thinking maybe some character such as * somewhere was causing problems). But none of this matters. No matter how small the CSV file is the images always come out distorted and the "large image" link doesn't show the large image (even though it is there on the server).

And, I've tried re-uploading the images but they are fine. I upload in binary, and image folder permission is correct (all other old products have no problem showing the image correctly). Something is going on in EasyPopulate that is telling it to shrink my images.

What is strange as I've always imported new products using EasyPopulate and never encountered this problem. Thank you for any help anyone can offer!

I'm using Zen Cart 1.5.1, and EasyPopulate 4.0

[amandavz]

If I download the Detail list and try to add the proper information in the proper fields (same as I did with the basic) I get the same error:

File Import Completed with issues.
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

I am only adding information to the fields I need:

v_products_model: 1
v_products_options_name: Download 1
v_products_options_values_name: Zip 1
v_products_attributes_filename: test.zip
v_products_attributes_maxdays: 90
v_products_attributes_maxcount: 5

Does the entire sheet need to be populated with content? Like 0 in the fields I don't need? This worked perfectly in the Basic list but with no actual zip file to download.

To answer your other question...I'm not sure what you mean by "linked"...if you're asking if I have the zip file attached to the product, no I do not. That's what I hoping to do with this module. I do have the test.zip uploaded into the downloads folders in the back end of my Zen Cart and named the same on the downloaded spreadsheet.

[mc12345678]

If I download the Detail list and try to add the proper information in the proper fields (same as I did with the basic) I get the same error:

File Import Completed with issues.
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

I am only adding information to the fields I need:

v_products_model: 1
v_products_options_name: Download 1
v_products_options_values_name: Zip 1
v_products_attributes_filename: test.zip
v_products_attributes_maxdays: 90
v_products_attributes_maxcount: 5

Does the entire sheet need to be populated with content? Like 0 in the fields I don't need? This worked perfectly in the Basic list but with no actual zip file to download.

To answer your other question...I'm not sure what you mean by "linked"...if you're asking if I have the zip file attached to the product, no I do not. That's what I hoping to do with this module. I do have the test.zip uploaded into the downloads folders in the back end of my Zen Cart and named the same on the downloaded spreadsheet.

Was an error file created in your list of download files? Something that shows the SQL code? I've been writing some independent mods so my version of the SQL code may have been corrected if there was in fact an error the original (remember beta) code.

As for my discussion of a "linked" product, what you described is what I was asking about: that the file exists on your server as it is expected on your server. It does appear that the issue is related to the upload of the detailed attributes file. This is the file that will "finish" your process. So somehow need to get that fixed. The error message seems to ask for the file to be searched for extra tabs in the data (like the tab key has been pressed), as for zeroing out or omitting data, it is possible, that this plugin will remove entered data if a field has been deleted from the file. Best way to maintain data is to download what is there, change data of things desired to change, then upload.

I'm not at a computer at the moment to test a single upload.

[amandavz]

This is the TXT error I get when I add JUST the fields I want to use:

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
products_id = AND
options_id = AND
options_values_id =
' at line 3
When executing:
SELECT * FROM zhs_products_attributes
WHERE (
products_attributes_id = AND
products_id = AND
options_id = AND
options_values_id =
) LIMIT 1

I tried adding it with all the fields populated after attaching a zip file to a product and THEN downloading the detailed csv file. It shows me the proper format of each field but also gives me an error message reading SKIPPED!! and something about Attributes not attached to model. I don't quit remember off hand, but it never generated a TXT error file.

[mc12345678]

I'm having a strange issue that I've been working on for days and I just cannot figure out. I've been using EasyPopulate with no problems until I recently tried to import some new products. I've never had this issue before, but this time when I imported new items everything is perfect except all the new items' images are distorted.

And when you you click on the "large image" link on the product page of one of the new items the same small distorted image is shown (it doesn't enlarge). But if you right-click on the small image and select "view image" the whole large image is shown.

So for some bizarre reason it is shrinking and distorted the images of any newly imported items (but for the other items that are already in the database the images are not distorted, only the new items). I have the Configuration/images settings the same as I've always had them, and as I said, the old products are still displaying the correct image sizes and nothing is wrong there (only new items are affected). This is the only issue with importing new items -- everything works perfectly except it is messing up my images.

I've even tried to zero in on the problem by removing most entries in the CSV file (such as v_manufacturers_name, v_metatags_description_1, etc), leaving just the bare minimum (v_products_model, v_products_image, v_products_name_1, etc). I even removed most products in the file except for five (thinking maybe some character such as * somewhere was causing problems). But none of this matters. No matter how small the CSV file is the images always come out distorted and the "large image" link doesn't show the large image (even though it is there on the server).

And, I've tried re-uploading the images but they are fine. I upload in binary, and image folder permission is correct (all other old products have no problem showing the image correctly). Something is going on in EasyPopulate that is telling it to shrink my images.

What is strange as I've always imported new products using EasyPopulate and never encountered this problem. Thank you for any help anyone can offer!

I'm using Zen Cart 1.5.1, and EasyPopulate 4.0

So when you say that the other "old products" have no problem showing the image(s) was this determined by uploading the new image in place of/in addition to an existing image of an old product? (Ie, if old product image is renamed, and new image uploaded with old image name, then that new image shows properly on an old product, but that same image doesn't show properly with a new product?)

EP4 does not actually affect images, it loads the base name(s) into the database. Generally speaking EP4 has little to nothing to do with the problem you are describing (note that a link has not been provided for us to inspect).
Might also help to identify the data uploaded for the offending product, ie pathname provided for the image(s). As typically and assuming you are not using an image handler, the base file is provided to the database, and your large file is uploaded with the appropriate extension before the suffix file type I think it is _LRG (or maybe it's _LARGE) I use an image handler that doesn't require uploading a filename with such an extension, so I forget the proper format.

[mc12345678]

This is the TXT error I get when I add JUST the fields I want to use:

MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
products_id = AND
options_id = AND
options_values_id =
' at line 3
When executing:
SELECT * FROM zhs_products_attributes
WHERE (
products_attributes_id = AND
products_id = AND
options_id = AND
options_values_id =
) LIMIT 1

I tried adding it with all the fields populated after attaching a zip file to a product and THEN downloading the detailed csv file. It shows me the proper format of each field but also gives me an error message reading SKIPPED!! and something about Attributes not attached to model. I don't quit remember off hand, but it never generated a TXT error file.

Also, to answer one of the questions, what you are missing? Well, each of the file types has been provided for a purpose. A basic file will address things that relate to the file type, like basic attributes addresses the existence of an attribute in the database and that the attribute has a relationship with the product (by model number of course), while a detailed attribute assigns data associated with the attribute and all of it's details to the specific product (by model name of course). The basic attribute file is used to give the selection of a file or whatever value(s) that are assigned. The actual file data would be handled in the detailed attributes (this data is also in a different database table than the data associated with the basic attributes.

And let me describe another way. ZC is made up of data associated with other "previous" data. That's why the operator must first enter a product, then enter attributes associated with that product, then identify specific detail about how that attribute affects the product. Each building on the next.

I started the above earlier, but hadn't sent it. Now it appears applicable.

First you need to do a basic attribute upload for your product, (which you did thinking that all of the new data was incorporated to find that not so.), then download a detailed attribute file, mod what you want modded (ie, add the filename, number of downloads, etc.), and upload the resulting file. There's no need to remove columns and in some cases removal of a column will prevent it from working.

The txt file you uploaded reflects that: it was looking for data specifically needed to make the upload work as seen by the blank between = and AND.

[JNR345]

Thanks for your response.

I have a store with products that all show the images properly. Now when I add new products (completely new, not updating or replacing any aspects of the old products), the new products' images are all distorted and small (the old products remain the correct size). It appears something in EasyPopulate is telling it to change the image size (smaller, and distorts it, and the "large image" doesn't display the large image unless you right-click on the image and select "view image").

All the images have unique names (for example SPFF84.jpg). All images go in the main directory "images" (like always, I don't use a separate sub-folder for Large or Medium images). None of the new images are replacing old images. It is showing the correct image for every item, just distorting it. I've imported new products before with no problem so that is why this is all very strange. I can't figure out how EasyPopulate is doing this to the images. Everything works perfectly in the CSV files except for it resizing the images. What is it in the CSV file that is telling it to shrink the images? Every single new image gets affected.

[JNR345]

Also, interestingly, when I click the edit button for one of these new items and simply click Save (without changing any of the fields at all), then the new image suddenly shows perfectly for that product. What does that mean?

[amandavz]

Also, to answer one of the questions, what you are missing? Well, each of the file types has been provided for a purpose. A basic file will address things that relate to the file type, like basic attributes addresses the existence of an attribute in the database and that the attribute has a relationship with the product (by model number of course), while a detailed attribute assigns data associated with the attribute and all of it's details to the specific product (by model name of course). The basic attribute file is used to give the selection of a file or whatever value(s) that are assigned. The actual file data would be handled in the detailed attributes (this data is also in a different database table than the data associated with the basic attributes.

And let me describe another way. ZC is made up of data associated with other "previous" data. That's why the operator must first enter a product, then enter attributes associated with that product, then identify specific detail about how that attribute affects the product. Each building on the next.

I started the above earlier, but hadn't sent it. Now it appears applicable.

First you need to do a basic attribute upload for your product, (which you did thinking that all of the new data was incorporated to find that not so.), then download a detailed attribute file, mod what you want modded (ie, add the filename, number of downloads, etc.), and upload the resulting file. There's no need to remove columns and in some cases removal of a column will prevent it from working.

The txt file you uploaded reflects that: it was looking for data specifically needed to make the upload work as seen by the blank between = and AND.

Okay...So I added a zip file to a product in the store, downloaded the detailed csv file, added a couple of more products with the same format that was on the spreadsheet, saved it, uploaded it into the Easy Populate and clicked the Import link and got this for an errors:

Located at the top of the page:
File Import Completed with issues.

Located at the bottom of the page:
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!

It's telling me there were 2 errors detected but generated no TXT file with them...

I do appreciate your thorough explanation of how this works and I understand what you are saying. I appreciate it because if I can get this figured out this will be a very useful tool moving forward for future installs. :)