Easy Populate and Product Extra Field

[alexd100]

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

[alexd100]

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

[alexd100]

One last final bump for help.

 

Then I will most likely look at an alternative for having extra fields.

[Kstock]

I'm having the same EXACT problem. Re-importing .csv file will not update the database. Please help!

[♥geoffreywalton]

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

[Guest]

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

[♥jailaxmi]

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

[♥geoffreywalton]

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

[♥jailaxmi]

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

[Guest]

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

[♥geoffreywalton]

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

[Guest]

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.