Be.Smart ERP Picker
(EN) ERP Picker
(EN) ERP Picker
  • ℹ️What is Be.Smart ERP Picker?
  • ⚙️System Requirements
  • 🔑Installation & Activation Guide
  • 🆕What's New
    • Version 2.2.1.0
    • Version 2.1.3.0
  • Common information
    • Application configuration
      • Configuration file structure
      • Configuration file location
      • Configuration file parameters
        • Section [Settings]
        • Section [Mappings]
        • Section [MappingsC]
      • Examples of connections to data sources
        • Text file (txt | csv)
        • MS Excel
        • MS Access
        • MS SQL
        • Autodesk Vault
    • Overview of error messages
  • ERP Picker (Inventor add-on)
    • Basic description of functionality
    • Overview of commands
      • Be.Smart ERP Picker
        • Pick & Exit
        • Pick & Exit (Custom)
        • Export to file
        • Cancel
        • About
        • Help
        • Filtering and searching
        • Panel of additional information
      • Config
        • Edit config
        • Open folder
        • Exit
        • About
        • Help
      • About
  • ERP Picker (standalone app)
    • Basic description of functionality
    • Overview of commands
      • Export to file
      • Open folder
      • Cancel
      • About
      • Help
      • Filtering and Searching
      • Panel of additional information
Powered by GitBook
On this page
  1. Common information
  2. Application configuration

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
PreviousApplication configurationNextConfiguration file location

Last updated 1 year ago