Easy Populate Uploading, but not updating

[Guest]

I run easy populate, and download the complete tab-delimited .txt file to my computer. Open it in excel, and add a new line at the bottom of the file just adding one new product. I save it and upload it through easypopulate.php . After a few seconds of uploading the file, it gives me a list of files imported :

| ahabs016.j | AHAbs016 | | | 0 | 0.00 | | 2003-07-05 | 0 | | Abstract-M | Alexis Hal | | | | | | --none-- | Active | Updated

| ahabs015.j | AHAbs015 | | | 0 | 0.00 | | 2003-07-05 | 0 | | Abstract-M | Alexis Hal | | | | | | --none-- | Active | Updated

| ahabs014.j | AHAbs014 | | | 0 | 0.00 | | 2003-07-05 | 0 | | Abstract-M | Alexis Hal | | | | | | --none-- | Active | Updated

| ahabs013.j | AHAbs013 | | | 0 | 0.00 | | 2003-07-05 | 0 | | Abstract-M | Alexis Hal | | | | | | --none-- | Active | Updated

It even lists the one product at the very bottom of the list, but it just says that it was 'updated' ... not that it was a new product.

 

At the bottom of this list of items it says :

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

 

So at this point, I think that it updated my catalog, and I take a look at it. There hasn't been any update at all in the catalog. The new item I added didn't get put there.

 

I don't know where to go from here!

 

Please help. Thank You!

[loxly]

Does every line in your excel spreadsheet end in EOREOR? If not it does not know where each product line ends and enters them as one.

[Guest]

Yes, every line at the end has EOREOR at the end of it.

 

Any thing else?

[Guest]

I just double checked, and yes, it does for sure have the ending of it on each line. Hmm....

 

Anything else? I dont' have to have anything in the temp directory to just update the database do I? I already have all of my images uploaded into the correct folder, and just want to update the database quickly without having to upload each one individually through the admin control panel.

[loxly]

Does every product have a unique product id in the first column? there are separate product id and product model. Also the lenghts of those fields should be checked in your database and changed to higher numbers. You could be truncating the data being uploaded.

[Guest]

My text file is kind of wierd actually... I don't know what happened to it. I am adding a link to the .txt file here, so you can take a look at it. Sometimes there are entries in the first column, and sometimes there isn't.

 

Text Version

http://www.eternaltomorrow.com/EP2003Jul26-1705.txt

Zipped version

http://www.eternaltomorrow.com/EP2003Jul26-1705.zip

 

I am getting it correct though on how to use it... aren't I?!

 

I download the file, open it in excel. Add info in a new row, save the file. Go back to easypopulate.php, upload the .txt file and hit update database. That's what ya do... right? I already have all the images already uploaded.

 

Thanks, Danno~

[Guest]

And I just checked as well... When I import it into excel, the first column is "v_products_model" and no where in the file, can I find "product id" when I open it in notepad, or in excel i can't find anything that says product id. Hmm... what do i do now?!

 

In my last post, I did put a copy of the text file for you to see. Thank you again for all your help.

[loxly]

you need a unique entry in each of the products in the first first field. It looks like you have some and not others.

 

I create a key that is a letter number combination and autofill the column.

[Guest]

Ok... so here's what I did.

 

I took the text file I had, in excel, and created a new column. I named it v_products_id. Easy enough. I just created a number for each one. Then I made the "products_model" match the same name as the "products_name" column. The "products_image" is teh same as the other 2 columns just listed, but with the addition of .jpg at the end of it. I did that, and added a new row at the end of the file, to test to see if it would update it in the database. Now rather than uploading it like I have been trying, I put it into my "temp" folder. Uploaded it through FTP, and then told easypopulate.php to import into the database.

 

To my COMPLETE SURPRISE, when I went and looked at the catalog... it actually added the new row of information I had given it!

 

So it worked.... kind of. Along with adding the new item that was at the bottom of the file, it also looks like it doubled EVERY ITEM that was in the catalog already. It added it twice! So now when looking at a catagory named "Children" , I have 2 of every item right next to each other.

 

My new question is how do I update the database, without duplicating each item?

 

Thanks.

[Guest]

So i figured out for future reference how to add products without duplicating, I just take the file I downloaded, and get rid of all the other products that are there, and start ... with a fresh file so to speak.

 

Ok.. good.

 

Now how do I get rid of all the duplicate files that have been created?

 

Would it be easiest to download a complete file, save it onto my computer, go into myphpAdmin, delete all the products, then take the .txt file I have, upload it, and go from there?

 

Thank You again.

[loxly]

Yup! That's what I did the first time I messed up and added dups of everything....

[Guest]

Ok... so i did that, and for some reason, the screen that came up from easy populate after updating, said that some items were updated, and some were new items. Oh well. The great thing is that it uploaded, and I don't have duplicates.

 

But when I did get the clean .txt file up, when checking the catalog, a lot of the items now are not available until 08/03/2007!

 

I don't know why that is, but it's happening! I'm still messing around with it.

 

Of course now that I can at least get it working, for the most part, is there a way to ... update the products already in the database all at once, and have easy populate recognize what has been updated, or do i have to each time completely wipe my database through phpMyAdmin and start from scratch?

 

Thank You.

[loxly]

Make sure you change the date of the product available to a date prior to now and that the date is in european format.

 

No, once you have a product id assigned, the product will be updated and not duplicated.

[thuyvu]

I took the text file I had, in excel, and created a new column. I named it v_products_id.

 

If I create an additional column in excel and called it v_products_image2 ..will it work?

 

8) :? :lol:

[loxly]

not without adding it in several other places in the script. Do a search on one of the images already there and add the code everywhere you see that.

[loxly]

Easy Populate has supoort for several of the image mods. Did you read the documentation?