2.1.1.2.4. VDI 3805 importer: Sort variables

As of V11 SP12 there is the possibility to explicitly determine the variables' sort sequence as is should then be displayed in the characteristic attribute table. For this, now the configuration file vdi3805import.cfg. contains the key "_SORT". You can find it after the wizard's first run under $CADENAS_USER/vdi.

  1. Perform the settings for the desired sort sequence in the key.

  2. Then run the import via Wizard again.

Note the following points:

  • The block numbers in the configuration file correspond to the sheet numbers. So for example: For sheet 20 the block 20 is relevant.

    Configuration file vdi3805import.cfg, excerpt block 20

    [20]
    _PATH=$SA010ID02./$SA100ID04./$SA110ID04.
    _NAME=Speicher und Durchlauferhitzer
    _SORT=SA010ID05, SA010ID04, SA010ID03, SA810ID03, SA810ID04, SA810ID06, SA810ID10, SA700ID04, 
     SA100ID04, SA110ID04, SA200ID03, SA300ID03, SA400ID03, SA450ID03, SA500ID03, SA550ID03, 
     SA700ID06, SA700ID07, SA700ID08, SA700ID09, SA700ID04
    SA010ID03={"desc":{"deu":"Ausgabedatum (Monat) der Richtlinie","eng":"Issue date (month) ...
    SA010ID04={"desc":{"deu":"Herstellername","eng":"Manufacturer’s name"}}
    SA010ID05={"desc":{"deu":"Revisionsdatum der Datei","eng":"Revision data of the file"}}
    #SA010ID06={"desc":{"deu":"Webadresse des Herstellers","eng":"Manufacturer’s web address"}}
    #SA010ID07={"desc":{"deu":"Kommentarfeld","eng":"Comment"}}
    ...

    You can find the sheet numbers in PARTproject by the index structure.

    Furthermore you will also find the sheet numbers in the VDI or PDT file right at the beginning.

    See following example of a VDI file:

    1. Value: Record type 010

    2. Value: Sheet number 20

    010;20;200602;Company 08/2015;20150810;Company.de;Armaturen aus Rotguss und Edelstahl, 
     Revision by www.....de, Stand 01/2015;;;;;;DEU;DE;
    100;5;5;Durchflusstrinkwassererwärmer;;;20120405;
    110;1;1;Heizwasser;;;20120405;
    200;4;nicht rostender Stahl;
    300;3;wandhängend;
    400;1;Geschlossen/druckfest;
    450;1;monovalent;

  • If "_SORT" includes all variables, the sort sequence will be accordingly displayed in the characteristic attribute table.

    If "_SORT" only includes a selection of variables, they will be displayed at the begin and the rest follows behind.

  • Keys which shall not be visible can be commented out by "#".

  • If only the sort sequence has been changed, you can select the option Skip geometry under Mode.

    VDI Wizard

    VDI Wizard

Example:

[20]
_PATH=$SA010ID02./$SA100ID04./$SA110ID04.
_NAME=Speicher und Durchlauferhitzer
_SORT=SA010ID04,SA010ID03,SA010ID05
SA010ID03={"desc":{"deu":"Ausgabedatum (Monat) der Richtlinie","eng":"Issue date (month) ...
SA010ID04={"desc":{"deu":"Herstellername","eng":"Manufacturer’s name"}}
SA010ID05={"desc":{"deu":"Revisionsdatum der Datei","eng":"Revision data of the file"}}
#SA010ID06={"desc":{"deu":"Webadresse des Herstellers","eng":"Manufacturer’s web address"}}
#SA010ID07={"desc":{"deu":"Kommentarfeld","eng":"Comment"}}

[20]
_PATH=$SA010ID02./$SA100ID04./$SA110ID04.
_NAME=Speicher und Durchlauferhitzer
_SORT=SA010ID05,SA010ID04,SA010ID03
SA010ID03={"desc":{"deu":"Ausgabedatum (Monat) der Richtlinie","eng":"Issue date (month) ...
SA010ID04={"desc":{"deu":"Herstellername","eng":"Manufacturer’s name"}}
SA010ID05={"desc":{"deu":"Revisionsdatum der Datei","eng":"Revision data of the file"}}
#SA010ID06={"desc":{"deu":"Webadresse des Herstellers","eng":"Manufacturer’s web address"}}
#SA010ID07={"desc":{"deu":"Kommentarfeld","eng":"Comment"}}

Details can be found under Section 5.8.2.1.15.33, “VDI 3805 Importer ” in eCATALOGsolutions Manual.