This document will explain how to use the Calc NV to display a Document Object as a URL Link within a Traveler. It could be used to display special Work Instructions that are Part specific. The operator could then easily click the hyperlink and the Document Object would open. This EZ-MES Document Object could be any number of things from an digital image to a Word Document or Excel file.
This is how the hyperlink would be displayed to the operator.
Pre-Requisite
In order to do this, you should already have a Document Object you wish to display. If you do not already have one, you should Create a New Document. Below is a sample of what our example looks like. It is a simple text file.
Part Definition Configuration
The Part Definition will require that you add two Specs. They should be configured as follows:
DC Number Spec
- Spec Name: DC Number
- Spec Value: EZFile.ashx?sJob=DC12-000000001&sFile=
Spec Value Explanation
The fist part of this, ' EZFile.ashx?sJob= ', is used to contruct a portion of the hyperlink.
The middle part, ' DC12-000000001 ' , is the number for the Document Object being used (see above image).
The final part, ' &sFile= ' , is also used to construct a portion of the hyperlink.
It is important to use each part and type them correctly into the Spec Value. Without this, the hyperlink will not work correctly.
Work Instructions
- Spec Name: Work Instructions
- Spec Value: WI-Widget1.txt
SPEC VALUE EXPLANATION
Because you can upload multiple files to a Document Object, you must also specify the filename in this spec value. This value is also used within the hyperlink being composed by the Calc NV.
Sample of Two Different Part Definitions Spec Values
Part Definition - Widget 1
Part Definition - Widget 2
In addition to your first Part Definition Spec Values, you can also add them to another Part Definition. Changing up the values to that of another Document Object and File will result in a different file opening up when the hyperlink is clicked. It is possible that some Parts may be handled differently through the same Traveler. This provides the capability of viewing a separate work instruction for each Part Definition being ran through the same Step/Traveler.
Step / Name-Value Configuration
In the Step Definition that you would like to display the Document hyperlink, create a Name-Value with a Value Type of 'Calc'. This is also known as a Calc NV.
Inside the Calc NV perform the following configuration.
- Toggle to the 'Spec' type variables, then select the variable you are working on. First Work Instructions then DC Number.
- Create a variable for both the DC Number and Work Instructions Specs.
- Compose your String Formula. This should be a concatenation of both variables created. DC Number Spec Value + Work Instruction Spec Value. If you are following the example, it would be [DC]+[FILE]
- Select URL for the Display Type.
After this configuration you are done!
Resulting Traveler Display
Travelers will now display the proper link. You can see by the following images the Hyperlink display differs from the Widget1 Traveler to the Widget2 Traveler. A click of the Hyperlink will now open the file!
Widget1 Traveler
Widget2 Traveler
