Configuration file structure
The configuration file contains several sections that can be configured step by step, in particular:
connection parameters to the data source,
automatic filtering of values,
mapping values from the data source to Inventor document iProperties.
An example of the config file, including commented sample values, is below.
[Settings]
ConnectionString=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\MATDBTK.accdb
ConnectionSelectCommand=SELECT ID, Group, Number, Name01, Description, Standard, Count, Material FROM MATDBEN
ConnectionSelectHeaders=
MainFormLabel=ERP Picker
LoggingLevel=Warning
ShowAll=true
ApplyFilterDelay=1200
FullRowSelect=True
SheetMetalThicknessDbFieldName=
SheetMetalThicknessUseDotAsDecDelim=False
InitiateFilterDbFieldName=
InitiateFilterValue=
AcceptVirtualComponent=True
[Mappings_DesignTrackingProperties]
; SAMPLE MAPPING STRUCTURE
; iProperty1InternalName=ConnectionSelectCommandField1NameA
Material=Material
[Mappings_DocSummaryInformation]
; SAMPLE MAPPING STRUCTURE
; iProperty2InternalName=ConnectionSelectCommandFieldNameB
[Mappings_SummaryInformation]
; SAMPLE MAPPING STRUCTURE
; iProperty3InternalName=ConnectionSelectCommandFieldNameC
[Mappings_UserDefinedProperties]
ERPPickerNumber=Number
ERPPickerName=Name01
; SAMPLE MAPPING STRUCTURE
;iProperty4InternalName=ConnectionSelectCommandFieldNameD
[MappingsC_DesignTrackingProperties]
[MappingsC_DocSummaryInformation]
[MappingsC_SummaryInformation]
[MappingsC_UserDefinedProperties]
ERPPickerNumber=Cislo
ERPPickerName=Nazev
; SAMPLE MAPPING STRUCTURE
;iProperty5InternalName=ConnectionSelectCommandFieldNameE