Easy Populate 1.2.5.4 support

[schoolboy]

So... You DID make a backup before using EP??? LOL!

Oh yes... ALL my hosting accounts (for clients) INCLUDE DAILY BACKUP service with the hosting co, and I ALSO employ a fantastic chap in Mumbai (India) who does manual backups a little later than the host's backup system. In that way, I have backups happening every 12 hours... Been doing it this way for years and years... (Only ever had to restore a full backup once though... Host is great!)

[schoolboy]

What you describe sure sounds like some funky end-of-line issues. Did they change something in excell 2007?

I tried a few things on a test install of ZC - using the EP file that seemed to be causing problems.

After running EP on one attempt, it seemed to go just fine. EP reported UPDATED PRODUCTS, but they did not appear in the store.

Looking at the DB in phpMyAdmin showed that the PRODUCTS table got populated OK, but the PRODUCTS_DESCRIPTION table was empty...

I figured that something (like line breaks) may be the culprit at v_products_description... but couldn't find anything. Also, looked for " " marks ... nothing.

I'll abandon MS now... Do everything in OpenOffice....

[crafterscafe]

background:

was using php v4, installed ep v 1.2.5.6 and had probs. so I upgraded to php v5.

I used a freshly downloaded sample file but whoops all the catagorie columns are missing. however, I didn't notice this until I uploaded. It did something but didn't add product.

now I have something really weird - this is the only one I have found like this but I have a product number #310 that is showing two times on the screen, but only one time in the admin section.

I have seen the opposite prob talked about here but not this.

here is the link to the product, if you click it then use the next prev buttons you will see it is only displayed one time. ???

I have looked in DB and see nothing odd. Please help as it also does not update quantities in cart correctly either.

http://crafterscafe.com/index.php?ma...ex&cPath=53_54

it is the polished chrome product 1 x 1"

[crafterscafe]

Is anyone able to use EP to populate new products and QBI for getting info to quickbooks?? are there conflicts with these two programs that I can not find in documention???
I am thinking my problems have something to do with this.

[Scrat]

crafterscafe Use version 1.2.5.4 from Modhole and you want have any major issues as it just works(One or two bugs) but it will not make your head hurt

Also check your product number for any extra characters, also check in your database to see if you have two records the same.
As for QBI I don't use it so I would need to know the format of the import required, if is a case of re-arranging the format that should be pretty straight forward in OO/excel

[jmebright]

I have EP working great on Zen 1.3.8a. I have my complete .csv file with all my products, and I need to compare it to a different excel file that has just model #'s and qty.'s. Is there a way to do this automatically or with a macro?

File 1 is a complete .csv file exported from EP.

File 2 is an excel file from my supplier that has roughly 3000 rows and 3 columns. Column A is model #, B is Qty., C is price.

I have excel and open office and I want the Qty. of each model from File 2 to be inserted in the correct Qty. cell for that model in File 1. I want the same thing to happen with the price. Then any model #'s that are in File 2 but not in File 1 should be added to file one.

Can somebody help with this or is there another site that my be able to help?

[Kristina]

I'm running zen-cart 1.3.8a.
I've installed easy populate 1.2.5.7
I'm using a downloaded file as a template but cannot get the file uploaded again.
The error message I'm getting is: "No model field in record. This line was not imported" and no lines are getting imported.
What am I doing wrong???
I'm so

[jmebright]

Are you using MS or Openoffice?

[Scrat]

jmebright What you are really asking for is a custom app. to search one file and populate another, Yes anything is possible, and this is quiet simple to do with very little knowledge of script writing, I would suggest you have a look at 'Python' its a great OO programming language and very easy to learn(pickup) with lots of free on-line tutorials (both text and video's to help)

Kristina Use version 1.2.5.4 from Modhole !!! (it just works with out any major issues) - other than that if you really want to use your version check your file format against the original download.
Always a good test, download a complete file and edit the file leading the header and just one product and try uploading again and see what happens. If you search this thread you will see that these .csv version of this module have many bugs, some people seem to have good results but if you just want a tried and tested version use version 1.2.5.4.

[Kristina]

Thanks for the input. I'll try it again with version 1.2.5.4.
BTW, I'm using microsoft excel to modify the file. But I've also tried it with Notepad and it didn't work there either. So I'll try 1.2.5.4.
Thanks again.