ITS ALOT OF MOOLAQuote:
Originally Posted by langer
Printable View
ITS ALOT OF MOOLAQuote:
Originally Posted by langer
Exactly. mod_security scans the contents of things being sent through the browser and stops things it thinks may be rogue. Typical things it will block are SQL commands like INSERT INTO and DROP TABLE and CREATE TABLE and so on. There are numerous others as well. This is the same reason why the SQLPatch tool has problems on some servers and throws the 406 error.Quote:
Originally Posted by langer
Woody, I see you have resolved your dilemma, but it sounded like you were looking for more information... hence this bit of clarification.
Thats what I got this time when I uploaded it. I'm insure why it tells me my upload folder is named temp, I didnt do anything with a folder named temp! I just did exactly what the directions told me to do.Quote:
Easy Populate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in Easy Populate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named temp/, and is located in /home/content/a/p/i/apinkpony/html/shop/, however this cannot be found.
Easy Populate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (usually chmod 700 but you may require chmod 777)
Nevermind, I figured it out. I'm dumb.
the older version still works on version 3 right??
I'm using easypopulate 1.2.5.4 and I'm getting a 500 Internal Server Error with this:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
This is what the error log says:
[error] [client myIPhere] Premature end of script headers: /pathhere/easypopulate.php
I've already contacted my host and I'm waiting on a reply. I just wanted to know if this is an easypopulate error or something to do with my host?
Thanks.
What happens if I don't reset the admin activity table log? I am nervous my entire site will delete!
Then the log will keep growing bigger and bigger consuming more and more space in your hosting account. You can safely purge older records using the Tools->Store Manager button for cleaning up old records.Quote:
Originally Posted by jillkap
The activity log is only useful for audit-trail issues in case there is an inquiry about who's been doing what or accessing customer data in your admin area.
If you want to retain the history, simply do a backup of the table before pruning.
"when" are you getting this error? What clicks can reproduce it?Quote:
Originally Posted by tj1
Hi DrByte, this happens anywhere in the 2 to 5 minute mark.Quote:
Originally Posted by DrByte
If I upload a relatively simple file with say, less than 1000 products, it seems to work just fine. It just happens with the larger files that require more processing time.
I'm not sure you can reproduce it. It's pretty straight forwared, I just go to Tools>Easy Populate, select the file I want to upload and click insert into DB.
What I'm trying to find out is if this is an issue with EasyPopulate or with my host.
I think it might be my host, because I've used EasyPopulate successfully on the past and I haven't changed or done anything different.
My host has asked me if I can add something to the script so I can see where it's stopping. But that's just way beyond my knowledge.
I know EasyPopulate has a 'debug logging' option, which is enabled, but so far it hasn't generated any logs.
I know this seems like a simple question, but I haven't found it clearly answered. How exactly do I upload images? Like, where do I need to put the images or whatever?
For hundreds of hours development & support to bring thousands of Zen Cart users (including you) the free version, as well as now the advanced version? I guess you would sooner not have them at all?Quote:
Originally Posted by zenned
this maybe a script timeout error. You may be able to get around it with a custom php.ini script.Quote:
Originally Posted by tj1
Don't feel too bad Nicholas ... it's like the 1000s of hours into Zen Cart ... :cool:
People forget how much money they are saving in time and functionality to run their businesses using things like Zen Cart and add-ons and such ...
Such is the life of an elf ... :unsure:
Sorry that was unclear. What I mean was, do I need to upload the imagines to a certain folder on my server, or do i need to keep them in the same root folder on my computer as my csv file is in... or...?Quote:
Originally Posted by apinkpony11
Easy Populate does not upload images, only data. The data you provide indicates to your store the location of the product image, relative to the store images directory.Quote:
Originally Posted by apinkpony11
Which simply means you need to upload the images separately, and if the path you provide is correct, they will show.
The 1st thing anyone should do with Easy Populate is create at least 1 product in their store via Zen Cart admin, download the "complete" file and study it to understand what it all represents. This is the best way to learn what is required.
Yes. I understand what you mean, but what I'm curious about is, for example, one of my images is shown in easy populate as "image.jpg" (for example), so if I add another image to another like, line, say "image2.jpg" where do i upload this image2.jpg to? I can't seem to find a specific place to put it.
This is off topic and is not an Easy Populate question.Quote:
Originally Posted by apinkpony11
Quite right Linda. I found an apt description in the dictionary for such types as you describe:Quote:
Originally Posted by Ajeh
"A follower who hangs around a host (without benefit to the host) in hope of gain or advantage"
Thanks langer, I am using custom php.ini files in all folder of my site and I've increased the max execution time considerably.Quote:
Originally Posted by langer
I'm going to wait and see what my host says. If you have any other suggestions, they're all welcomed. :)
apinkpony11, that question is answered in several other threads or in the FAQ I believe. But I might as well answer here too.
In EasyPopulate, you only indicate the location of the images.
All images are located in the 'catalog/images' folder.
You upload them to the image folder or subfolders via FTP. You can also upload images via the ZenCart create item page or through other contributions, but it's just easier to upload via FTP.
Then you just indicate the location of the images in EasyPopulate.
If for a product you put product1image.jpg, the image should be in be in the 'catalog/images' folder. If you indicate a subfolder in EasyPopulate like 'clothing/productimage.jpg', then you need to upload the image to 'catalog/images/clothing'
MODERATOR NOTE: "catalog" here refers to the main Zen Cart folder on your server. You may have called it "zencart" or "store" or maybe you didn't even use a subfolder. In the Zen Cart ZIP file there was an "images" folder, which you uploaded to your server. That's where you put your product images. There are FAQ's on this topic.
Hi langer, I just noticed the advanced version is out now. :)
Can you tell how the performance of easypopulate advanced compares to the regular current easypopulate?
I tried the demo on you site, but I found it a bit confusing and wasn't able to import my test file. Do you do things differently to upload products? It said it didn't import products because no category existed, or something like that.
I read something about first importing categories and then products. How is that done, can't you just specify the categories in the same file like in the current standard easypopulate?
Performance is really my issue right now. Now until my host doesn't fix this early excution termination I'm really screwed. I'm limited to splitting files with 300 records. I have about 15000 products. It's taking me hours just to update the prices.
Before performance wasn't that good either compared to the old buggy easypopulate.
So if performance is better on easypopulate advanced I'll get that ASAP. Otherwise, I guess I'll have search for an alternative to do bulk imports and updates.
Something I've thought of, I can use the old buggy easypopulate and easypopulate standard 1.2.5.4. The old buggy version has much better performance and more features, then uninstall that and use easypopulate 1.2.5.4, which fixes errors that might have been created by the old buggy easypopulate.
I know uninstalling/installing between old buggy easy populate and easypopulate 1.2.5.4 seems rather tedious, but it'd actually take less time than it currently takes me to import or update something.
I cannot offer support for Easy Populated Advanced here. Any questions regarding it can be raised here: http://www.zencartbuilder.com/forums/
I am usign Canada Post Shipping Module.
Anyone know how to add dimensions(L x W x H) & weight to Easy Populate ??
Thanks
Where do you add dimensions in Zen Cart? Weight is handled by Easy Populate already.
L/W/H are extra columns in the products table when using the CP shipping module, and accessible on the normal product-edit screen for data-entry purposes
aarrgghh .. sorry .. i just took out the version i have in .. have downloaded the other version from your website and will yell if i get stuck again (knowing how fick i can be, there will be no doubt i'll be yelling very soon lol)Quote:
Originally Posted by langer
Erica xx
well it didnt take me long to start yellin did it !! lol
i dont know what i have done .. but I am getting a 404 page not found error when i go to admin/easy populate.
To remove the old version i just worked my way thru the list of files that i ftp'd and deleted them .. then i installed the newest version.
please help this ficko get started :cry:
Erica xx
oh grrrrr i am so sorry :blush: :blush:
I just went thru all the files and compared to what i had uploaded etc . and found that one of them was in the wrong place .. sorry:blush: :blush:
Erica xx
Quote:
Originally Posted by Erica
Glad I could help! :D
so, are you sick of seeing my name here yet ? lol
This one will only confim my densness lol
is there a thicko's guide to using easy populate ? in particular the attributes (i think this is the attributes bit i am stuck on lol) ?
I am doing an online adult store and have a range of products that vary in size and colour etc .. eg: toy, available in 8", 10" and 12" .. the 8 and 10 are available in flesh, black and purple. the 12" is only availble in purple and black. The larger the toy, the greater the price.
also eg: lube, in 200, 500 and 1000ml .. in flavours strawberry, orange and vanilla. the larger the bottle the greater the price ...
how do i set all this up on the excel sheet ?
I went to tools, easy populate and downloaded the full list to edit. I also downloaded the model and attributes one. they both have a column called EOREOR which i am assuming is the attributes bit. do i just put in the various options in there. and will it then show the one 'model number' and all the various options and prices, or am i totally not getting this at all ?
Thanks for any light you can shed on this for me
Erica xx
Attributes are poorly supported by Easy Populate at this time. It is an area I will be attending to shortly.
Basically, Easy Populate is limited to managing: Option Name, Option Id, Option Value Name, Option Value Id, Attribute Value. That's it, which for most people may be enough. The gotcha is that it is so poorly implemented (legacy code) that it does an enormous amount of sql queries (= slow & server resource hungry) to produce a file that exceeds almost every spreadsheeting apps X x Y capabilities.
The attribute download file shows you the format required. Create some attributes in Zen Cart, and download the attributes file in Easy Populate to understand the relationship. Unfortunately, you cannot set the value display mode (drop down/checkbox/etc) using Easy Populate.
nice one .. thank you .. i am in the process of sorting that out .. but am having a bit of a problem uploading my stock at the moment (I really don't think i know enough to be doing this kinda thing:wacko: )
I have tried a large database and it didnt work. so i have cut it down to 9 products. I created all the categories and subcategories myself after the large list didnt work, and then uploaded the list of 9 products. for some reason only the first product at the top of the list goes into my shop :huh: heeellllppp !! lol
Erica xx
Are you adding 'EOREOR' at the end of every row? This is a common mistake.Quote:
Originally Posted by Erica
no, I left that column blank, am i supposed to be putting it in ?Quote:
Originally Posted by tj1
Erica xx
oooooooooo you little star .. i just went and put it in and its worked .. i have products !! .. thank you :)Quote:
Originally Posted by Erica
Erica xx
Erica, yes, you're supposed to add "EOREOR" at the end of each row. Glad it solved your problem.
Langer, thanks. I've visited your website for easypopulate advanced, but couldn't find some info I needed, I've PM'd you.
The most important thing I want to know if how performance of Easy Populate Advance compares to Easy Populate Standard.
My host, which BTW, I believe your familiar with (s***5.com, won't mention full name here), has limited my use of Easy Populate. They always kill the process at about 2 minutes max. They said they can't allow such type of script to run for more than a few minutes because it consumes too much resources.
I'm really looking for an alternative right now.;(
Got problem after upload.
It seems it's caused by line feed(\n) has been replaced to <br /> aftre upload.
1. Firefox - copy
2. dreamweaver - paste
3. copy the code, copy to excel
4. save as tab delimited text file
<table cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td valign="top"><img src="http://usa.asus.com/999/images/products/768/b.gif" border="0" height="23" width="16"></td>
<td>Quality K8 939 Solution with Leading Features All on 1 Board</td>
</tr>
</tbody>
</table>
Anyway can avoid the problem.
Thanks
hello again
I decided to bite the bullet and upload just over 1700 products all together. it seems to upload them ok because when i go to admin home it says 1714 products but it did bring up this error message, does it mean anything ? or should i just ignore it ?
Warning: explode(): Empty delimiter. in /home/costumej/public_html/shop/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
thanks again
Erica xx
If you're seeing this error, then you likely didn't upload a date field ... in which case you can ignore it. Date fields aren't required, but this error appears if no date field is found.Quote:
Originally Posted by Erica
thats right, i didnt put in a date field .. thank you :)Quote:
Originally Posted by DrByte
Erica xx
This is the smart tag option in EP config: Admin -> Config -> Easy PopulateQuote:
Originally Posted by ericpeng
Maybe I've missed it someplace and I opologise if I have but are there any detailed instructions on how to use Easy Populate?
I know that fromt he readme that if you set the v_status to 9 it deletes the product. What about the catagory? After testing teh v_status 9 I noticed that the products were gone but the catagory and sub catagories are still present. How are those deleted?
Details on how to use the file would be of great help:)
Thanks
Hi Guys.
Every time i try to update my items with easy populate, i get duplicate items! (Perticularly if i try to change categories). Is there a way to avoid getting duplicate items?
Also, now that i have 6000 items that have been duplicated, is there a way to delete them, without doing it one by one?
This is perticularly frusterating.
Anyone? There has got to be a way.
you cannot delete categories with Easy Populate.
The default behaviour for Easy Populate when an existing product is found and a new category specified is to create a linked product. You must 1st delete the product and then upload it to any new category.
Delete each product with v_status = 9.
I didn't understand this statement...Quote:
Originally Posted by langer
As Langer suggested in post #89 of this thread... ;-)Quote:
Originally Posted by DrByte
Quote:
To delete products, use v_status = 9 for each product. This is explained in the readme.txt and the install.txt...
Oops -- caught me skipping a few posts and a readme ... :ohmy:
sorry everybody, luckily working on EP, to bother you with this:
I am hardly trying to get ep 1.2.5.4 running, but neither on a fresh 1.3.01 nor in an fresh 1.3.0.2 install the installer is willing to do his job. In both versions this error is prompted:
1136 Column count doesn't match value count at row 1
So this was my troubleshooting up to now:
Downloaded a "virgin" copy from the modhole, just to see, if maybe some files were not correct;
Tried to install on a fresh copy of 1.3.1, just to see, if maybe the database-structure could handle the sql-stetment different;
Reinstalled the fresh ep on a fresh 132, again to check, if all files are correct;
Results see above. Does anybody can give me an Idea about what I am doing wrong?????
Thanks to all
this results from a modified configuration table. Have you added a module that has altered this table?
To overcome this, you will need to change the sql code text file to match the database schema of your modified store, and use the sql patch tool in Zen Cart admin to install it.
i'm running into an interesting situation - i'm able to upload all product and i'm a HUGE fan of easy populate - used it in osCommerce and now i'm moving up in the world to zen cart! 'priciate all the hard work langer
NEway, to the issue at hand, when i upload the spreadsheet, i get all my products, however, i have manufacturers for some products but not all - the products i leave empty are somehow acquiring a manufacturer from (i believe) the previously added product that DOES have a manufacturer. an exerpt from a fresh upload (after removing all products using v_status=9):
NEW PRODUCT! - Model: 90000 | 90000.gif | Essential | We're spil | 15.95 | | 8/11/2006 | 0 | Gifts | | Taxible Go | 1 |
NEW PRODUCT! - Model: 120000 | 120000.gif | SportDog™ | Blaze oran | 219.95 | SportDog | 8/11/2006 | 0 | Dog Produc | Training A | Taxible Go | 1 |
NEW PRODUCT! - Model: 250000 | 250000.gif | Dale Spart | Page after | 66.95 | | 8/11/2006 | 0 | Gifts | | Taxible Go | 1 |
these three items are the first three items in my spreadsheet. model 90000 is fine, the manufacturer is blank (which is good). the second item (model 120000) has a manufacturer 'SportDog' (which is good). the third item (model 250000) show's here no manufacturer (which is good) - however checking the item (250000) in my store, the listing has 'SportDog' as the manufacturer (which is NOT good). i'm lead to believe that this is due to a bug where all the fields are not cleared before the next SQL statement is executed (in particular the v_manufacturers_name field).
am i the only one who's run across this scenario? i've perused /admin/easypopulate.php and i'm looking between lines 1765 and 1802 of v1.2.5.4 - the IF statement that converts the manufacturer's name to the ID and the only place where the $v_manufacturers_name variable is used. i see that there is no ELSE statement to handle the case where $v_manufacturers_name==''.
the obvious workaround would be to put the items that do not have a manufacturer at the top of the spreadsheet, so there would be nothing to replace the nothing that is listed. but this is just another step, that could be easily forgotten.
a heads up to you langer, right now i do not have time to work on that ELSE or perhaps an ELSEIF... but if you might know of what i'm speaking and might be able to turn around a quick fix for this, that'd be most excellent.
again, love the plugin! and thanks for all the hard work!
Yep, thanks for this Idea, and indeed, as I am running my installation multilangual I had to add the language-table into the code. It now reads as follows:Quote:
Originally Posted by langer
INSERT INTO configuration_group VALUES ('','43', 'Easy Populate', 'Config options for Easy Populate', '1', '1');
see the '43' in it. This way it's working fine now. Thank you!
jens
I set up one product in Zen cart 1.3.0.2 then via EP 1.2.5.4 downloaded a "complete file" to edit.
Then I added 12 sample items to the file (some in the same categories and some in different categories) and exported as tab-delimited text and uploaded from client via EP.
EP Upload results displayed NEW PRODUCT! at beginning of each line and no errors reported (besides the next to the last line "no model field in record" which means end-of-file, so not an error). Then last line showed "Upload Complete".
And then when I checked the shop Catalog side I can see the new categories were created and numbers besides each primary category correctly indicate subcategories. However when I drill down thru the subcategories to an expected product listing, no products are displayed.
And similar within admin. New categories and subcategories display correctly. And on the lowest level subcategory listing, products are indicated as contained in the sub category (e.g. "Quantity 3 of 3 active" is displayed). But when opening the subcategory no products are listed.
I'm stumped. Any ideas? Thanks.
Woody
something has caused the description rows to not be created in the table products_descriptions. Have you changed this database table?
Hi Langer, Not sure if you are replying to my query. I think so.Quote:
Originally Posted by langer
No changes to the DB. The products I entered via Zen Cart admin are displaying just fine. But not the products I uploaded via EP.
Some of the products I uploaded purposely have the question mark in the model field and have HTML in the description field (but not all). And I have left some of the fields blank (inlcuding images) but all model, name and description fields contain data. v_status is set to 1 for all products.
I assume the above is ok.
My previous test upload went fine after my host staightened out mod_security issues. And not seeing similar errors now. Products just are not showing up.
Woody
i just tried to install ep 3.0.2 and when I click on easypopulate in admin->tools, all I get is a blank page. What's up with that?
Thanks,
Tom
Ok, I got the blank page fixed, and ep is trying to work, except now, I get the following when I try to upload a file:
I do have v_products_model in the first column. In fact, it's a file I've succesfully uploaded with the earlier versions of ep.Quote:
Progress: >
Warning: fopen(/hsphere/local/home/wtashby/theashbymint.com/uploads/NFL): failed to open stream: No such file or directory in /hsphere/local/home/wtashby/theashbymint.com/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 146
Warning: fgets(): supplied argument is not a valid stream resource in /hsphere/local/home/wtashby/theashbymint.com/admin/includes/easypopulate/classes/eclipse/FileIterator.php on line 132
Warning File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information
Help!:shocking:
Also, when I try to import a file directly after browsing for it by clicking the import button, I also get:
Somebody please throw me a lifeline here, this is killing me.:no: :wacko: :cry:Quote:
Warning File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information
Can anyone help please .. I have added over 1700 products using EP. everything was brill .. i did the customisation and got the rest of the site done .. then i downloaded a full sheet with the details in and made a start on the descriptions .. but they are not showing at all .. please can someone help .. i cant stand the thought of having to enter 1714 descriptions manually lol
Erica xx
incase you need to see it, the site is www.costumejewelleryaccessories.co.uk .. please be aware that there is adult products on there.
Is your file properly-saved as "tab-delimited" ?Quote:
Originally Posted by wtashby
Does it have the closing EOREOR column at the end of each row?
Does it work any differently if you upload the file by FTP and then tell EP the filename to use directly?
I'm not sure I follow you. You downloaded the details, but the descriptions aren't showing...Quote:
Originally Posted by Erica
Are you saying the downloaded file doesn't contain the descriptions, or that your edits don't show after uploading, or that after uploading ALL your products no longer have descriptions?
i started initially with a blank sheet, and added all bits except the descriptions and uploaded it all and it worked great. i then went and customised the rest of the site. this evening i went to admin/tools/easy populate .. and downloaded the complete delimited file. i opened it up in excel and started copying and pasting descriptions. i only did a few full ones and the rest i put 'info to follow' in the space. i uploaded the file and the descriptions are not showing on the products.Quote:
Originally Posted by DrByte
Sorry .. i just tried again, as i was describing what i was doing .. and its working :blush: sorry .. i obviously did something wrong last time
Erica xx
Thanks for the tip. Looking in the DB at the products and products_description tables I observe the products uploaded via EP appear ok in the products table but do not appear in the products_description table.Quote:
Originally Posted by langer
Any possible causes?
The products I added manually via admin appear in both tables (and display correctly).
The products and products_description table structure follows. (all default ZC 1.3.0.2 fresh install structure)
--Code:Products table structure
products
Field Type Null Default
products_id int(11) No
products_type int(11) No 1
products_quantity float No 0
products_model varchar(32) Yes NULL
products_image varchar(64) Yes NULL
products_price decimal(15,4) No 0.0000
products_virtual tinyint(1) No 0
products_date_added datetime No 0001-01-01 00:00:00
products_last_modified datetime Yes NULL
products_date_available datetime Yes NULL
products_weight float No 0
products_status tinyint(1) No 0
products_tax_class_id int(11) No 0
manufacturers_id int(11) Yes NULL
products_ordered float No 0
products_quantity_order_min float No 1
products_quantity_order_units float No 1
products_priced_by_attribute tinyint(1) No 0
product_is_free tinyint(1) No 0
product_is_call tinyint(1) No 0
products_quantity_mixed tinyint(1) No 0
product_is_always_free_shipping tinyint(1) No 0
products_qty_box_status tinyint(1) No 1
products_quantity_order_max float No 0
products_sort_order int(11) No 0
products_discount_type tinyint(1) No 0
products_discount_type_from tinyint(1) No 0
products_price_sorter decimal(15,4) No 0.0000
master_categories_id int(11) No 0
products_mixed_discount_quantity tinyint(1) No 1
metatags_title_status tinyint(1) No 0
metatags_products_name_status tinyint(1) No 0
metatags_model_status tinyint(1) No 0
metatags_price_status tinyint(1) No 0
metatags_title_tagline_status tinyint(1) No 0
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 15 products_id
idx_products_date_added_zen INDEX None products_date_added
idx_products_status_zen INDEX None products_status
Code:Products_description table structure
products_description
Field Type Null Default
products_id int(11) No
language_id int(11) No 1
products_name varchar(64) No
products_description text Yes NULL
products_url varchar(255) Yes NULL
products_viewed int(5) Yes 0
Indexes: Keyname Type Cardinality Field
PRIMARY PRIMARY 4 products_id
language_id
idx_products_name_zen INDEX None products_name
I cleared the text in each products description field in the spreadsheet and instead just entered D1 for each product description and then uploaded. But same negative result.
It is strange why one table would get updated but the other table would not.
Any other tables I should look at?
Wonder if the mod_security filtering on server is contributing to this isssue?
And I just did the same for model numbers. Cleared them all out and instead entered simple unique numerics for each product model eg. 1, 2, 3 etc. no errors reported but same negative result. Any clues?
Yes, it's tab-delimitedQuote:
Originally Posted by DrByte
Yes, EOREOR ends every line
No, it doesn't act differently using ftp.
I still get the error:
Quote:
File Import Failed! Primary index column v_products_model missing from uploads file. Please consult the readme.html file for more information
Can someone please tell me what the header fields for 3.0.2 are?
Many are the same as older versions, but many are also different! Especially the categories. I have already tried creating and downloading all of the test files available in ep, and NONE of them show me what to name my sub categories. In fact those data files and data templates you can create and download as examples are completely useless.:huh:
What do you name the master category, and subsequent sub-categories.
Thanks,
Tom
Hi again,
for some reason, when i go to split my file of around 7000 items, it will only split twice, and then those two splits only have around 600 items each!
I know I saved it correctly, and all of that, but I'm not sure what's going on.
This time, it told me this:
Not sure what to do w/ that information though.Quote:
Warning: fopen(/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1126
Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1129
Warning: fgets(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1141
Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/p/i/apinkpony/html/shop/admin/easypopulate.php on line 1168
Support for the advanced version is not offered here.Quote:
Originally Posted by wtashby
Any thoughts?
v_products_model ... must exist. EP cannot run without it.Quote:
Originally Posted by wtashby
Is this the name of the file you were uploading?: Full-EP2006Aug12-1111.txtQuote:
/home/content/a/p/i/apinkpony/html/shop/temp/Full-EP2006Aug12-1111.txt): failed to open stream: No such file or directory
Not sure why it would have trouble splitting the file. Haven't used that feature much.
While I realize it's a bit of a pain, can you split the file manually on your PC, and then upload the separate files manually?
Yeah. That's what I originally did was split in manually, but that's before I realized it could split it, it self.
It worked fine the first time, but I had to like, start over because I had a lot of ugly stuff going on with categories.
Anyway, yeah, guess it's back to manually splitting. No biggie, thank you.
Look, I said earlier, and I'll say it again, I HAVE v_products_model in my files. I also said that this is a file I have succesfully uploaded with earlier versions of EP. The problem seems to be that many of the header names for the advanced version are different than previous versions, causing errors, unless you updated your header names as well.Quote:
Originally Posted by DrByte
However, I have learned that support for the advanced version can be found elsewhere, as Langer was kind enough to tell me where to find it. Thank you.
Therefore, please consider my issue resolved and closed. Thanks.
Hosting provider reported that all is well with mod_security configuration.Quote:
Originally Posted by Woodymon
I'm out of ideas.
Anyone else observe similar issues of EP updating the products table but NOT the products_description table?
Anyone here know this mod well enough to explain if an internal EP log file is maintained, which records the INSERT SQL attempts which should be occurring during the HTTP upload process?
I've heard of a possible EP debug file but don't know where to find it. I have Admin > Config > EP > Debug Logging set to "true". Or maybe that feature refers to the "Upload Results" written to screen during the upload?
And/or is there would be a server log file (MySQL or Apache or otherwise) that might provide useful troubleshooting info?
If not able to solve this will just have to give up on EP and begin the long process of enter hunderds of products and categories manually. Or maybe enter via phpmyadmin
Thanks for any ideas.
Woody
EP log is in the uploads folder. I see it only when there are problems during operation, not continiously for all activities I don't know if ZC admin log would be any use for you ?Quote:
Originally Posted by Woodymon
Petteri
Thanks. Where would the EP "uploads" folder be located?Quote:
Originally Posted by petteriu
Or are you referrring to the directory on the client PC which we are uploading from? No log files appear there.
Where is ZC admin log located?
I was referring to EP advanced, but it seems that you aren't using advanced, are you ? There should be uploads directory defined in either EP configuration settings or easypopulate_config.php file.
Not sure if there is a place to view Zencart admin log, except going to databse itself (table admin_activity_log, note possible prefix in table name)
Petteri
Quote:
Originally Posted by Woodymon
No. v.1.2.5.4Quote:
Originally Posted by petteriu
I am uploading directly from client so not directly observing the temp directory. I see now the upload directory points to the /temp directory on the server.Quote:
Originally Posted by petteriu
I assume this refers to /public_html/shop/temp. That directory contains copies of the *.txt files I processed via HTTP upload from the EP client. But no log or debug files appear in that directory.
via phpyadmin looked in admin_activity_log table and page accessed column shows entries for easypopulate.php with page_parameters of "split=0&", corresponding to the times when I processed my various test uploads. No other info displayed.Quote:
Originally Posted by petteriu
I suspect I need to check the Apache logs. I'm not sure if I have access to DB server logs on this particular host.
Would you know if EP Advanced has the debugging and logging tools that might assist?
Any server confguration settings that I should investigate which might apply to my issue?
Woody,
If you download a fresh TXT file from EP for your products, then delete all but 5 records, edit their descriptions, and then re-upload to test whether their descriptions get updated, what happens?
Also, what tools are you using to do your edits?
I have some specials that I would like to remove.
ie. Revert back to the standard list price.
If I set the v_specials_price to the normal price, EZ pop will skip the record saying the specials price is higher than the normal price. Anyone have any ideas on how to use EZ pop or another method to remove specials in mass ?
Thanks
Hi I just aquired EP Advanced 3.0.2 and I thought I followed directions fully however when I go to tools menu I see BOX_TOOLS_EASYPOPULATE.
Clicking that brings me to an page not found error. Not sure what I'm doing wrong and I am really really new to this. I have checked prev posts but do not see an answer. Help.....
set specials price to 0 to delete themQuote:
Originally Posted by Muddler
Easy Pop has been working great for me but today it started giving me an error message:
Warning: explode() [function.explode]: Empty delimiter. in /home/bhstore/public_html/admin/includes/functions/extra_functions/easypopulate_functions.php on line 241
Funny thing is that Easy Pop still functions correctly it is just that this error is displayed after the process.
Not sure if I should be worried but I assume explode() does a lot of work when I am importing data.
Should I be worried?
Any limitation for uploading pictures or data for the permission 775 (cannot use 777 because of hosting limitation) of temp folder using Easy Populate?
Any limitation for multilanguage support?
Thanks.
this has to do with blank or unrecognised dates. You can usually omitt date columns without issues.Quote:
Originally Posted by madk
rergarding permissions, I'm not sure - you would probably need to test it, but I think it will be ok.Quote:
Originally Posted by icemanchai
The free version does not support multi language sites, and will in fact render non-default language fields uneditable for any new categories or products produced by Easy Populate.
I need help!
I've installed the ep program and now there is a link to the Easy Populate program in the Zen Cart program. When I click on the link to access Easy Populate I get a 404 error message. I'm totally new to this but I think the incorrect link was caused by the inability to configure this line of code change in the easypopulate.php file:
"Please set DOCUMENT_ROOT to $DOCUMENT_ROOT in your /catalog/admin/includes/configure.php. "
The DOCUMENT_ROOT code does not exist in the configure.php file.
I need help!
Thanks for your reply. :laugh:
I am getting a strange new problem
When I upload the file it says its adding the products as new.
I see the new folder I created, However the new items are not listed.
Then I go into admin, I see the folder. It says the products are there.
But When I go into the folder. There is nothing there!
What do i do??
Oh. Btw figure I would add this as it may help my desperate problem.
I was first uploading all my products to a "Temp" directory.
(Checking if all images was there. Troubleshooting etc)
then once I was satisfied with that I would send another upload of the same products to the proper categories I wanted them in.
Problem is, I cannot delete the Temp directory because then it would delete all of the products. Also, All the product now have no Master ID to them. Something I was afraid that would haunt me later. So when I was done with them I moved the "Temp" folder to another spot of witch I closed the file. So I have a bunch of files in a closed directory that I called for fun "The Temp Graveyard"
Now my fear is that maybe with all the multiple places, Is there a limit on how many products I could have? Should I have been doing something different all along?
I'm not fully understanding your problem here but I want to try to help...Quote:
Originally Posted by milobloom
If I understand things correctly. You are uploading your CSV file and instead of creating the product in the folder they belong..you are creating them in a temp directory. You are then double checking everything and then reuploading them into the correct folders. Is this correct?
If this is correct I would assume what is happening is that since you are uploading the same products to 2 seperate folders they are linking themselves together. If this is the case then deleting one should give you an option as to leave one of them.
My recommendation to you would be to just upload them with a status of 0. Then you can check all your data and activate them if they are ready to roll out.
Now maybe I am just not understanding this at all and everything I said makes no sense..ha. If so please elaberate.
- "folder" vs "category" may be confusing
- according to the readme, if you want to change the category in which a product appears, easy populate requires that you actually create a new record, and delete the old one. You do this by creating a column called "v_status" and set the value to 9 for delete, or 1 for active, or 0 for inactive.
(If there's another way, feel free to correct me !)
Ok. Ill will expand.
I have soo many products with diffrent size options.
Some Small Medium Large
Same Mediam Large Extra Large
etc...
So first, I upload say 300 S,M.L
I Put them in a temp directory.
Then add S,M,L attributes on the 1st item then copy the
attributes to the entire category. Then when I am done,
They are all then moved to their respective catagories.
I thought that was a smart idea.
But perhaps your right. Ill try it. Set status to 0 on the temp
Then take of the 0 status when they get moved to their catagories.
Is that right?
But now. I have this horrible problem.
After i run easy populate, Here is what i see.
Folder Temp. Yup its there. Says there is say 176 Items in the folder.
But when I go into the folder (GASP!) its empty! Where did my files go!
I look on the site. Same thing. Folder is there. No products inside.
I have 1000's and more products to go. So if I was doing it wrong with the folders then I wanted to make sure that wasnt causing the problem and if it was, is there a way to fix it?
I guess I'm not sure exactly what is going on.Quote:
Originally Posted by milobloom
I would get rid of any sort of temp category. Upload products directly to their home. Setting the status to 0 will allow you to view the items through the admin panel but they won't display in your catelog till you activate them.
When you upload your database does EasyPop list all the new products one by one?
Well think about this.
I want to add alot of products to existing directories.
But the problem is that I have to put attributes to them
(I used the example Small,Medium & Large)
For me to put them into say 170 different items, It would take me
a very long time. So what I do is stage them in the "Temp" Directory.
Then I added all the attributes all of the products in that "Temp" direcrtory.
Sooo The next step i do is upload the same products again.
Because the ID's are the same. Now I have those products in
their correct catagories WITH the attributes in them! A huge time saver!
But when I went back and deleted the "Temp" folder. All the products were gone!
So I thought, Why is it doing this? So I went into one of the items to see what their master ID was. (I figured that the master ID must have been the first directory I uploaded the files to. The "Temp" directory. The way I found this out is I went into the products attribute controller and then to the "Multible Catagories Manager" In this area you can select multible catagories for any product. It is there where I saw that all the products I uploaded did not in fact have a Master ID, in fact they all had invalid Master ID's for them. Now I could in fact go into each file and set the master ID to their correct folders and then after I do that delete the temp folder. However with soooo many products, That too would be extremly time consuming. So then the only assumption I could come up with is to "Keep" the "Temp" folders and move them to somewhere I dont need them.
I know this sounds very wastful in terms of Database space, but what I am doing is uploading 100's of products at a time wityh attributes. So It was the only quick way I could think of to do it.
This being said.
There are the few questions I have.
1) Is this the wrong way to do this?
2) Can doing it this way cause the problem I am having
3) Is there an answer to my biggest probem, that I cannot upload any more products using my easy populate. (That the folder shows up, shows a count but the products are not inside.)
Okay this is making sense now.
When you upload the 2nd database Zen is creating a link between the 2 items.
If you were to delete these items 1 by 1 you would recieve a prompt asking you if you want to delete the item from both the temp category and the final category.
What is probably happening is that you are deleting these items through EasyPop or just deleting the entire folder. I assume that is you are doing so this way you are not recieving this notice and it is removing the product from both categories.
Import a small batch of test products and follows the same steps you have followed but try to delete the items one at at time and see if it has the same effect.
Well.
I would except for one thing. Which is why I started asking questions in the first place.
I Cannot upload anything now. I Upload to temp directory.
The folder is there, It says there are say 176 Items in the folder.
But when I open the folder. Its empty. The products arent there.
OH BTW I also wanted to add. I do not have the same problem if I add products manualy.
1. Are you importing directly from your pc or are you importing from Temp Dir?
2. After you import what is displayed on the screen?
I am importing directly from my PC
When I import it looks like everything is working properly.
It says NEW PRODUCT after each one.
Yea there are NO errors.
Do you think I would get diffrent results adding it from the temp directory???