Do you know the Cabinet Vision Guy?  He's created an awesome series of instructional videos for Cabinet Vision users.  Check back often to see his new videos - frequently updated with answers to your top questions.



Edit Door List Show Totals Info Icon
In this video, I go over how to separate out the door totals from the door types on the Door List w/Profiles (DLP002).

Software used:
Cabinet Vision v9: http://www.cabinetvision.com
 

Edit Door List   Show Totals

Edit Door List Show Totals

In this video, I go over how to separate out the door totals from the door types on the Door List w/Profiles (DLP002).

Software used:
Cabinet Vision v9: http://www.cabinetvision.com

 
Filtering Material Summary by Vendor

Filtering Material Summary by Vendor

In this video, I go over how to add vendor information to the Material Summary as well as create a filter using that same vendor information

Software used:
Cabinet Vision: http://www.cabinetvision.com
FlySpeed SQL Query: http://activedbsoft.com/overview-querytool.html
Notepad++: http://notepad-plus-plus.org

 
POC - Filtering By Vendors in Material Summary

POC - Filtering By Vendors in Material Summary

This is just a proof of concept for filtering data from the Material Summary. You can see that I have the ability to select a vendor and the report will filter it out all of the stuff based on the vendor selected

 
Cabinet Qty Correction

Cabinet Qty Correction

In this video, I go over how to account for disparate material id values in cut list reports.

Applicable to Cabinet Vision Version 9.0.0.149

 
Creating Union Tables

Creating Union Tables

In this video I go over how to create a union table that joins together two or more disparate data tables

Software Used:
Cabinet Vision V9: http://www.cabinetvision.com

 
Recreating V8 Reports in V9

Recreating V8 Reports in V9

This is a recreation of a 'Jing' video that was posted to eSupport. In this video, I go over how to re-create the Cabinet Vision V8 style of reports in Cabinet Version 9.0

Software Used:

Cabinet Vision V9: http://www.cabinetvision.com

 
Setting Decimal Precision in a Report

Setting Decimal Precision in a Report

This video describes the steps to change the decimal precision in a report. It uses the Material Summary (not optimized) as an example, but it applies to all reports

 
Altering an Imported Table

Altering an Imported Table

In this video, we add a new table import, then alter the SQL of a table to pull in the data, to a report, that we need. I use Cabinet Vision's Report Editor, as well as a program called Notepad++ (http://notepad-plus-plus.org)

 
Filtering Data

Filtering Data

In this video, we learn about filtering data. I use the Molding Report as an example, to show how to use the report editor's filter options to create a formula that filters out molding of a specific type.

 
Custom Unit of Issue On Material Summary

Custom Unit of Issue On Material Summary

In this video I discuss how to change the unit of issue for a specific material. Instead of listing out the all of the materials I want to use, I create a custom group, and put a unit of issue restriction on the report. With that setup, I can add multiple new materials to the group and the report will work with them automatically.

The restrictions set, in this video, are as follows:

1. A new group has to be created and all materials, that need this custom unit of issue, MUST be placed there
2. The unit of issue set on the materials MUST be SQ M.

You can change these restrictions as needed to suit your needs however.

The software tools used in this video are (not including OS and Cabinet Vision):

* Notepad ++ (http://notepad-plus-plus.org)
* Flyspeed SQL Query (http://www.activedbsoft.com/overview-querytool.html)

If you use the above mentioned tools, please support the people that make them...they are awesome tools (at an amazing price) and people have to work hard to make them (Notepad++ is free, but donate if you can :))

 
Add Fields to Report in S2M Report

Add Fields to Report in S2M Report

This video illustrates how to add additional fields to an S2M Center report. This is valid for the initial release of Cabinet Vision Version 9/S2M Center Version 6. These steps must be taken as the 'Report Properties' in the S2M Center do not have the advanced editor that is available in Cabinet Vision v9.

 
Material Summary Correction - Missing Ctop Parts

Material Summary Correction - Missing Ctop Parts

In this video, I discuss how to alter the Material Summary to ensure that the counter top parts are available. This video was filmed for Cabinet Vision Solid v9.0.0.148 and might not be valid for earlier, or later, versions.

 
Getting Options from a Stock Catalog

Getting Options from a Stock Catalog

In this video, I explain the steps to get a list of options from a Stock Catalog. I use the Generic.cvc, but you can use any stock catalog for this. You can also use this for protected and distributable catalogs.

In this video I use the built-in report editor in Cabinet Vision Solid v9 as well as a database program named FlySpeed SQL. A link for the software I used in this video is listed below:

FlySpeed SQL Builder: http://www.activedbsoft.com/products.html

 
Door Check List Correction (for v9.0.0.148)

Door Check List Correction (for v9.0.0.148)

The issue described in this video is to be corrected in a future build of Cabinet Vision Solid. Please make sure that you are not altering a report that is working correctly.

In this video, I show how to correct a door check list issue for cabinets that have multiple matching doors, and the 'Cabinet (Qty) List' lists out the same Cabinet ID multiple times.

I use the following software in this video:

Cabinet Vision Solid: http://www.cabinetvision.com
Notepad++: http://notepad-plus-plus.org

 
Add Adj Shelf Count to Cabinet List

Add Adj Shelf Count to Cabinet List

In this video, I show how to add an adjustable shelf count to an existing Cabinet List Report. I use the following software in this video:

- Cabinet Vision (http://www.cabinetvision.com)
- FlySpeed SQL (http://www.activedbsoft.com)

 
Modify Door Cut List - User Added Parts

Modify Door Cut List - User Added Parts

In this video we add in User added parts and remove hardware from the door cut list.

 
Adding Door Notes to Door List

Adding Door Notes to Door List

In this video, I cover how to add door notes, added via a UCS (listed below) to an existing door list report (in this example I used DL002). I use the following software in the video:

Cabinet Vision: http://www.cabinetvision.com
FlySpeed SQL Query: http://www.activedbsoft.com

Here is the UCS that I used to add the notes to the doors. Just a note, if you are using an assembly that has nothing but drawers, then you may recieve incorrect values, use at your own risk:

(I couldn't post it here, so I made it a note on my Facebook page):
https://www.facebook.com/notes/the-cabinet-vision-guy/door-notes-ucs-v900149/811278125612003

 
Door List Overlays

Door List Overlays

In this video I cover how to alter an existing report so that we can have overlays displayed on it. I use the following software in this video:

* Cabinet Vision: http://www.cabinetvision.com
* Notepad++ - http://www.notepad-plus-plus.org
* Flyspeed SQL Query - http://www.activedbsoft.com/overview-querytool.html

 
Displaying Fixed Images in a Report

Displaying Fixed Images in a Report

In this video, we go over creating a report, from scratch, that will display images linked to specific profiles in Cabinet Vision.

The following software is used in the video:

Cabinet Vision: http://www.cabinetvision.com
Microsoft Access 2010: http://www.microsoft.com

 
Combining Reports

Combining Reports

In this video I explain how to combine two, distinct, reports into one common one using simple copy/paste functions in Cabinet Vision

Software Used:

Cabinet Vision: http://www.cabinetvision.com

 
Making Barcodes

Making Barcodes

In this video I show you how to create barcodes using the built in functionality of the New Report Designer for Cabinet Vision Solid Version 9.0

Software Used in this video:
Cabinet Vision: http://www.cabinetvision.com

 
Adding Frames

Adding Frames

In this video I illustrate how to add a default frame to report elements as well as how to edit individual element frames.

Software used:
Cabinet Vision Solid v9.0: http://www.cabinetvision.com

 
Prompting for Values

Prompting for Values

In this video I illustrate how to prompt a user with a choice, and whether or not to enter a value based on that choice

Software used
Cabinet Vision Solid v9.0: http://www.cabinetvision.com

Link to SQL mentioned in video: http://esupport.planit.com/cabinet_vision/f/13/t/28837#pi239031345=2

 
Collection Variables

Collection Variables

In this video I go over what collection variables are and how you can use them for various tasks

Software Used:
Cabinet Vision: http://www.cabinetvision.com

 


You can view the Cabinet Vision Guy on Youtube here >