Easy Populate & Products Attributes

January 13, 2007

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 January 13, 2007 by innovahn

magicspon · January 13, 2007

there is some code in tips and tricks for doing this.

Where will i find the tips and tricks...

thanks

surfalot · January 13, 2007

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.

surfalot · January 13, 2007

Where will i find the tips and tricks...

the EP docs would be a good place to start.

danielwetzler · January 14, 2007

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

January 14, 2007

you need to have your temp directory set at 777, reset your osC directories to their default per documentation.

surfalot · January 15, 2007

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.

imbarney · January 15, 2007

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

No products_model field in record. This line was not imported

January 15, 2007

| 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?

magicspon · January 15, 2007

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

January 15, 2007

Empty a Database

http://www.oscommerce.com/forums/index.php?sho...c=45037&hl=

January 15, 2007

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.. :(

imbarney · January 15, 2007

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?

January 15, 2007

you have a strange character after your <br> in your file.

<br>

i would recommend also, using <br /> in your statements.

graphicore · January 15, 2007

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.

January 15, 2007

if your ep file has tab delimited, (99.9% use this) then save in tab delimited. did u use word, etc for the typing of descriptions?

sonixtwo · January 16, 2007

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

imbarney · January 16, 2007

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

surfalot · January 16, 2007

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.

surfalot · January 16, 2007

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.

January 16, 2007

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

andytc · January 16, 2007

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 ?

marciak · January 16, 2007

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

internetautomart · January 16, 2007

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:

marciak · January 17, 2007

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

Easy Populate & Products Attributes

Recommended Posts

Guest

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

tgely

Guest

surfalot

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation