If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Easy Populate 1.2.5.4 support

Easy Populate 1.2.5.4 support

Started by langer on 9 May 2006, 9:44 PM · Views: 1,303,111

Results 541 to 560 of 3,834
7 Feb 2007, 11:09 PM
#541
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

ok i fixed that but what about the fact that it still says

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

8 Feb 2007, 6:10 AM
#542
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I posted a week ago, and then others posted, and their questions were answered, but not mine? :cry:

I have a new problem too... I tried to download the "froogle" file... it downloaded, but the information is not even for my store! Is there something I am supposed to change somewhere? It took me to a competitor's store when I tried to follow a url in the file!

And I still cannot download attributes, it gives me a sql error, as shown below, and I cannot download by category, or it just boots me out to the admin login page.....

HELP!!!!!!!!! :cry:

grayceworks:

I also am having trouble with this. I have zencart 1.3.6, and downloaded and installed the latest version of easy populate (standard)

When I try and download the files using some of the menu selections, it takes me back to the admin login page.

But the most troubling thing, is I can't download my product attributes. Using a "complete" download, there are no product attributes, and using the "attributes" selection, I get an error:

<br /> <b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/hermes/web10/b2369/pow.villadec/htdocs/villadec/admin/easypopulate.php</b> on line <b>140</b><br /> v_products_model EOREOR ```

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

8 Feb 2007, 10:42 AM
#543
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have an issue I have installed version 1.2.5.4 and it works fine , but in

Config>Easypopulate

I have only Uploads Directory and none of the other values, but I go into PhpAdmin and all the values are in the database and I can change them in there ok, and import files using the new config that I set in Myphpadmin import ok with the new values, I have removed the records in the database and reinstalled the sql file but I still have the same problem
, could it be a problem with one of my PHP files?

grayceworks :- I have a similar issue that from time to time when import or downloading files the browse resets its self to the logon page, I would question what browse or you using IE, Mozilla, SeaMonkey,Firefox? as I have found it may be your browse try other browsers and see if that makes a difference, it did to me!
Re - your other issue try and give us some examples, as Easypopulate should be connecting to your database as it is only doing sql queries on your database, not someones which I think you are suggesting.

8 Feb 2007, 6:20 PM
#544
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

when I try to download using the "Froogle" setting... then I open the downloaded file to view it, it does not show MY products at MY url... it shows MY products appended to some one else's url... as if there was an example url that did not get taken out somewhere maybe? But I don't want to mess with the code unless I know what I am doing... LOL

When I try to download using the filters, such as by categories, it boots me out of admin, and I have to log in again. I am using Mozilla.

When I try to download "complete" it does not show the products meta tags or attributes or anything except the product model, number, category, and descriptions...

When I try to download "attributes" it SEEMs to work, but when I open the file that it downloads, there is the error written in the file as listed below, and nothing else in the file.

<br />	
<b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b> /hermes/web10/b2369/pow.villadec/htdocs/villadec/admin/easypopulate.php </b> on line <b>140</b><br />	
v_products_model	EOREOR

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

8 Feb 2007, 6:52 PM
#545
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ok... I was using EP2.75somethingor other...

I've now uploaded and installed 1.2.5.4 instead, which as I've read is supposed to be better?

It seemed all right at first, it created the "complete" file in my temp directory, prompted me to clean up a bunch of partially deleted products to clean up my database, and has links to download the files, instead of the drop down menu.

However, clicking on any of the links other than...complete ... causes a "500 internal server error" after sitting there trying to download for a while.

I NEED to download my ATTRIBUTES and FROOGLE files... and it won't let me! grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr :blink:

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

8 Feb 2007, 7:00 PM
#546
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

correction... I can export the Froogle file to the temp directory, and then download it from there.... I still can't do the Attributes... :no:

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

8 Feb 2007, 7:02 PM
#547
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

When I try to download "complete" it does not show the products meta tags or attributes or anything except the product model, number, category, and descriptions...

v_products_model	v_products_image	v_products_name_1	v_products_description_1	v_products_url_1	v_specials_price	v_specials_date_avail	v_specials_expires_date	v_products_price	v_products_weight	v_date_avail	v_date_added	v_products_quantity	v_manufacturers_name	v_categories_name_1	v_categories_name_2	v_categories_name_3	v_categories_name_4	v_categories_name_5	v_categories_name_6	v_categories_name_7	v_tax_class_title	v_status	EOREOR

The above is the fields you will get from a complete down load it does not include meta tags or attributes(Note the note in Brackets), you have to download Model/Attributes to get Attributes. I think I am right saying this but with version 1.2.5.4 meta tags are not supported.

Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file

I was using Firefox and it was always going back to logon try a different browers, Opera on Linux or IE for windows, I am sure you will fine that does the trick.

I really don't know about the issue, have you got these other url's in your database or listed in the product details, as its got to be in your database to pull the information from, have a look in your database via Phpadmin in you products records and you will see the fields froogle download is pulling the information from.

PS don't use version EP2.75 its broken with bugs version 1.2.5.4 is good!

8 Feb 2007, 7:21 PM
#548
grayceworks avatar

grayceworks

New Zenner

Join Date:
Jan 2007
Location:
Atlanta, GA
Posts:
71
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I uninstalled the 2.75 and installed the 1.2.5.4... I am no longer having trouble with the code thingy... I am no longer having trouble with being taken back to login... the Froogle thingy is fixed.. sorta.. it lets me export to "temp" then download from there....

I still cannot download Attributes, it times out with a 500 internal server error.

give me feedback on my home decor store

sleep is a symptom of caffeine deprivation

COFFEE.SYS Not Found: User startup disabled.

~~ if(pot.coffee=EMPTY) {programmer->;brain=OFF}; ~~

9 Feb 2007, 12:01 AM
#549
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

i've finished uploading EP to my mainframe. However, now when i try to "insert into DB" my file: F**ull-EP2007Feb08-1503.txt **i get this message:

Upload Results
File uploaded.
Temporary filename: /tmp/phpMJlOfM
User filename: Full-EP2007Feb08-1503.txt
Size: 10240

Upload Complete

Of course i get all excited but only to find out that my test product did not get uploaded or if it did it got lost in cyberspace b/c it's not in the correct category (digital/cameras) nor is it a part of the .txt file when I download it ONCE MORE to try and edit...

Any suggestions would be greatly appreciated. Thanks

9 Feb 2007, 9:40 AM
#550
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Has anyone done any work on the Froogle download, Google are changing the feeds regularly and this mod. does not comply?

9 Feb 2007, 9:59 PM
#551
jbhansen avatar

jbhansen

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

langer:

at this time, Easy Populate does not detect new fields. This will change shortly.
Has this changed yet? If not, does anyone know whether it's difficult to add a couple fields from our PRODUCTS table into the upload process manually?
Thanks.

10 Feb 2007, 4:18 PM
#552
niteryder avatar

niteryder

New Zenner

Join Date:
Jul 2005
Posts:
30
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Ez Populate has been working great, what a tool! The only problem I have is that when I enter in something to v_products_description_1 column, it does not import to Zen (the product does not show any description). If I add a description to a product under the admin section of Zen then get the export from EP, it's there. Does it have to be in some other format or field to import? Or, am I missing something obvious?

Here is what I'm currently importing: v_products_model v_products_name_1 v_products_description_1 v_products_price v_categories_name_1 v_categories_name_2 v_products_image v_products_weight v_date_added v_products_quantity v_tax_class_title v_status EOREOR

12 Feb 2007, 5:42 PM
#553
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

guys - i'm still having problems getting SQL errors when uploading the complete tab-delimited .txt file :(

**An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Upload Results
File uploaded.
Temporary filename: /tmp/phpGTa2YQ
**User filename: Full-EP2007Feb12-0909(2).txt
Size: 820

**
UPDATED! - Model: VP-DCM10BCVP | ../catalog | 100K Mini | long descr | | | | | 19.95 | 11.49 | 0 | 2007-02-07 | 2007-02-01 | 20 | VuPoint So | Digital | Cameras | | | | | | --none-- | 1 |
**[COLOR=red]ADD NEW PRODUCT FAILED! - Model: VP-DCM10PVP - SQL error. Check Easy Populate error log in uploads directory

The Error log says the problem is in * INSERT INTO zen_products * Where though would I find the coding for this?

If anyone could help that would be GREAT.

12 Feb 2007, 6:00 PM
#554
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_wholesale_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_categories_name_4 v_categories_name_5 v_categories_name_6 v_categories_name_7 v_tax_class_title v_status EOREOR
VP-DCM10BCVP ../catalogartwork/VP-DCM10B2VP.jpg 100K Mini Camera long description 19.95 11.49 0 2007-02-07 15:14:28 2007-02-01 08:53:29 20 VuPoint Solutions Digital Cameras --none-- 1 EOREOR
VP-DCM10PVP ../catalogartwork/VP-DCM10PVP.jpg 100K Stick Camera long description 19.95 11.49 0 20 VuPoint Solutions Digital Cameras --none-- 1 EOREOR

I have tried to look at you test file but it will not import into excel(with tab limited format), but your date format in the second line appears to be wrong but cannot really tell from your example, if this is not the problem attach the file to your reply

12 Feb 2007, 6:05 PM
#555
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I'm thinking not... However, good idea. I think it's the "insert into zen_products" sql that is the problem although I don't know where it's expecting me to go... I went to my phpMyAdmin and checked the zen_products table and all seemed to be okay.

12 Feb 2007, 6:14 PM
#556
scrat avatar

scrat

Zen Follower

Join Date:
Dec 2005
Posts:
451
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I looked at the file and it looks OK, it is updating the first product OK, I could see there was an issue in your original post but not in this file, if you read the error it is suggesting there are/an tab/s in a field. Have you changed anything to do with easypopulate since you entered the first product?

12 Feb 2007, 7:13 PM
#557
yellowdaises avatar

yellowdaises

New Zenner

Join Date:
Nov 2006
Location:
Los Angeles
Posts:
91
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

ok thanks for those suggestions but what if i want to at least check the INSERT INTO zen_products ?? i can't seem to find it in my phpmyadmin. i'm sure i'm looking in the wrong place. if someone could direct me there i'd be grateful. thanks

13 Feb 2007, 9:11 PM
#558
hugslife avatar

hugslife

New Zenner

Join Date:
Feb 2007
Posts:
3
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello everyone! I'm curious if any people have successfully integrated product types into easypopulate? I'm currently redesigning a bookstore website which has 1000++ products, and 100s of new titles and restocks every month. So an easypopulate + product type is a must.

Way back in 2003 I used oscommerce 2.1 for the bookstore and hard coded all the extra product fields into oscommerce and easypopulate... ugh. Back then, the easypopulate mod was a pain, but ultimately a matter of copy + paste. However with Zen Cart and product types, modding easypopulate is a different animal altogether.

Hope that made sense. Suggestions, encouragement, links, anyone?

:-hugslife-:

17 Feb 2007, 10:44 PM
#559
mbheald avatar

mbheald

New Zenner

Join Date:
Feb 2007
Posts:
28
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I have installed EZpopulate Standard with my 1.3.7 store and I am able to download the complete data that I imported using admin, however I am unable to upload anything to the DB. I get a 406 error that says: "Not Acceptable: An appropriate representation of the requested resource /~hotnbott/catalog/admin/easypopulate.php could not be found on this server." I checked to make sure the file was uploaded in the file manager and It is there. What could be causing this problem?

Matthew Heald
All Hot N' Bottled - Retail
http://hotnbottled.com

Hot Shots Hot Sauce - Wholesale
http://hotshotshotsauce.com

18 Feb 2007, 12:11 AM
#560
hugslife avatar

hugslife

New Zenner

Join Date:
Feb 2007
Posts:
3
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

It could be a permissions issue--check to make sure that easypopulate.php is set to 644 on your server. If that doesn't work, try setting the permissions to 777.

mbheald:

I have installed EZpopulate Standard with my 1.3.7 store and I am able to download the complete data that I imported using admin, however I am unable to upload anything to the DB. I get a 406 error that says: "Not Acceptable: An appropriate representation of the requested resource /~hotnbott/catalog/admin/easypopulate.php could not be found on this server." I checked to make sure the file was uploaded in the file manager and It is there. What could be causing this problem?