EasyPopulate 4.0 Support Thread

salvo72:

how modified the file for this

how delete the control

you can give me a support or customize?

Definitely the easypopulate4_import.php file in the admin directory would need revision. The extra_functions file may need some revision as well as possibly the main admin file... There are a few fields that were considered to be always present and were to be loaded at the start of processing. (The description field was one of them, but thtgot modified to preload, but ignore if not present in the data.) There were a few others that made sense and were a good practice to keep in the upload file because they made the line understandable to someone reviewing the file in the future. I think product name was one of them. Can that be coded out? Yes, but to include as an always situation leading to muliple users of the software being confused about the data that is maintained in the file, well that may cause more confusion for the masses instead of the few that would like to only upload two columns...

That may be more of a "one" site item to address instead of something to distribute for all. The description field was made not required because of the problems that were experienced by trying to upload very large amounts of information that wasn't changing each time. That was seen as a problem, not as an inconvenience. I would think that a strong case of removing the few required fields that are currently identified wouuld be appropriate to make that change.

Afterall, it seems that the data was there before, otherwise what was the process used to identify the rows that needed to be revised with the new data?

mc12345678:

Definitely the easypopulate4_import.php file in the admin directory would need revision. The extra_functions file may need some revision as well as possibly the main admin file... There are a few fields that were considered to be always present and were to be loaded at the start of processing. (The description field was one of them, but thtgot modified to preload, but ignore if not present in the data.) There were a few others that made sense and were a good practice to keep in the upload file because they made the line understandable to someone reviewing the file in the future. I think product name was one of them. Can that be coded out? Yes, but to include as an always situation leading to muliple users of the software being confused about the data that is maintained in the file, well that may cause more confusion for the masses instead of the few that would like to only upload two columns...

That may be more of a "one" site item to address instead of something to distribute for all. The description field was made not required because of the problems that were experienced by trying to upload very large amounts of information that wasn't changing each time. That was seen as a problem, not as an inconvenience. I would think that a strong case of removing the few required fields that are currently identified wouuld be appropriate to make that change.

Afterall, it seems that the data was there before, otherwise what was the process used to identify the rows that needed to be revised with the new data?

yes
the data you have loaded a year ago

you can change the fiel import and delete the control that requires me to have more fields validated?

we need to import files for certain products of which we have the description

if you give me your email and if I can give you support sending the file to upload

thanks

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?

Import Results

Filename: PriceQty-EP2014Dec10-103644-TEST.csv
Finished Processing Import File

Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 6688720
Memory Peak: 6938216
Execution Time: 0.00019407272338867 seconds.

ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

Kevin205:

For some reason the Model/Price/Qty does not import data, quantity or price!

I exported the PriceQty-EP2014Dec10-103644.csv, modified and imported it via PriceQty-EP2014Dec10-103644-TEST.csv. As you can see it did not update anything.
Where can I start to find out what is causing this?

ps. I am using Easy Populate 4.0.22 - Beta 6-10-2012 version.

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

salvo72:

yes
the data you have loaded a year ago

you can change the fiel import and delete the control that requires me to have more fields validated?

we need to import files for certain products of which we have the description

if you give me your email and if I can give you support sending the file to upload

thanks

Provided I still have a clickable link in my signature, contact can be made/initiated there to address potential customization of the code.

I am having an issue importing new files using Easy Populate 4.

When I import, it gives me errors for my new products. When I take a look at the debug log, it appears as though it has duplicated my v_products_upc column for each of my entries.

If there is an entry that already exists on my cart, it will update that one correctly, it's only giving an issue for the ones that are new.

I have attached the CSV file in question, as well as a screenshot of the debug log with the upc error. Help!

Attachment #14766

themusicstore:

I am having an issue importing new files using Easy Populate 4.

When I import, it gives me errors for my new products. When I take a look at the debug log, it appears as though it has duplicated my v_products_upc column for each of my entries.

If there is an entry that already exists on my cart, it will update that one correctly, it's only giving an issue for the ones that are new.

I have attached the CSV file in question, as well as a screenshot of the debug log with the upc error. Help!

Attachment #14766

Have you added the upc field as an additional user defined column in your configuration panel? The code should automatically take care of considering that field if it has identified that you have the UPC mod installed (which I would presume you do). So you would remove that field from your configuration area in the admin and now should not have the field populated twice on the import... As for why it doesn't appear twice on the output is because, well, it already was in the data array initially and then when the system checked against the user defined field, it didn't have to do anything because it already existed...

mc12345678:

My suggestion would be to review the csv file that is being provided to EP4/ZC using a plain text editor. Extra spaces before/after a column header, extra row from the top, etc... These types of things can cause the code to bail out. The code does not specifically look for that filename (yes was looking at the version described), but does have some fields that are expected as well. So could maybe provide a line or two from your file captured between code tags that are made by clicking the # symbol in the posting toolbar.

Copied using Notepad++

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

Thank you.

Kevin205:

Copied using Notepad++

v_products_model,v_status,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_products_price,v_products_msrp,v_products_quantity
XTO-7SS420524,1,,,,50,,1
JADI-P00059,1,,,,100,,119
JADI-P00060,1,,,,100,,82
JADI-P00061,1,,,,100,,68

> 
> Thank you.

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there.  I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results.  Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

mc12345678:

Not sure if somewhere in the process of providing the data for posting or if at all present, but there are no double quotes used. Not saying it is a must, but files do get successfully imported when they are there. I would suggest trying the following.m
Keep the first row and the second row. Place double quotes " around each word and double quotes without a space between empty commas with a final "" at the end of each line. Save that file (two lines) and try to upload it and report results. Also can compare the file to be uploaded to the file that was downloaded to see what differences exist in general fomatting.

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".

Thank you.

Kevin205:

Sorry for the trouble. Issue fixed!
They use excel to export the .CSV files, and saved as type MAC instead of MS-DOS. Even though they look the same in Notepad++, it wasn't importing.

Furthermore files export with "", but it can be imported without the "".

Thank you.

No problem, glad the issue has been resolved. Biggest issue I've seen with using Excel and EP4 has been the date format needs to be properly situated so that ZC accepts the input. OO seems to address it without issue. :)

Love this plugin and have used it for many years! I have it installed and working on my newly upgraded version 1.5.3. Thank you! I've downloaded my complete products file of almost 23,000 items - Complete Products (with Metatags). In the past I have used this file to modify and send to google, bing, etc. using the the Froogle download option. Of course they ask for the item URL. Since the v_products_url_1 column is not populated it will not work. Is there a way to download URLs for each product in the file? I've seen the Google product feeder but want to sort and submit different items to each search engine.

Keith z,
If not mistaken, the version 4.0.27+ discussed at this post: http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1263574#post1263574
Offers the capability to export the uri of the product. By default (after installation of EP4) this option is actually turned off. The product_uri_1 field you are seeing is the uri field at the bottom of a product entry form that would be displayed near the product when the product page is shown. It is not the uri that the browser displays say from the categories section to get to the product. Further the number 1 at the end identifies which language version of the field is being displayed. The product_uri field is available in multiple languages depending on what is installed to the cart.

So, to export the uri that is found in the browser when navigating to a product, would need to go to the admin's configuration for EP4 and turn the switch on ('Export URI with Prod and or Cat') that relates to displaying the product's uri. :) This option should be the last in the list of configuration options for EP4.

Thank you mc12345678. I am having trouble finding that switch. Here are the choices I have from my configuration screen. The last one allows me to enter User Defined Products Table Fields (comma delimited, no spaces). It is currently blank. Should I enter the header row columns here?

Title Value Action
Uploads Directory temp/ Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Upload/Download Prices Include Tax false Info
Verbose Feedback true Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Maximum Quantity Discounts 3 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields

keith z:

Thank you mc12345678. I am having trouble finding that switch. Here are the choices I have from my configuration screen. The last one allows me to enter User Defined Products Table Fields (comma delimited, no spaces). It is currently blank. Should I enter the header row columns here?

Title Value Action
Uploads Directory temp/ Info
Upload File Date Format m-d-y Info
Default Raw Time 09:00:00 Info
Upload/Download Prices Include Tax false Info
Verbose Feedback true Info
Make Zero Qty Products Inactive false Info
Smart Tags Replacement of Newlines true Info
Advanced Smart Tags false Info
Debug Logging true Info
Maximum Quantity Discounts 3 Info
Split On Number of Records 2000 Info
Script Execution Time 60 Info
Convert Curly Quotes, etc. 0 Info
Convert Character 0x92 1 Info
Enable Products Meta Data 1 Info
Enable Products Music Data 0 Info
User Defined Products Fields

Nope.

Goto tools->Easy Populate v4
Top right corner select uninstall (this will lead to the default settings of the menu just posted above),
Then select install from the center of the screen. Goto the configuration menu for EP4 and as necessary re-enter the values shown above.
The last option is as described.

You do see that while in the tools->ep4 menu option that the version is 4.0.27 (or higher) correct?
Alternatively, it is possible to run a single sql statement for that one option, but the above process is preferred.

Mine is Easy Populate 4.0.24 - Beta 7-15-2014. Sorry show have listed that before.

keith z:

Mine is Easy Populate 4.0.24 - Beta 7-15-2014. Sorry show have listed that before.

No problem, follow the link posted above to download version 4.0.27 (or whatever has been incorporated/posted by me) unfortunately chadderuski and I do not pay for service on that site, so we can't upload each other's content to the other site. Therefore, for now the code is a little out of sync between the two of us. I keep mine up-to-date with whatever is posted to the "main" version, but continue to add functionality as identified.

Most of the upgrades recently did not affect configuration menu options and therefore the code could simply be copied over the existing, but this upgrade added a menu option and at the moment that requires a soft "uninstall" and reinstall without removing the files.

Hi everyone, new to the forum.

I have EP4 and it is great except for working out the categories. In my old shop I have v_categories_name_1 and v_categories_name_2. Example is

v_categories_name_1..........v_categories_name_2
Audio & Video.....................Acoustic Foam
Audio & Video.....................Acoustic Foam
Audio & Video.....................Acoustic Foam

There are about 1350 items and many categories and sub categories. I understand how the Audio & Video^Acoustic Foam works but how can I import all these items without having to edit 1300+ lines of my spread sheet?

Is there a way to add the other category and upload like I did with the old version of Easy Populate? The reason I am using EP$ is that the other will not work on my new server due to the PHP version etc.

Hope someone can help.

Mike :)

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.

Mikec87:

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.

To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...