easy populate csv where to find uninstall sql?

[giuly]

hello, I had installed easy populate advanced 2.76 (I guess I made a mistake because it is osc so I guess it is for the files from osc to zencart), but I would remove because causes errors maybe obviously .

I would install this addon
http://www.zen-cart.com/index.php?ma...oducts_id=1240

but before installing I would know the uninstall.sql file in way that if I have to uninstall, I upload uninstall.sql and all will be right.


So please I need with urgence if possible.
the original install.sql is
# Install Easy Populate Configuration v1.2.5.4
INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES
('', 'Uploads Directory', 'EASYPOPULATE_CONFIG_TEMP_DIR', 'tempEP/', 'Name of directory for your uploads (default: tempEP/).', last_insert_id(), '0', NULL, now(), NULL, NULL),
('', 'Upload File Date Format', 'EASYPOPULATE_CONFIG_FILE_DATE_FORMAT', 'm-d-y', 'Choose order of date values that corresponds to your uploads file, usually generated by MS Excel. Raw dates in your uploads file (Eg 2005-09-26 09:00:00) are not affected, and will upload as they are.', last_insert_id(), '1', NULL, now(), NULL, 'zen_cfg_select_option(array("m-d-y", "d-m-y", "y-m-d"),'),
('', 'Default Raw Time', 'EASYPOPULATE_CONFIG_DEFAULT_RAW_TIME', '09:00:00', 'If no time value stipulated in upload file, use this value. Useful for ensuring specials begin after a specific time of the day (default: 09:00:00)', last_insert_id(), '2', NULL, now(), NULL, NULL),
('', 'Split File On # Records', 'EASYPOPULATE_CONFIG_SPLIT_MAX', '300', 'Default number of records for split-file uploads. Used to avoid timeouts on large uploads (default: 300).', last_insert_id(), '3', NULL, now(), NULL, NULL),
('', 'Maximum Category Depth', 'EASYPOPULATE_CONFIG_MAX_CATEGORY_LEVELS', '7', 'Maximum depth of categories required for your store. Is the number of category columns in downloaded file (default: 7).', last_insert_id(), '4', NULL, now(), NULL, NULL),
('', 'Upload/Download Prices Include Tax', 'EASYPOPULATE_CONFIG_PRICE_INC_TAX', 'false', 'Choose to include or exclude tax, depending on how you manage prices outside of Zen Cart.', last_insert_id(), '5', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Make Zero Qty Products Inactive', 'EASYPOPULATE_CONFIG_ZERO_QTY_INACTIVE', 'false', 'When uploading, make the status Inactive for products with zero qty (default: false).', last_insert_id(), '6', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Smart Tags Replacement of Newlines', 'EASYPOPULATE_CONFIG_SMART_TAGS', 'true', 'Allows your description fields in your uploads file to have carriage returns and/or new-lines converted to HTML line-breaks on uploading, thus preserving some rudimentary formatting (default: true).', last_insert_id(), '7', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Advanced Smart Tags', 'EASYPOPULATE_CONFIG_ADV_SMART_TAGS', 'false', 'Allow the use of complex regular expressions to format descriptions, making headings bold, add bullets, etc. Configuration is in ADMIN/easypopulate.php (default: false).', last_insert_id(), '8', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),'),
('', 'Debug Logging', 'EASYPOPULATE_CONFIG_DEBUG_LOGGING', 'true', 'Allow Easy Populate to generate an error log on errors only (default: true)', last_insert_id(), '9', NULL, now(), NULL, 'zen_cfg_select_option(array("true", "false"),');


So please if someone knows how to uninstall this sql, he makes me a favour.

[niccol]

Don't know about 2.76 but I would recommend doing an uninstall through phpmyadmin or a similar database tool.

There is a pretty good instruction of how to uninstall 1.2.5.6 based on schoolboy's post in the easy populate thread.

http://www.zen-cart.com/forum/showth...all#post776901

You are after post number 2514.

That might help...

[giuly]

thanks to you now I do step by step

thanks a lot, I didn't found anything about it
thank


I don't know where to download the old version of EP 1.2.5.4 do you know?

[giuly]

ok found
http://www.zen-cart.com/archived_con...s/admin-tools/

[giuly]

ok now I have installed 1.2.5.4 but I have problem like before, so the csv duplicate products, instead in store are all right

[niccol]

OK. I would post on the 1.2.5.4 thread which is pretty active and has people with lots of knowledge beyond mine...

Oh, and you have unique model numbers, right?

[schoolboy]

ok now I have installed 1.2.5.4 but I have problem like before, so the csv duplicate products, instead in store are all right

If you are managing to UPLOAD products into your store (even though they are duplicating), it suggest EP is working - and the fault is with the "input clerk" rather than the program.

So... EP is working, and now you want to get rid of those duplicates...

Get EP to do a full EXPORT and then open up that tab-delimited file in a spreadsheet.

Use the spreadsheet's DATA SORT feature to help you list the data in ways that make finding the duplicates easier. (For example, if you uploaded an EP list and included one of the DATE fields, then you may find getting rid of the duplicate set easier by doing a data sort BY DATE COLUMN).

... but I am surprised you ended up with duplicates...

Firstly, EP will not write data to the database unless there is a PRODUCT CODE (model number)...

Secondly, EP will NOT write a duplicate product (2 or more products with the same model number) to the SAME CATEGORY. EP assumes that if a model number is duplicated for DIFFERENT categories, then it is a LINKED product.

So, your duplicates are probably sitting in DIFFERENT CATEGORIES...

In which case, you can sort the spreadsheet by CATEGORY levels - making finding the duplicates easy.

NOW... HOW TO REMOVE THE DUPLICATES ???

You have TWO options and BOTH should give you cause to BACK UP YOUR DATABASE FIRST !

ALSO... work with a COPY of your EP spreadsheet - keep the original un-touched!

Option 1.
Using EP's delete feature, put " 9 " into the v_status column cells of all products you want to remove. When you're done, SORT the spreadsheet by column v_status, and then DELETE all products with a 0 or 1 in v-status. (That's right - erase them from the spreadsheet). You are now left with a spreadsheet of products where v_status = 9 . SAVE spreadsheet as TABBED TXT and run it through EP.

This will delete all those products....

BUT... it may ALSO delete all images associated with them!

(What I do before using this method is re-name the images folder temporarily via FTP)


Option 2.
Similar - but requires a bit of a "leap of faith" because you will need to delete ALL your categories and products from your store. Only use this method if you DO NOT have attributes associated with products. You will "dis-associate" all attributes from the products as well!

So now you have a store with NO products and NO categories...

Now, when you sort your spreadsheet, this time you will KEEP all products with v_status = 0 or 1, and erase all those with v_status = 9 .

Your spreadsheet will now contain only products and categories you want to KEEP.

If the resultant TXT file is "EP compliant", running it through EP on your store should load everything in a minute or two.

[giuly]

I SOLVED (finally), I guess that EP advanced created an error, because had create linked product, so the yellow button.

So manually I delete all linked products and now it goes perfectly.


The only thing I don't try to view the price included tax, it shows always without taxes, also if I set true on configuration>easy populate.

But...within tomorrow I upload products without taxes id I don't solve that and the EP goes.

Thanks to everybody

[giuly]

no I have to reply also 1.2.5.4 when I upload creates linked products, so this time less products and I remove linked manually.

Why this???
Please



Obviously the ID is unique

Is it possible that SSU it is in conflict with EP?
because I noticed that the url for new4 products isn't like others isn't correct.