alexd100 Posted October 26, 2008 Posted October 26, 2008 I have installed the excellent Easy Populate module, and it is working perfectly for me. I also have the Product Extra Field module, and this too is also working great. However, my problem is when using both together. I have used the contribution by geoffreywalton ( Product Extra Fields and 2.76f-MS2 r1 ) and have followed through the instructions about what to do and what I need to change in the admin/easypopulate.php file. I download the Extra Fields .csv file to edit and make my changes, save it as a tab-delimited txt file and upload the file back. I see confirmation on the page saying ... File uploaded. Temporary filename: /tmp/phpYkbBcv User filename: apd2.txt Size: 1578 1 | | 80cm | UPDATE_EP 4 | | 80cm | UPDATE_EP 7 | | Pieces | UPDATE_EP However, when I go to check my products, none of my changes are visable. It appears as though I can download, edit and then upload the file with no problems, but it seems that somewhere, the uploaded file is not updating the database. I have been looking at trying to fix this all morning, but seem to be getting nowhere. Has anyone else had such a problem when using the Easy Populate and the Products Extra Fields contributions together ?? I have searched through the forums here, but haven't found any suggestion or solution as to what I can do to fix my specific problem. Any help from anyone would really be most appreciated. Thanks Alex Quote
alexd100 Posted October 27, 2008 Author Posted October 27, 2008 Just wondering if anyone can help with this ?? Been trying various things all morning as well as all day yesterday and seem to be stuck in a loop. Thanks Alex Quote
alexd100 Posted October 28, 2008 Author Posted October 28, 2008 One last final bump for help. Then I will most likely look at an alternative for having extra fields. Quote
Kstock Posted October 30, 2008 Posted October 30, 2008 I'm having the same EXACT problem. Re-importing .csv file will not update the database. Please help! Quote
♥geoffreywalton Posted October 30, 2008 Posted October 30, 2008 Did you look at the sample file in the documentation that shows what has to be in the "upload" file? Then did you apply this knowledge to your particular extra products? Should get an output like KA-TI-H10 : KA-TI-H10 : 2411 1 | KA-TI-H10 | £529.00 | Product Updated 12UCM : 12UCM : 2412 1 | 12UCM | £79.00 | Product Updated 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 ======>>>>>.
Guest Posted October 31, 2008 Posted October 31, 2008 (edited) I've also got a problem using EP with PEF, everything works good with the seperate contributions BUT when I try to populate the Extra Fields table it adds the fields into the table but sets the products_id to 0 (zero). It's driving me mad. I've tried multiple versions of EP, adding the fixes, etc but it still keeps doing this. Upload file is spot as I've double, triple checked it against the manual. This is a biggie for me as all my products have 7 extra fields, eg, voltage, capacity, etc. Any ideas would be most helpful?, I've searched and searched, my head is starting to hurt!! Edited October 31, 2008 by tryer Quote
♥jailaxmi Posted November 2, 2008 Posted November 2, 2008 (edited) Hi, I am having trouble with this contribution, which btw I think is awesome. I installed it no problem and made the proper changes in easypopulate.php. I ran a test to see if it worked fine, so I downloaded a complete file, made a few changes and then uploaded it again. Everything seemed fine, but I noticed that some of my products were switched from the original category to another category, some of the pictures were also switched from the original product to another, and some of the products were added to a few new categories. If I try to delete the repeated products from my admin panel, they won't delete. What did I do wrong? I am not sure why it would switch things around, if the excel file is accurate. Any ideas? I'd love to be able to use this contribution, as it would save me tons of time. :D Thanks, Yol Edited November 2, 2008 by jailaxmi Quote I repeat myself when under stress, I repeat myself when under stress, I repeat myself... --King Crimson (“Discipline”)
♥geoffreywalton Posted November 3, 2008 Posted November 3, 2008 (edited) I have just exported and imported the same file using Easy Populate 2.76f-MS2 r1 Works with and without fields being enclosed in quotes. v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ cts_extra_fields_value,EOREOR "19LS4D","List Price","1","£219.00",EOREOR "22LS4D","List Price","1","£259.00",EOREOR "KDL20B4050U","List Price","1","£399.00",EOREOR v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ cts_extra_fields_value,EOREOR KA-TI-H10,List Price,1,£529.00,EOREOR 12UCM,List Price,1,£79.00,EOREOR 17ARM,List Price,1,£99.00,EOREOR John Sample for you v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ cts_extra_fields_value,EOREOR 12UCM,Voltage,1,7.0,EOREOR 12UCM,Capacity,2,350ma,EOREOR 12UCM,List Price,3,£99.00,EOREOR The products_extra_fields_id will vary according to the value of you ids. Yol Try reading the EP documentation that comes with the contribution and follow the instructions on how and more importantly in which thread to ask for help. Edited November 3, 2008 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 ======>>>>>.
♥jailaxmi Posted November 3, 2008 Posted November 3, 2008 Yol Try reading the EP documentation that comes with the contribution and follow the instructions on how and more importantly in which thread to ask for help. Oh, ok. Sorry about that. I just did a search and assumed this was the main thread. Will look it up. :blush: Thanks, Yol Quote I repeat myself when under stress, I repeat myself when under stress, I repeat myself... --King Crimson (“Discipline”)
Guest Posted November 4, 2008 Posted November 4, 2008 This is my input file, it imports the fields into the PFE table but sets the product id as 0 (zero) and obviously doesn't link it to the necessary product: v_products_model,v_products_extra_fields_name,v_products_extra_fields_id,v_produ cts_extra_fields_value,EOREOR 134,Capacity,1,1100mAh,EOREOR 134,Voltage,2,9.6v,EOREOR 134,Dimensions,3,100mm x 100mm x 100mm,EOREOR 134,Battery Type,4,Li-ion,EOREOR 134,Weight,5,200 grams,EOREOR 134,Colour,6,Grey,EOREOR 134,Standard or High Capacity,7,Standard,EOREOR Any ideas? Not being able to use this great contrib is going to cause me big headaches..! Quote
♥geoffreywalton Posted November 4, 2008 Posted November 4, 2008 (edited) What version of EP are you using? Does a product with model no of 134 exist? Have you looked in PEF to check no and descriptions are correct. Is the model no in PTPEF zero? How many records are created with this zeoro value? Edited November 4, 2008 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 ======>>>>>.
Guest Posted November 5, 2008 Posted November 5, 2008 My EP version etc, is: EP vers: 2.76g-MS2 osCommerce 2.2-MS2 OS: Linux 2.6.18-92.1.13.el5 HTTP: Apache/2.2.9 (Unix) mod_ssl/2.2.9 OpenSSL/0.9.8b mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 DB: MySQL 5.0.51a-community-log PHP: 5.2.6 (Zend: 2.2.0) Extra Fields: true Extra Fields table is: products_extra_fields_id products_extra_fields_name products_extra_fields_order products_extra_fields_status languages_id 1 Capacity 3 1 1 2 Voltage 4 1 1 3 Dimensions 5 1 1 4 Battery Type 1 1 1 5 Weight 6 1 1 6 Colour 7 1 1 7 Standard or High Capacity 2 1 1 Just tried on a product I have, model #100. I've also set the model and id to be the same. So this item as products_id set to 100 and products_model set to 100. This is my import file: v_products_model v_products_extra_fields_name v_products_extra_fields_id v_products_extra_fields_value EOREOR 100 Capacity 1 1100mAh EOREOR 100 Voltage 2 9.6v EOREOR 100 Dimensions 3 100mm x 100mm x 100mm EOREOR 100 Battery Type 4 Li-ion EOREOR 100 Weight 5 200 grams EOREOR 100 Colour 6 Grey EOREOR 100 Standard or High Capacity 7 Standard EOREOR This is the output from EP: File uploaded. Temporary filename: /tmp/phprShnzq User filename: Book1.csv Size: 356 1 | | | 1100mAh | Product Extra Fields Inserted 2 | | | 9.6v | Product Extra Fields Inserted 3 | | | 100mm x 100mm x 100mm | Product Extra Fields Inserted 4 | | | Li-ion | Product Extra Fields Inserted 5 | | | 200 grams | Product Extra Fields Inserted 6 | | | Grey | Product Extra Fields Inserted 7 | | | Standard | Product Extra Fields Inserted Strange thing is it doesn't echo the model id back and seems to have empty columns. This is the result in the product to product extra fields: products_id products_extra_fields_id products_extra_fields_value 0 1 1100mAh 0 2 9.6v 0 3 100mm x 100mm x 100mm 0 4 Li-ion 0 5 200 grams 0 6 Grey 0 7 Standard One thing I did try, I've been at this for a few days now, is install an older version of PEF and it sort of worked but only if I put the products_id field in the import file instead of the model number. I don't really want to use the id field and i'm sure the contrib is supposed to work with products_model. As I said this Contrib will be great when I get it to work, if I can't sort it I may have to start adding extra fields in the products table and trying and displaying them as a table. Any ideas would be great. 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.