My Office Program is 2007, don't know if that helps. Otherwise, I don't know what Excel I'm using.Quote:
Originally Posted by chadderuski
sph
www.prommart.com
www.fashion-mart.biz
Printable View
My Office Program is 2007, don't know if that helps. Otherwise, I don't know what Excel I'm using.Quote:
Originally Posted by chadderuski
sph
www.prommart.com
www.fashion-mart.biz
I am using Excel V14 from Office 2010 and CSV works fine.
Hi,
I just installed the latest version of ep 4.0. I have a bunch of custom product fields, most are in the products table except for the second description which is in the description table. I had the old easy populate working for inputting the data and I'd like to get that working with the new EP, I saw the post on page 5, but I didn't really understand. I was wondering if you could explain in more detail how to add extra fields. Thank you for your help.
I install Easy Populate successfully. But when i click download it redirect me to admin login page. Every link in the Easy Populate page is linked to login.
I don't know why. Please help me. Thank you
OK here's how I did it - my example shows the field I wanted to add (products_family), obviously yours will be different :)Quote:
Originally Posted by amirshawn80
There are three files to edit:
YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php
YOUR-ADMIN-FOLDER/easypopulate_4.php
and YOUR-ADMIN-FOLDER/easypopulate_4_import.php
You're using the existing 'upc' field each time to create a new product field.
Firstly open YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php. Search for
if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
Now make a copy of this code directly underneath and change this to
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}
so you now have
if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}
Now find the following a few lines further down:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
Copy this chunk of code and change as before, so you now have:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // Products Family mod
$filelayout_sql .= 'p.products_family as v_products_family,';
}
Now open YOUR-ADMIN-FOLDER/easypopulate_4.php and search for 'upc' again - around line 90
$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
Make a copy so you now have
$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
$ep_supported_mods['family'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_family'); // Products Family
Finally open YOUR-ADMIN-FOLDER/easypopulate_4_import.php and search for 'upc' again, there are four edits to make here, here's what mine looks like with the 'family' fields added (the line numbers may be slightly out)
Line 26:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_family';
}
Line 150:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod- chadd
$sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // products_family
$sql .= 'p.products_family as v_products_family,';
}
Line 594:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // products_family
$query .= "products_family = '".addslashes($v_products_family)."',";
}
Line 660:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // family
$query .= "products_family = '".addslashes($v_products_family)."',";
}
Hope this helps - this should work for the fields in the products table, but it might need a bit of tweaking for the field you have in the description table (not sure myself as I haven't tried it)
Just installed EP 4.0 into my test cart and I am thrilled with it. It's FANTASTIC and is going to save so much time. I especially love the ability to be able to choose which categories to export from and this is an outstanding feature of it. I'm also using Microsft Excel 2007 with SP2 in case anyone is interested.Quote:
Originally Posted by chadderuski
Now all I have to do is tidy up the csv template I created and then I can install it to one of my live sites.
Thanks so much for creating it Chadderuski you've done a fantastic job!
:smartalec:
:clap:
Ken,Quote:
Originally Posted by kendamnit
Scroll back a few pages for more detailed info. Basically, you have something strange in your config file. Look at your url when you login to your admin.
If you see something like this:
http://www.yourstore.com//admin/easypopulate_4.php
See that second pair of forward slashes? That is wrong. It needs to be one forward slash. This seems to happen with some cpanel auto installers.
-chadd
igi2011,
THANKS FOR THE ASSIST!
-chadd
No problem chadd, happy to help !
Lee
Hi everyone,
I'm new to both eCommerce and Zen Cart so I'm making a few mistakes but getting there slowly.
I'm using [the very wonderful] Easy Populate 4 with my Zen Cart 1.5 install to add/update about 1600 products to my fledgling site.
All is good so far but I've come across an issue that I'm sure is user error but I could do with some advice.
My products are clothes so I want to upload size and colour options for each product.
I've got two csv files (one for sizes and the other for colours) in the following format:
"v_products_model","Colours","v_products_options_type","v_products_options_value s_name","EOREOR"
"AD009","Colours","0","Black,Coast (Light Blue),Navy,University Red,White","EOREOR"
"AD012","Colours","0","Black,Navy,Red,White","EOREOR"
"AD013","Colours","0","Black/White*,Coast/White,Navy/White*,Neon/Precinct,Pirahna/White,Precinct/White,White/Black*","EOREOR"
and
"v_products_model","v_products_options_values_name","v_products_options_type","v _products_options_values_name","EOREOR"
"AD009","Sizes","0","2XL,L,M,S,XL","EOREOR"
"AD012","Sizes","0","2XL,L,M,S,XL","EOREOR"
"AD013","Sizes","0","2XL,L,M,S,XL","EOREOR"
Now I realised too late that the first line of my colours file read:
"v_products_model","Colours"
instead of
"v_products_model","v_products_options_values_name"
but the colours showed just fine on the product page, but when I imported the Sizes file all the size information was added to the Colour information in the same dropdown box. :huh:
I had not entered anything regarding options via the Zen Cart config and was expecting EP to do all this for me.
So firstly, what have I done wrong to cause this error and secondly how can I delete all the imported options data and start again?
Thanks in advance.
Hi Chad,
Products in my store are priced by attributes. I have installed your ep (which is fantastic) however when I try to upload new prices using Attrib-Full, it says products updated but when i check prices nothing has changed?
Is this feature not supported as yet? If not, do you know if the split files created using your version can be used in previous versions?
Hiya Moesoap!Quote:
Originally Posted by moesoap
There is only a basic attribute at this time. File name must start with "Attrib-EP", and only the columns in the examples directory are valid. The Export for Attributes DO NOT IMPORT as noted (yet, I'm working on this but have been inundated with work).
Once I get the Import > Export > Import "round robin" working (meaning the same file imported can be exported, edited, them re-imported), I'll be able to expand functionality like attribute pricing.
Sorry I don't have a better answer for you yet.
chadd
Hi Tedm!Quote:
Originally Posted by tedm
You don't have to use two files to add multiple attributes to your products! These can be done one after the other for each model number.
As for figuring out what is wrong with your data files, it would be better if you ATTACHED a portion of each file so that I can see the structure.
ALSO >>> you DO NOT need EOREOR with EP4!
Did you install the MySQL Backup Mod? It is best practice to install this and make a backup before each import so you can roll the databases back if you encounter an error. Also... It is best practice to first work with a FEW records at a time, then once you are confident, the entire database.
Did you carefully read the README.txt file? I explain the attribute import in some detail there.
-Chadd
I'm having a problem loading products. This is the error I am getting:
No model field in record. This line was not imported12/640 PS" |
I'm using zencart 1.3.9
Easy Populate 4
I have unique models. so this is strange. The file is tab deliminated from Open Office.
If you could attach a portion of the csv with headers it will help to diagnose what is going on.Quote:
Originally Posted by vwaltz
Hi Chad,
That data I put in the above post was extracted from the two cvs files I used
I did read the readme but I don't think there's anything about importing more than one option type (I.e. sizes and colors) in a single file, which was why I used two files.
So to import two sets of options should I simply repeat the data on the same line, e.g. "v_products_model","v_products_options_values_name","v_products_options_type ","v _products_options_values_name",""v_products_model","v_products_options_values_na me","v_products_options_type","v _products_options_values_name"?
I look forward to it Chadd. Thanks for taking the time to create this addon. It looks great and will solve many of the problems that people face with Zen.Quote:
Originally Posted by chadderuski
:hug:
Hi Ted,Quote:
Originally Posted by tedm
No, one record per line. You would like the SAME model number twice, but the second one will have the different options/values.
Your headers look wrong to me. That is why I prefer the attached file. I had one person that had a space after a header name that was breaking his import. Notice that you use v_products_options_values_name twice. This is wrong.
From my example file:
"v_products_model","v_products_options_name","v_products_options_type","v_produc ts_options_values_name"
"Widget","Color",0,"red,green,blue"
"Widget","Size",0,"S,M,L,XL"
First Color will be added, then Size for the same products_model number "Widget" (which must be unique to your store).
Hope this gets you one the right tray.
Hello,
I opened this file in notepad for copynpaste here.
"v_products_model" "v_categories_name_1"
"M4683G/A" "Toner-MONO^APPLE"
"M2473G/A" "Toner-MONO^APPLE"
"M2473G/A Extended" "Toner-MONO^APPLE"
"C3900A" "Toner-MONO^APPLE"
"DR400" "Toner-MONO^BROTHER"
"DR350" "Toner-MONO^BROTHER"
The above gave me the following when I imported the .csv file created with save as from open office:
Import Results
Filename: Category-EP2012Mar27-174859.csv
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
No model field in record. This line was not imported
OK nice one.... thanks for your help :DQuote:
Originally Posted by chadderuski
Chadd,
Sorted. I redid the file and found an error in one of the headers and it all worked great.:clap:
OK, next question :dontgetit
Is it possible to add references/links to multiple images per product using EP4?
I'm specifically trying to add extra images showing colour options for each product.
That's not a CSV file "Comma Separated Values". You probably selected TAB as the delimiter and is why it's failing.Quote:
Originally Posted by vwaltz
-chadd
You don't actually do THAT with EP4 (although there are attribute images, but not in EP4 yet).Quote:
Originally Posted by tedm
You can specify your base image, and then just upload the others.
Base Image: HBB-250.jpg
Extra Images: HBB-250_01.jpg, HBB-250_02.jpg, HBB-250_03.jpg, etc.
Attribute Images are different (if you want them used in conjunction with a check or radio selection). You will have to do these manually.
-chadd
Hello, when using the sample file below I get a 500 error. website cannot display the page after trying to import the csv file.Quote:
Originally Posted by chadderuski
"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name" ,"v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"
Hi,
I'm start using EP4 with zencart 1.3.9a. Is working perfect, the only problem i have is to update with the new csv. I'm using a csv file from my supplier but they do not have included the primary categories (only subcategories which are too many). I used to populate first time my zencart and then from administration i moved all the products in categories and subcategories. Now, the problem is, if i want to update the products and prices how i have to do that without changing the categories already created. Or is there any option to update automatically the csv file in excel from the master csv supplied? There are too many products to do it manually.
Thanks.
Please check:
www.itshoptrader.co.uk
Hi Waltz,Quote:
Originally Posted by vwaltz
How large is your file? This is more about your server settings timing out when you upload the file with http. Are you on shared hosting? With who?
If you have a very large CSV file, you could first ftp it to your admin directory, then run the Split function should importing generate 500 errors. There are a number of settings you can change depending on your hosting, but that is beyond this thread.
For existing products, you can use the Model/Price/Qty sheet format... you wont need categories since they are already defined.Quote:
Originally Posted by itshoptrader
For new products, you could create a non-active category and import to there first. This is hard to know for certain without seeing your sheet. If you want, you can PM me and I can take a look at it.
chadd
Can't understand why this isn't working. Can you post a copy of what a line is supposed to look like? I tried to load the info below. as you can see it isn't very big. I got the web site can't display page error with it.Quote:
Originally Posted by chadderuski
"v_products_model","v_products_name_1","v_products_price","v_manufacturers_name" ,"v_categories_name_1"
"M4683G/A","M4683G/A",57.2,"Apple","Toner-MONO^APPLE"
"M2473G/A","M2473G/A",33.15,"Apple","Toner-MONO^APPLE"
"M2473G/A Extended","Extended",41.6,"Apple","Toner-MONO^APPLE"
"C3900A","C3900A",50.7,"Apple","Toner-MONO^APPLE"
"DR400","DR400",45.5,"Brother","Toner-MONO^BROTHER"
"DR350","DR350",55.9,"Brother","Toner-MONO^BROTHER"
"TN360","TN360",35.75,"Brother","Toner-MONO^BROTHER"
"TN330","TN330",31.2,"Brother","Toner-MONO^BROTHER"
"DR360","DR360",53.3,"Brother","Toner-MONO^BROTHER"
Hi Waltz,
What is your setting for "Script Execution Time" under Configuration -> Easy Populate 4
and
"Admin Set max_execution_time for processes" under Configuration -> My Store
and
"Maximum File Upload Size" under Configuration -> Max Values
Do you have access to your php.ini file in the root of our site? Or does your host prevent that?
Answer these and we'll see where that takes us.
-chadd
Hello,Quote:
Originally Posted by chadderuski
Configuration->Script Executation Time is 60
Admin Set max_execution is 60
Max File Upload Size is 2048000
I can access php.ini file
Thanks.
Your Zencart settings are fine.Quote:
Originally Posted by vwaltz
Check your php.ini file. Look for these:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M
Those numbers are from my VPS server. If you are in a shared hosting environment, start by increasing them moderately. Post your numbers.
What kind of hosting are you using? Which browser?
Oh, also make sure there aren't any extra "//" in your url except after http://www.....
-chadd
Thanks.Quote:
Originally Posted by chadderuski
I also want to know if is possible to do an automatic update with ftp. Do you want to see the original csv from my supplier?
Hello,Quote:
Originally Posted by chadderuski
I had a failure with the new settings also. I'm using IE browser. Hosting is linix.
Previous settings:
memory_limit - 48M
max_input_time - 60
max_execution_time - 30
New settings:
max_execution_time = 300
max_input_time = 300
memory_limit = 64M
I don't know if this means anything. If I export the Model/Category option from the Full Export Options, the import I do also fails.
Thanks.
This would be CRON support. I don't have direct CRON support added at this time.Quote:
Originally Posted by itshoptrader
Send me a PM and I'll look at your supplier file.
-chadd
I don't see anything wrong with your original settings for PHP.Quote:
Originally Posted by vwaltz
If you do a full Export, then do a direct Import (not file upload), you are also getting a 500 Server Error? If so, then you need to contact your hosting as it must be a server related issue.
How many products in your store? A a decent server, 50,000 records can process in about 3 minutes. WHO IS YOUR WEB HOST?
From within your Admin, click the Version... scroll down to see if your php settings are accepted. Some hosting over ride this.
Developer's Note: I am still working on the "Basic Products Attributes (single-line)" download options.
This file is supposed to be in the same format as the current example files, but as yet I have
not worked out the sql/code to do so.
really need above feature, we really need this function,thanks
Hi, we just had an upgrade to 1.5.0 and a complete redecorate of our store and easy pop 4 was installed by the person we hired. I am trying to update the stock quantity and when I change the quantity and upload it, the stock doesn't change on our product pages. It is necessary for us to be able to do this because we have over 19000 products and to do it without ep would take a lifetime. Does anyone know what is causing this and how to fix it?
Thank you,
Cayla C
Everayla Outdoors
Hello,Quote:
Originally Posted by chadderuski
Full Export when exported and imported fails (cannot display webpate). no download or editing involved.
Model/Price/Qty export but no error and no update
Model/Category export but no error and no udpate
PriceBreak and PriceQty export and import works fine and updates.
At this time i have 2 products in the store for testing.
This fails also (Model/Category from above):
v_products_model,v_categories_name_1"1001","Toner-MONO^APPLE""1000","Toner-MONO^APPLE"
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 25M
Server provided through Liquid Web
Hi Cayla,Quote:
Originally Posted by everayla
Could you PM me with the CSV you are using? This make diagnosing importing issues MUCH easier. Most often cause of a failure to update is an error in headers.
Thanks,
Chadd
Hi Chadd,
I seem to have an issue where EP4 is not showing up in the tools drop down menu after installation to two live sites.
The menu appears on the test site which is also located on the same server but in a different directory such as "/public_html/test_cart/"
I have triple checked that the uploaded files including the files from the zencart 1.3 extra files directory are uploaded correctly to their correct directories inside the admin folder.
I even did a side by side comparison of directories between the test cart and the live site just to make sure all the files are the same and to ensure that the files are where they are suppose to be. But still EP4 isn't shown under the tools menu.
I then went to another site I managed and tried installing EP4 on that site as well. But again EP4 isn't shown under the tools menu. There is no test site under this store so I could not test it under a test directory like the other site.
Now both of these sites basically run the same templates and the same mods. But I only have one test site and this test site doesn't have all the mods installed to it that the live sites do.
Is it possible that EP4 isn't compatible with a mod I have installed?
But even if there is a compatibility issue with one of the mods that doesn't explain why it won't show in the tools menu for?
So I'm just wondering if you have any thoughts as to why this might be happening for?
A couple of points of interest.
Firstly on the test site I previously had EP v1.2.5.4 installed prior to installing EP4. I didn't uninstall EP prior to installing EP4 so both EP and EP4 were shown under the tools menu.
Secondly I completely removed EP and EP4 from the test site and went back to an earlier database backup as well. I then installed just EP4 to the test site and it showed up under the tools menu.
So I am unsure what to try next and was wondering if you have any insight as to what might be causing EP4 not to show up on the tools menu of the live sites for?
Thanks.
Never mind problem fixed :smartalec:...
For those of you who come across this issue the issue is caused by having the "Admin Profiles" mod installed.
To fix the issue go into Tools --> Admin Settings - Edit Permissions
Scroll down to the bottom to where it says:
Third Party Mods (when enabled these 3rd party contributions will appear in the Admin menus determined by their authors)
Then put a tick in the box that says "easypopulate 4" and click the Save Changes button.
EasyPopulate 4.0 should then be shown under your Tools menu.
Chad you might consider adding this information to your install file so that others who are using the "Admin Profiles" mod don't forget to edit their profiles accordingly.
BTW for those of you who are interested. I found out what the issue was by directly accessing the link to EP4 from within my admin panel.
:clap:
Hi CybaGirl!Quote:
Originally Posted by CybaGirl
Glad you figured this out and shared your discovery. I've never used "Admin Profiles" so I wouldn't have know it was an issue. I will put a note in the next release's note.
chadd
I seem to be having a problem with easypopulate 4.0 I have it installed on another web site and have no problems at all but on my new site I can't seem to get it to work. I am running
zen 1.5
PHP Version: 5.2.17 (Zend: 2.2.0) PHP Memory Limit: 99M
and have installed Easy Populate 4.0.19 - Beta 1-28-2012 whenever i try to upload my products I get the following message:
Import Results
Filename: Full-EP2012Apr04-110754.csv
No model field in record. This line was not imported these Ana |
No model field in record. This line was not importedthese grad | soft ana | yet fast p | an explosi | then the b |
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 5727912
Memory Peak: 6130832
Execution Time: 0.00957083702087 seconds.
I have tried uninstalling the program first through tools/easypopulate and then it tells me that I am missing the configuration file and to click to install I have done that and no change I have also manually removed all ep 4.0 files reset "optimize database" and have download a fresh copy of ep 4.0 and no changes
I have even tried to manually enter a couple of products and then download new "Complete Products (with Metatags)" file edited it in openoffice with more products and uploaded to my site and still get the same message that "No model field in record. This line was not imported these Ana | ":frusty:
wj694,
Could you either attach a portion of your csv file, or PM it to me so I can check your file format? These situations nearly always are the result of something wrong in the CSV.
-chadd
Here is a copy of my csv file also one thing that I noticed between the databases for my 2 sites is the one that is working I have zen_ as the prefix for all the tables where as the site that ep 4.0 does not work on does not have this could this be the problem?
It should not. That is handle behind the scenes via the zencart inner functions.Quote:
Originally Posted by wj694
After a quick look, it seems you exported your CSV incorrectly. You select TAB Delimited. Change this to Comma Delimited and it should work.
-Chadd
Thank you chadd I will try this and let you know
wj694,
Your file will work, but you should know that your product names are longer than 64 characters. Have you modded your database to handle long names? You CAN do this, and EP will let you know if your data violates a number of conditions like this .... especially Category Names where is can cause real havoc!
-chadd
P.S. to all readers: This is a perfect example of THE most common import problem. A simple error in your exported file. It is also why I request a sample of your data or working file because I can usually spot the problem VERY quickly.
Chadd-
I tried what you suggested I opened the file in openoffice te only box that I had checked was "comma" and text delimeter is " and it is still not working this is the message I received this time
No model field in record. This line was not imported ruffled m | |
No model field in record. This line was not imported ruffled m | |
No model field in record. This line was not imported ribbon an | gathered |
No model field in record. This line was not imported ribbon an | gathered |
No model field in record. This line was not imported ribbon an | gathered |
No model field in record. This line was not imported ribbon an | gathered |
Finished Processing Import File
Updated records: 0
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0
Memory Usage: 5727632
Memory Peak: 6130504
Execution Time: 0.0163788795471 seconds.
I have attached another copy of my spreadsheet so you can see how it looks now
Thank you for all your help
Chadd
Yes I have made the changes to my database I changed the name and category fields to 120 characters
Nope, that one is even worse :(
You have to make sure that when your FIRST export your CSV from your spreadsheet in Open Office, that you check the "Edit Filter Settings" and make sure you have Field Delimiter the comma , and Text Delimiter the double-quote "
Here is the first file corrected:
Chadd
It worked thank you!!!!!:clap:
Chadd,
I have been using your mod and it rocks!! Thank you tons!! You are saving me a huge amount of time. I have been able to import both products and attributes. However, I am having one problem that I can't figure out. Is there a way to import attributes with prices for them? And having them marked as default or display only? I have exported the Detailed Products Attributes (detailed multi-line) and I can see these fields, but when I import back into my store nothing happens. I have thousands of products that have attributes priced and copying/pasting is about to kill me. Any suggestions?
Thanks,
Sappster:blink:
Hey Sappster... The Detailed Products Attributes is for diagnostic export only. There is no import for that yet.Quote:
Originally Posted by sappster
I'm actually working on attributes again >now< as we speak. I needed to do some rewriting to support multiple languages, and get my export file to also work as an import file (like the other export files). I cannot give you a time-to-completion yet. It's been a real challenge. But once I can get the basic import/export working correctly I'll add in the other attribute fields (or some workable solution).
-chadd
I am trying to install the EP 4.0 on my ZenCArt 1.5 but for some reason it's not working.
I downloaded a template and my page is KDMproject.com
I used filezilla to upload the content of admin to my remamed admind folder and I also uploaded the zencart 1.5 extra files to my root directory.
You have to maintain the file structure of the additional files for zen 1.5 ... just like you did for the "admin" directory. These don't go in the ROOT, but YOUR admin directory.Quote:
Originally Posted by shopsfm
The additional file are different for 1.38/1/39 and 1.5 so be sure you correctly upload the right files.
-chadd
Thank you for the quick response.
Original files
Admin
Examples
zencart 1.3 extra files
zencart 1.5 extra files
.gitignore
changelog.txt
INSTALL.txt
license.txt
README.txt
• from the instructions I understood that I have to rename the "Admin" to match the name of my "Modified Admin" then upload using filezilla the renamed "Admin" folder to my renamed folder on my site including the "zencart 1.5 extra files".
but when I did that I a new "renamed Admin" folder appeared under my "Admin".
From my other installs it has never creadted a new "Admin" under the original "Admin"
Quote:
Originally Posted by shopsfm
You are over complicating this a bit. The Admin in "zencart 1.5 extra files" is at the same level as your stores Admin. You have to maintain the same directory structure from http://yourstore.com/admin ... So you first upload all the Admin files in the mod, then - depending on the version of zencart - add the files needed for your version (1.3/1.5).
Hope that clears things up.
I got it.. thank you.
Progress Report: Attributes!
I finally had some free time and have been working on attribute importing again. So far, I have the Basic Attributes export/import working and have added Multiple-Language support so you can define your Options Names and Options Values for each language at import.
The Basic Attributes import sheet is for creating Options Names and Options Values and assigning them to a existing Product Model. Options Names and Options Values are created dynamically at import and assigned to the specified product.
I am now working on the Detailed Attributes import. This sheet will let you set all the specific micro details for attributes as assigned to a product. This sheet will be a restrictive 1-to-1 import that is used ONLY to update Attribute/Option Values details as assigned to a given product.
This shouldn't take too much longer ... hopefully I'll be able to complete things this week and get an update posted by the week-end. No Promises! But this is my goal, BUGS willing!
-chadd
Outstanding news, thanks!
sph
WANTED! Guinea Pigs for Attribute Testing.
I am looking for several zencart veterans that are avid Attribute users for some pre-release testing. You should be confident on how to install mods, have a backup of your site for testing purposes and also be using the MySQL Backup mod so you can easily backup/restore your store's databases. Multiple language users a plus.
Please DO NOT use on a LIVE site.
This is what I've accomplished to date:
Basic Attribute export: Single Line for each products_model. Will create
options_name and options_values_name dynamically and assign that set to
given products_model. Multi-language enabled!
This export is now 'round robin' ... meaning that the export file layout now matches the import file layout.
Once carefully tested, I will add select additional columns based on feedback from KNOWLEDGEABLE attribute users (of which BTW, I'm NOT one. LOL!).
Detailed Attribute export: This is the "whole shabang" ... giving you all
the info in the PRODUCTS_ATTRIBUTES table. This sheet has an entry for
each products_model + options_name + options_values_name. With this table
you can set all the specifics for each option. This sheet is ONE-TO-ONE and only used
to UPDATE existing PRODUCTS_ATTRIBUTES table entries, i.e. no deleting/adding options_names or options_values_names.
Current state is working. However, I don't have a great deal of error
trapping. I also don't have a functionality that will "replace" an
existing attribute set. This would need to be done within the admin, but
you can add to existing options/values.
This testing is not for noobies, so please be confident in your skills.
Leave me a PM if you qualify and want to do some pre-release testing.
Thanks,
chadd
Hey Chad,
I have tried several times to download the EasyPopulate 4.0 from https://github.com/chaddro/EasyPopulate-4.0 but I cannot get it or download it. :(
Could you please advise?
Thanks in advance,
Kind regards
EC
It looks like github may be having some issues. I got a 503 Bad Gateway error myself when attempting to download the zip. Give it a little time. Perhaps github is having some server issues.Quote:
Originally Posted by ecosmic
-chadd
Yep, it seems this happens from time to time...Quote:
Originally Posted by chadderuski
Github is back online:
https://github.com/chaddro/EasyPopul...zipball/master
Thanks a lot Chadd!! :clap: I'll install it today.
:clap:Quote:
Originally Posted by chadderuski
Can't Wait!
How do you add non-product table values - example Featured?:
v_featured_date_available
v_featured_expires_date
v_featured_date_added
v_featured_date_modified
Thank you.
Chad,
Is the new basic attribute import functionaltiy already in the current github Ep4 zip download? Id love to play with it.
makenoiz
This would require specific programming and I'd have to look to see where the "featured" information is held. I can do this, but it will have to wait until attributes passes muster.Quote:
Originally Posted by fewusa
Yes, but it is VERY basic. Give me a few more days to round out the new attribute import features.Quote:
Originally Posted by makenoiz
Hi Chad, this is my first time posting in zencart community. I have installed Easy Populate 4.0.19 - Beta 1-28-2012 safely and add some product in my category. This is my new zencart store and i have tried upload my 500 product into the database using 4.0 version.
The problem i'm having is data upload all but it appear in my admin only less than half. i check in my phpmyadmin, it only upload half.
Updated records: 461
New Imported records: 21
Errors Detected: 0
Warnings Detected: 14
Memory Usage: 3720348
Memory Peak: 3925776
Execution Time: 2.43897008896 seconds.
The updated records seems did not appear in my cart but updated. This is my second attempt try to upload full data into the database and failed.
Really need your advise why it can't fully upload although system said updated.
http://emporiumonline.net/shop/images/temp/updated.JPG
Thanks in advance.
Ariff
Chad... changing the delimiter from COMMA to TAB is just a case of:
TOPHP Code:// CSV VARIABLES - need to make this configurable in the ADMIN
// $csv_delimiter = "\t"; // "\t" = tab AND "," = COMMA
$csv_delimiter = ","; // "\t" = tab AND "," = COMMA
$csv_enclosure = '"'; // chadd - i think you should always us the '"' for best compatibility
Is that all that needs to be done?PHP Code:// CSV VARIABLES - need to make this configurable in the ADMIN
$csv_delimiter = "\t"; // "\t" = tab AND "," = COMMA
// $csv_delimiter = ","; // "\t" = tab AND "," = COMMA
//$csv_enclosure = '"'; // chadd - i think you should always us the '"' for best compatibility
Chad,
New to ZenCart, advised to get EP4 "The Chad Version", have read this complete thread. Downloaded EP4 from github, and have installed per instructions. :smile: All have gone very well, until we went to Tools->Easy Populate 4.
The stated version and date on this is: "Easy Populate 4.0.19 - Beta 1-28-2012". :dontgetit
Reading the thread shows a flurry of activity has happened since then. :lookaroun
Is the downloaded version actually up-to-date with your releases and just not marked correctly, or is there a better/newer version for download? :unsure:
I got a fatal erro after i changed my host,The version worked fin in my old host,someone please help.
atal error: Call to undefined function mb_internal_encoding() in /home/...easypopulate_4.php on line 4
what can i do to solve this problem.Thank you very much
Hello,
I have a clean install of Zencart 1.5 I downloaded chad's EP 4.0
I put all my admin folders in and the zen 1.5 extra files in. I ran the sql to create the table.
To test the file I put a fake product in. And exported full product categories list.
The csv came through with the headers, but no product?
So I put a few products into the file, and imported in. I did not get the congrats products added, lines ready. Anything.
Did I miss a step in the installation?
Thank you.
I've followed the installation directions exactly for ZenCart 1.5, but Easy Populate 4 is still not showing up in my tools. I've tried reinstalling it twice now with no luck. Where should I start with troubleshooting this?
I ended up getting the installation working, but I'm still getting the warning that my uploads folder is missing even after I change the directory.
What are the permissions set to on that new directory? (Just a thought.)Quote:
Originally Posted by StevenMagnet
777. I also can't get export to actually do anything, though that might be related to the upload directory issue.
All has been working fine with EP4 until we tried to modify the price of the items and upload back to the site.
Edits were done using a plain text editor.
All items are updating EXCEPT the price field. This is the standard price field, v_products_price.
I'm pulling my last two hairs out trying to find out why. It worked earlier, but nothing I do now will get it to work again.:wacko:
Even used a fresh download from the site, just changed the price, and uploaded/inserted. No go.
Anyone have any ideas?
Not quite sure why, but I was able to create a list from the site, edit it using notepad++ (really nice plain text editor), and reupload it to the site. The changes took! The difference here was that I did NOT change the name of the file.
Earlier in this thread I saw mention of naming conventions. Can we get a better explanation as to what is required to upload as far as the names required and any other item that could cause a problem?
Originally, I had a problem with the name and location of the temp directory. Ended up putting it just off of the root directory. Once I did that it worked just fine. (I originally wanted to bury it a couple of layers deep to prevent it from being seen. Oh well.)
http://www.ebcbrakegoodridge.com/images/zc-ep01.png
i can not open my easy populate 4.0,after i upload a 1 CSV file have 742 Products.i want more, but i can not load it again!:shocking::shocking:
How can i load the CSV file ,w/o admin page?:no:~
Hiya Schoolboy!Quote:
Originally Posted by schoolboy
Yes... BUT! You would need to carefully test everything. I 'believe' I was consistent in my use of $csv_delimiter, but you will also have to use $csv_enclosure. Remember I'm using fgetcsv(). I noticed some odd things with tabs, but it may have been because of the platform I was using.
-chadd
Hi Ariff,Quote:
Originally Posted by Ariffshah
I will need to look at you CSV file. You can PM that to me or attach a portion of the file that contains the problem product numbers. Also, which version of zencart are you using, and which character encoding are your databases (utf-8, iso-8859-1, etc.).
-chadd
4.0.19 is the current version of github. I will be updating hopefully this week. I was dreadfully sick since friday so I made no progress this weekend. 4.0.19 work fine, but does not have the new attribute features, plus I've added some more goodies that I hope are useful.Quote:
Originally Posted by algerdes
-chadd
Find out what version of PHP you are on. It should be 5.3... if you are older than that then your host needs to upgrade. Support for 4.x is being discontinued by most hosting companies.Quote:
Originally Posted by estandard
This function is needed to deal with importing utf-8 character encoding for multi-byte languages like Greek, Russian, etc.
-chadd
You will get a different error notice if you don't have write permissions.Quote:
Originally Posted by StevenMagnet
If you want your import folder to be: http://www.yoursite.com/temp
Then you would set this in your admin: Configuration -> Easy Populate 4
"Uploads Directory" = temp/
NOTE: this is not the same as = /temp/
You can bury it, but depending on the folder, you may have to modify your htaccess file to allow this. For example: If you want to put this in you admin directory, you will have to edit your htaccess file. There is a post earlier in this thread that explains how to do this.Quote:
Originally Posted by algerdes
-chadd
Yes, several import have naming conventions so the script knows how to handle the import file. If you keep the first part of the name:Quote:
Originally Posted by algerdes
Category-EP
CategoryMeta-EP
Full-EP
PriceBreaks-EP
PriceQty-EP
etc...
Yes, you need to match case (but I can loosen that restriction in a future update).
Hope that helps.
Send me a PM and I'll see what if I can help you off line.Quote:
Originally Posted by kan109
Can you do an export/import without downloading the file. This will not change anything, but it will give you an "Updated" notification. If this doesn't work, then there is something wrong with your install.
-chadd
Thank you.
I hope you are feeling much better.
So the stated version discrepency is purely cosmetic. It does get one thinking.
I have more questions, but I'll wait till after today's exploratory surgery on my website. Perhaps I'll have more answers than questions after it.
Good information.
Thank you.
Attributes Update:
Turns out I had no brave souls to test the pre-release code, so I will be putting this out into the wild soon... hopefully this weekend.
However, wanted to give people a chance to voice what columns they would like for the basic import.
Remember, the basic import ties a products_model to an products_options_name with a set of { products_options_values_name }.
I have mult-language support working correctly.
What attributes settings are the MOST common. The detailed attribute sheet will work to set any value in the table. So I'm not going to substitute that (it will over complicate in the initial import).
So if you have some feedback, now is the time to speak up and I'll see what I can do.
Once the new attribute features pass muster, I'll take this out of beta and submit to zencart's team for inclusion here.
thanks!
chadd
We make extensive use of attributes, mostly Colors for our dresses. (Sizes we can usually just copy across a category from a dummy product.)
Do I have the latest? My zip is called chaddro-EasyPopulate-4.0-9773477
sph
www.prommart.com
Hi,
I'm using easypopulate 4.0 with zencart and it's working like a charm. But i have many many subcategories, and haven't found a way to use zencart to setup the image path for categories. Is this possible ? How ?