The Report externally functionality allows for the export of reports with an external program.
Using the functionality
- Select the Tools > Settings > Reports > Report externally menu items.
- Under the appropriate report type select the path to the external program.
You may use the <Harness ProD installation directory>\HReportExternally.exe demo program which will export the report as an *.xlsx file. - Click on the adjacent field and enter any additional arguments the program may require.
For the demo program this would be the path to the appropriate report template. The template path must be entered in the following form: -template "<Harness ProD installation directory>\Demo\Demo_ReportExternally\<template name>.xlsx". - Click [OK].
- Open the report you would like to export with this program.
- Select the File > Report externally menu items.
Select a directory in which to save your final report, define its name, and assign the appropriate file extension. For the demo program the extension has to be *.xlsx. - Click [Save].
Information for developers
The uncompiled source code for
When the report is saved using the Report externally functionality, Harness ProD will perform the following steps:
- Harness ProD creates the *.xml file containing the report data.
- Harness ProD calls the program with the following arguments:
- -source "<file path to xml data file>"
- -output "<file path to output file that has been specified by the user>"
- Any additional user-defined arguments, such as -template "<file path to template>" for the
HReportExternally.exe demo program.
The program then uses this information to create the final report.
The
Keyword | Description |
---|---|
|
Name of the project |
|
Date when the report was exported |
|
Time when the report was exported |
|
Mandatory indication of where the first column of the table to be filled with data is |
|
Mandatory indication of where the last column of the table to be filled with data is |
Property keywords
Property keyword | Property |
---|---|
Assembly / device report | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
Assembly / device name |
|
Composition |
|
Name |
|
Type |
|
Part name |
|
Library version |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Cost/item |
|
Cost/unit |
|
Weight/item |
|
Weight/unit |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |
Bill of materials (aggregated & single-line) | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
Type |
|
Part name |
|
Library version |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Quantity |
|
Quantity/packaging |
|
Order quantity |
|
Length |
|
Cost/item |
|
Cost/unit |
|
Total cost |
|
Total raw cost |
|
Weight/item |
|
Weight/unit |
|
Total weight |
|
Lead time |
|
Product color |
|
Temperature range |
|
Part status |
|
Object names |
|
Variant name |
|
Document name |
|
Project name |
Cable report | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
Cable name |
|
Wire name |
|
Part name |
|
Library version |
|
Outside diameter |
|
Cross-section |
|
Length |
|
Parent bundles |
|
Imprint |
|
Label |
|
Label text |
|
Insulation |
|
Wire twisted |
|
Material code |
|
Strands |
|
Internal part number |
|
ERP number |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Connectable object from |
|
Connectable object from supplier |
|
Connectable object from supplier part number |
|
Connectable object from manufacturer |
|
Connectable object from manufacturer part number |
|
Connectable object from internal part number |
|
Connectable object from ERP number |
|
From |
|
Pin from |
|
Pin designation from |
|
Connection point designations from |
|
Plug designation from |
|
Level from |
|
Wire terminal from |
|
Wire terminal from supplier |
|
Wire terminal from supplier part number |
|
Wire terminal from manufacturer |
|
Wire terminal from manufacturer part number |
|
Wire terminal from internal part number |
|
Wire terminal from ERP number |
|
Coating from |
|
Coating length from |
|
Coating material from |
|
Crimp applicator from |
|
Crimp applicator ID from |
|
Crimp applicator force from |
|
Crimp applicator tool options from |
|
Cavity seal from |
|
Cavity seal from supplier |
|
Cavity seal from supplier part number |
|
Cavity seal from manufacturer |
|
Cavity seal from manufacturer part number |
|
Cavity seal from internal part number |
|
Cavity seal from ERP number |
|
Fixed extra length from |
|
Stripping length from |
|
Exposed length from |
|
Residual length from |
|
Exposed twisted length from |
|
Residual twisted length from |
|
Untwisted from |
|
Connectable object to |
|
Connectable object to supplier |
|
Connectable object to supplier part number |
|
Connectable object to manufacturer |
|
Connectable object to manufacturer part number |
|
Connectable object to internal part number |
|
Connectable object to ERP number |
|
To |
|
Pin to |
|
Pin designation to |
|
Connection point designations to |
|
Plug designation to |
|
Level to |
|
Wire terminal to |
|
Wire terminal to supplier |
|
Wire terminal to supplier part number |
|
Wire terminal to manufacturer |
|
Wire terminal to manufacturer part number |
|
Wire terminal to internal part number |
|
Wire terminal to ERP number |
|
Coating to |
|
Coating length to |
|
Coating material to |
|
Crimp applicator to |
|
Crimp applicator ID to |
|
Crimp applicator force to |
|
Crimp applicator tool options to |
|
Cavity seal to |
|
Cavity seal to supplier |
|
Cavity seal to supplier part number |
|
Cavity seal to manufacturer |
|
Cavity seal to manufacturer part number |
|
Cavity seal to internal part number |
|
Cavity seal to ERP number |
|
Fixed extra length to |
|
Stripping length to |
|
Residual length to |
|
Exposed length to |
|
Exposed twisted length to |
|
Residual twisted length to |
|
Untwisted to |
|
Thickness |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |
Cable units report | |
|
Document |
|
Document revision |
|
Document description |
|
Name |
|
Part number |
|
ERP number |
|
Description |
|
Quantity |
|
Object names |
|
Variant name |
|
Project name |
Connectable object report | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
REFDES |
|
Type |
|
From |
|
Pin from |
|
Pin designation from |
|
Connection point designations from |
|
Plug designation from |
|
Level from |
|
Pin cavity size |
|
Wire name |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Imprint |
|
Label |
|
Label text |
|
Insulation |
|
Parent cable |
|
Parent cable supplier |
|
Parent cable supplier part number |
|
Parent cable manufacturer |
|
Parent cable manufacturer part number |
|
Parent cable internal part number |
|
Parent cable ERP number |
|
Outside diameter |
|
Cross-section |
|
Material code |
|
Parent assembly / device |
|
Parent assembly / device supplier |
|
Parent assembly / device supplier part number |
|
Parent assembly / device manufacturer |
|
Parent assembly / device manufacturer part number |
|
Parent assembly / device internal part number |
|
Parent assembly / device ERP number |
|
Part name |
|
Library version |
|
Length |
|
Stripping length |
|
Wire twisted |
|
Connectable object to |
|
Connectable object to supplier |
|
Connectable object to supplier part number |
|
Connectable object to manufacturer |
|
Connectable object to manufacturer part number |
|
Connectable object to supplier internal number |
|
Connectable object to ERP number |
|
To |
|
Pin to |
|
Pin designation to |
|
Connection point designations to |
|
Plug designation to |
|
Level to |
|
Pin cavity size to |
|
Wire terminal |
|
Wire terminal supplier |
|
Wire terminal supplier part number |
|
Wire terminal manufacturer |
|
Wire terminal manufacturer part number |
|
Wire terminal internal part number |
|
Wire terminal ERP number |
|
Wire terminal material |
|
Wire terminal cross-section |
|
Wire terminal outside diameter |
|
Coating |
|
Coating length |
|
Coating material |
|
Crimp applicator |
|
Crimp applicator ID |
|
Crimp applicator force |
|
Crimp applicator tool options |
|
Cavity seal |
|
Cavity seal supplier |
|
Cavity seal supplier part number |
|
Cavity seal manufacturer |
|
Cavity seal manufacturer part number |
|
Cavity seal internal part number |
|
Cavity seal ERP number |
|
Cavity seal diameter |
|
Cavity seal size |
|
Cavity plug |
|
Cavity plug size |
|
Cavity plug supplier |
|
Cavity plug supplier part number |
|
Cavity plug manufacturer |
|
Cavity plug manufacturer part number |
|
Cavity plug supplier internal number |
|
Cavity plug ERP number |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Position X |
|
Position Y |
|
Position Z |
|
Rotation X |
|
Rotation Y |
|
Rotation Z |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |
Wire harnesses report | |
|
Document |
|
Document revision |
|
Document description |
|
Name |
|
Part number |
|
ERP number |
|
Description |
|
Quantity |
|
Variant name |
|
Project name |
Special components report | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
REFDES |
|
Type |
|
From |
|
Pin from |
|
Pin designation from |
|
Connection point designations from |
|
Plug designation from |
|
Level from |
|
Pin cavity size |
|
Wire name |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Imprint |
|
Label |
|
Label text |
|
Insulation |
|
Parent cable |
|
Parent cable supplier |
|
Parent cable supplier part number |
|
Parent cable manufacturer |
|
Parent cable manufacturer part number |
|
Parent cable internal part number |
|
Parent cable ERP number |
|
Outside diameter |
|
Cross-section |
|
Material code |
|
Part name |
|
Library version |
|
Length |
|
Stripping length |
|
Wire twisted |
|
Connectable object to |
|
Connectable object to supplier |
|
Connectable object to supplier part number |
|
Connectable object to manufacturer |
|
Connectable object to manufacturer part number |
|
Connectable object to supplier internal number |
|
Connectable object ERP number |
|
To |
|
Pin to |
|
Pin designation to |
|
Connection point designations to |
|
Plug designation to |
|
Level to |
|
Pin cavity size to |
|
Wire terminal |
|
Wire terminal supplier |
|
Wire terminal supplier part number |
|
Wire terminal manufacturer |
|
Wire terminal manufacturer part number |
|
Wire terminal internal part number |
|
Wire terminal ERP number |
|
Wire terminal material |
|
Wire terminal cross-section |
|
Wire terminal outside diameter |
|
Coating |
|
Coating length |
|
Coating material |
|
Crimp applicator |
|
Crimp applicator ID |
|
Crimp applicator force |
|
Crimp applicator tool options |
|
Cavity seal |
|
Cavity seal supplier |
|
Cavity seal supplier part number |
|
Cavity seal manufacturer |
|
Cavity seal manufacturer part number |
|
Cavity seal internal part number |
|
Cavity seal ERP number |
|
Cavity seal diameter |
|
Cavity seal size |
|
Cavity plug |
|
Cavity plug size |
|
Cavity plug supplier |
|
Cavity plug supplier part number |
|
Cavity plug manufacturer |
|
Cavity plug manufacturer part number |
|
Cavity plug internal part number |
|
Cavity plug ERP number |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Position X |
|
Position Y |
|
Position Z |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |
Surface protection report | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
Name |
|
Type |
|
Part name |
|
Library version |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Length |
|
Length correction |
|
Order quantity |
|
Fill ratio |
|
Thickness |
|
Width |
|
Max. diameter |
|
Overlap ratio |
|
Overlapping length |
|
Diameter |
|
Shrink diameter |
|
Diameter range |
|
Knitted density |
|
Braid crossings p.i. |
|
Cost/item |
|
Cost/unit |
|
Weight/item |
|
Weight/unit |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |
Wire list | |
|
Wire harness name |
|
Wire harness ERP number |
|
Wire harness part number |
|
Wire harness description |
|
Cable unit name |
|
Cable unit ERP number |
|
Cable unit part number |
|
Cable unit description |
|
Cable name |
|
Wire name |
|
Length |
|
Parent cable |
|
Parent bundles |
|
Part name |
|
Library version |
|
Outside diameter |
|
Cross-section |
|
Insulation |
|
Wire twisted |
|
Material code |
|
Imprint |
|
Strands |
|
Label |
|
Label text |
|
Separation code |
|
Electrical class |
|
Supplier |
|
Supplier part number |
|
Manufacturer |
|
Manufacturer part number |
|
Internal part number |
|
ERP number |
|
Connectable object from |
|
Connectable object from supplier |
|
Connectable object from supplier part number |
|
Connectable object from manufacturer |
|
Connectable object from manufacturer part number |
|
Connectable object from internal part number |
|
Connectable object ERP number |
|
From |
|
Pin from |
|
Pin designation from |
|
Connection point designations from |
|
Plug designation from |
|
Level from |
|
Wire terminal from |
|
Wire terminal from supplier |
|
Wire terminal from supplier part number |
|
Wire terminal from manufacturer |
|
Wire terminal from manufacturer part number |
|
Wire terminal from internal part number |
|
Wire terminal from ERP number |
|
Coating from |
|
Coating length from |
|
Coating material from |
|
Crimp applicator from |
|
Crimp applicator ID from |
|
Crimp applicator force from |
|
Crimp applicator tool options from |
|
Cavity seal from |
|
Cavity seal from supplier |
|
Cavity seal from supplier part number |
|
Cavity seal from manufacturer |
|
Cavity seal from manufacturer part number |
|
Cavity seal from internal part number |
|
Cavity seal from ERP number |
|
Fixed extra length from |
|
Stripping length from |
|
Exposed length from |
|
Untwisted from |
|
Connectable object to |
|
Connectable object to supplier |
|
Connectable object to supplier part number |
|
Connectable object to manufacturer |
|
Connectable object to manufacturer part number |
|
Connectable object to internal part number |
|
Connectable object to ERP number |
|
To |
|
Pin to |
|
Pin designation to |
|
Connection point designations to |
|
Plug designation to |
|
Level to |
|
Wire terminal to |
|
Wire terminal to supplier |
|
Wire terminal to supplier part number |
|
Wire terminal to manufacturer |
|
Wire terminal to manufacturer part number |
|
Wire terminal to internal part number |
|
Wire terminal to ERP number |
|
Coating to |
|
Coating length to |
|
Coating material to |
|
Crimp applicator to |
|
Crimp applicator ID to |
|
Crimp applicator force to |
|
Crimp applicator tool options to |
|
Cavity seal to |
|
Cavity seal to supplier |
|
Cavity seal to supplier part number |
|
Cavity seal to manufacturer |
|
Cavity seal to manufacturer part number |
|
Cavity seal to internal part number |
|
Cavity seal to ERP number |
|
Fixed extra length to |
|
Stripping length to |
|
Exposed length to |
|
Untwisted to |
|
Lead time |
|
Product color |
|
Quantity/packaging |
|
Temperature range |
|
Alternative parts |
|
Electrical options |
|
Part status |
|
Variant name |
|
Document name |
|
Project name |