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.



Combining Pair Doors with different hinging Info Icon
In this video, I give a quick rundown on how to join the records in a door list so that pair doors with dissimilar hinging (Left and Right) will be joined together into a single item (this can join a whole bunch of pair doors that have the same size)

Software Used in this Video:
Cabinet Vision Solid: http://www.cabinetvision.com
Notepad++: http://notepad-plus-plus.org
 

Combining Pair Doors with different hinging

Combining Pair Doors with different hinging

In this video, I give a quick rundown on how to join the records in a door list so that pair doors with dissimilar hinging (Left and Right) will be joined together into a single item (this can join a whole bunch of pair doors that have the same size)

Software Used in this Video:
Cabinet Vision Solid: http://www.cabinetvision.com
Notepad++: http://notepad-plus-plus.org

 
Creating a Space on the First Page of a report

Creating a Space on the First Page of a report

In this video we go over how to create a larger space on the first page of a Combit List & Label report while leaving the rest of the pages with a predefined margin all around.

In doing this, we cover how to:
1. Create variables
2. Position the Report Container programmatically
3. Assign elements to a specific layer
4. Create Conditional formulas

 
Custom Edgebanding Headers

Custom Edgebanding Headers

In this report, we will create a custom report that will group by material, then by banding code, and then display results. It's for Adj. Shelves only, but the principles work for all parts.

So...near the end of the video (which you should watch before worrying about this), I will show you that the Cabinet (Qty) SQL is incorrrect. To make the correction, you have to do the following:

Alter the Original SQL in the PartList table, not the Link, found here:

https://www.dropbox.com/s/vf21kcwjtkpgjwl/CustomReport_EdgebandHeader_PartListSQLCorrection.txt?dl=0

Now, alter the Caibnet(Qty) SQL to the one located here:

https://www.dropbox.com/s/fzypmuqcg4k8ppn/CustomReport_EdgebandHeader_PartListCabinetSQLCorrection.txt?dl=0

 
CreateMaterialFilter

CreateMaterialFilter

In this video, we go over creating a custom material filter that can be dynamically selected at report runtime

 
Puck it...let's do this!

Puck it...let's do this!

In this video I go over how to create a Puck Light Part/Material combo to easily place puck lights, get CNC information, and even get a count of puck lights that I need (with purchasing information and everything)

Software used:

- Cabinet Vision Solid v9
- Sketchup (referenced to only)

If you have any comments or questions on this, feel free to post them on the eSupport website:

http://esupport.planit.com

 
Boring pull holes?  I think it's exciting...

Boring pull holes? I think it's exciting...

In this video we go over how to alter you pulls to bore holes in your subfronts automatically. It's easy and allows a greater flexibility than UCS'.

 
The trouble with rabbets is...nothing really.

The trouble with rabbets is...nothing really.

In this video we, go over how to easily add rabbet operations to your parts, whether using Master/Slave operations, or applying your operations directly to the

 
Changing Material Names in a Job

Changing Material Names in a Job

Here we setup a report we made earlier (on eSupport) to change the material names in the job

 
Adding Material Notes to a report

Adding Material Notes to a report

In this video, we added job notes under the material, as we had done with material parameters on a report previously.

 
Adding Part Counts to the end of a report

Adding Part Counts to the end of a report

In this video, we add a part count to the end of a material grouping.

 
Creating a very simple door list

Creating a very simple door list

In this video, we create a very simple door list from scratch. The door list Groups by Door Name, Width, and height.

 
Removing Materials from a Material Summary

Removing Materials from a Material Summary

In this video we remove an entire material type from the MTOT01 material summary

 
Material Part Numbers in Report

Material Part Numbers in Report

In this video we go over how to use the material parameter functionality, that was introduced in Cabinet Vision v9, to enhance our reports with additional data

 
Copied drawer parts show up on Cut List, but not on Check LIst

Copied drawer parts show up on Cut List, but not on Check LIst

So, copied drawer parts are showing up on cut lists, but not on check lists, this is why.

 
Report Object Interlinking

Report Object Interlinking

Here we learn how to link objects together so that they print in a specific order

 
Increasing the number of labels

Increasing the number of labels

In this video, we figure out how to add redundant data to a report. Basically, add a label for each quantity of items that were added in order entry.

The script that is referenced in the video can be downloaded here:

https://1drv.ms/u/s!AoDpvSQXd4hige0FJxub8QwC7NruOw

 
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 >