Easy Populate 1.2.5.4 support

Hello Langer and all,

As I try "Insert Into DB" option, both Browsing to select your EP file (Full-EP2005Aug31-0404.txt) from my local PC and specifying the file name under /Temp at server, it gives me a web page with "The resource cannot be displayed, HTTP Error 406 - Not acceptable Internet Explorer " error message.

Please Help Again!
Zzzzzeeeennn

Hi

After some initial problems, with some help, I got EP installed and it did the right thing, even after I made my own template. The template works and EP does populate the store the correct way, with the exception of images. My catalog has been set to main category, for images. But on each additional upload, EP seems to be the common demoninator here, unless you can explain otherwise. (I have the EROROR at the end of each line in a tab deliminted CSV file.

The problem is on easy successive load on EP after a day or two, EP seems to add paths to my file names. I have looked at the CSV file and I see none in the raw data (the CSV file). I can only think of two things. A. EP is picking up a setting from a template already produced and one where I tried to alter the path for images, but its a template I am not using. or B. EP is trying to find a path and insert it, thinking it should be in there. but why would they bother to program it that way? C: Someone could have hacked my website, but then, they could have pulled down the whole store, why mess with a path to just images?

Also, after a CSV file is used, it longer seems to be loadable in excel, Fortunately I keep my orginginal spreadsheets handy after figuring this out. I back up my MYSQLdatabase before each EP upload, so I would recommend to any new users of ZEN CART to please do so, every step of the way, back up your site.

I like EP for the quick work it makes of data entry. but if Langer or anyone else has an idea about this, this would be a good time. I have nothing bet praise for EP otherwise.

On a note to the changed site. yeah my threads are gone that I saved. and its difficult to find what I am after.

thanks MrMikl

Hi

After some initial problems, with some help, I got EP installed and it did the right thing, even after I made my own template. The template works and EP does populate the store the correct way, with the exception of images. My catalog has been set to main category, for images. But on each additional upload, EP seems to be the common demoninator here, unless you can explain otherwise. (I have the EROROR at the end of each line in a tab deliminted CSV file).

The problem is on easy successive load on EP after a day or two, EP seems to add paths to my file names. I have looked at the CSV file and I see none in the raw data (the CSV file). I can only think of two things.

A. EP is picking up a setting from a template that is installed with the initial load of ZEN CART, and after I tried using it, I may have put in a path in a preformated template like "CLASSIC".

I made my own template and then loaded the data in there. If I load data the same day I make the template it works fine. And no where I tried to alter the path for images in my template.

But if I added a path in the "CLASSIC" template, the "CLASSIC" template is one I am not using. or

B. EP is trying to find a path and insert it, thinking it should be in there. but why would they bother to program it that way?

C: Someone could have hacked my website, but then, they could have pulled down the whole store, why mess with a path to just images?

Also, after a CSV file is used, it no longer seems to be loadable in excel, Fortunately I keep my orginginal spreadsheets handy after figuring this out. I back up my MYSQLdatabase before each EP upload, so I would recommend to any new users of ZEN CART to please do so, every step of the way, back up your site.

I like EP for the quick work it makes of data entry. but if Langer or anyone else has an idea about this, this would be a good time. I have nothing but praise for EP otherwise.

On a note to the changed site. yeah my threads are gone that I saved. and its difficult to find what I am after.

thanks MrMikl

langer:

The old thread is located here:
http://www.zen-cart.com/forum/showthread.php?t=22180

In that 81 page thread, is the file on the first page still the most up-to-date version?

Is there anything available that can edit these csv files once they get exported larger than 255 columns, excel just dumps on it, I imported into acces, same result, do not really want to start using sql, though i know that supports 1024 columns..

what else is available, anyone any suggestions?

Steven

pfff ok I installed ez populate but I cant get it how do I can change the tax class for the all products at this moment they are 300 and more but they are splitted in deferent folder, e mean....
i have 30products in Mainboards
60 in Graphic adapters
... and so on

Hi

can we get ep to add V.A.T and take off all Discount for froogle.

and

can we add a field for the Products Cost (used in Profit Markup/Margin Calculator)

simon

oh I got it

simon-m

When U install EP u can export your products in Excel Table but care full its a txt file. U HAVE TO OPEN IT WITH EXCEL but whatch out u save it.
And whan u open excel table u have to changte tax class with its name and price and all products attributes and options

its easy just have to see it and u will get it
good luckkkkkkkkkkkkkkk

NOTE: if u use diferent language u have to copy ur EP languge folder and rename it to ur needed language !!!

hi quick question, i need to download easy populate so i went to the mod hole to do so but i think something is wrong with the file. when i click on the download for EP_v1.2.5.4.zip it says I'm downloading index.php.

and when download ep_v2_75_zen-cart_1_2.zip its only one file but no instructions or anything like that.

i remember when i used EP before there were a bunch of file this just doesn't look right.

does anyone know where i can find a good copy or is this a good copy and how do i install.

thanks so much in advance

Cara

I'm also having the same issue, only get index.php at modhole.

Is there anyway someone could email this to me or attach it here in this thread?

I've been looking forward to adding this contribution for quite some time but have been unable to download it.

Thanks

Hi,
I'm have a database in FileMaker Pro that I'm using to populate ZC with. I have installed and used EP successfully to make product updates. I'm running into a snag with Attributes.
The products in the cart are audio tapes and CDs. They are available with an attribute called Soundtrack and attribute values called Music, Nature or Music & Nature.

I've downloaded a recent Attributes-EP2006May27-1111.txt file, open that in FileMaker and see the following headers:
v_products_model v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_values_id_1_1 v_attribute_values_price_1_1 v_attribute_values_name_1_1_1 v_attribute_values_id_1_2 v_attribute_values_price_1_2 v_attribute_values_name_1_2_1 v_attribute_values_id_1_3 v_attribute_values_price_1_3 v_attribute_values_name_1_3_1 v_attribute_options_id_2 v_attribute_options_name_2_1 v_attribute_values_id_2_1 v_attribute_values_price_2_1 v_attribute_values_name_2_1_1 v_attribute_values_id_2_2 v_attribute_values_price_2_2 v_attribute_values_name_2_2_1 v_attribute_options_id_3 v_attribute_options_name_3_1 v_attribute_values_id_3_1 v_attribute_values_price_3_1 v_attribute_values_name_3_1_1 v_attribute_values_id_3_2 v_attribute_values_price_3_2 v_attribute_values_name_3_2_1 EOREOR

But, when I look in ZC through a MySQL client, I can't find those fields in the ZC database. What am I missing? Are the underscored numbers parsed somehow by EP? If so, what do they correlate to?

I've added all those fields to my FileMaker Pro database, filled them with data, exported an EP file and I see ALL possible options for every defined attribute. ?? I have since deleted them all and I'm stuck. What I want is the lead product, CD123 to show that it is available in Music or Nature via radio buttons on the product detail page.

Help???

Is it possible to add extra fields to EP? I need one that will upload the products cost (not price) Can I add a field called v_products_cost? If so, how would I do that.

Thanks,

Tom

StevenD:

Is there anything available that can edit these csv files once they get exported larger than 255 columns, excel just dumps on it, I imported into acces, same result, do not really want to start using sql, though i know that supports 1024 columns..

what else is available, anyone any suggestions?

Steven

I would have bet money that openoffice would go past 256, but it doesn't. :(

Gnumeric (which has a windows port in progress) can be compiled to support more columns, but the binary doesn't. :(

I read that Quattro Pro can do far more than 256 - I have not confirmed it.

The only one I found (that worked) was koffice-kspread (KDE Spreadsheet), but if you're on windows, it isn't going to be much help.

Maybe someone else can come up with more...
Chris

Any update on what has happened to the download at modhole?

Still shows download link is EP_v1.2.5.4.zip, but is actually a single (and bogus) index.php file.

Is there an alternative download site or can someone send/post the correct file?

Thanks and have a LARGE day!!!

Found out from modhole that prob is in browser version(s) used for download... using IE I was unable to get anything but the "index.php" file but Netscape had no prob getting full zip download.

HOWEVER... I am a bit confused on how to set up my excel columns so that the categories/subcategories/products will import correctly.

My store is for power sport vehicle batteries and I will set it up with various categories/subcategories drilling down until the correct battery is listed. As an example:

Motorcycles > Honda > 1800cc > GL1800 Gold Wing > battery

Thus, each type of vehicle (motorcycle, snowmobile, water craft,etc) will be a category and each of those will have a subcategory of makes, with each of those having a subcategory of sizes, with each of those having a subcategory of models, finally ending w/ the appropriate battery for that vehicle.

I set up a singular product in my store and then did a download from EP to see the format that I would need to use in Excel, but no categories are showing. I was hoping to do my actual category/subcategory setup using EP as I actually have more categories than I do products (many of the batteries will fit multiple vehicles).

I must surely be overlooking the obvious here. Any help would be greatly appreciated.

Thanks and have a very LARGE day!

I'm not sure why or how, but I received an error message from w/in the EP module with a "click here" to correct link. After clicking the link, EP did another export of my data and all was well.

No clue what was wrong w/ first one but all is well now.

ZZZZZeeeennn:

Hello Langer and all,

As I try "Insert Into DB" option, both Browsing to select your EP file (Full-EP2005Aug31-0404.txt) from my local PC and specifying the file name under /Temp at server, it gives me a web page with "The resource cannot be displayed, HTTP Error 406 - Not acceptable Internet Explorer " error message.

Please Help Again!
Zzzzzeeeennn
I found the answer to my own question at Langer's modhole.com site. It was a security issue with the web server who easily took care of it. Since Langer seems to be absent these days here at Zen place, maybe busy updating releasing EasyPopulate Advanced Version, those seeking EP related answers may have better chance at his site.

Good Luck to You All

hi,

thanks for the program! i installed it and everything seemed to go smoothly. i put all the files on the servers where they were indicated to go and i also created the txt file to download so i can add more products to it.

i finished editing the txt files using open office then copy it to gedit. i tested it to make sure that the spaces were all tabs. and now i tried to upload it using admin/easy populate. i get a response like this:

Not Acceptable
An appropriate representation of the requested resource /zencart/admin/easypopulate.php could not be found on this server.

i checked again t omake sure that easy populate.php is there and it is..

am i not doing something properly?

wtashby:

Is it possible to add extra fields to EP? I need one that will upload the products cost (not price) Can I add a field called v_products_cost? If so, how would I do that.

Thanks,

Tom

Any chance someone knows the answer to this question?

at this time, Easy Populate does not detect new fields. This will change shortly.