lcanania Posted June 16, 2009 Posted June 16, 2009 All - I am having no success at importing the manufacturer_URL and manufacturer_image via EP. I named the column headers in the same fashion, E.G.: v_manufacturer_image v_manufacturer_URL , etc. I also tried: v_manufacturer_image_1 and also v_manufacturer_image_1_1 Your help would be very much appreciated! Probably a very easy fix for you all. Thanks in advance, Lance (Dying in Chicago!) Quote
♥geoffreywalton Posted June 16, 2009 Posted June 16, 2009 Lance Did you read the instructions that come with the contribution? I believe it explains how to update additional fields. G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
lcanania Posted June 16, 2009 Author Posted June 16, 2009 Well, this sample from the documentation looks, not sure, to be related to adding additional fields for the product. So v_products_model exists in the CSV. I have v_manufacturer_image in the CSV. So....if I'm on track here then I need the id and value. Both of which I do not know how to find out. Any help? Extra Fields Contribution (Please ignore if you do not have this contribution installed) -------------------------------------- There is no option to download product options using EP. To use EP to add and maintain Extra Fields create a file with the following columns. 'v_products_model' The model number for the product. You must add this to each line and all v_products_model must be unique. 'v_products_extra_fields_name' Case sensitive name of the extra Field. Must be exactly the same as the name of the extra field in the admin area. 'v_products_extra_fields_id' This is the tricky one, it is the extra fields ID. You will probably need to use PHPMyAdmin to find out what it is. 'v_products_extra_fields_value' The value you want for the extra field. Quote
♥geoffreywalton Posted June 16, 2009 Posted June 16, 2009 That bit is for updating the product extra fields table // The following setup will allow you to define any additional // field into the "products" and "products_description" tables // in your shop. If you have installed a custom contribution // that adds fields to these tables you may simply and easily add // them to the EasyPopulate system. Set up a product on your shop and download a file, see if the fields are already being processed by EP. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
lcanania Posted June 17, 2009 Author Posted June 17, 2009 I did that, and the manufacturers_image and manufacturers_URL fields are not being processed. Manufacturers_name is being processed however. v_products_model v_products_name_1 v_manufacturers_name EOREOR I would imagine the process would be similiar though. I am just not experienced enough at this point. These two fields are the only thing I'm having an issue with. EP works great, and until I found it I just beat my head against the wall trying to get data uploaded. Quote
WebDev22 Posted June 17, 2009 Posted June 17, 2009 I'm having a similar problem trying to upload a CSV with six custom fields. I set up easypopulate.php according to instructions but it seems something is being left out. I might end up using phpMyAdmin. Meanwhile, I added the six custom fields to admin/categories.php and am able to individually add items through admin, but what a long process for the number of items we have in our CSV file. Quote
♥geoffreywalton Posted June 17, 2009 Posted June 17, 2009 So did you go and find the section in the documentation for how to update new fields? Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
WebDev22 Posted June 17, 2009 Posted June 17, 2009 So did you go and find the section in the documentation for how to update new fields? Indeed I did. The documentation starting on line 245 in easypopulate.php appears to be very thorough but something is amiss. Is there perhaps more documentation I could read besides this: // ******************** // ** products table ** // Lets say you have added a field to your "products" table called // "products_upc". The header name in your import file will be // called "v_products_upc". Then below you will change the line // that looks like this (without the comment double-slash at the beginning): // $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export // // TO: // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC' ); // // If you have multiple fields this is what it would look like: // $custom_fields[TABLE_PRODUCTS] = array( 'products_upc' => 'UPC', 'products_restock_quantity' => 'Restock' ); // // ******************************** Quote
♥geoffreywalton Posted June 17, 2009 Posted June 17, 2009 What is amiss? Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
WebDev22 Posted June 17, 2009 Posted June 17, 2009 What is amiss? I've created a CSV file with custom fields, however, when I use the Easy Populate tool, in Admin, it won't import my custom fields. I made all the necessary additions to the code for easypopulate.php and can't figure out why these fields aren't being imported. Quote
♥geoffreywalton Posted June 17, 2009 Posted June 17, 2009 (edited) perhaps if you post the first 3 lines of import file and the code changes you made..... Edited June 17, 2009 by geoffreywalton Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
WebDev22 Posted June 17, 2009 Posted June 17, 2009 perhaps if you post the first 3 lines of file the code changes you made..... Thanks for taking a look. Here it is: // $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export $custom_fields[TABLE_PRODUCTS] = array( 'products_length' => 'Length', 'products_end' => 'End', 'products_wattage' => 'Wattage', 'products_reflector' => 'Reflector', 'products_uvb' => 'UVB', 'products_rated' => 'Rated' ); $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export Quote
♥geoffreywalton Posted June 17, 2009 Posted June 17, 2009 Missed a few words perhaps if you post the first 3 lines of import file and the code changes you made..... What happens when you import the file? Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
WebDev22 Posted June 17, 2009 Posted June 17, 2009 Missed a few words perhaps if you post the first 3 lines of import file and the code changes you made..... What happens when you import the file? Here are the first and only four lines of the test CSV I created. When I import the file, everything gets imported except for the six custom fields: v_products_model,v_products_length,v_products_end,v_products_wattage,v_ products_reflector,v_products_uvb,v_products_rated,v_categories_name_1_1,v_catego ries_name_1_2,v_products_name_1,v_products_price,v_products_weight,eoreor test0004a,F73,RDC,120,N,5.5,1200,Radiance Lamps,Radiance Test,Radiance Test Product 004,16.95,1,eoreor test0005a,F71,BP,100,N,3.0,1200,Radiance Lamps,Radiance Test,Radiance Test Product 005,14.95,1,eoreor test0006a,F59,BP,80,N,5.0,1200,Radiance Lamps,Radiance Test,Radiance Test Product 006,14.95,1,eoreor Here is the modified code from easypopulate.php: // $custom_fields[TABLE_PRODUCTS] = array(); // this line is used if you have no custom fields to import/export $custom_fields[TABLE_PRODUCTS] = array( 'products_length' => 'Length', 'products_end' => 'End', 'products_wattage' => 'Wattage', 'products_reflector' => 'Reflector', 'products_uvb' => 'UVB', 'products_rated' => 'Rated' ); $custom_fields[TABLE_PRODUCTS_DESCRIPTION] = array(); // this line is used if you have no custom fields to import/export Here's the link to the site: www.tanninglampstore.com. It's still under development. Quote
RhinoFish Posted June 18, 2009 Posted June 18, 2009 i think that the easypopulate instructions tell you how to address getting extra fields from your csv data into the database, but before you can do that, you have to add these custom fields to the database. so i think so many people used the "Extra Product Fields" contribution that the person who built EasyPopulate says in his/her instructions, how to use EasyPopulate is you've got Extra Product Fields you want to populate with data. So do you folks install the Extra Product Fields add-on and are now trying to get EasyPopulate to work with those fields? Or are you expecting the EasyPopulate itself allows you to create extra fields to store the additional data you want to upload? Quote
lcanania Posted July 1, 2009 Author Posted July 1, 2009 Had NO idea that was an additional add-on. It came off as a feature of EasyPopulate. :huh: I will download and investigate now. Thanks for the clarification! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.