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,113

Results 841 to 860 of 3,834
25 Jul 2007, 4:40 PM
#841
qm360 avatar

qm360

New Zenner

Join Date:
Jul 2007
Posts:
40
Plugin Contributions:
0

Easy Populate 1.2.5.4 support

Damunz:

When I installed 2.5.4, it disabled my sales maker and specials in my admin. Can this be fixed? Thanks!:smile:

When you say installed 2.5.4, to what are you referring to?

25 Jul 2007, 4:41 PM
#842
alex_clarke avatar

alex_clarke

Totally Zenned

Join Date:
Mar 2006
Posts:
909
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

I know that there's one for osCommerce (it's mentioned in this thread ealier on), but nothing for Zen Cart at the moment.

My Contributions: Zen Lightbox | Best Sellers Reloaded

25 Jul 2007, 5:12 PM
#843
qm360 avatar

qm360

New Zenner

Join Date:
Jul 2007
Posts:
40
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

I am using EP and I get this error:

Upload Results
File uploaded.
Temporary filename: /tmp/phps2pv9z
User filename: Full-EP2007Jul25-1301.txt
Size: 29658

No model field in record. This line was not importedproducts/i | ALLMAX 100 | IsoNatural | | 35.9900 | 0001-01-01 | 0001-01-01 | 54.99 | 2 | | 2007-07-19 | 100 | ALLMAX | Protein Po | | | | | | | GST (Shipp | 1 |

26 Jul 2007, 1:53 PM
#844
medusa avatar

medusa

New Zenner

Join Date:
Jun 2007
Location:
Scotland - UK.
Posts:
4
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

qm360:

I am using EP and I get this error:

Upload Results
File uploaded.
Temporary filename: /tmp/phps2pv9z
User filename: Full-EP2007Jul25-1301.txt
Size: 29658

No model field in record. This line was not importedproducts/i | ALLMAX 100 | IsoNatural | | 35.9900 | 0001-01-01 | 0001-01-01 | 54.99 | 2 | | 2007-07-19 | 100 | ALLMAX | Protein Po | | | | | | | GST (Shipp | 1 |

QM360,
I'm having problems with EP_v1.2.5.4 myself ! Your error message is very familiar !!
Looks as though you (and I) are using this tool to upload products which do not use a 'model' reference. It would appear from comments I've had to my own query, that EP_v1.2.5.4 does NOT support the import into the database of products where no model is defined ! Also, the replies I've received indicate (allegedly?) that even the 'paid' version has its own problems which the developer is trying to solve !
Where do we go from here ? - Sorry, still waiting for guidance - will let you know if I can find out more ! Good luck !

26 Jul 2007, 1:57 PM
#845
alex_clarke avatar

alex_clarke

Totally Zenned

Join Date:
Mar 2006
Posts:
909
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

The model field cannot be left blank (as far as I know).

If you think about it, it makes sense. The model number is used like a 'primary key' within a database, a unique identifier if you will. How would Easy Populate know which record to update if you don't supply it with a model number?

My Contributions: Zen Lightbox | Best Sellers Reloaded

26 Jul 2007, 4:11 PM
#846
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Alex Clarke:

The model field cannot be left blank (as far as I know).

If you think about it, it makes sense. The model number is used like a 'primary key' within a database, a unique identifier if you will. How would Easy Populate know which record to update if you don't supply it with a model number?

The ill fated ver 2.75 would allow the use of the product id as the main key field from an option in configuration. But this version is plagued with problems and not recommended for use if you can still find it.

I believe Langer added product_id as the main key in the paid version that can be selected in the config panel, but I do not know if the product model is still required at some point. Actually, from a developer point of view, the product_id is the correct key to use as it is THE key that zencart uses to link product data between databases. But identifying products from an automatically assigned digit when you are editing data is troublesome.

The product model is not actually needed to run zencart. I don't remember off the top of my head, but i believe zencart has an option to allow only unique product models... but don't take my word for it. Product model is keyed in the database, but this is for searching purposes only. product_id is the key that links the various databases together.

Perhaps Langer or someone familiar with the paid version can verify that you can run EP (paid) without model numbers?

26 Jul 2007, 5:16 PM
#847
gxjenkins avatar

gxjenkins

Zen Follower

Join Date:
Apr 2007
Location:
Tampa, Florida
Posts:
180
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

hugslife:

it looks like the query is missing an end quote
the query reads
**products_quantity="20, products_price_w="11.4900"
**where it ought to be
**products_quantity="20", products_price_w="11.4900"
**
hope that helps you out!

ps---has anyone come up with a solution for incorporating product types into easypopulate?

What was the fix for this? I'm getting this error when I do a search, so I don't think it has anything to do with EP which seems to be working fine.
Thanks.

Gary Jenkins
Your Neighborhood Store
It Ain't Over Until You Quit, So Don't!

26 Jul 2007, 8:46 PM
#848
alex_clarke avatar

alex_clarke

Totally Zenned

Join Date:
Mar 2006
Posts:
909
Plugin Contributions:
1

Re: Easy Populate 1.2.5.4 support

ThePatch:

I was getting the same thing until I changed the permissions on the temp folder to 777; at least i think it was the temp folder. I've got one of those summer colds and down south we use a Jack Daniels Toddy to make it all better, between that and the nyquil i might be off. But I'm pretty sure that's what I had to do.

After playing around with the file permissions on my Windows temp folder and then some help from Bjorn I managed to resolve this issue.

And guess what... it has nothing to do with the Windows temp folder at all!

I simply changed the permissions on the temp folder within the root of my website and everything seemed to work! :)

My Contributions: Zen Lightbox | Best Sellers Reloaded

27 Jul 2007, 7:56 AM
#849
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

floridalou - Bad version you should version EP_v1.2.5.4

milobloom - > Is there any progress with downloading and uploading products with Attributes yet?
What do you mean?

dnolan - Try a different Browser ( I have the same issue with Firefox but not with SeaMonkey

tolefairy - PROBLEM #1: Make sure you opening the file correctly with Excel
PROBLEM #2: Known Bug see earlier posts in this thread

27 Jul 2007, 1:54 PM
#850
qm360 avatar

qm360

New Zenner

Join Date:
Jul 2007
Posts:
40
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Alex Clarke:

The model field cannot be left blank (as far as I know).

If you think about it, it makes sense. The model number is used like a 'primary key' within a database, a unique identifier if you will. How would Easy Populate know which record to update if you don't supply it with a model number?

I opened the exported EP file in excel and added those number manually. Then imported using EP and it worked.

27 Jul 2007, 2:18 PM
#851
hyperlite635 avatar

hyperlite635

New Zenner

Join Date:
Jun 2007
Posts:
46
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

qm360:

I am using EP and I get this error:

Upload Results
File uploaded.
Temporary filename: /tmp/phps2pv9z
User filename: Full-EP2007Jul25-1301.txt
Size: 29658

No model field in record. This line was not importedproducts/i | ALLMAX 100 | IsoNatural | | 35.9900 | 0001-01-01 | 0001-01-01 | 54.99 | 2 | | 2007-07-19 | 100 | ALLMAX | Protein Po | | | | | | | GST (Shipp | 1 |

I'm getting the same error and I have model numbers in my excel file.

Electronic-Pulse.com
Discount consumer electronics

EPNFragrances.com
Wholesale fragrances for men and women

27 Jul 2007, 2:28 PM
#852
hyperlite635 avatar

hyperlite635

New Zenner

Join Date:
Jun 2007
Posts:
46
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Also, when I import the file, it creates a category for each manufacturer for some reason.

For instance, I try to import a list of cameras, and it creates a category for every manufacturer with "cameras" as the subcategory.

Electronic-Pulse.com
Discount consumer electronics

EPNFragrances.com
Wholesale fragrances for men and women

27 Jul 2007, 4:22 PM
#853
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

hyperlite635 - Check your file format, I would think you are missing a field in your .txt file and it is picking yup the next field.

Best way to trouble shoot - download a complete file and compare the two files.

27 Jul 2007, 6:42 PM
#854
chadderuski avatar

chadderuski

Totally Zenned

Join Date:
Apr 2006
Location:
Dark Side of the Moon
Posts:
986
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

hyperlite635 -

Don't forget you also need EOREOR at the end of every record including the first line header.

Also, when uploading your data be sure to NOT leave important fields blank like the manufacturer, or image. What will sometimes happen is the data from the previous non blank record will be assigned to that blank item (and all blank fields following! - this bugged me up till I figured out what was happening!)

AND, you can remove columns that you do not need to update. Try just updating Models, Categories and Prices.

<sigh> AND also note that you cannot move/del items/categories in the ADMIN area and upload data without getting linked products. Gotta be careful there!

AND AND.... be very careful what you put in the description field. Try to keep it simple! Watch out for quotes and apostrophes... this has driven many an EPer nuts!

Oh yeah, that temp directory must have read/write permissions... 777 safest!

good luck!

27 Jul 2007, 8:15 PM
#855
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

If anyone is needing this the install.sql file for the database for MySql 5

# MySql 5 Config 
# Install Easy Populate Configuration v1.2.5.4
INSERT INTO `configuration_group` VALUES (NULL, 'Easy Populate', 'Config options for Easy Populate', '1', '1');

UPDATE `configuration_group` SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

INSERT INTO `configuration` VALUES (NULL, 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'temp/', 'Name of directory for your uploads (default: temp/).', last_insert_id(), '0', NULL, now(), NULL, NULL),
(NULL, 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'),
(NULL, 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL),
(NULL, 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL),
(NULL, 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL),
(NULL, 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
(NULL, 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');

Enjoy !

28 Jul 2007, 5:25 AM
#856
awev avatar

awev

New Zenner

Join Date:
Mar 2007
Posts:
42
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Hello folks,
I will see about creating an EP FAQ in the future, but not now, I have to get my sites up and going first.

First, to answer a couple questions that keep popping up.

Q. What versions of Easy Populate (EP) are currently available?
A. The stable free version is 1.2.5.4, the buggy free version is 2.75, and the paid version is Easy Populate Advance (EPA) 3.03 - as of this writing on 7/28/07

Q. Can I have EP add product categories for me?
A. The non-commercial versions can, the paid version can not.

**Q. **Can EP upload special fields?
A. All three can, just that with EPs you have to edit the file, while it seems as if EPA has the support built in.

Q. I have uploaded 15 products, yet only 2 show up. The file looks something similar to this:

book | book.jpg | First book | ... |EOREOR
book | book.jpg | Second book | ... | EOREOR
...
dvd | dvd.jpg | 1st dvd | ... | EOREOR
dvd | dvd.jpg | 2nd dvd | ... | EOREORWhy am I only seeing two items?
A. Each row must have a unique product model (i.e., item number), and the end of record EOREOR must be on the end of each row. If you change it from book to book_1, book_2, etc, then EP will insert the items. Failure to do so will have EP insert the first item, book, and then each additional occurrence of book updates the first, same thing with dvd in this example.

Q. After uploading I find only a few records uploaded correctly, and there are a few others with a number of records all in the last field. What happened?
A. Did you remember to place EOREOR on the end of each row/record?

Tip: You may want to turn off "Text delimited with quotes" in both your spreadsheet (i.e., Excel and Open Office Calc) and the database you are using. May I suggest the tide "" symbol if you must use something as a text delimiter (i.e, you have a few commas , single or double quotes, in your description, and want to preserve them). The tide symbol can be stripped off and out as needed. If, for example, you import a great amount of data using the LOAD DATA INFILE command in MySQL you can use the option FIELDS OPTIONALLY ENCLOSED BY '' to remove it.

Tip: See the above post for an updated sql script for installing on systems that use MySQL version 5.x

About me: I have used, and modified, version 2.75 in the past. I have downloaded, but not installed, version 1.2.5.4 If people are interested I can download a copy of 2.75 from my site (computer crashed so I don't have a local copy), and post it here. I have been playing with computers for over two decades. I understand some coding, and can do a bad, yet working, hack if I have to, just don't ask me to re-work Zen Cart for your needs :no: . I will take a fresh look at both EP versions and see what I can do to make them more user friendly, or at least create instructions on how you can do it yourself (a DIY guild if you will). Again, this may not be for a while as I have my daytime job and then my two web sites to worry about.

29 Jul 2007, 7:25 AM
#857
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

awev - I would be very interested in a DIY guide to add additional fields eg sort order in Attributes.
I am thinking of a idea to use a Python script to manage the .txt file as I have far too many attributes to use Excel or OO but this is still very early days, and I am currently working on another program for B2B for my work.

29 Jul 2007, 5:00 PM
#858
empower avatar

empower

New Zenner

Join Date:
May 2006
Posts:
30
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

awev:

Q. Can I have EP add product categories for me?
A. The non-commercial versions can, the paid version can not.

That's awkward. Shouldn't the paid version offer MORE features? Is there a workaround or better solution for this on the paid version?

awev:

**Q. **Can EP upload special fields?
A. All three can, just that with EPs you have to edit the file, while it seems as if EPA has the support built in.

Which files are necessary to edit when you want to do this?

As for a DIY -- maybe we can just have a Wiki or something so everyone can contribute.

29 Jul 2007, 8:28 PM
#859
scrat avatar

scrat

Zen Follower

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

Re: Easy Populate 1.2.5.4 support

Zen Cart already has a wiki :-

http://www.zen-cart.com/wiki/index.php/Main_Page

But I would agree > As for a DIY -- maybe we can just have a Wiki or something so everyone can contribute.

30 Jul 2007, 4:51 AM
#860
empower avatar

empower

New Zenner

Join Date:
May 2006
Posts:
30
Plugin Contributions:
0

Re: Easy Populate 1.2.5.4 support

Scrat:

Zen Cart already has a wiki :-

http://www.zen-cart.com/wiki/index.php/Main_Page

But I would agree

I was actually talking about one specific to EP. Don't think there is one (a good one) out there yet?

I know there's this one:
http://www.modhole.com/modhole/index.php?module=wiki&page=FrontPage&MMN_position=5:5

But it doesn't seem to be very helpful