Product/Category Fixing/Reporting Utils for VP-ASP (BYZ055/12) by BigYellowZone

Software Search

HELP/FAQs?

Got questions/problems? Take a look through our FAQs (frequently asked questions), or email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly.

Want Discounts?

Are your prices for multiple domains too large? Are you trying to get licences for test domains but being asked to pay full cost? Don't worry; we can add test domains to your licences manually. Just purchase a single domain addon/upgrade for what it is that you need, and then email us about your situation regarding the remaining domains and we'll liaise with you over the options. email us at: support@bigyellowkey.com. We shall do our best to get back to you promptly. click here for more information regarding multiple domains, upgrades, and discount policies.

Subscription Services

BYZ Member Plan Subscription
add to cart

£157.00
more...

Points system now available!
Want something done? Installation, upgrade of addons? Customisation? From tiny-tweaks to large scale projects,
click here for info on BigYellowZone points.

Money Saving Bundles

Image Processing Mega-Bundle for VPASP add to cart	£75.00 more...

Google-Base and Yahoo Feed Bundle for VP-ASP add to cart	£45.00 more...

Category Bundle for VPASP add to cart	£45.00 more...

FREE Downloads!

Free Trial Admin Category Tree for VP-ASP
add to cart

free!
more...

BigYellowKey News

Released: 3/10/2010 2:05:00 PM

Twitter: You can now keep up with BigYellowZone releases and news using twitter: http://twitter.com/bigyellowzone If you're a Twitter user, Click the "Follow" link on http://twitter.com/bigyellowzone to keep up to date.

Released: 12/14/2009 2:45:00 PM

VPASP V7 status for BigYellowZone Addons:
click here for details

Released: 8/25/2009 2:05:00 PM

We've decided to extend the discounting of the BYZ subscription services, where the initial fee element is reduced by the cost of BYZ Addons that you've purchased in the last 12 months. This relates to the subscription services of BYZ147, BYZ148, and BYZ149. The reduced price will be shown when you get to the confirm-order page (ie after you have entered your domain).

Released: 4/25/2009 10:45:00 AM

BYZ Subscription Services added! You can now subscribe to get addons, or hosting, or both. For people who have bought BYZ addons in the last 12 months, you can trade-in what you've spent on addons in the last 12 months against a reduction in the relevant initial-fee element of the subscription service. This trade-in offer will only last for the next 30 days, so trade-in now! This trade-in relates to BYZ147, BYZ148, and BYZ149. See "subscription services" in the right-panel above or click on "services list" at the top. You'll get/see your discounted price of the subscription when you get to the final "confirm order" page (ie before you make payment, but after you've chosen your domain(s)). For example, if you've spent £120 on BYZ addons in the last 12 months, then you can get BYZ147 for just £37. If you've spent £200 on BYZ addons in the last 12 months then BYZ147 would only cost you £7. The prices concerned relate to prices excluding vat/tax and do not include installation cover/services. PLEASE NOTE: If you already have BYZ072/02 (Installation Cover) then that installation cover becomes invalid after you subscribe.

Released: 4/14/2009 2:00:05 PM

The My-Software screen has been changed to show a traffic-light system which shows a red cross for any modules which need upgrading, and a green tick for any modules which are up to date, which allows you to see at a glance if you need upgrades. NOTE: Please check your my-software screen regularly to see if upgrades are available.

Released: 4/14/2009 2:00:00 PM

Upgrade protection has been added which you can optionally purchase whenever you buy new modules, domains, or upgrade. It will give you permanent cover against the cost of future software upgrades for your module/domain. This is a major change to the bigyellowkey.com system; please let us know if you have any problems/questions.

Released: 2/23/2009 11:05:00 PM

**Notice: There was a temporary glitch with the bigyellowkey.com checkout process today; we have now investigated/fixed the problem. Apologies for any inconvenience this may have caused.

Released: 12/1/2008 12:00:01 AM

VAT Reduced to 15% - Following the recent government announcements in the UK, VAT (only payable on orders placed from the EU) has now been reduced from 17.5% to 15% with immediate effect from Midnight 1st December 2008, and will remain at 15% for 13 months. All of the bigyellowkey.com ordering and payment processes have been changed to accommodate this. Customers outside the EU do not pay any VAT. Customers from the UK always pay VAT. Customers from the EU (but outside the UK) who have a valid VAT/Tax number do not pay vat. Customers from the EU (but outside the UK) who do not have a valid VAT/Tax number pay VAT.

Released: 11/10/2008 1:05:00 PM

FAQs (Frequently Asked Questions) section has been added. Click on the Help link at the top of the page, or click on the FAQs link on the right panel help section.

Released: 10/17/2008 5:05:00 PM

What's New Link added to the top of the BYK screens. This allows you to see all new software released, and all new versions (upgrades) released, in descending date order. Want to know what's been happening on the software front? Just click on "what's new?" at the top of the screen.

Released: 9/2/2008 6:00:00 PM

New Software Vendor! SQLInjectionScanner.com (a sister company of BigYellowZone) is now using the BigYellowKey.com site to distribute anti-hacker tools and other products/services which site owners will find very useful. Visit SQLInjectionScanner.com for more info. If you previously bought the BYZ "hack checker", then check your my-software screen to grab the latest update; it has now become the "SQLInjectionScanner.com Scanner" and the new version has lots more features. A data cleaner is also available, as are check/fix services.

Released: 11/22/2007 4:29:00 PM

Mail-Lists (with discounts) added. Your profile now has a mail-list option at the bottom where you can optionally sign up to mail-lists. Some mail-lists will give you discounts (these discounts will be explained on the mail-list description). Default will always be "no sign up" for any customer, either historic or new customers. You will need to explicitly tick the sign-up box and save the changes to get added to the mail-list (and receive the relevant discount).

Released: 10/16/2007 11:57:00 AM

Live/Archived radio buttons fixed - the live/archived/all radio buttons at the top of your "My Software" (and other "My") screens have now been fixed. They were previously one-step behind what you pressed, but are now correct and automatically refresh as soon as you click on one of the radio buttons.

Released: 10/16/2007 11:56:00 AM

localhost assigned for free - you can now add localhost to any of your licenses during purchases/upgrades, or via your "My Domains" tab, and it will automatically give you the localhost key for free.

Released: 10/16/2007 11:55:00 AM

New version of byk released - if your customer control panel shows you the login screen, then please login again. Once logged in you will no longer need to login again.

Released: 10/11/2007 12:30:00 PM

Upgrade fix applied. There was a problem when upgrading Backfilled BYZ licences, this has now been fixed, but if you upgraded on BYK prior to this news item being added then go into your "My Software" screen, and check if you have multiple versions of a given product for a given domain; if you have multiple versions then press the archive link on the old versions, then go to your license keys page and create a new license key file, then download that key file and upload it to your site.

Released: 10/8/2007 11:50:00 PM

Sub-Modules added to your software lists - We have now ensured that all of your sub-modules are now listed for your main modules on your software screen. This means that you can now upgrade/download either the main module, and/or the sub-modules. Our upgrading and purchasing procedures use "intelligent" bundling, whereby if you've upgraded/bought all the corresponding sub-modules then you'd automatically also be assigned all appropriate parent bundls, and if you buy/upgrade a bundle then it will automatically assign access to all the sub-modules as well. Checkout your "My Software" screen, as it may now be showing you additional/new sub-modules.

Released: 9/28/2007 8:15:00 AM

BYZ Interface Improved - We have now changed our sister site (bigyellowzone.com) so that you will only get directed to bigyellowkey when you checkout, and not each time you add an item to your cart. This means that you can continue freely shopping/browsing on bigyellowzone.com without having to jump between byk/byz sites for each item. Note that for upgrades you should always use bigyellowkey.com for browsing/purchasing, and not bigyellowzone.com.

Released: 9/25/2007 11:45:00 PM

Version History Displays - We've added a link on the product-codes on your "My Software" screen which will popup a printer-friendly page that displays all the product details and the full version history (ie all the release notes of all versions) so that you can now see if you want/need to upgrade specific modules.

Released: 9/23/2007 2:05:00 PM

We're Live ! - BigYellowKey.com has now become a live system. There might be some teething questions/problems following its release, so if you have any questions/problems then please do let us know.

BYZ055 - Product/Category Fixing/Reporting Utils for VP-ASP

<< back to previous screen

This is a set of 11 new Admin screens, with a common menu used at the
top, having 11 different sets of data checks with buttons to auto-fix
the missing/incorrect data where relevant.
If you use ProdCategories then we guarantee that your data will need cleaning up
and this is a great tool which lets you clean up your data at the push
of a fix button.

Compatibility, Bundling, and Status Notes:

Compatible with VPASP V4.5 to V7
Before installing, you must have installed:
BYZ038
BYZ036

This product includes:
BYZ038
BYZ036

This product is also available in the bundle:
BYZ109

Latest version:		12/08-JUL-2010
From vendor:		BigYellowZone
Price:		£30.00
add to cart

Each of the 11 screens shows the precise cause of the data errors, showing summaries of each record that's at fault with relevant links to the product, category, and/or prodcategories records.

Technical/Developer Information:
The checks carried out are:

1) Invalid Categories on Matrix
"fix data" will delete these spurious matrix records

2) Invalid Products on Matrix
"fix data" will delete these spurious matrix records

3) Invalid Categories on Products
no "fix data" available; just use the links on each record to get to the product screen and edit the categories for the product.

4) SubCategories on matrix but no parent Categories on Matrix
"fix data" will generate the missing parent categories matrix records

5) Infinite Looping Categories
Shows the relevant branches/categories and allows you to set the highercategoryid of relevant categories.

6) Products with no Matrix entries
no "fix data" available; just use the links on each record to get to the product screen and edit the categories for the product.

7) Categories with no Matrix entries
"fix data" will delete the unused categories

8) Category records with invalid hassubcategory value
"fix data" will correct the hassubcategory values

9) Category records having no sub categories but hassubcategory flag is set to 'Yes'
"fix data" will correct the hassubcategory values

10) Category records having sub categories but hassubcategory flag is set to null ('No')
"fix data" will correct the hassubcategory values

11) Category records with higercategoryid values which do not exist.
(no "fix data" button available; links to the categories are given instead so that you can manually change them)

For further information from the vendor about this product, please visit:
http://www.bigyellowzone.com/shopexd.asp?id=74

Full Version History:

VerNo	Version Date	Release Notes
01	01-JAN-2005	Initial version - Big Yellow Zone Category/ProdCategory Fixing Utility For VP-ASP
02	04-JAN-2006	Added four new utilities/steps for category records. New checks were added for: 1. Category records with hassubcategory value other than Yes or null (No). 2. Category records having no sub categories but hassubcategory flag is set to Yes. 3. Category records having sub categories but hassubcategory flag is set to null (No). 4. Category records with highercategoryid values which do not exist. Changed documentation to make it VP-ASP V6 compatible. Added extra warning message to the Categories with no matrix section. Effected files: README.htm (changed) byz055_install.asp (changed) byz_prodcatcheck_menu.asp (changed) byz_prodcatcheck_missingcatsonmatrix.asp (changed) byz_catcheck_correct_hassubcategory_value.asp (new file) byz_catcheck_flaggedsubcats_nosubcats.asp (new file) byz_catcheck_higher_category_exists.asp (new file) byz_catcheck_subcats_flaggednosubcats.asp (new file)
03	21-FEB-2007	Changed to be able to cater for some additional versions of MySQL, as MySQL has restrictive sql syntax relating to using sub-queries compared to Access/SQLServer. Changed to fully close-down/clear cursors and connections (previously some cursors/connections were being left open). Added a max-errors-shown config option, changeable for each stage by altering the settings in the new byz_prodcatcheck_$config.asp file. Changed array size logic to avoid memory problems. Changed/corrected some boiler-plate text typos. Added current stage titles to the header of each stages screen. Changed the formatting to highlight errors and relevant messages in a clearer way. Added notes regarding indexing columns to speed up the tool/site. Effected Files: README.htm (changed) byz055_install.asp (changed) byz_catcheck_correct_hassubcategory_value.asp (changed) byz_catcheck_flaggedsubcats_nosubcats.asp (changed) byz_catcheck_higher_category_exists.asp (changed) byz_catcheck_subcats_flaggednosubcats.asp (changed) byz_prodcatcheck_$config.asp (new file) byz_prodcatcheck_invalidcatonmatrix.asp (changed) byz_prodcatcheck_invalidcatonproducts.asp (changed) byz_prodcatcheck_invalidprdonmatrix.asp (changed) byz_prodcatcheck_menu.asp (changed) byz_prodcatcheck_missingcatsonmatrix.asp (changed) byz_prodcatcheck_missingproductsonmatrix.asp (changed) byz_prodcatcheck_subcatsnocats.asp (changed) byz_prodcatcheck_sys.asp (new file)
04	15-MAR-2007	Upgraded BYZ038 (Licensing) module to cater for VP-ASP V6.5. Changed installation instructions to cater for VP-ASP V6.5 (categories has moved from occasional to everyday menu section between 6.0x and 6.5). Effected files: byz055_install.asp (changed file) README.htm (changed file)
05	03-JUL-2007	Changed to be able to cater for some olders versions SQLServer, similar changes as to what was done on version 03. Effected files: byz055_install.asp (changed file) README.htm (changed file) byz_catcheck_flaggedsubcats_nosubcats.asp (changed file) byz_catcheck_subcats_flaggednosubcats.asp (changed file)
06	05-SEP-2007	Changed stage 8 to cater for recent MySql syntax rule changes. Effected files: byz055_install.asp (changed file) README.htm (changed file) byz_prodcatcheck_subcatsnocats.asp (changed file)
07	08-NOV-2007	Upgraded BYZ038 (from V07 to V08) Upgraded BYZ036 (from V02 to V04) Changed instructions to be compatible with bigyellowkey.com licensing notes. Effected files: README.htm (changed file) byz055_install.asp (deleted file)
08	16-JAN-2008	Added explicit command timeouts for database connections. Effected files: README.htm (changed file) byz_catcheck_correct_hassubcategory_value.asp (changed file) byz_catcheck_flaggedsubcats_nosubcats.asp (changed file) byz_catcheck_higher_category_exists.asp (changed file) byz_catcheck_subcats_flaggednosubcats.asp (changed file) byz_prodcatcheck_invalidcatonmatrix.asp (changed file) byz_prodcatcheck_invalidcatonproducts.asp (changed file) byz_prodcatcheck_invalidprdonmatrix.asp (changed file) byz_prodcatcheck_missingcatsonmatrix.asp (changed file) byz_prodcatcheck_missingproductsonmatrix.asp (changed file) byz_prodcatcheck_subcatsnocats.asp (changed file)
09	16-JAN-2009	Upgraded BYZ038 (from V08 to V10) Upgraded BYZ036 (from V04 to V05) Created version file for reference/info. Added more notes to all the stage screens to explain in more detail about the errors/checks. Effected files: README.htm (changed file) byz$055_version.asp (new file) byz_catcheck_correct_hassubcategory_value.asp (changed file) byz_catcheck_flaggedsubcats_nosubcats.asp (changed file) byz_catcheck_higher_category_exists.asp (changed file) byz_catcheck_subcats_flaggednosubcats.asp (changed file) byz_prodcatcheck_invalidcatonmatrix.asp (changed file) byz_prodcatcheck_invalidcatonproducts.asp (changed file) byz_prodcatcheck_invalidprdonmatrix.asp (changed file) byz_prodcatcheck_missingcatsonmatrix.asp (changed file) byz_prodcatcheck_missingproductsonmatrix.asp (changed file) byz_prodcatcheck_subcatsnocats.asp (changed file)
10	12-JUL-2009	Added an additional stage (stage 5) to check for infinite-looping category branches, and renumbered subsequent stages to bump them up by 1 (eg old stage 5 is now stage 6 etc). Changed menu (stage selection) links to show current stage/screen as highlighted. Effected files: README.htm (changed file) byz$055_version.asp (changed file) byz_catcheck_loops.asp (new file) byz_prodcatcheck_$config.asp (changed file) byz_prodcatcheck_invalidcatonmatrix.asp (changed file) byz_prodcatcheck_invalidcatonproducts.asp (changed file) byz_prodcatcheck_invalidprdonmatrix.asp (changed file) byz_prodcatcheck_menu.asp (changed file) byz_prodcatcheck_missingcatsonmatrix.asp (changed file) byz_prodcatcheck_missingproductsonmatrix.asp (changed file) byz_prodcatcheck_subcatsnocats.asp (changed file) byz_prodcatcheck_sys.asp (changed file)
11	15-DEC-2009	Changed installation notes and program files to cater for VPASP V7. Added version info to pages. Upgraded BYZ038 (from V10 to V11) Upgraded BYZ036 (from V05 to V06) Effected files: README.htm (changed file) byz$055_version.asp (changed file; all versions) byz_catcheck* (changed files; all versions) byz_prodcatcheck* (changed files; all versions)
12	08-JUL-2010	Speeded up stage 5 (Infinite Loop check) and stopped it from using nested cursors which were causing problems on some servers. Upgraded BYZ038 (from V11 to V12) Upgraded BYZ036 (from V06 to V07) Effected files: README.htm (changed file) byz$055_version.asp (changed file; all versions) byz_catcheck_loops.asp (changed file; all versions)