Download barcodes to CSV file - Intergraph Smart Materials - Version 5.0 SP1 (5.0.1) - Help - Hexagon PPM

Intergraph Smart Materials MobileScan Help (5.0 SP1)

Language
English
Product
Intergraph Smart Materials
Subproduct
MobileScan
Search by Category
Help
Smart Materials Mobile Scan Version
5.0

Click Download to generate and view the barcodes for the selected document. For more information on barcode generation rules, see Barcode generation and printing.

  • The generated barcodes are exported to a CSV file, which is a formatted excel spreadsheet that includes all information pulled from the selected purchase order or release note.

  • You can send the CSV file to the manufacturer or a third party commercial printer for barcode creation.

    4.4 Downloading Barcodes to CSV File

    The CSV file can be configured as desired, up to 20 CIP fields and are named cip_CsvExportCol[1-20]. To configure the CSV file, you must use the CIP package m_sys.ms_pkg_custom.

    CIP Column Configuration 3/23/2016

    • The column names are case sensitive and must start with a lower case character.

    • Column name must not contain numbers, spaces, or special characters.

    • The CIPs can be modified by the user as per columnName and then use the select statement on m_sys.ms_pkg_custom.

Project Default ZC_ALL_SUP

By default, when you click Download, the Barcode Manager downloads barcodes belonging to all the supplements of a PO. The project default ZC_ALL_SUP enables the user either to download the barcodes from the latest supplement or to download barcodes belonging to all the supplements of a PO. The project default ZC_ALL_SUP takes the following values:

Y - (default) Show barcodes belonging to all supplements of a PO.

N - Show barcodes belonging to latest supplement of a PO.

For example, the following PO has two supplements, Suppl: 0 and Suppl: 2.

BArcode Manager - Barcode Supplements - 1

  • When ZC_ALL_SUP is set to Y, the Barcode Manager lists all the barcodes, including all the supplement barcodes (old and new) as seen in the generated .csv file:

BArcode Manager - Barcode Supplements CSV - Y - 2

  • When ZC_ALL_SUP is set to N, then the Barcode Manager shows:

    • newly modified barcodes (excludes earlier modified barcodes for the same line item)

    • unmodified barcodes

    • newly added barcodes

      as seen in the generated .csv file in the following screenshot:

BArcode Manager - Barcode Supplements CSV - N - 3