Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
fusionsp
ok but the csv version doesnt have a uninstall sql? any directions as to how to properly remove a mod? My old template had sooo many extra useless mods that i couldnt figure out how to get rid of.
And if i dont get rid of this, how do i install the older version?
It looks like the csv version creates the same dbase tables as 1.2.5.4 so there's no need to do a SQL uninstall.
All you need do is remove the php FILES, and you do this via your FTP program.
In the left frame (local drive) open up EP CSV version module admin folder and see what sub-folders and files are there (something like includes, then inside that, boxes, extra_datafiles, functions, languages.
In the right frame (remote server), navigate to the identical folders and simply delete the "macthing" php files that are appearing in your left frame for EP-csv. Do not delete the FOLDERS on the server... just the EP files inside them...
In other words, you are using the ORIGINAL module files on your local drive as a GUIDE to see what must come off your server.
------------------------------------------------------------------
EP 1.2.5.4 comes with a admin and a temp folder when you unzip the mod download. There are some EXTRA FILES there, but ignore them.
NB: you do NOT need to run the install.sql file unless you have problems getting EP to auto-run it later. See the readme... EP 1.2.5.4 ONLY needs the "admin" folder ftp'd... nothing else
Now... if you already have a folder called "tempEP" on your server (that was being used by the CSV version), you can keep it there, or re-name it to just temp.
(If you keep it as tempEP, you'll LATER change/check the EP configuration in your shop admin panel to make sure you have the correct name specified.)
--------------------------------------------------------------------
If you have re-named YOUR SERVER's admin folder to something else, then remember to re-name the "admin" folder in ep to the same name.
So, you will have this scenario on your FTP program, with EP 1.2.5.4 in the left frame and your server in the right frame
LEFT . . . . . . .| RIGHT
admin . . . . . | admin
temp . . . . . . | cache
install.txt . . . | editors
install.sql . . . | email
license.txt . . .| extras
readme.txt . . | includes
... just ftp the admin folder on the left, to the right, by clicking the right-facing arrow in the FTP console.
Then... follow my WIKI tutorial on Easy Populate.
Re: Easy Populate support for Version 1.2.5.4
How do you replace the line breaks in an excel spreadsheet with <br /> tags? I'm trying to do an edit/replace but the line breaks are not visable in excel.
I'm trying to import descriptions with Easy Populate but having problems with excell formatted text.
Thanks
Date_Added column updating to todays date issue with new products side box
Has anyone found a solution to this issue? I've been searching and have not been able to find any.
To clarify the problem:
You have old items in your database and are uploading updates to those items. the Date added column auto updates to todays date. Hence making all old items appear new and show up under new products side box.
I use zen-cart 1.3.8a
and ez populate 1.2.5.4
thanks in advance
Michael C.
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
pritchb
How do you replace the line breaks in an excel spreadsheet with <br /> tags? I'm trying to do an edit/replace but the line breaks are not visable in excel.
I'm trying to import descriptions with Easy Populate but having problems with excell formatted text.
Thanks
http://www.zen-cart.com/forum/showthread.php?t=144306 (See my post #4)
Re: Easy Populate support for Version 1.2.5.4
A few notes converning CSV files:
A number of people are having issues with CSV files (phazie's version, and the latter hacks to it) so I just wanted to relay a few notes from what I've noticed in my own work.
Working with CSV files is convenient ... you download your CSV file, and double-click it to edit ... then click "save" and upload... WRONG!!
You cannot just click "save". You must use "save as" and from the drop down box and select "CSV Windows". Just clicking "save" will put the file in microsoft's version of a CSV file, and this will not import correctly into EP!
Now, lets say you use OpenOffice to edit the CSV... look at the import window on open. Most people just click through and are fine. HOWEVER, if you have any special characters like (R) (C) tm the degree symbol, you must make sure your character set matches your data. OO will default to UTF-8 ... but most websites (in the US) will be Western ISO-8859-1. If you try to upload UTF-8 data to an western iso-8859-1 website, you will get "funky characters". This has to do with your databases and what collation they are in.
You can check your database collation by going into your phpMyAdmin and picking the products database, then "structure". You will see a "Collation" column. This in most cases will be latin1_swedish_ci which is compatible with iso-8859-1.
This perhaps sounds complicated, but it really isn't ... it's just a matter of knowing what your databases is going to export (say you typed descriptions in the zencart admin) or what type of data your vendor supplier is giving you.
HTML also has special characters that you can use in place of the extended characters. So, for the (R) registered symbol, you can use the HTML equivalent ® There are HTML equivalents for (R) (C) tm the degree symbol and more. Just google it.
Also. There is a big difference between normal single and double quotes and SMART QUOTES. Be sure you use the standard " and not the smart quote equivalent for your delimiter!
If you want to use a lot of special symbols and smart quotes, I recommend using OpenOffice.
Exporting CSV data from OO:
Once your data is ready, you select "save as" from the main menu, "Text CSV (.csv)" from the File type drop menu AND check "edit filter settings". You need to make sure you have the proper Character set selected!!! For CSV file, you would use the comma for your Field Delimiter and for TAB delimited files (aka .txt files for 1.2.5.4) select {TAB}.
The nice thing about OO is it will properly delimit every field with " (or what ever you choose). Excel will NOT do this!!!! It tries to be smart and in the end often causes problems.
Now the clincher. These notes are very pertinent if you are using a MAC. I have not verified on the PC yet, but I imagine everything would still apply. I think the CSV files on Windows normally export as "CSV Windows" but have not had a chance to check this. Windows users have it a bit better because they don't have the Mac end-of-line recognition problem that some mac users have encountered.
Hope this info helps!
Oh. Just remembered. If you look at your text data and see a lot of funky characters, try changing your font to Lucidia Sans Unicode. This is a good way to see if your data is in UTF-8.
Re: Easy Populate support for Version 1.2.5.4
i downloaded the .csv file that had the products i had inputted manually, added new products to the list (in Excel), saved as .csv and tried to upload the new list. it goes through all of the old products fine but stops at the new items with a SQL error.
" 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" at the top of the screen.
The first item were the error occurs says "ADD NEW PRODUCT FAILED! - Model: WCA4540 - SQL error. Check Easy Populate error log in uploads directory".
i have checked to make sure that the new item looks the same (column-wise) in Excel as the previous entry (old product) but i can't see anything that would stop it there. any help would be appreciated. :lookaroun
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
meandk0610
i downloaded the .csv file that had the products i had inputted manually, added new products to the list (in Excel), saved as .csv and tried to upload the new list. it goes through all of the old products fine but stops at the new items with a SQL error.
" 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" at the top of the screen.
The first item were the error occurs says "ADD NEW PRODUCT FAILED! - Model: WCA4540 - SQL error. Check Easy Populate error log in uploads directory".
i have checked to make sure that the new item looks the same (column-wise) in Excel as the previous entry (old product) but i can't see anything that would stop it there. any help would be appreciated. :lookaroun
if you have any non-empty cells after the last column you can get this behavior. check your .csv file with a text editor like notepad to see it still is correct. And also note my previous post above.
All else fails, attached some of the offending data so we can see it.
Re: Easy Populate support for Version 1.2.5.4
Version: 1.3.8 no upgrade
Previously installed add-ons: ez seo, stock by attribute
OS: Linux
:::PROBLEM:::
The below Warnings and Fatal error keeps occurring. I can login into the admin area just fine, only when I try accessing the EasyPopulate Module. eg(when i go to admin=>tools=>easypopulate, and CLICK)
eg(http://www.*************.com/admin/easypopulate.php)
it gives me those follow lines of error....
----------------------------------------------------------
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0
Fatal error: Unknown: Failed opening required '/******/******/public_html/admin/easypopulate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
----------------------------------------------------------
:: MY CURRENT STATE OF MIND ::
I was going to create my own script, but do to my time constrant, i figure zencart should have an addon for this use, but I cant get this one to work. Now after burning many hours of trying to get this to work, I'm now on a even tighter time constrant and now asking you fellow Zenners for some assistants.
:: THE QUESTIONs ::
Have anyone ran into this same PROBLEM and have found a SOLUTION?
what exactly is the problem, the error is point me to line 0 but all i see is "<?php " ???
THANKS AHEAD OF TIME FOR ANY ASSISTANT
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
cvue
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0
Fatal error: Unknown: Failed opening required '/******/******/public_html/admin/easypopulate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
Sounds like a folder/file permissions issue. Is your admin folder set to 755 and easypopulate.php set to 644?
Re: Easy Populate support for Version 1.2.5.4
Ok, so I use ep on a few of my sites. Just loaded it, to a new site and when I try and run it, I get database errors when I try an download the complete .csv files. Ideas?
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 811
Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1156
Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1157
Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1161
Warning: Cannot modify header information - headers already sent by (output started at /home/grapedis/public_html/vinoadmin/easypopulate.php:811) in /home/grapedis/public_html/vinoadmin/easypopulate.php on line 1165
v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_specials_price,v_specials_date_avail,v_specials_expires_date,v_p roducts_price,v_products_weight,v_date_avail,v_date_added,v_products_quantity,v_ manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v _categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v _tax_class_title,v_status,v_EASYPOPULATE_CONFIG_CUSTOM_FIELDS,v_metatags_product s_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_s tatus,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v _metatags_description_1
