Printable View
Easy Populate 4
Back to having issues, this program has yet to work correctly. Any help on what I am doing wrong would be greatly appreciated!! I keep getting this error:
No model field in record. This line was not imported
What am I doing wrong to get this error?
I have uploaded the csv with nothing in the v_products_model column, then again with the same thing for every product, then with different things for each product but i'm getting this message every time.
Is there any export/import type that includes both v_customid and v_options_values_price? Attrib-Detailed and SBA-Detailed both fall short. Mass updates of price by customid, like stock by customid, would be a killer feature.
So the easiest way to identify the issue is to provide an example csv data row (including header) for a row of data not importing. (Please place contents between CODE tags generated by clicking # in the toolbar.)Quote:
Originally Posted by ExtensiveEnterprises
Every item being added/modified must have a model # in the file. Product in the database with the matching model# will be updated. Now that said, there are some languages that have proven to be problematic with the process. What language(s) are being used? Also the charset of the database canbe an issue as EP4 is designed to work UTF8 throughout just like later versions of ZC are.
V_customid was only offered under the SBA import/export file. That file was originally generated for a very specific reason (stock quantities basically) that said, it seems that the v_options_values_price might be able to be combined in a sense, though it seems as if it would only apply for product that have a single attribute, or if not just single that multiple attributes will become a bit more complex/error prone.Quote:
Originally Posted by SHK
One could argue that the SBA listing falls short in that it doesn't allow editing of the order history or more directly the product description. The database is a relational database, there are things that relate to one another throughout the database, but the relationship may not be the best suited for the majority. And yes some ofthat determination is made by those that support the software. Custom mods are likely to occur that might combine certain aspects, but with the minimal documentation currently available it seems like it would be unwise to offer that particular feature at this time. Besides, what factors are involved to need to update those values so frequently? Is there not some other relationship used that would facilitate the price update of attributes?
Actually I might be able to give you some insight on this "no model field in record". I fought with it on all of the EPs over the years. After fighting again I looked, and sure enough. The delimiters were not right when I saved.
Using Openoffice,
Save As> under the options check "Edit Filter Settings", and then when the box comes up, even if it set right (comma delimiter, and "" for text), be sure to check "quote all text cells". Then save.
This has been my exact problem every single time I have fought with this issue, and I kept forgetting about it the next time I worked with files. It has always worked like a charm once I figured out my delimiters were screwy for each one I was working with.
Hope it helps.
Hi
Question error for upload.
Using Open office
Server Upload Failure could not be uploaded due to a server issue. Check that the file size being uploaded does not exceed the maximum for your PHP server configuration in php.ini, and file uploads are permitted. Contact your web host if you cannot resolve this issue.
Easy populate 3.0.3
http://www.filedropper.com/csvzencart0515prova
<a href=http://www.filedropper.com/csvzencart0515prova><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >upload files free</a></div>
Regard
Hi
Question error for upload.
Using Open office
Server Upload Failure could not be uploaded due to a server issue. Check that the file size being uploaded does not exceed the maximum for your PHP server configuration in php.ini, and file uploads are permitted. Contact your web host if you cannot resolve this issue.
Easy populate 3.0.3
http://www.filedropper.com/csvzencart0515prova
Regard
Besides the fact that the link is broken, this thread is for EasyPopulate v4 not version 3.0.3. An upload issue such as described is likely to be resolved by splitting your file so that it is smller or as suggested by the error message increasing the maximum upload file size.
Otherwise don't know what thread to access for EasyPopulate v 3.0.3, but if you go to the first post of this thread you can download EasyPopulate v 4.
Hi, new to EP4 and Zen Cart in general. I'm exporting ~1500 records from my old storefront into Zen Cart. I loaded EP4 with little hassle, formatted my data in OO to fit your example, uploaded it to the temp/ folder on my site, chose the import option from the admin->tools->EP4 page, got a green bar at the top saying it was imported successfully, yet I see no items added to my catalog nor do they display in my shopping cart. Any ideas on what I may have messed up on? Or will it take a bit to populate? I appreciate the help in advance!
It has been a few years since I used ezpopulate but I remember it showing the records as they came in, or the products I should say. You can also use phpmyadmin from you cpanel to see if anything was entered but it prob wasn't if you don't see anything.
Did you try adding one or two items into zencart directly and then using ezpopulate to export the data? You can then use this as a master file to compare w the file u are using.