Data Access, Export Tabs,Reports and Templateswww.jgroptics.com

Data Access, Export Tabs, Reports andTemplates
The Auto Export Label function can be enabled to automaticallysave results in .pdf, .txt or .html format. The default save location is:“C:\Users\yourUserName\Documents” This will use the “TemplateFile” selected for the Label. We will examine editing these files later.

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates
The system can also be set to automatically print labels from anattached printer.

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates
The template files for labels can be edited in ComponentOne’s
VSReport Designer. This can be found on the MS05B software flash
driver under “6) VSVIEW 8.0 Reporting Edition”

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates
The report designer will allow editing of the Label .xml files. You canfind these files at the file path shown on the right. If you cannot find
“Program Data” you must open windows file explorer Press “alt” tobring up the menu -> Tools -> folder Options -> view -> check “showhidden files”.

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates
Any of the sections can be edited, added or changed. A list ofavailable properties that can be used in the “Text” section can befound on the following slide.

www.jgroptics.com

Properties

Data Access, Export Tabs, Reports andTemplates• [Fix Serial Number]• [Incremental Serial Number]• [Wavelength 1]• [Wavelength 2]• [DUT Part Number]• [Measurement Date]• [Fiber Number]• [Il Wavelength 1]• [Il Wavelength 2]• [Il EndA Wavelength 1]• [Il EndA Wavelength 2]• [Il EndB Wavelength 1]• [Il EndB Wavelength 2]• [Reflectance Wavelength 1]• [Reflectance Wavelength 2]• [Reflectance EndA Wavelength 1]• [Reflectance EndA Wavelength 2]• [Reflectance EndB Wavelength 1]• [Reflectance EndB Wavelength 2]
www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates

Save your new template
under an appropriate namein the “Templates” folder. It
will automatically appear
under the Template files inMS12001.

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates

Data from measurements can be easily accessed through the“Browser” tab. You must build a filter in the “Filter Builder” to see
any results.
www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates• Start by clicking “Add” then give
your filter a name (here it iscalled “new filter training”).
• Now select the values you wish
to sort by. For example set thefield name to “Fixed Serial
Number” operator “=“ and value“12345” to see only results whichhave the serial number “12345”.
• Then click “And” and set the fieldname to “Cus_Name” operator“=“ value “Client ABC”.

• Click “And” once more to add the criteria, this will display only results with the customer“Client ABC” and Serial Number “12345”.
• Next Check the boxes beside the Fields you wish to display under “Display these Fields”.
• Finally you must select at least one Sort Criteria, for example set the field name to“Measurement Date” and click “Insert” to sort results by Measurement Date.
• Click “Apply” then “Close”

Data Access, Export Tabs, Reports andTemplatesMore examples of filters:All Results• Dum_GlobalTestStatus >= 0
All results from March 2013
• Dum_MeasurementDate BETWEEN '3/1/2013 01:01:01 AM'AND '3/31/2013 11:59:59 PM'
All Failed results from March 2013
• Dum_MeasurementDate BETWEEN '3/1/2013 01:01:01 AM'AND '3/31/2013 11:59:59 PM' And Dum_GlobalTestStatus = 3

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates

Once a filter is built a Report can be generated by clicking“Reports”.

www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates• Now select a report template to generate the report on theright.
• In order to examine it click the magnifying glass.
• If it is satisfactory the report can be exported to .html, .pdf or.txt file formats.
www.jgroptics.com

Data Access, Export Tabs, Reports andTemplates• Reports can be edited the same way as labels inVSReport Designer.
www.jgroptics.com