Easy Populate 1.2.5.4 support

[dynamica]

Heres my EP file, I don't think anything is disabled, but I'm not sure if the format I'm using is creating a problem (I've left out a lot of columns and put them in different order)...

http://www.doctorsmedicalsupplies.co...20modified.txt

[awev]

IS there any way to include the product URL when you want to have a link to another page at the bottom of your item in the database? What would be the heading?

If you are looking to insert a link, and have it retrieve the product info, then Zen Cart, and hence EP, can't do it. You can stick a link into the bottom of a product description if you want, or place the link under the column heading of v_products_url_1.

Heres my EP file, I don't think anything is disabled, but I'm not sure if the format I'm using is creating a problem (I've left out a lot of columns and put them in different order)...

http://www.doctorsmedicalsupplies.co...20modified.txt

I haven't seen anything where the column order has been customized so much. I believe in the last 10 posts or so someone has mentioned that the product number has to come first, and I would not be surprised by that.

The other thing is you need EOREOR (End Of Row/End Of Record) at the end of each product/item. Because a product description could be up to 64K in size (or larger with things set correctly), not that I would suggest including a whole book in the description, EP looks for the EOREOR on the end of a record/row. Adding EOREOR would be the first thing to try. It is kind of like a run-on sentence/paragraph, without the proper indication you don't know when to breath. It helps let the program know when to stop with one item and begin with another.

[kiddo]

Far be it from me to deny someone an opportunity to make a buck, but I thought the whole idea behind open source was to keep it free. Why is EPA even mentioned on this forum??? It is not open source as the person who modified the original script decided to charge for his work. If I were the among the "powers that be", I would remove every post that hinted at or mentioned EPA and I would also ban the writer from posting on this site.* Call me a hard case if you will, but open source means just that!

Why give free advertising to this "Not So Community Minded Individual"?

* Unless, of course, he is one of those powers. If so, then I am probably in deep dodo for posting this reply.

The distribution kit for EPA comes with a GPL license. I believe what you are asked to pay for is support. However, for reasons unknown, support does not seem currently available by any means provided by the author to paying customers. I hope this is not due to some mis-fortune or illness on the authors part.

[awev]

The distribution kit for EPA comes with a GPL license. I believe what you are asked to pay for is support. However, for reasons unknown, support does not seem currently available by any means provided by the author to paying customers. I hope this is not due to some mis-fortune or illness on the authors part.

I did not know that EPA came under the GPL licensing scheme. It seems as if Nicklaus took the original code and reworked it so much that in it's current form it doesn't resemble the original. Because of that he is byte-encoding it, doing something similar to how java is encoded for speed, and it makes it hard to decode (it is still possible to decode, and reverse engineer, just something the average person is not able to do). The byte encoding is a copy protection scheme for php, if you will, in addition to a speed boost. And to get the byte code for downloading you have to pay for it. If it is still under the GPL license then the source code should be available for review, yet I have not seen it.

EPA has a limited audience, being those who use osC or derivatives, and not all computer users employ it like a word processor or spreadsheet. Even if he is a programmer by profession, and has his own business, we would represent small beans compared to a major contract. On the osC side of things EP is well into version 3, and has different branches based on what you need it to be compatible with. OsC does have a larger user database, and so more people are working on supporting it.

Take the above with a bag of salt. Most of what I state I have concluded based on what I have seen, what little I know about php, and a few other things. I hope what I have posted is correct, as I don't like making mistakes, nor be misinterpreted as slanderous. If there is hard and fast info, and not something inferred from the internet, then please share. I don't mind being corrected.

[kiddo]

I haven't seen any encoded script (but I haven't looked at all of it). My employer purchased it for a client and sent it to me to install. When I unpacked it, it includes a GPL license file, and the parts I did look at contain a GPL notice at the top of the code.

Perhaps there may be some code among the files that is not GPL. But I would suspect if that was the case, it would somehow indicate that at the beginning.

Either way, it does seem to be a well written and fairly comprehensive mod. I am not sure if I am using the very latest release. 3.something... I simply try to point out to poster, that just because it is GPL, doesn't mean it HAS to be handed out for free.

[webguygary]

First, let me thank the authors of Easy Populate, this is an invaluable tool.

My question is about quantity discounts.

In my source database I have a database field that shows 3 quantity discount prices.

example:

1 or more = .76
3 or more = .46
6 or more = .34

the data entry in my source file for this example appears like this:

0.76:1:0.46:3:0.34:6

I have over 5,000 of these, how do I get them into the SQL database using Easy Populate?

[awev]

Hello WebGuyGary,
If that is a discount that applies to all items, regardless to the group or person ordering it, then you should be able to set the discounts globally, and just upload the standard pricing.

If you set the discounts differently based on the item then you most likely need a special pricing mod, and find out what fields needs to be updated. Once you have gathered the needed info you can then refer to the links below, in my signature, for more detailed info on how to modify EP for your needs.

If the pricing changes based on the group, i.e., regular shopper, university, large corporation, etc, then you would set everything by the special pricing module you have chosen.

Sorry if I am not able to be very helpful at this time, it depends a lot on what you have installed, and how the programs/modules expect the data, and where and it is stored.

[Still Crazy]

Hi guys.

I have a problem on a new site when using EP v1.2.5.4 [zen-cart 1.3.7.1 and PHP v 5.2.4].

I have manually added a few products, and then downloaded an EP file so that I can add more products to the existing category structure.

When I upload the modified EP file all appears to upload successfully, but no new products appear in the catalogue. If I look in admin>catalogue>products>category the product quantity appears to have increased but if I drill down to the level where I would expect to be able to edit the new products, only the original products are there.

Any suggestions greatly appreciated.

[webguygary]

If that is a discount that applies to all items, regardless to the group or person ordering it, then you should be able to set the discounts globally, and just upload the standard pricing.

the discounts are always 1, 3, and 6 or more, but the prices are different per item. does that mean that you say I can do this?

example:

1 or more = .76
3 or more = .46
6 or more = .34

the data entry in my source file for this example appears like this:

0.76:1:0.46:3:0.34:6

[tcarney.]

HELP!

I am new to Zen Cart, and find it an amazing, comprehensive tool. I am having the following problem:

I'm using a WinXP machine (testing for now):
ZC 1.3.7.1
PHP 5
MySQL 5.0
Apache 2.2.6

I have installed Easy Populate 1.2.5.5 per the install.txt file. I copied all files into their respective folders. When I click Tools>Easy Populate I get the Easy Populate 1.2.5.5 page. However, on top of the page is a pink line that reads "Easy Populate Configuration Missing. Please install your configuration by clicking here". When I click on the "here" link I get a message saying - 1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1 in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')].

I'm not sure what I'm doing wrong, but if somebody can tell me what to do I would really appreciate it.

P.S.
I have been reading the posts in this forum for about 6 hours now and can't find an answer (also searched the posts for the error and google).