newb to easypopulate

[Chunks30]

Hi,

I'm new to easypopulate & osCMAX and have been having some trouble with it today. I've got a shed load of products I need to upload to my site and I really don't want to have to go about doing it one by one.

I've searched on the forums for easypopulate help and anything i've come across has either not been relevant to my problem or hasn't worked out for me. That's why i've created a new thread...

My problem is as follows:

• I'm uploading a number of products to certain categories
• i've already populated a number of categories and sub categories manually
• I've downloaded a csv file which shows all the relevant products uploaded so far

• I then put my new products into the excel csv file ( copying the layout and format of the above products exactly)

• I then use the 'upload and import EP file' option on 'Normal' - browse to my newly updated csv file and then hit 'insert into db'

• The screen changes and I get this message:

" File uploaded.

Temporary filename: /tmp/phpgF8l9s

User filename: test_upload.csv

Size: 26657

##Can not open file for reading. Script will terminate. "

• When I check if anything new has gone into the database there's nothing new

What am i doing wrong? Please help!

thanks in advance.

[Tripic]

Depends on your csv file, make sure that everything is in correct order and you have it saved properly so that excell doest add anything new Im not sure if the easypopulate system uses anything special for a end of file marker but if it does and it got whiped out of file somehow that woul;d cause the problem as well if you cant get it in excell try just adding a product or two by opening it in notepad or a basic text editor try to avoid using word pad etc has a tendency to add white space and other random junk the file doesnt need then just save as "filename.csv" make sure you use the quotes when you save

[pgmarshall]

Chunks30,

I have just finished cobbling together some instructions for EasyPopulate that you may find useful.

They are in the Wiki here ...

Edit: Also is your tmp/ folder set to be able to be read? CHMOD it to 777 and test.

Hope they help.

Regards,

[Chunks30]

Below quote is now obsolete. I changed the CHMOd of the temp dir to writeable (777) by all. Now I'm getting to the next step, but not all the way.

So, what i've done so far is:

1. I download and edit an EP file (in CSV format)
2. Open in in excel
3. edit it (the price field)
4. resave it
5. and then select 'upload and import EP file'
6. I browse to the updated version
7. select 'update' from the drop down menu (ive also tried the 'normal' option)
8. select 'insert into db'
9. I now get the following message:

"No products_model field in record. This line was not imported: | | M99X | | | MOD 99x.jp | 21 | 1.png | Sunglasses | | | Mod35c1.jp | Marco | | | | | | | | | | | | | | | | | | | | | | | Marco"

Even though the bit in red (21 - the price) was changed by me in the CSV file from 20 to 21. It's still not updating the field on the database, i've checked it via the catalog section and also on the frontend of the site.

Any suggestions as to why this isn't updating the products price?

Thanks for all the help so far guys, i'd be completely lost without the input!

Hi,

thanks for all the info so far.

I've tried it all again to no avail. I've listed the steps taken below:

1. I download and edit an EP file (in CSV format)
2. Open in in excel
3. edit it
4. resave it
5. and then select 'upload and import EP file'
6. I browse to the updated version
7. select 'update' from the drop down menu
8. select 'insert into db'
9. Then I get the following message:

"File uploaded.
Temporary filename: /tmp/php0IL2oz
User filename: EP2009Oct30-1010_updated.csv
Size: 79512
##Can not open file for reading. Script will terminate."

I'm not using the temp dir so does that mean it doesn't need to be set to 777 (if it isn't already... I havent checked)

Thanks for the help guys.

[pgmarshall]

No products_model field in record. This line was not imported:

This is the clue!

According to easypopulate you have not got the product_model field - which is the unique identifier for the system.

Have you used any special characters in your product_model codes - eg. / | " ' * & ^ % $ etc. - if you have then you need to remove them.

Did you download a "complete", edit, save (without changing format), upload?

Regards,

[Chunks30]

That's the thing... When i look at the CSV file the first column is labelled
v_products_model
and it has nothing in it...

[pgmarshall]

That's your problem then!

Open the product in the admin --> Catalog --> Categories/Products --> Browse to your product --> Click Edit

Then on the product page find: Product Model ... near the bottom of the page ... and make sure it is not blank!

Regards,

[Chunks30]

Hmmm...

It is blank for all products. Does that mean that I have to go into each product to give it a product model before I can edit them via the easypopulate option? Or can i add a product model in the csv file and then it should work...?

Cheers

[pgmarshall]

I think you should be able to add them in the csv file - although I have never tried it!

Regards,

[Chunks30]

i'll give that try then and see how I get on.

Am I able to update the images via the CSV file, provided I insert the right classpath (i.e; "mydocuments\website\images\imagename.jpg")for them?