Help Needed with Easy Populate 4.0.35.

[mc12345678]

Attachment 16499 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.

[LittleAngell52]

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 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.

[mc12345678]

Well I uploaded the file I created and got a nice message to say that the upload has been successful 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.

[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.

[LittleAngell52]

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?

[LittleAngell52]

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.

[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.

[mc12345678]

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.

[LittleAngell52]

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.

[mc12345678]

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&quot; 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&quot; 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?