Help Needed with Easy Populate 4.0.35.

When I upload my csv file to my store I am getting what is show on the image below which I generated on Easy Populate. Now if i was to make up my own csv file using the same v_products_model and so on would it work? Can you use excel as that is what I have and save the file as csv?

LittleAngell52:

When I upload my csv file to my store I am getting what is show on the image below which I generated on Easy Populate. Now if i was to make up my own csv file using the same v_products_model and so on would it work?

As identified in the Ep4 forum thread a recent update was pushed that allowed stores without the original suggested/required software to use EP4. There was a coding bug introduced. The bug patch was posted, it also has been incorporated into a github version of the software that is to be uploaded to ZC. That version can be found at https://github.com/mc12345678/EasyPopulate-4.0/tree/v4.0.35.ZC.1 and from there downloaded as the patch to the above "issue" (which also would be resolved if the host had multi-byte related software installed) as well as some other minor things.

mc12345678 I saw your pm and that is the version I have up on my store. I have been trying to get this plugin for ages and cos I got a new computer I had realized that the update has been out since April. I just cant undersand why it skipped everything.

LittleAngell52:

mc12345678 I saw your pm and that is the version I have up on my store. I have been trying to get this plugin for ages and cos I got a new computer I had realized that the update has been out since April. I just cant undersand why it skipped everything.

Well, it would seem likely to be related to the import file as it seems that almost the entire text of the row is being considered as the v_products_model field...

And actually when looking at the fuzzy picture closer, it appears that it is complaining that the v_products_model field is too long, not as reported in the forum where the category field was too long...

The screen output (**SKIPPED! - Model: **%s - Products model exceeds max. length: %s) is supposed to show the model information and the expected size. Above, it looks like the model information is a very long line of text... This has to do with the import file typically, which may relate to how it was generated...

mc12345678:

Well, it would seem likely to be related to the import file as it seems that almost the entire text of the row is being considered as the v_products_model field...

And actually when looking at the fuzzy picture closer, it appears that it is complaining that the v_products_model field is too long, not as reported in the forum where the category field was too long...

The screen output (**SKIPPED! - Model: **%s - Products model exceeds max. length: %s) is supposed to show the model information and the expected size. Above, it looks like the model information is a very long line of text... This has to do with the import file typically, which may relate to how it was generated...

Yes it has been all quashed together and why I don't know. So I have got the file open in excel and I am copying each cell on line 1 and send you the blank csv file just to make sure its correct then if you ok it I will then will use that as a template.

mc12345678:

Well, it would seem likely to be related to the import file as it seems that almost the entire text of the row is being considered as the v_products_model field...

And actually when looking at the fuzzy picture closer, it appears that it is complaining that the v_products_model field is too long, not as reported in the forum where the category field was too long...

The screen output (**SKIPPED! - Model: **%s - Products model exceeds max. length: %s) is supposed to show the model information and the expected size. Above, it looks like the model information is a very long line of text... This has to do with the import file typically, which may relate to how it was generated...

This is what I am getting in each Cell

Meaning one cell has all of that? or the data has been taken from text to columns?

One thing of note, Excel does not make it easy to save in UTF-8 CSV format. Open Office and I think there is another open source product that does make it easy. Typical process of using Excel with EP4 includes saving it in one format, then opening it up with another application to save it as another, ultimately so that all of the proper "markings" are applied. Unfortunately an Excel handler has not been built into EP4, but that is not to say that it can't be used... Suggest an internet search on 'export Excel to UTF-8 CSV format'.

mc12345678:

Meaning one cell has all of that? or the data has been taken from text to columns?

One thing of note, Excel does not make it easy to save in UTF-8 CSV format. Open Office and I think there is another open source product that does make it easy. Typical process of using Excel with EP4 includes saving it in one format, then opening it up with another application to save it as another, ultimately so that all of the proper "markings" are applied. Unfortunately an Excel handler has not been built into EP4, but that is not to say that it can't be used... Suggest an internet search on 'export Excel to UTF-8 CSV format'.

Yes that is what I mean. I do know that excel does save as CSV but it not a problem to use open office as I downloaded it last night. So I am trying to split everything out into the correct groups and upload it to my store.

mc12345678:

Well, it would seem likely to be related to the import file as it seems that almost the entire text of the row is being considered as the v_products_model field...

And actually when looking at the fuzzy picture closer, it appears that it is complaining that the v_products_model field is too long, not as reported in the forum where the category field was too long...

The screen output (**SKIPPED! - Model: **%s - Products model exceeds max. length: %s) is supposed to show the model information and the expected size. Above, it looks like the model information is a very long line of text... This has to do with the import file typically, which may relate to how it was generated...
I have just added the easy populate file so you could see what it looked like

mc12345678:

Meaning one cell has all of that? or the data has been taken from text to columns?

One thing of note, Excel does not make it easy to save in UTF-8 CSV format. Open Office and I think there is another open source product that does make it easy. Typical process of using Excel with EP4 includes saving it in one format, then opening it up with another application to save it as another, ultimately so that all of the proper "markings" are applied. Unfortunately an Excel handler has not been built into EP4, but that is not to say that it can't be used... Suggest an internet search on 'export Excel to UTF-8 CSV format'.

Well the last file I uploaded was the file that Easy Populate created. Now here is the file I created can you check if I did this correct I have added 2 of my products to the file and I don't want to carry on and find out that i gone wrong some where. :smile:

LittleAngell52:

I have just added the easy populate file so you could see what it looked like
There is something "unusual" with the data in the products_model field... if that file was exported by EP4 and not yet touched/modified, then there is definitely something amiss. It is possible to correct it with EP4, but will have to take a look at the file provided from a computer.

mc12345678:

There is something "unusual" with the data in the products_model field... if that file was exported by EP4 and not yet touched/modified, then there is definitely something amiss. It is possible to correct it with EP4, but will have to take a look at the file provided from a computer.

Well I uploaded the file I created and got a nice message to say that the upload has been successful:smile: so if I use the one I created until we have worked out how to fix the error. So sorry for being a pain but I don't know much about php.

LittleAngell52:

Well I uploaded the file I created and got a nice message to say that the upload has been successful:smile: so if I use the one I created until we have worked out how to fix the error. So sorry for being a pain but I don't know much about php.
Uploaded or imported? They are two different things.

I suspect when you try to import what was posted above, that you will come across an issue again. The problem(s) are not directly php related, although if the import file will always be prepared as has been, then php could be used/modified to make it work.

See, a csv file typically is made up of things separated by commas, the file(s) presented have semi-colons between fields. Then at the end of the first row is several more semi-colons with no fields associated.

You want your upload file to "look" similar to your download file. This is when the download file is opened in a plain text editor, not something like excel or open office.

Upload puts the file on the server. Import processes the uploaded file and tries to apply it to the store. The two have been maintained separate to minimize errors of say selecting the wrong file to upload.

mc12345678:

Uploaded or imported? They are two different things.

I suspect when you try to import what was posted above, that you will come across an issue again. The problem(s) are not directly php related, although if the import file will always be prepared as has been, then php could be used/modified to make it work.

See, a csv file typically is made up of things separated by commas, the file(s) presented have semi-colons between fields. Then at the end of the first row is several more semi-colons with no fields associated.

This is what I did. I login to my admin center and went to Tools/Easy Populate 4. Under Upload EP File I search on my pc for the file and upload it once has uploaded I get a success message. I scroll down the page and look for the file i just uploaded and then click on Import. Is that correct?

mc12345678:

You want your upload file to "look" similar to your download file. This is when the download file is opened in a plain text editor, not something like excel or open office.

Upload puts the file on the server. Import processes the uploaded file and tries to apply it to the store. The two have been maintained separate to minimize errors of say selecting the wrong file to upload.

how do i do that then. I am lost now.

Now I am getting this error. No model field in record. This line was not imported How can I create my own file to work on EP I am getting lost. If EP would just create a poper file then I have something to work on. As I said before I don't know much about php. I can edit it if I was told how to do it.

LittleAngell52:

This is what I did. I login to my admin center and went to Tools/Easy Populate 4. Under Upload EP File I search on my pc for the file and upload it once has uploaded I get a success message. I scroll down the page and look for the file i just uploaded and then click on Import. Is that correct?

Yes that is the correct sequence of operations to import a data file to the database.

mc12345678:

Yes that is the correct sequence of operations to import a data file to the database.

I just realized something. I have got no model numbers so I am going to added them to the store by hand then see if it produce a EP spreadsheet that I can edit. So give a day or so to do this. I will reply in this post or do you want me to pm you if its worked or not.

LittleAngell52:

Now I am getting this error. No model field in record. This line was not imported How can I create my own file to work on EP I am getting lost. If EP would just create a poper file then I have something to work on. As I said before I don't know much about php. I can edit it if I was told how to do it.

EP4 does create a proper file... It is before it gets brought into Excel or any other editor. Once modified and then saved again is the issue...

EP4 creates a plain text file that has a list of fields in the first row, each field separated by a comma. Then in the second and subsequent rows the data for each field applies... This has nothing to do with PHP.

Here is an example of a file created by EP4 on a system that had two languages and the demo product installed, though not really "translated yet" as viewed from a plain text editor and will import just fine with EP4:

"v_products_model","v_products_type","v_products_image","v_products_name_1","v_products_description_1","v_products_url_1","v_products_name_2","v_products_description_2","v_products_url_2","v_specials_price","v_specials_date_avail","v_specials_expires_date","v_products_price","v_products_weight","v_product_is_call","v_products_sort_order","v_products_quantity_order_min","v_products_quantity_order_units","v_products_priced_by_attribute","v_product_is_always_free_shipping","v_date_avail","v_date_added","v_products_quantity","v_manufacturers_name","v_categories_name_1","v_categories_name_2","v_tax_class_title","v_status","v_metatags_products_name_status","v_metatags_title_status","v_metatags_model_status","v_metatags_price_status","v_metatags_title_tagline_status","v_metatags_title_1","v_metatags_keywords_1","v_metatags_description_1","v_metatags_title_2","v_metatags_keywords_2","v_metatags_description_2"
"MG200MMS","1","matrox/mg200mms.gif","Matrox G200 MMS","Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.<br /><br />With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br /><br />Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.","www.matrox.com/mga/products/g200_mms/home.cfm","Matrox G200 MMS","Reinforcing its position as a multi-monitor trailblazer, Matrox Graphics Inc. has once again developed the most flexible and highly advanced solution in the industry. Introducing the new Matrox G200 Multi-Monitor Series; the first graphics card ever to support up to four DVI digital flat panel displays on a single 8" PCI board.<br /><br />With continuing demand for digital flat panels in the financial workplace, the Matrox G200 MMS is the ultimate in flexible solutions. The Matrox G200 MMS also supports the new digital video interface (DVI) created by the Digital Display Working Group (DDWG) designed to ease the adoption of digital flat panels. Other configurations include composite video capture ability and onboard TV tuner, making the Matrox G200 MMS the complete solution for business needs.<br /><br />Based on the award-winning MGA-G200 graphics chip, the Matrox G200 Multi-Monitor Series provides superior 2D/3D graphics acceleration to meet the demanding needs of business applications such as real-time stock quotes (Versus), live video feeds (Reuters & Bloombergs), multiple windows applications, word processing, spreadsheets and CAD.","www.matrox.com/mga/products/g200_mms/home.cfm",,,,"299.99","23","0","0","1","1","0","0",,"2003-11-03 12:32:17","31","Matrox","Hardware^Graphics Cards","Hardware^Graphics Cards","Taxable Goods","1","0","0","0","0","0",,,,,,

If your product does not have information in the products_model field, then you will need to change the primary key to either products_id or new_blank so that when uploading the software can find a unique record to which to apply the data...

BTW, I thought that this was something that was previously in use but had been seen as an upgrade?