Jump to content
VJ

Easy Populate & Products Attributes

Recommended Posts

OK ok ok iam sorry i post again but my english is not so good so iam a bit confuse. Well EP is now runing OK But i have the DVD movie rental so i wade the categories like this

 

-Movies DVD

----Accion

----Comedy

----Dramas ....and so on

-Snacks

----Food

----Drinks

-Sex Toys

----Male

----Female

 

I manually put 1 produst on each subcategory. Then i downloaded the EPfile.txt(complete) with EP.

I didnt even open the file and upload it again. Now i have The products double in a mess like this

-Accion

-comedy

-male

-female

-food

-drinks... and so on

I didnt respect the Parent category.

What is the problem ???

 

Question #2

Can i delete products using EP ? How ?Is their a bigger and more detail manual? EP for Dummies :P ?

Can we delete categories using EP ?

Edited by innovahn

Share this post


Link to post
Share on other sites
there is some code in tips and tricks for doing this.

 

Where will i find the tips and tricks...

 

thanks

Share this post


Link to post
Share on other sites
OK ok ok iam sorry i post again but my english is not so good so iam a bit confuse. Well EP is now runing OK But i have the DVD movie rental so i wade the categories like this

 

-Movies DVD

----Accion

----Comedy

----Dramas ....and so on

-Snacks

----Food

----Drinks

-Sex Toys

----Male

----Female

 

I manually put 1 produst on each subcategory. Then i downloaded the EPfile.txt(complete) with EP.

I didnt even open the file and upload it again. Now i have The products double in a mess like this

-Accion

-comedy

-male

-female

-food

-drinks... and so on

I didnt respect the Parent category.

What is the problem ???

 

Question #2

Can i delete products using EP ? How ?Is their a bigger and more detail manual? EP for Dummies :P ?

Can we delete categories using EP ?

I think everything you need has been asked in this page or the previous page, and in the docs. please do a little reading before posting.

Share this post


Link to post
Share on other sites
Where will i find the tips and tricks...

the EP docs would be a good place to start.

Share this post


Link to post
Share on other sites

Problem with Easy Populate :

 

Hi folks,

I installed Easy populate but if I click on the Link in my admin-area

I get the following error :

 

Access Denied

No Right Permission Access

Please contact your Web Administrator to request

more access or if you found any problem.

 

 

I assumed that it was due to a access right problem in my filesystem but even if I

set all my directories of my oscommerce-shop to 777 I get the same error.

Since I don't know where I can get more information about that error (e.g. logfiles)

I don't know what to do to solve this problem.

 

Any help is appreciated ;-)

 

Best regards,

 

Daniel Wetzler

Share this post


Link to post
Share on other sites
Access Denied

No Right Permission Access

Please contact your Web Administrator to request

more access or if you found any problem.

in addition to Mibble's comment I would say that if you are using v2.76d, there is a setting:

 

$show_ep_settings = false;

 

set that to true and you will see the complete path this contribution is trying to use displayed on the EP mainpage. Make sure your setting for the path near the top of EP does not produce a double slash and ask your host if the path is correct to your hosting storage and that it has the 777 write permissions.

Share this post


Link to post
Share on other sites

I installed EP and was able to fix all of the errors that were coming up by checking out the forum (thanks). I'm stumped with the message that I'm getting now. I think it's trying to import the info, but it's not showing up. I'm doing a test of 10 products for my pet supply store. I'm using a mac and running on an OSX server. I am reading the guide and it gives a special notice to mac users to enter in 'unix' at the end of the line. I know we need EOREOR at the end, but where would the unix go if I have to insert in. I have listed the message below (and I do have a product model in the file as otherwise stated at the end):

 

 

File uploaded.

Temporary filename: /home/simplethink/tmp/php0Axcg0

User filename: 1-14-07Upload.txt

Size: 41860

| min D3 Sup | Ascorbic | Niacin | Thiamin M | Riboflavi | Beta Caro | Calcium P | Pyridoxin | Calcium I | Folic Aci | D-Biotin | Sodium Se | Papaya | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

Share this post


Link to post
Share on other sites
| min D3 Sup | Ascorbic | Niacin | Thiamin M | Riboflavi | Beta Caro | Calcium P | Pyridoxin | Calcium I | Folic Aci | D-Biotin | Sodium Se | Papaya | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

 

When I see this, I'm assuming your file is not impoted correctly. What field are we seeing here? it looks like it's always the same type of data - an ingredient

 

could you upload your file online post a link to it so we can see how it is structured?

Share this post


Link to post
Share on other sites
1) EP is not able to delete multiple products.

The best way to do this, if you have 8000 products with no description/prices and want to start from scratch is to use the admin backup/restore function (did you backup first ? ;-)

 

If not, another solution consists in going in the Myphpadmin control panel on your hosting service and empty the table products and products descriptions, (the "empty" tab at the top of the table display)

 

2) no need to create categories in admin, if you create your categories and subcategories in easypopulate, they are created on the fly when the file is imported. Just be careful that, if you already have some categories set up and want to retreive your products in them, that the names in the EP file match exactly what you already have on the site.

 

Hi,

 

Sorry little bit lost here.

 

1. What does on the fly mean? (probably a stupid question!!!) :blush:

 

2. Once all of the files are uploaded, am i right in saying that you can't access the products to alter them at all from the admin section?

 

Thanks

dave

Share this post


Link to post
Share on other sites

I've trying trying to find if in this contrib, we can organize the attributes.. can I just reorder things in the database? Or will that not work?

 

Sorry if this has been answered before.. :(

Share this post


Link to post
Share on other sites

I've download the file to my site, here is the link:

 

http://store.wipeyourpawz.com/1-14-07Upload.txt

 

This file is exported from Excel for ac to the Tab-delimited file. When I look on the web however to see if it posted, i'm seeing some extra characters, not sure where they came from or if they need to be there or not.

 

 

 

When I see this, I'm assuming your file is not impoted correctly. What field are we seeing here? it looks like it's always the same type of data - an ingredient

 

could you upload your file online post a link to it so we can see how it is structured?

Share this post


Link to post
Share on other sites
I installed EP and was able to fix all of the errors that were coming up by checking out the forum (thanks). I'm stumped with the message that I'm getting now. I think it's trying to import the info, but it's not showing up. I'm doing a test of 10 products for my pet supply store. I'm using a mac and running on an OSX server. I am reading the guide and it gives a special notice to mac users to enter in 'unix' at the end of the line. I know we need EOREOR at the end, but where would the unix go if I have to insert in. I have listed the message below (and I do have a product model in the file as otherwise stated at the end):

File uploaded.

Temporary filename: /home/simplethink/tmp/php0Axcg0

User filename: 1-14-07Upload.txt

Size: 41860

| min D3 Sup | Ascorbic | Niacin | Thiamin M | Riboflavi | Beta Caro | Calcium P | Pyridoxin | Calcium I | Folic Aci | D-Biotin | Sodium Se | Papaya | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | Vitamin B1 | Lower Fat | Reduced C | Turkey | Lamb and | Cardiac a | Turkey Me | Brown Ric | Lamb Meal | Chicken F | (Preserve | Herring M | Eggs | Flax Seed | Psyllium | Sun Cured | Sunflower | (Preserve | Chicken | Kelp | Potassium | Linoleic | Rosemary | Sage Extr | Amaranth | DL Methio | Taurine | Lecithin | Cranberri | Apples | Dried Ent | Dried Lac | Dried Asp | Dried Bac | Fructooli | Dried Sac | Yucca Sch | Zinc Amin | Manganese | Copper Am | Cobalt Am | Iron Amin | Vitamin A | D-Activat | Vitamin E | Ascorbic | L – | Riboflavi | Niacin | Choline C | Calcium P | Folic Aci | Pyridoxin | Thiamin M | Beta Caro | D - Bioti | Glucosami | Chondroit | Calcium I | Sodium Se | Papaya | Pineapple | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

 

No products_model field in record. This line was not imported

 

The file is imported right. But at some point it found some extra stuff that did not import.

This happends if:

- Your excel file has a broken line; OR

- After the last fields (last rows) there is blank information.

 

To easily get rid of this issue just click on the rows tab section (Where it select the entire column when clicked) and right-click and press delete. (select as many as possible). Save your file in a Comma delimeted and try again. You'll see the issue dissapeared.

Share this post


Link to post
Share on other sites

I am trying to get Product Extra Fields to work with Easy Populate. This issue seems to have been covered in older versions, but finding the info on this thread isn't easy.

 

I am using Easy Populate 2.76d-MS2 (with attributes) from surfalot. I added the code provided by jobonline from here and it does download some information. I found that I just have to manually enter 'www.website.com/catalog/admin/easypopulate.php?download=stream&dltype=extra_field' in the address bar.

 

The problem with the file this creates is there is no Model, just the products_id and it gives product_extra_fields_id instead of the name of the extra field.

ep.sample.output.png

 

What I would like is to add a checkbox in the create-on-the-fly box to add the correct fields to the file.

 

here is the box I am referring to:

ep.extra.fields.png

 

Any help with this would be greatly appreciated. It seems that there are many others looking for this too.

 

Thanks

Share this post


Link to post
Share on other sites
The file is imported right. But at some point it found some extra stuff that did not import.

This happends if:

- Your excel file has a broken line; OR

- After the last fields (last rows) there is blank information.

 

To easily get rid of this issue just click on the rows tab section (Where it select the entire column when clicked) and right-click and press delete. (select as many as possible). Save your file in a Comma delimeted and try again. You'll see the issue dissapeared.

 

 

I'm actually exporting the information from filemaker, then editing in excel and exporting as a tab file. I think there is something getting added in this process. It seems I have to go back and check the data coming from filemaker to make sure it's clean in there before I export. Thanks for everyone for taking a peek at my problem.

 

Shawn

Share this post


Link to post
Share on other sites
1. What does on the fly mean? (probably a stupid question!!!) :blush:

 

I think this from the upload description describes it best.... :rolleyes:

Added on-the-fly downloads. Along with the Custom File Builder this helps those

with extremely large databases to actively stream the export and avoid time-outs.

All other types of export and temp dir file generators in this contribution builds

the entire download in server memory before sending to the export location.

On-the-fly downloads output the file as it is created saving server memory.

8000 products = over 50 meg file. As in previous versions, this still pulls

the entire product catalog in one SQL query for a complete download. Maybe

look for a more conservative approach to this in the future.

 

2. Once all of the files are uploaded, am i right in saying that you can't access the products to alter them at all from the admin section?

 

not true. the import should create full products editable from the admin.

Share this post


Link to post
Share on other sites
I've trying trying to find if in this contrib, we can organize the attributes.. can I just reorder things in the database? Or will that not work?

 

Sorry if this has been answered before.. :(

Others may disagree, but I think this contrib was designed to move product sets from shop to shop. Many try to manage small product databases by exporting, editing in text or excel, the re-importing. Attributes can be a real mess trying to edit them after an export (not recommended). Exporting attributes from a shop with liberal use of attributes can create very large and confusing files.

Share this post


Link to post
Share on other sites
1. What does on the fly mean? (probably a stupid question!!!) :blush:

 

by "on the fly" I meant:

 

"No need to create categories and subcategories in your admin section, Easy populate creates them for your alomg with your products when you define them in the text file."

 

That's it. Nothing to do with timeouts or temp files as mentionned by surfalot

Share this post


Link to post
Share on other sites

I used "download on the fly" to try and update some product names , i chose only to build the file with the product names.

 

After i edited the names and uploaded the edited file, it deleted all my product descriptions ?

 

I had to restore them from a DB back-up .

 

Is it supposed to do this ?

 

I though i could update certain fields on a product and leave the rest as is

 

The model numbers remained the same in the file i downloaded , i never edited them , just the product name. The file had the correct ending tag on every line.

 

Is this human error on my part or is something wrong ?

Share this post


Link to post
Share on other sites

I have installed EP vers. 2.76d. I have errors turned on. I can download my txt file. I added one product to see how it would work. I uploaded according to directions. Upload seems to have gone fine. Got this at top:

 

File uploaded.

Temporary filename: /var/tmp/php0c54XC

User filename: EP2007Jan10-0707-2.txt

Size: 118686

 

...then the file with the new product at the end. This at the bottom:

 

No products_model field in record. This line was not imported

 

...but I know that's ok.

 

Where is my product? It is not in the catalog nor, I imagine, the database. Is there another step I missed somewhere? The file is in the osc/temp file.

 

Help!

 

Marcia

Share this post


Link to post
Share on other sites

Got a problem that I didn't find the answer to in my searching

 

I get this :

Filename: ep_split1.txt

Warning: file(/kunden/homepages/42/dxxxxxxx/htdocs/catalog/temp/ep_split1.txt) [function.file]: failed to open stream: No such file or directory in /homepages/42/dxxxxxxx/htdocs/catalog/admin/easypopulate.php on line 675

Warning: Invalid argument supplied for foreach() in /homepages/42/dxxxxxxx/htdocs/catalog/admin/easypopulate.php on line 680

 

when I try to read a split file

I tried to read the file whole too, but there was absolutely nothing!

 

HELPPPPPP Please!

 

:blush:

Share this post


Link to post
Share on other sites

Well, I believe the file did upload but it sorta messed up my products. It doubled up on a lot of them and put some in the wrong category. I rechecked the downloaded Excel file to correct any mistakes because the download has some things wrong...categories, mostly.

 

When uploaded I got the double entries only in some of the categories.

 

Any idea what is going wrong???

 

Marcia

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×