It happens. Glad I could help to some extent. Sorry I wasn't in a position sooner to possibly point that out. But you did find the mistake on your own, so good work. :)Quote:
Originally Posted by ValleyJim
Printable View
It happens. Glad I could help to some extent. Sorry I wasn't in a position sooner to possibly point that out. But you did find the mistake on your own, so good work. :)Quote:
Originally Posted by ValleyJim
Well, I haven't used it yet, and I may have it wrong, but I was thinking that if you reduced your split number perhaps on export fewer rows per file will be provided?!Quote:
Originally Posted by Feznizzle
The alternative is a bit more intrusive, but to rewrite some of the code to recognize that a column (ie, description) has not been imported and to not adjust the database as a result.
It was my understanding that generall speaking that was how other fields worked (ie in full attributes, to only upload/update the desired columns); however, it would be my guess that in design/further development it was considered that the product description would always be attached to the product/most likely the field to be updated and therefore not setup to be bypassed when empty.
I can see why the ability exists to make the field go blank when the field header is imported, but I think this scenario was not necessarily an expected situation.
Been reading for hours and trying to catch up. Hate asking questions which have been answered. I have 1.5.1 store and installed 1.2.5.7d, which I guess isn't even this product. I also have no luck with sql statement but was able to load basics, just don't have the config menu items yet. Basic question, should I get on 1.2.5.7 some other support link, or should I download 4.0 on Gitwhatever? Can someone send advice, and the proper link if I should go with 4.0?
I have downloaded the empty database file, and could not download my products yet. Should I go, 4.0?
Just so nobody needs to do a long post about it, I deleted 1.2.5.7, and came onboard this thread. Installed the program, no sql, and worked immediately. I downloaded a copy of my database, and while it may be right, it is not particularly pretty, especially in excel, and I have downloaded OO for use Why no pictures, or do you only get the .jpg information? Much other stuff is there as well. Why so many 1s and 0s?
v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_d escription_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_ expires_date,v_products_price,v_products_weight,v_product_is_call,v_products_sor t_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products _priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added ,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_tax_class_title, v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_mode l_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_titl e_1,v_metatags_keywords_1,v_metatags_description_1
RR01-0104,"1","castturnbuckle.png","""Classic"" Cast Turnbuckle","<b>Our extremely Sail-Friendly 316 Stainless Steel Closed Turnbuckle design</b> promises full weather and salt protection in a fully rounded near-mirror finish. Our Classic Model"" features a hand-polished silky smooth shell, and we carry it in many sizes, through relatively massive proportion. <p>You may choose from 4 1/2"" on our smallest units to over 38"" on the largest. Our <b>Classic Turnbuckles</b>, like all of our stainless products, are covered by our 10-Year Guarantee, that they will always look and perform to your <em>total satisfaction</em>.","","","","","0","0.45","0","1","1","1","1","0","","2013-08-07 01:28:51","1000","Reasonable Rigging","Turnbuckles","Taxable Goods 00000","1","0","0","0","0","0","","",""
RR01-B0106,"1","4wayturnbuckle.png","4 Way Forever"" Turnbuckle","The 4 Way Forever"" Turnbuckle allows your rigging to flex and adjust in all 4 directions. Though standing rigging does not require excessive movement, this design insures minimum stress to your fittings and cable, and insures the longest possible life for your investment. <p>These pieces are <b>an elegant and heavy duty design</b>. We can custom order them dramatically bigger in size than we have posted, so if you have a 130 footer, and really want to get your groove on, <b>we can hook you up!</b> </p><p>We believe this is one of the finest and cleanest turnbuckles on the market, and have trouble telling you low points on either this or the A0106 unit, so please review both. </p><p>If we were to characterize them for your comparison, the B0106 model is slightly slimmer and slightly less stylized than the A0106, which is slightly heavier duty, and a tad more stylish. </p><p>We realize this is not how rigging is often characterized, but the personalization of the products is important to allow you to make not only a raw strength statement, but to accurately capture the style sense of your new rigging.</p>","","","","","0","0","0","3","1","1","1","0","","2013-08-09 10:46:40","975","Reasonable Rigging","Turnbuckles","Taxable Goods 00000","1","0","0","0","0","0","","",""
RR02-0105,"1","danforthssanc.png","Danforth SS Anchor","<b>The Danforth SS Anchor</b> is a classic model, upgraded to the maximum look possible for boaters with a strongly developed sense of personal or boating style! <p>We offer these anchors often at <em>hundreds less than our competitors</em>. <p><b>You'll Love our Rigging for as Long as you Love your Boat!</b>","","","","","0","32","0","5","1","1","1","0","","2013-08-11 14:40:51","100","","Anchors^Stainless Steel Anchors","Taxable Goods 00000","1","0","0","0","0","0","","",""
Quote:
Originally Posted by Trademagic
Quote:
Originally Posted by Trademagic
So, you are correct 1.2.5.7 is a different product having it's own forum in which to ask questions (which I suggest if you are going to continue using that product). This particular version, while quoted as version 4, is not a linear upgrade from 1.2.5.7, but a variation of EP. That said there are probably differences in the way the data is populated/managed between the two "versions". EP4 requires each product to have a unique model number designation. As for the difficulty of running the SQL statements, what do your various error logs say?
I thought there were a few suggestions posted in this forum related to the SQL, but it's been a long time since I have installed it. To that end, the download location is provided in post 1 of this forum (select arrow at top or bottom of page that says "first" and will be taken straight there), until an official ZC version is provided.
Was there uninstall SQL to 1.2.5.7? Could it be interfering with installation of this version?
So related to your other questions and I know that you are still learning about some of the details of ZC, what you are seeing/working with is the raw data that is used to present information in the store. So, showing things like pictures and sometimes the word true instead of 1 are all things handled by ZC code based on the data provided. So a majority of the ones and zeros in the column. Are because they relate to statements such as, is on sale or display or don't display meta tags, etc.
Be sure that you make a backup of everthing before you use this, I know that you wouldn't want to have to rebuild either the code of the store or the database again.
I think it is working. I got the file, and it looked actually fine in my post above, except I question why the 1st example had so many quotes around the word Classic first few words. Is this because I used quotes in the actual filename? That could be dangerous, I guess, and I will change this to avoid confusion. What about the pictures? Does the file only need the image location, or am I looking for pictures here in the file. Also, if I use IH4, should I upload all pictures separately, or does the program do this in an integrated way?
To learn this best way possible, what should I read, the wiki?
Finally, do I import the OO file in the spreadsheet to change, or do I export the comma delimited quote enclosed text file itself? Thank you all for your knowledge and application of it to help others.
Marc
So, the double quotes are needed as part of importing/exporting the data to provide the final result of a single set of quotes around the word. There is no reason to avoid that if the desire is to have the word(s) in quotes when viewing a product on your website. It's just part of the process of converting what is stored to what is seen and vice versa.Quote:
Originally Posted by Trademagic
As for the pictures, and just about everything associated with EP4, this plugin (and I have somewhat said this before) interfaces directly with the data that is presented in the store, so yes things can go wrong and negatively effect what is shown/done on the store. (Backup before making change, review/become familiar with affects of action taken.) Unfortunately there is little documentation associated with this plugin at this time, but the author has been working on that and it is why this is not yet an official zen cart plugin. To that end, the issue with/question about the pictures is related to how Zen Cart (and other plugins such as Image Handler) deals with pictures. Zen Cart requires a base picture name and picture file(s) associated with that name. The name is the path to where the picture(s). Are stored, and the base name for all pictures associated with that product. So to learn more about the picture part, there are wiki related entries to how to have more than one picture associated with a product. At the same time, if that knowledge is not learned, then it is possible to inadvertently have more pictures shown than expected.
So yes, you will need to also upload/verify uploaded the pictures that will be displayed. My recommendation would be to first upload the file(s) then to use EP4 to have them displayed (prevents any customer from not seeing a picture when the EP4 entry is uploaded.) The entry made in EP4 should reflect the base name (path included) when uploading.
As for the question of chicken and egg, I'm not sure I understand, but the process is this for a "first" time action: backup your database; download the EP4 data as a CSV; open the file using a program that can manage a CSV file (Open Office is recommended because out of the box it can be setup to export a CSV that will be properly interpreted upon upload), make the desired changes, additions, modifications desired; export the data from the editor (recommend a filename that ends differently than before); import/upload the file to EP4; maybe backup your database again in case changes made would be overwritten if the database was restored from the last backup; and then import the new CSV file from within EP4 and check the results. If the results are good, keep doing what you're doing, if not, then restore from your most recent backup.
So hopefully that answers that last question.
Ok... I finally need some help myself. I got everything setup. I built my CSV table. Imported... worked fine. Go to my site and all shows up. Click on ANY product and I get 404 Page Not Found from my site.
Have a look if you like... www.obesupply.com">www.obesupply.com
Anyone have an explanation or solution?
Thanks.
Can't specifically identify why this has happened to you. It does seem that product numbers have gotten modified in some way. I randoml attempted a product numberafter observing what you described as a 404 page not found. The page not found was assumed to be your entire site, not the Zen Cart page not found error that exists. In the main body area of the site. So, I found that: http://www.obesupply.com/index.php?m...ducts_id=18190 provided a product description, but I couldn't tell you if that product id is the one that you expected it to be and if it was at all involved with the file upload you provided.Quote:
Originally Posted by dgantonacci
So there is more that you could describe to try to narrow down what happened: what editor did you use, using a file compare programn how does the downloaded CSV file compare to the uploaded CSV file? What error log messages do you have if any? Did you install this app in parallel with a similar one instead of uninstalling all parts of the previous? When did this start happening (first upload?) Did the upload include all items from your store? If not, do those that were not affected work as expected? What changes were you trying to make(ie what did you change in the file before uploading)? If you downloaded a new CSV file now and did a comparison of the uploaded and newly downloaded, what's different?
Something in there should help either answer your question(s) or help us help you. :)
I write for first time on this forum
hello to all
I wonder if with the plugin easypopulate 4 I import products of more 'than 2 levels of categories.?
thanks
maybe I'm wrong, and I'm glad to be wrong! in the short guide of the plugin there is textually
"Categories are handled differently from other versions of EP. You can now import multilingual categories (Like Products Names, descriptions, etc.).
To achieve this, each v_categories_names_1, v_categories_names_2, etc. correspond to a language installed in your system, and individual category
names are separated by the Carat "^" symbol. For Example: Bar Supplies^Glass Washers^Brushes
"Bar Supplies" will be your Top level Category, with "Glass Washers" as a sub-directory, and "Brushes" as a sub-directory of "Glass Washers"."
in this case seems to support 3 levels of product categories.............
Hopefully I understood correctly, you want to know if a single product can be uploaded to an area of your site that is for example in a sub-sub-sub-etc Category of a category. For example: The "product" (Dog named Fluffy to be located in the category path of Animal->Mammal->Canine->Small Breed->Chihuahua.Quote:
Originally Posted by favjola
Yes, it will place the "product" Fluffy in the sub category Animal^Mammal^Canine^Small Breed^Chihuahua when uploaded with that information.
Off the top of my head, I thought that it would create those categories if they did not exist automatically when uploading the product; however, I know that there is at least one file format that processes the entry to create the new category(ies) if they don't exist. The existence of the category is dependent on Capitalization as well. As you may have read, Chihuahua and chihuahua are two different categories when processed by the plugin, so a "new" category would be created if it didn't exist at the point the record was imported.
1) Does that help and 2) did I understand your question correctly?
I am wondering if someone can please tell if this mod support product deletion. What I want is to use this mod (if possible to delete all products from our server that are no longer available). In the other Easy Populate, changing the status to 99 deletes the product from the server but I don't know how to accomplish the same goal in this mod. Thanks!
Don't hold me to it, but I thought I ran across something that said a status of 9 would delete it (or something). Otherwise hiding the product would make it unavailable to customers (status of 0 I thought).Quote:
Originally Posted by BlessIsaacola
Sorry, I'm mobile and don't have a good link to the code to be able to find out if the above is 100% accuratei do know that the "alternate" status was 9, but not sure what exactly it deletes.
Thank you so much for your prompt response. Status of 9 did the trick. Thanks!Quote:
Originally Posted by mc12345678
Sorry I'm new here and not sure how to post a new thread. I'm also a newbie using Zen Cart and I'm currently using EP4. The problem I'm having is that when I upload my attributes to the site the items are then listed with the following *Mixed ON. I didn't have this problem when using EasyPopulate and I'm not sure what I'm doing wrong. I am having to manually change all the items on the admin console through the price manager. I'm not sure where the problem is as when I upload the full ep products are uploading to the site fine but when I upload the attributes file that's when it happens. I'm using the Basic attributes file. The Qty Min/Unit Mix:is switched to 'no' so I'm having to edit every item to switch it to yes. Any help greatly appreciated.
Welcome to the forums!Quote:
Originally Posted by cherylc
I would say that your post is good, it defines your problem, identifies how you have basically repeated it. Perhaps there could be more about the version(s) of things you have installed; however, I would say that there is sufficient information to start problem solving the situation.
You said you are using the basic attributes file to upload your data, have you gone back after a basic upload and done a detailed attributes upload? Or an update of the all products? (I am not sure where the mixed attribute field is brought out of ZC via EP4 to be able to describe in what file to set the value and then upload into ZC/EP4.) In the mean time, it may be necessary to run a SQL statement to toggle the Mixed attribute on (which would be faster than digging into each product).
Hi. thanks for your reply. No I haven't done a detailed attributes upload as I'm not sure how to do this. I was getting along with EasyPopulate fine then it just stopped working. Apparently there is some kind of bug? I've really struggled with EP4 - I'm OK with the full EP just the attributes files. I know I sound hopeless but I'm not sure how to run a SQL statement. Like I said I'm a total newbie to all this and am learning as I go along. I managed to find where the problem lies in the admin console but just can't figure out what it is on my files which is causing this to switch to 'no'. Also, the admin console runs really slow on my pc so yesterday it took me over 2 hours to edit 111 items. By the way I'm using Excel - don't know if this makes a difference. I'm also using version 1.5.1 of Zen Cart
Generally speaking, using Excel with EP4 could cause problems if additional actions are not taken with the CSV file that is produced from it or from within Excel to ensure that the CSV file is properly formatted.Quote:
Originally Posted by cherylc
Examples identified here have been, the change of date format (Excel default (01/02/2013 versus 2013-02-01)), not all strings get captured in quotes, and a few other things that are "unexpected" when exporting a document as a CSV.
So a detailed attributes file is a lot like the basic attributes file. The easiest way "to do that" is to export a detailed file and take a look through it. From there you can make changes (suggest saving as a different name so that you don't lose the previous download), and then upload the changed document. The suggested editor when using EP4 is Open Office (OO) as it can be configured to address all of the "other" issues not addressed by Excel. That said, I do not think that Excel specifically is the reason you're seeing what you are seeing.
If you look in the file admin\includes\functions\extra_functions\easypopulate_4_functions.php search for "function ep_4_set_filelayout" then find "$filelayout[] = 'v_products_quantity_order_units';" just below that and add:
and then a little below there, look for:Code:$filelayout[] = 'v_products_quantity_mixed';
"p.products_quantity_order_units as v_products_quantity_order_units,"
and just after that add:
save the file back to it's location, and then your import and export of the full product list should include the information related to the mixed attribute.Code:p.products_quantity_mixed as v_products_quantity_mixed,
Regarding why you have to "change" that value, for products that have already had that set as on (value of 1) this should not change; however, the typical default setting of ZC is to create the product with the attribute set to off (value of 0).
My recommendation would be this: Upload new product(s), add attribute(s), then upload the product list again with the value of v_products_quantity_mixed updated to show 1 for those products that are to have mixed value(s).
(Knowing the version of ZC in this regards, does help at least a little. It confirms that this product is compatible and not a reason for the "error".)
Help? (BTW, don't have a problem providing more information as requested, I understand that you are new to all things Zen, but also don't want to talk down to you and go through some long description that you already know how to do or understand. :) )
Hi. Thanks very much and believe me you can talk down to me....the simpler the better for me!! I will try what you suggest and hope this works. I don't have an EP to upload at the moment as I am still working on the next category product. I've found it easier to do all my categories as a separate file then upload individually. As the website is now live I am basically just adding more stock as we get it. So just to make clear...I make the changes you suggest on the admin console, then I download a new EP file, save it to my computer, add products then upload and import? Can I still use the basic attributes file? Also, I added our website to the 'Showcase' list but it hasn't appeared and there was no option to add a photo. Does the site need to be verified first? Many thanks for taking the time to reply. It is much appreciated!
I really am hopeless, I can't even find the file admin\includes\functions\extra_functions\easypopulate_4_functions.php So sorry :blush:
I'm not entirely sure on the "process" that the operators of the Zen Cart showcase go through, but it could possibly be a few days before they "authorize" the site to appear in the showcase area. The process is relatively quick in the grand scheme of things, but each individual has his/her function and some of them do particular things on particular days of the week so as not to get too back logged and to keep things moving at a good pace.Quote:
Originally Posted by cherylc
Also to be sure that we are speaking on the same page, the changes I suggested are not something that can typically be "entered on the admin console", rather it is change to the code that was added when EP4 was installed. Inserting the lines provided into that file (approximately where suggested, doesn't have to be immediately below each of the recommended lines, but seems to make sense to be adjacent to them as they relate to each other). Yes you will still be able to use your basic attributes file; however, the code changes I recommended will apply only to uploading the full file. I got to thinking that perhaps that attribute is more applicable to an item than it is to an attribute; however, I think that both must exist in order for the function to work as expected. (That is that need to have some differences in attributes in order to buy 2 red shoes and 4 blue shoes to meet a minimum purchase of 6 shoes, if you were selling shoes with a minimum purchase quantity of 6). I should have also stated, that these are merely suggestions and are made on a best effort principle. I did not test that change; however, presented it based on my past experience with modifying that portion of the code to obtain the information I wanted.
As far as having an EP file at the moment to upload, after making the code change even downloading a file, keeping one line (possibly of a deactivated product), changing the one attribute to it's alternate state, uploading that file and checking to see it's success (or hopefully not failure), could make the world of difference for you. Course should backup before doing anything that affects the database.
If not mistaken, the basic attributes file associates an attribute to a product, while the detailed attributes file specifically identifies all of the factors of the attribute that is associated with the product. You will still be able to use that method of upload/update, and in fact the changes suggested above do not affect that at all.
Okay, so in your store (on your website), you should be able to use FTP to login to the files area. Then off of the main part of the store is an admin folder of some type, (In order for your store to be shown on a computer, the admin folder must be named something else...) That said: Don't provide it here... Don't give that folder out to the public... Under that folder will be includes, then functions, then extra_functions. If you have EP4 installed, you should have easypopulate_4_functions.php (If not yet installed, then the file is found in the downloaded zip file... But let's start from there... Found it?Quote:
Originally Posted by cherylc
Hi Everyone...
I need some help understanding what I am doing here. I've got the Easy Populate module installed and it seems to be working. I downloaded a FullEP set and added some products and it all seemed to load just fine. My issue is that I am selling downloadable products and would like to be able to add the zip file field right to the same spreadsheet and upload it. I already have my option names and option values set up in the store as Download 1 - Zip 1 (radio button).
My question is: Can I simply add the fields for my zip file onto the same spreadsheet as all my other product info? and if so...
What do I list the fields as and where do I add the zip file name?
Thanks so much...
So, I must say a good question. First would say that as a result of the appropriate fields not showing up, that it may take a little more to turn around and get the desired data back into your database. Typically the field name in your spreadsheet file is the field name in the database with v_ prepended. So would have to identify what the field name(s) are that would be needed to hold the information you are looking to include. The other part of that is what table(s) hold that additional information. My thought is that some additional coding would be necessary to accomplish the task. The functions file under the full section of the set file layout would need to include the additional lookup info in the sql command, and then I think in the import area some more coding may be necessary to properly upload/import the new data to the correct table(s).Quote:
Originally Posted by amandavz
Quote:
Originally Posted by amandavz
Basically, I might have been able to edit my last post, but doubtful within the time allowed, so thought I would answer the questions asked a little more specifically.Quote:
Originally Posted by mc12345678
Yes you can eventually have the related information added to your table, but I think you will have to have additional coding to handle it. The zip file location would be a path much like the photo path. I thought I remembered seeing download attribute information though in the attribute(s) file(s). So it would take a series of download/upload to get all of the info into the database the way desired.
I haven't personally looked into that attribute of it yet, but I seem to remember seeing the additional fields addressed in the code. If that is the case (and I'll take a quick look in the near future to see if I'm right), then you would work with the appropriate attributes file after the product description/details were uploaded.
Okay, so had an opportunity to look at the code from a computer. The detailed attributes file is the way that EP4 is currently setup to handle/address the attributes that you are looking for. If you download a version of that file now, you should see examples of how to format and upload additional attributes. One reason that I think this is setup this way is that you can have multiple files associated with a single product, therefore, a format like how the attributes files work is the path to go. As said previously, this would require working with two different files. The full file for all of the data associated with/specific to the item, and then an attributes file to link the download file information to the product.Quote:
Originally Posted by mc12345678
Specifically, the fields: v_products_attributes_filename, v_products_attributes_maxdays, and v_products_attributes_maxcount would at least be applicable. with your zip file filename listed in the first field designator shown here.
Okay...So I downloaded the attributes files and set it up with the following fields:
v_products_model
v_products_options_name
v_products_options_type
v_products_options_values_name
v_products_attributes_filename
v_products_attributes_maxdays
v_products_attributes_maxcount
I then added only 1 product to test this and imported the information. In doing so I get this error:
File Import Completed with issues.
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
Do I not need to add the
v_products_options_name
v_products_options_type
v_products_options_values_name
To the file since they are already set up in the store? I am not sure I completely understand how this works but I do appreciate your helping me. Thanks so much. :)
I GOT IT!!! :)
Thanks for all your help!!! :)
Okay...so I tried multiple ways to get this thing right. I ended up downloading the Basic Products Attributes and added the fields you mentioned above. I was trying to create it with JUST the fields above, I left the Basic Attributes in tact and added the fields you specified, uploaded, imported and it worked!!!
I am going to run a test purchase just to make sure I got it all correctly done...thank you so much for your help. My customer will be very happy. :)
UPDATE:
So I ran the test purchase and everything "looks" like it is there, t shows me the attributes attached to the product, but there is no actual zip file t download at the end of the checkout.
It only takes me to a page that says: "Please notify me of updates to these products" if I go into My Account, it does not show the download button there either.
I feel that I am so close to getting this, I am just not there yet and not sure what I am missing.
If you want to take a look, the site is: http://studiorockcreek.com/shop/ and it's the product marked FREE.
Thanks. :)
What were the results of downloading the detailed attributes file? It seemed that there were more fields in there that would accomplish what you are trying to do, and the way the code appears to be written it includes download (and subsequent upload) of the information needed to populate/activate the download. Perhaps another question is, the file that is "linked" to the product, does it exist where it is supposed to be and named the way it is supposed to be on the server?Quote:
Originally Posted by amandavz
I'm having a strange issue that I've been working on for days and I just cannot figure out. I've been using EasyPopulate with no problems until I recently tried to import some new products. I've never had this issue before, but this time when I imported new items everything is perfect except all the new items' images are distorted.
And when you you click on the "large image" link on the product page of one of the new items the same small distorted image is shown (it doesn't enlarge). But if you right-click on the small image and select "view image" the whole large image is shown.
So for some bizarre reason it is shrinking and distorted the images of any newly imported items (but for the other items that are already in the database the images are not distorted, only the new items). I have the Configuration/images settings the same as I've always had them, and as I said, the old products are still displaying the correct image sizes and nothing is wrong there (only new items are affected). This is the only issue with importing new items -- everything works perfectly except it is messing up my images.
I've even tried to zero in on the problem by removing most entries in the CSV file (such as v_manufacturers_name, v_metatags_description_1, etc), leaving just the bare minimum (v_products_model, v_products_image, v_products_name_1, etc). I even removed most products in the file except for five (thinking maybe some character such as * somewhere was causing problems). But none of this matters. No matter how small the CSV file is the images always come out distorted and the "large image" link doesn't show the large image (even though it is there on the server).
And, I've tried re-uploading the images but they are fine. I upload in binary, and image folder permission is correct (all other old products have no problem showing the image correctly). Something is going on in EasyPopulate that is telling it to shrink my images.
What is strange as I've always imported new products using EasyPopulate and never encountered this problem. Thank you for any help anyone can offer!
I'm using Zen Cart 1.5.1, and EasyPopulate 4.0
If I download the Detail list and try to add the proper information in the proper fields (same as I did with the basic) I get the same error:
File Import Completed with issues.
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
I am only adding information to the fields I need:
v_products_model: 1
v_products_options_name: Download 1
v_products_options_values_name: Zip 1
v_products_attributes_filename: test.zip
v_products_attributes_maxdays: 90
v_products_attributes_maxcount: 5
Does the entire sheet need to be populated with content? Like 0 in the fields I don't need? This worked perfectly in the Basic list but with no actual zip file to download.
To answer your other question...I'm not sure what you mean by "linked"...if you're asking if I have the zip file attached to the product, no I do not. That's what I hoping to do with this module. I do have the test.zip uploaded into the downloads folders in the back end of my Zen Cart and named the same on the downloaded spreadsheet.
Was an error file created in your list of download files? Something that shows the SQL code? I've been writing some independent mods so my version of the SQL code may have been corrected if there was in fact an error the original (remember beta) code.Quote:
Originally Posted by amandavz
As for my discussion of a "linked" product, what you described is what I was asking about: that the file exists on your server as it is expected on your server. It does appear that the issue is related to the upload of the detailed attributes file. This is the file that will "finish" your process. So somehow need to get that fixed. The error message seems to ask for the file to be searched for extra tabs in the data (like the tab key has been pressed), as for zeroing out or omitting data, it is possible, that this plugin will remove entered data if a field has been deleted from the file. Best way to maintain data is to download what is there, change data of things desired to change, then upload.
I'm not at a computer at the moment to test a single upload.
This is the TXT error I get when I add JUST the fields I want to use:
MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND
products_id = AND
options_id = AND
options_values_id =
' at line 3
When executing:
SELECT * FROM zhs_products_attributes
WHERE (
products_attributes_id = AND
products_id = AND
options_id = AND
options_values_id =
) LIMIT 1
I tried adding it with all the fields populated after attaching a zip file to a product and THEN downloading the detailed csv file. It shows me the proper format of each field but also gives me an error message reading SKIPPED!! and something about Attributes not attached to model. I don't quit remember off hand, but it never generated a TXT error file.
So when you say that the other "old products" have no problem showing the image(s) was this determined by uploading the new image in place of/in addition to an existing image of an old product? (Ie, if old product image is renamed, and new image uploaded with old image name, then that new image shows properly on an old product, but that same image doesn't show properly with a new product?)Quote:
Originally Posted by JNR345
EP4 does not actually affect images, it loads the base name(s) into the database. Generally speaking EP4 has little to nothing to do with the problem you are describing (note that a link has not been provided for us to inspect).
Might also help to identify the data uploaded for the offending product, ie pathname provided for the image(s). As typically and assuming you are not using an image handler, the base file is provided to the database, and your large file is uploaded with the appropriate extension before the suffix file type I think it is _LRG (or maybe it's _LARGE) I use an image handler that doesn't require uploading a filename with such an extension, so I forget the proper format.
Quote:
Originally Posted by amandavz
Also, to answer one of the questions, what you are missing? Well, each of the file types has been provided for a purpose. A basic file will address things that relate to the file type, like basic attributes addresses the existence of an attribute in the database and that the attribute has a relationship with the product (by model number of course), while a detailed attribute assigns data associated with the attribute and all of it's details to the specific product (by model name of course). The basic attribute file is used to give the selection of a file or whatever value(s) that are assigned. The actual file data would be handled in the detailed attributes (this data is also in a different database table than the data associated with the basic attributes.
And let me describe another way. ZC is made up of data associated with other "previous" data. That's why the operator must first enter a product, then enter attributes associated with that product, then identify specific detail about how that attribute affects the product. Each building on the next.
I started the above earlier, but hadn't sent it. Now it appears applicable.
First you need to do a basic attribute upload for your product, (which you did thinking that all of the new data was incorporated to find that not so.), then download a detailed attribute file, mod what you want modded (ie, add the filename, number of downloads, etc.), and upload the resulting file. There's no need to remove columns and in some cases removal of a column will prevent it from working.
The txt file you uploaded reflects that: it was looking for data specifically needed to make the upload work as seen by the blank between = and AND.
Thanks for your response.
I have a store with products that all show the images properly. Now when I add new products (completely new, not updating or replacing any aspects of the old products), the new products' images are all distorted and small (the old products remain the correct size). It appears something in EasyPopulate is telling it to change the image size (smaller, and distorts it, and the "large image" doesn't display the large image unless you right-click on the image and select "view image").
All the images have unique names (for example SPFF84.jpg). All images go in the main directory "images" (like always, I don't use a separate sub-folder for Large or Medium images). None of the new images are replacing old images. It is showing the correct image for every item, just distorting it. I've imported new products before with no problem so that is why this is all very strange. I can't figure out how EasyPopulate is doing this to the images. Everything works perfectly in the CSV files except for it resizing the images. What is it in the CSV file that is telling it to shrink the images? Every single new image gets affected.
Also, interestingly, when I click the edit button for one of these new items and simply click Save (without changing any of the fields at all), then the new image suddenly shows perfectly for that product. What does that mean?
Okay...So I added a zip file to a product in the store, downloaded the detailed csv file, added a couple of more products with the same format that was on the spreadsheet, saved it, uploaded it into the Easy Populate and clicked the Import link and got this for an errors:Quote:
Originally Posted by mc12345678
Located at the top of the page:
File Import Completed with issues.
Located at the bottom of the page:
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!
It's telling me there were 2 errors detected but generated no TXT file with them...
I do appreciate your thorough explanation of how this works and I understand what you are saying. I appreciate it because if I can get this figured out this will be a very useful tool moving forward for future installs. :)
Quote:
Originally Posted by amandavz
Did you do a basic attribute add to the two new products before downloading the detailed attributes? (Or within ZC add the attributes to the product without assigning all of the detail at the bottom).
Here is how I see the process generally running though I haven't gone back to confirm this exact sequence (and I think I provided something similar several pages back).
add a basic product, add a basic attribute to the product, add detailed product data, add detailed attributes for the product.
Basically, saying that basic data should be added before detailed data. Once a product is fully loaded in, changes can be made using the detailed data.
From the description above, I don't see that the attributes were captured to the product fully. The detailed attributes file includes specific data that is in the database after a basic attribute upload. (the id number). While it could have been programmed with less steps (looking up the attribute_id based on the name of the attribute), the overall flow is upload a basic file, download the detailed, make a change, upload the detailed. If want more options/data tied to the product, upload a new basic, download detailed, mod detailed, upload detailed...
The lack of the error file means that the code ran fine, but the data it looked for was not present... The error file is created on an actual error in the programming/SQL statement.
Make sense?
This appears to be more of an indication that it is not specifically EP4 that is causing a problem as an interaction with something else or a template issue. There are a number of things that could be going on. The product type may be wrong in the uploaded file invoking the wrong template type to show the product (though still not sure how the image was affected because no link has been provided to your problem area or where something shows correctly), and that by editing and saving (without changes) may rectify something. The file that you are uploading may be missing something that is needed (again no specific data provided), you may have some sort of old/incorrectly uploaded files (state that running 1.5.1; however, was there an upgrade? Are there files that remain that possibly shouldn't do any of the replaced files end with .php instead of .old or some other extension...) Etc... I can't say that I have seen anyone else express this problem, so there is something about your store/use of EP4 that is causing this, unfortunately.Quote:
Originally Posted by JNR345
On another note, if you were to upload a new EP4 product, then do the edit/save that you described then download the same detailed EP4 file and compare the row of data associated with the new product, what differences are there if any?
Okay...so I added 2 products to the Basic with the basic info and then added the same 2 products to the detailed and it gave me the zip file on my 2nd product added. It told me this: SKIPPED! - Attribute Entry on Model: 2 - Not Found! but I think maybe if I try another zip file name it might work.
I'll get back to you with details. :)
Nope...I added the basic and that worked really well....then I tried to add the detailed with new zip file names and it's giving me this again:
SKIPPED! - Attribute Entry on Model: 1 - Not Found!
SKIPPED! - Attribute Entry on Model: 2 - Not Found!
SKIPPED! - Attribute Entry on Model: 3 - Not Found!
I'm wondering if I should try to leave off the v_products_options_name, v_products_options_type and v_products_options_values_name off of the detailed? It seems a little redundant.
And to be clear, after the two products were added using the basic attributes file, that you downloaded a new detailed attributes file to enter/change the zip file information... Also remember to keep the model_number unique (Ie, if you download and have two rows with the same model number, upload will have a somewhat interesting affect depending on which download/upload you're working with.) I know that you identified that you used model number 1 for one product, and then 2 and 3 for additional products, but and again it depends on which file you are working with, a duplicate model number may cause some "issues". For now keep it simple and should be okay/make sense as you go along. :)Quote:
Originally Posted by amandavz
Okay...so here I am again. I did get model 1 and 3 to show up, for some reason it is not giving me model 2. I had to change the v_products_attributes_id #'s. So this might have something to do with why Model 2 isn't showing.
I am going to work on this for a bit and see now that I have the answer...if I can't maybe get my equation correct. LOL.
Thank you so much for all your help and information...you have truly been a blessing. :)
So the only reason to receive this message, is that there is no result from the following query:Quote:
Originally Posted by amandavz
SELECT * FROM zhs_products_attributes
WHERE (
products_attributes_id = v_products_attributes_id AND
products_id = v_products_id AND
options_id = v_options_id AND
options_values_id = v_options_values_id ) LIMIT 1;
(which means that if the value associated with the v_variable on the right is not present in your CSV file (check that using a basic text editor) then the error message appears. You should see that in each of the four columns (v_products_attributes_id, v_products_id, v_optinos_id, and v_options_values_id) that there is some data associated with each of those and that data is other than "0", "", or NULL.
If the query results in a find, then it will/should process the data successfully.
If I remember correctly, those three fields are simply human readable versions of the fields (instead of a number that corresponds to something). Before I personally could suggest leaving them off, I would have to look at where they are used (if for any import information) and then assess who is using the file because it may make sense now in the "battle" with learning how to use it that it may be redundant, but it may also be worth having in the future to reference back. But as the original programmer has said, some things were added for human convenience, others for necessity. It is still in Beta, so it is always possible that it could end up being revised, or even those that use it can always effect how it works on their own installation.Quote:
Originally Posted by amandavz
Best of luck, it really is a powerful tool. I will say that if you plan on using it for your own store or others that you consider the affect of the need for unique model numbers. Generally speaking it is a minor impact on business, and I think having looked briefly at your site it will have no impact other than don't lose track of what your most recent "number" is. :)
If you follow the process of uploading a basic, then downloading a detailed, touch up the things that are specific to the detailed, then upload that, you should not run into any problems generally speaking.
Hi mc...so I went through an entire process and it seems to all work just fine. Now that I understand the formula. I deleted all of the existing product from the site and started fresh with new products, by adding them via the Full-EP, then I added the basic attributes and then the detailed attributes, went through the checkout and was redirected to the site for my downloads. Worked like a charm. Thanks so much again for all your help.
I do have another question for you...if I want to add "new" products to the Full-EP list (I have like 7,000 on another site) should I delete the existing information loaded onto the spreadsheet and start with my new products or do I leave them all and then add my new products to the bottom? I am scared I might screw something up if they are on the list. Also, the same with the Basic & Detailed csv files? Delete and upload or just add and upload?
Thanks again. :)
So, I would say that is a bit of a personal choice, which may be swayed based on a number of factors. First and foremost, you should always make a backup of your database before making changes such as what this plugin does. So, regardless of what is in the datafile, you should be able to come back to what you had. Now, other things about which way to go could include, as you said the possibility of making a mistake by changing something that is "older" and should not have been changed, if a single filename is used and "backups" are not maintained, a mistake in the future may not be noticed until it is way too late, storing the same information again and again on the server in the same file type will use ever more and more space, having a single file that contains all of the recent information will/could help in the future, splitting the files up and including some sort of date/time info can help make sense of it all.Quote:
Originally Posted by amandavz
Personally though, I would take the safest quickest route. I would remove all of the "old" data from the one spreadsheet, incorporate the new (though if you download the info from the other site, there really is no "new"/"old" to worry about. But, I would temporarily merge the two files or perform some other verification to ensure that the model numbers were different between the two sets of data, make necessary changes to the new data, and then upload the whole new thing.
After that, well, have to perform a sort of risk assessment. Just remember, you're probably doing this to make some sort of money, so whatever keeps you in business, minimizes time away from that, and minimizes duplicattion of effort.
Btw, glad that you got it sorted out. It really does work well. :)
sorry to ask a dumb question, but am i looking for examples usages,
i.e., a csv file example exported from Open Office. there must one available somewhere around here??
there is an attribute example file but that is all.
thanks
So, the downloadable version of this plugin only has the one example, but if not mistaken this forum has examples of files at least that have been tried.Quote:
Originally Posted by tcarden
If I may ask, why is it that you ask for examples? Perhaps there is another way for you to gain what you want.
Zen Cart 1.5.1
Database Patch Level: 1.5.1
v1.5.1 [2013-08-19 12:38:13] (Version Update ocov_1.5.0->1.5.1)
v1.5.0 [2011-12-30 23:57:33] (Version Update zc_1.3.9->1.5.0)
v1.3.9h [2011-12-30 23:56:11] (Version Update zc_1.3.8->1.3.9h)
v1.3.8 [2009-05-30 08:43:48] (Fresh Installation)
added a skin
php 5.4.21
using easypopulate 1.2.5.4 works fine
trying easypopulate_4 I have the menu item under tools, but when I click on it I get website cannot be displayed.
I went over the install several times without any success.
I don't see the config option under tools.
I want to use this version, allows metatags.
would like to avoid a fresh install.
I did uninstall my version and tried it, without success. Read here it is co compatible.
searched here for a couple hours and couldn't find a fix.
any suggestions appreciated.
I didn't include the web, your not going to see the issue.
Probably best summary seen in a while. Error log messages?Quote:
Originally Posted by nick02895
Menu item under tools means at least part of SQL worked for the installation.
Config menu option ought to be under configuration menu option.
Regarding attempts, cleared browser cookies/cache before trying after change? (Saw a new zenid= in browser path?)
i am having trouble with my installation of easy populate in version 1.39 of zen caart
i have downloaded all three version
installed the easy populate master admin file to my stores admin directory.
i changed the name of the easy populate admin directory to my stores admin.
i still do not see the easy populate program under tools in zen cart
please help
Thanks mc12345678 for the reply.
error log:
[15-Nov-2013 15:44:59 America/New_York] PHP Fatal error: Call to undefined function mb_internal_encoding() in /easypopulate_4.php on line 139
I found the config menu option where you said it would be.
Cleared the cache.
I used the developers toolkit to search all php files for "mb_internal_encoding" and it only found instances in easypopulate_4.php
Quote:
Originally Posted by milagromac
Good, so looked through my cart as well which is ZC v1.5.1 and found only one instance of that function as well, it was in easypopulate_4.php. A search of the global encyclopedia indicated that requires php 4.0.6 or higher to be installed/used...Quote:
Originally Posted by nick02895
Also it appears that you need to enable mbstring in your php.ini file... Possibly installing/activating php-mbstring or something similar?
The only other thing is that if the above doesn't resolve your issue, there may be something related to the text in that statement, that you may need to use something other than UTF-8. I do not recall what format the ZC database is in for version 1.3.8, but if not UTF-8 then there may be a compatibility issue with EP4 and your database. I can not say that for sure, but it could be an issue.Quote:
Originally Posted by mc12345678
I couldn't install mb-string, not my server.
Did some research and zen cart still uses utf8, depending on language options.
I commented out the function mb_internal_encoding() and removed it in the echo statement and works.
Thanks
Nick
Couple of things. You say, still uses utf8. I understand that 1.5.x does, but does 1.3.8?Quote:
Originally Posted by nick02895
Also, state unable to "install mbstring because not your server", does that mean you do not have access to the php.ini file as it shouldn't take much to activate it,and it is probably already "installed" just not active.
Thanks for following up with me.Quote:
Originally Posted by mc12345678
I don't know that 1.3.8 does or doesn't. From what I've read to convert to utf8 there is a procedure which replaces charset in English.php to include utf8. Mine has that.
Also in phpadmin there is a change to the structure to utf8, my already has that. I have to assume that somewhere in the upgrade to 1.5 my charset was changed to utf8.
I cannot find the php.ini file on this server. This server is very restrictive with limited access. I guess I may be able to create one and make my own settings, but if it's working I will leave it.
Looks like the mb_internal_encoding() just checks utf8 and if not then easypopulate4.php restricts the input.
Certainly. Wasn't sure if it was your host, or if you were helping someone with their installation. Who are you with? The host company should be able to help. I realize all of the conditions you listed. I would have to at this time defer the discussion of that factor to chadderuski if he's still out there. :). I have not looked at that. Aspect of the code yet and what affects if any there would be of working with the plug-in without that function. I know that when I installed this locally, I chose to enable mbstring on my local install. Glad you have all of the other "upgrades". Thought it was important to discuss for others that read. The forum.Quote:
Originally Posted by nick02895
This is regards to the MAP Pricing mod. I followed your instructions by setting User Defined Field = v_map_enabled (which I confirmed in my SQL db as the correct field name). I download FULL-EP and it doesn't show up. I upload a CSV with a single record to test and I get the following output (but no change to the db or the product record):Quote:
Originally Posted by chadderuski
Import Results
Filename: MAP_UL.csv
UPDATED! - Model: 806-1206 | 1 |
Finished Processing Import File
A "1" enables it, a "0" disables it. I'm trying to fully convert away from the old EP version which I had modded to do this. I've had no problems in the past uploading metatag fields with EP4.0 so I'm not sure if I'm missing something? There's no debug error found. I confirmed I can go into the product record manually and change it successfully. Any ideas? Thanks!
Scott
So, I left this message alone last night, because I didn't quite follow it and also thought perhaps the code author might jump in with an answer.Quote:
Originally Posted by scottj
I haven't worked with that aspect of this plug-in (using the user defined fields; however, it may be helpful to see the "single line" data file for one thing (this would identify the fields that are being attempted to be added). That said, it seems that unless you have created a new file type to be able to upload with a filename prefix associated with MAP_UL, then there are several routines within the plugin that will not be activated. Additionally, it appears that the original code author provided direction related to the new fields being added to the products table. Were the new fields added to the products table or some different table? Also (and not to question your knowledge/understanding) the fields entered into the user defined fields, they are the actual field names that were added, not field1,field2,field3,etc... correct?
On the issue of the filename, it seems like the expectation (if the fields were added to the products table) that import to ZC should have the same prefix as the download file ("full...etc"). (Sorry at the moment have forgotten what the exact prefix is.)
Any of that help?
Thanks for the reply. The user defined field I added was v_map_enabled (I had a good chuckle... would've been funny had I added "field1") and the new MAP field *is* located in the products table. As I noted, I know just enough to be dangerous having modded the old EP1.2.5.4 for the MAP field. The contents of MAP_UL.csv test file was simply:Quote:
Originally Posted by mc12345678
v_products_model | v_map_enabled
806-1206 | 1
As for the file name, this may be the most promising. I don't quite understand all that. I previously attempted to add about 100 new products using the Full-EPxxxx prefix and for whatever reason it deleted all the title/descriptions for the existing 10,000 products. Luckily I had a backup but understandably I've stayed far away from that prefix!
Without any mods I successfully upload metatag data using a CSV file called metatags_UL.csv (which is why I originally added EP4.0 since the old EP doesn't support metatag stuff). Thus I made the assumption, perhaps erroneously, that any file name will work if you just want to upload product fields without "triggering" any of the EP4.0 logic... logic which I readily admit I don't understand. References to it in the instructions were a bit ambiguous for me.
Thoughts?
So to confirm, your database has a field name that begins with a v_? Or if you were to look in mySQLadmin would it be map_enabled?Quote:
Originally Posted by scottj
The code automatically adds v_ as part of creating the CSV file.
So, it looks like the only way to get those fields out of ZC is to do a full export. To get them back in, it looks like you don't have to do a full import. At least there is some data loaded without that type of file...
But I think the real problem is that you have already prefixed the field with v_...
Holy crap, that did it! Isn't it always something simple? I defined the user field in admin as v_map_enabled. I just changed it to map_enabled and it worked. Thank you very very much!Quote:
Originally Posted by mc12345678
Sorry couldn't help sooner, I didn't have the code available to review. Figured I'd take a quick look since I saw your message.Quote:
Originally Posted by scottj
Regarding the logic of the program, ah it's a program. :) It does many powerful things and has a lot of capability. With regards to losing the description, I think there is a bit of misconfiguration in that it basically requires the description to be uploaded, and so if the description is not in the CSV file, it uploads NULL... NULL on existing data means bye bye.. But it's handles/addresses a lot of ZC options and processes.
Problem with error message "No category provided for this new product"
I have installed EP4 since last year, it works well until today. Some products were inserted and others got the error message. There is no any difference in the category filed. Is anyone can help?
Attachment 13417
So, reviewed the code for this particular error message. It only appears as is if the category identified in the field does not exist as part of the existing category list. When you look at the CSV file using a basic text editor with just those two entries, do you see any displacement of the quotes? The same number of spaces between the first and the second listing? Have you tried copying the category from the successful one to the unsuccessful? Wondering if there might be some other character code that is not "visible" onscreen.Quote:
Originally Posted by su35
The other thought depends on the editor that you are using and whether it is saving the file as a proper CSV file and therefore if it is not, then when uploaded for import it is not understanding the line of information properly. Just some basic thoughts.
Thanks mc12345678Quote:
Originally Posted by mc12345678
However, after deleted almost everything, I got the same result. I had dumped the $categories_name_exists on screen, it was null.
Attachment 13423
I am assuming that the correct variable was used for the screen dump, would expect it to not be a "true" value because the error message is displayed. It would be more important to track backwards and see if a value was provided at all for the category and other information to see where/when it "lost" the name.Quote:
Originally Posted by su35
I haven't used NotePad++, I see that there are no quotes around the text in the string. This could be a problem. I'm not sure that it is causing your problem. Also, considering how much has been removed, there is little that could/would get in the way. I haven't counted the commas, but hope that the right data got to the right place. (BTW, unless you have corrected it, I think that the lack of description used in this upload will cause your description to be erased for that/those models.. )
I'm trying to help, but this is a really odd situation that it is not working for a few cases... :/ If you only have model 64636 in a file, will it add it? (I'm thinking no because the failed row is before the successful row. ) I'm trying to think how to help without having a copy of the file causing the problem. :/
can you tell me what the longest field length is for the "v_products_description_1" field is?
Thank you kindly in advance!
Thanks for the GREAT plugin. Seems to work ok just need to do more testing in my particular store.
This is an operational nit with oo and Excel but may save some a lot of time.
If you Creating a part name (or any other entry in zc) with a leading zero, as in "078453M" when editing in oo or Excel you must set the appropriate column to "text" .
To do this after you DOWNLOAD the *.cvs file on your local machine first rename it with a *.txt extension before opening with Excel or oo.
When opening file you have the opportunity to change the "General" type to "Text" which you must do for columns you want to retain the leading zero(s) in.
Save as a *.txt file then rename to *.cvs before uploading and Viola! you will retain the leading zero(s)
To do this when you create a NEW *.cvs file on your local machine first save it with a *.txt extension change the "General" type to "Text" for columns you want to retain the leading zero(s) in.
Save as a *.txt file then rename to *.cvs before uploading and Viola! you will retain the leading zero(s)
You can use this special naming convention to group different product lines etc.. in applications like zc and QuickBooks.
where I can download this 4.0 version?
Please see the first post of the thread.Quote:
Originally Posted by 100asa
From what I have been able to gather, there is nothing about EP4 that specifically limits the length of the field. The field is a text field in the database, the applicable editor may have some limitations or maybe a function that is called, but EP4 doesn't truncate the field length of the description, regardless of the language.Quote:
Originally Posted by laquilino68
Hi All! No, I did not fall off the planet :pQuote:
Originally Posted by mc12345678
EP4 does NOT limit field lengths, but it does check the database to see what the size of the fields are and gives you a warning/error message if you go over that length.
I believe that non-critical data gives a warning, but something like a category name generate an error and does not add that record. This is necessary especially when creating category names, or even manufacturer names. With out it, a name the exceeds the length in the database would be truncated and added multiple times (there would be not match when comparing values). Other versions of EP don't do this unless they've fixed it recently.
Multi-byte encoded languages are a bit harder to work with, but should function correctly.
-chadd
no solution mc123456... relating to my post on 08/24/2013
please answer with a simple yes or no.
Quote:
Originally Posted by any_way
Quote:
Originally Posted by any_way
Wow... My apologies. I can generate a solution. Not a difficult add in, at least if just want to have the data displayed on the screen. If want the program to use the data, that may take a little more. Below is the changes to show the products name (multilingual potential) for the product model being discussed when doing price quantity discounts. It does not necessarily import that data back into the database. (Haven't looked through the import code, nor did I see that it was expected to import the name.) So this is just for user benefit when updating the other fields.
In admin/includes/functions/extra_functions/easypopulate_4_functions.php
Main code section: function ep_4_set_filelayout
At the case for priceqty: (Add the foreach statement after the first $filelayout and before the next $filelayout... This forces the name to be after the model...)
in admin/easypopulate_4_export.php find the end of the 'full' routine as shown below, insert the text in red (oops, used php tags... There is no custom coloring for PHP tags so the code area as described) before the //BEGIN: Specials. (This just happens to be a convenient location and is not required to be at that specific point in the code. There is an area lower in the code that addresses the calculations of the priceqty discount; however, after quickly coding this, it seemed like this area still may be preferred. The lower area is heavy in math and affects of performing a discount and not so much in the other "random" data to be exported.PHP Code:case 'priceqty':
$filelayout[] = 'v_products_model';
foreach ($langcode as $key => $lang) { // create variables for each language id
$l_id = $lang['id'];
$filelayout[] = 'v_products_name_'.$l_id;
}
$filelayout[] = 'v_status'; // 11-23-2010 added product status to price quantity option
PHP Code:} // if($ep_dltype == 'full')
if ($ep_dltype == 'priceqty') {
foreach ($langcode as $key => $lang) {
$lid = $lang['id'];
$sql2 = 'SELECT * FROM '.TABLE_PRODUCTS_DESCRIPTION.' WHERE products_id = '.$row['v_products_id'].' AND language_id = '.$lid.' LIMIT 1 ';
$result2 = ep_4_query($sql2);
$row2 = mysql_fetch_array($result2);
$row['v_products_name_'.$lid] = $row2['products_name'];
} // end foreach $langcode
} //end if ($ep_dltype == 'priceqty')
// BEGIN: Specials
After more testing I discovered easypopulate-4.0-master (configuration part) cannot be installed AFTER fec.
Something to do with the database fields not matching (Haven't narrowed it down)
My work around was to install ep-4 first and then css_js_loader & fec.
This seems to work on a fresh install (classic template).
I am loading 4 other modules so I'll report back if I have success (or failure) on my full blown site.
What tables does Fast Easy Checkout (fec) modify? The configuration script for EP4 appears to only use the default number of columns for table insertion, without directly assigning a field to a value. If EP4 fails after fec, what else will fail after fec installation? I am assuming that the failure occurs when clicking the link at the top of the screen upon first time upload. Otherwise, where in the process does it stop (error log?). What version of ZC did you try this on? EP4 should not be affected by nor affect either of those two plugins, unless one of those two changes the tables in a way that is unrecognizable...Quote:
Originally Posted by linuxguy2
I had a working installation of ep-4. (Installed ep-4 first then css_js_loader & fec) uninstalled ep-4 from the admin menu "Tools - EP - Uninstall" and then tried to reinstall it from the same screen (see graphic) and below is the error I got. Where would I look for a more detailed error report?
WARNING: An Error occurred, please refresh the page and try again.
Attachment 13509
Look in your logs or cache directory, depending on which version of ZC you are using. My guess is more than likely it is a SQL error that an option has already been loaded into the database. Not sure how you "uninstalled" the plug-in. Removing the files would not remove the SQL settings.Quote:
Originally Posted by linuxguy2
I reloaded my test site so I'll have to reinstall (tomorrow) and see if I can get more specific error codes.
Un-Install here in EasyPopulate-4.0-master.
Attachment 13510
How do I uninstall Easy Populate 4.0?
I had developer upgrade my site from 1.3.9 to 1.5.1 recently (I was not able to get the upgrade to see my db) and he installed Easy Populate 4.0 over the old csv version previously installed. The older version was configured to connect the attributes for downloadable products (most of my products). After a problem with the attributes not working after the upgrade, he "corrected" the problem by replacing the new 1.5.1 admin folder with the old 1.3.9 one, which had the old EP files.
I figured out how to fix the old EP for uploading and altho all the EP 4 files are removed, EP 4 still shows up on Admin > Config. How do I remove it? I'm trying to clean up the site as much as possible after a sloppy upgrade.
Lindee
Might be easier to reinstall and the have it remove EP4, but: The below is the SQL that is run from within it that will address your database (including the menu option). I might suggest running all five statements, as it does seem unclear what version of ZC you are really working to... :/ Not cool...Quote:
Originally Posted by LindeeG
SELECT @ep_group_id := configuration_group_id FROM CONFIGURATION_GROUP WHERE configuration_group_title = 'Easy Populate 4' LIMIT 1;
DELETE FROM CONFIGURATION WHERE configuration_group_id = @ep_group_id;
DELETE FROM CONFIGURATION_GROUP WHERE configuration_group_id = @ep_group_id;
DELETE FROM ADMIN_PAGES WHERE page_key = 'easypopulate_4';
DELETE FROM ADMIN_PAGES WHERE page_key = 'easypopulate_4_config';
So, the above 5 statements cover version 1.5.x on, and may provide an error if run on a pre 1.5.x database... The errors (if they are to occur) would be in the last two statements.
It would be easiest to tell by looking at the database, because there is potentially an issue with the first statement... If the select statement returns a zero then, this could affect the other databases. And actually, if you are okay with keeping information in your database, but just want to make the menu option(s) go away, then perhaps the last two queries should be run to remove the menu options. But that wouldn't fully cleanup your existing condition (possibly if other EP4 data was still present).
I'm a little confused about what the issue is with using EP4 as it too allows download/upload/export/import of attributes as well... But, the above will accomplish what you asked for. It is my understanding as well, that there may be benefit to running more than one EP product, depending on the task at hand, and I believe this version (EP4) can co-exist with another/others.
I am posting this here because this is the only module that I am having this problem with...
Whenever I try and Import a file it is making me relog into the Admin as if the session ID has reset. So I click import It will then import..... am forced to relogin and it imports.. and done.. I had a different Easypopulate and it did the same thing. So whatever the POST function is doing, it's resetting my Session ID to a new one..
Is there a fix for this? Is there a place to look?
I have done a bunch of Google searches and this problem pops up from time to time, but no one ever has a solution.. I think it has to do with a PHP config. setting or a Sessions setting in Zen Cart.. I have had to change things with those in the past in order to get Facebook to pull images off the website to post...
Thanks for any help or direction that you may have!
Brian
Hi,
I installed EP on zencart 1.5.1. When I try to download an ep file, I get this error: Firefox can't find the server at epuploads.
I made sure the folder is writable, and put in the folder name in the ep configuration as follows foldername/
The file does exist in the folder and I could download via ftp, but this should be available when in the tools section of the admin
Any help would be appreciated.
At this time, there appears to be more questions to ask than answers to provide:Quote:
Originally Posted by webmiss
1) Are you sure that you have this version of EP installed. Asked for the following reasons: epuploads is not found in the coding of the program, no other text in the message indicates why epuploads would be referenced, the config description does not include the value 4 which is related to the version number identified for this plugin
2) It is not clear if foldername/ is the actual content of the folder listing or if it is meant as an example/template and that the contents were actually epuploads/
3) Making the folder (and file) writable is half of it, also readable yes?
Sorry I wasn't more specific. I installed easy populate 4. I created a folder called epuploads and set permissions at chmod 777. In the configuration section in the admin it asks for the uploads directory. I have it set at epuploads/
Is there something else I am missing?
If you "right" click on one of the download links and copy the link, could you paste it here? (because of the location identified, you're welcome to substitute what you need to, but the important part is to try to identify if the link is "incorrectly created")Quote:
Originally Posted by webmiss
Is there a difference in URI between a secure connection and a standard connection? (ie. have a dedicated SSL versus a shared one? If shared, what is the format of it and how is that integrated into your configure.php files?)
Do you have any URI rewriter? htaccess redirects/rewrite rules? It may be that the folder is "hidden" from standard web browsing, even though the permissions are set. May need a new .htaccess file for the upload directory... Sorry I didn't respond earlier, wanted to look at the code a little and see how the system is expected to operate...
Hi,
I figured out the issue. If you just click on the download link, it gives that error, if you right click as you suggested, it will download the file. Not sure what the difference is, but as long as the file can be downloaded, that's the important thing. Now, I haven't tried to import anything yet. Still waiting on client to send a file for the updates.
Left clicking attempts to open the file on screen. I believe if there are restrictions in the htaccess file ie, allow .jpg|.gif, etc... That don't include .csv, then you won't be able to "view" the file, but you can download it. I haven't tried altering the functionality in a while to see if that aspect is true, it may be that there is a setup in firefox that needs to know where to find the file to open for the data type... Generally speaking it is still better to right click and save the file, but if properly setup to "view" it on screen, that too can be helpful, but also can be confusing if there is a lot of information and depending on the needle for which your looking. :)Quote:
Originally Posted by webmiss
Good job, glad I didn't lead you too far away, though still may want to make some changes.
Hello:
Does anyone know of any step-by-step instruction manual available for EP4? Especially when it comes to converting a wholesalers .csv file to EP's version? I found some instructions on Youtube but that video is so small, it just as well not be there!! A youtube video converter would be nice. If there is a video available for this, it would be great, again, as long as you can see it.
Thanks for your help,
Silver
Whatever the original source of your data, it must be arranged to meet the structure of the zencart database.
If you open one of the SAMPLE FILES from easypopulate v4, you will see the names of the column headers. These names cannot change.
So what you need to do is arrange the data from your supplier's spreadsheet, so that the content can be listed under relevant Easypopulate column headers.
Your supplier may have a column called PRODUCT INFORMATION. Now there is no column called "PRODUCT INFORMATION" in Easy Populate - but there is a column called "v_products_description_1".
So it is probable that all you need do is get the product information from your supplier, an make sure the column header is v_products_description_1, and not PRODUCT INFORMATION.
The same principle applies to all the data and column headings.
However, sometimes a supplier may have product information is SEVERAL DIFFERENT COLUMNS - in which case you may need to use spreadsheet FORUMLAS to merge the content of one column with the content of others.
In MS EXCEL for example, the =CONCATENATE(parameters here) formula will join the contents of specified cells. A knowledge of how your spreadsheet operates is very valuable, as this can save you huge amounts of time and effort.
fairescape;
Thank you for the information. I will look into it. Everything you said seems relatively simple except for the last part on product information. Couil you tell me how you place attributes, such as sizes, colors, etc? BTW, I'm guessing by your byline that you must know Schoolboy?
Silver
Yes, I am based in Cape Town, South Africa - but spend about half the year in the UK doing presentations on online trading. Schoolboy and I work on joint projects. I have been assisting with the latest venture in engraving services.Quote:
Originally Posted by SilverHD
Easypopulate does not handle attributes (yet) but if you send a PM to chadderuski (the module's author) he may have updates on this.
We have found that APSONA SHOPADMIN is a more intuitive interface for importing data - including attributes.
Thanks for the tip. I will PM him. Schoolboy helped me quite a bit when I didn't know very much about Zen. He is very knowledgeable. Looks like he has a tiger by the tail now!
Take care,
Silver
While I haven't used apsona shopadmin, I would like to offer a correction to the above post, EP4 does handle attributes, in fact I had added partial functionality for stock by attributes available through github off of chadderuski's version.Quote:
Originally Posted by fairestcape
As for other instructions on use, there have been posts in the last several pages about general usage of this plugin including sequencing of imports and exports and building the database for a product.