5.8.2.1.16.28. VDI 3805 Wizard
5.8.2.1.16.28.1. Scope of application

With the VDI 3805 Wizard, manufacturers from the TGA sector can[26] (building services for heating systems, pipes, pumps, etc.) can import their VDI catalog with eCATALOGsolutions and create a PARTsolutions catalog, which is then made available on PARTcommunity portals. The download formats currently offered are the neutral formats STEP/IGES (3D) and DWG/DXF (2D).

Process chart

Process chart

Geometry and meta data specific to certain sheets are imported.

Currently only the import of static data is supported.

Data can be updated constantly.

VDI 3805 controls product data exchange in the TGA by different data sheets. Each sheet defines a specific product range with details on all attributes and detailed product descriptions.

PARTsolutions supports a large number of sheets. Details are available on request. 5

The following figure shows the current editing status[27] of data sheets.

VDI 3805 data sheets

VDI 3805 data sheets

5.8.2.1.16.28.2.  VDI Wizard

The following describes how you can easily create your VDI catalog using the VDI Wizard.

  1. Open the wizard in PARTproject in the project selection [Project selection] via the context menu under Automation -> VDI 3805 Wizard.

    PARTproject index tree with context menu command "VDI 3805 Wizard"

    PARTproject index tree with context menu command "VDI 3805 Wizard"

    -> The Wizard is opened.

  2. Perform the settings:

    VDI Wizard -> Settings

    VDI Wizard -> Settings

    • VDI file [VDI File]: Use Browse ... to specify the directory in which the VDI files to be imported are located.

    • PDT file [28]by specifying a PDT file, you can subsequently enrich the classification. To do this, select the Enrich classification [Enrich classification] option under Mode.

      Enrich classification

      Enrich classification

      The classification data is displayed in PARTdataManager under part information [Part information].

    [Note]Note

    Either the VDI or the PDT file is used. If both is specified, the VDI file will win.

    Translations:

    Individual attributes in the PDT file can be provided with translations.

    Example:

    If you have "Pressure reducer" in the attribute SA100ID04 and want to translate this term, the entry in the Excel file (PDT file) looks like this:

    #deu#Druckminderer#fra#Réducteur de pression#ita#Riduttori di pressione

    The country code has to be according to ISO 3166 ALPHA-3 and the values have to be stated in one line.

    The translation of individual attributes in the PDT file should only be used if a translation via the configuration file does not make sense. The configuration file (CADENAS_USER/vdi/vdi3805import.cfg) is written the first time the VDI Wizard is run.

    • Media directory (optional): If preview images (png format) are not provided, they are generated automatically (as with Quick & Simple or PLMsynchro).

    • Level of detail: Determine the level of detail (Low quality [Low Quality] | High quality [High Quality] | Both | None ).

      This affects the quality and structure of the geometry to be imported. Both are set by default. Depending on how complex the data is, more data can be imported with Low quality [Low Quality] than with High quality [High Quality] (tolerances, accuracies, compatibility).

    • Mode: Determine the import mode:

      • Standard [Default]: Catalog creation by importing a VDI or PDT file (one of the two must be specified).

        (Currently the creation of geometry is only possible via VDI file.)

      • Skip geometry: The same process as under "Standard", but when importing into existing catalogs, correct 3dbs cannot be overwritten under any circumstances (and no dummy.3db files are created and attached in the event of an error). The process also runs faster.

      • Enrich classification: With this option, values from an existing catalog can be written from a PDT file to the classification (which are then also displayed again in the part information [Part information] ).

      [Note]Note

      As of V11 SP11 no descriptive product names are used anymore for identification purposes when reading data, but unique attributes like "SA700ID04". This is advantageous, because it avoids special characters and the name in the pipeline is always the same.

      Don't perform data enrichment with the new attribute names for already existing catalogs, because then columns would exist two times (old + new name).

    • Process settings [Processing settings] -> Conversion strategy:

      • Standard [Default]: An attempt is made to create a standard 3db file. If this fails, an attempt is made to write an STP file as a fallback (corresponds to Quick and Simple).

      • Q&S: The Quick and Simple method is used from the outset.

      • Feature-based: It only attempts to create a standard 3db file. This is intended as a premium path. It may not be possible to create some geometries, but the rest will be of the highest quality (3db). If you only want to create content quickly and easily, select Standard [Default] ).

    • Catalog name: The catalog name is automatically set to the catalog from which the wizard was started, but it can also be changed (.. .), which then creates a new catalog or imports it into another catalog. If you start the wizard via the root node, the field is empty.

    • Catalog author:

    • Catalog license: As with every catalog import, a license (if required) must be entered here:

      Example:

      CNS2009*CATALOGS*KATALOGNAME

    • Catalog language [Catalog Language]: For VDI it should almost always be German. Other languages must be added via PARTProject.

  3. Finally, click on Finish.

    -> The import and the catalog creation are started. Depending on size of source file and chosen settings (preview images, LOD) this may last some minutes or hours.

    -> Classes and characteristics were entered under Classification (VDI 3805) or Characteristics (VDI 3805).

    Class variables " dialog box with classes and features

    Class variables " dialog box with classes and features

  4. Open the VDI catalog in the PARTdataManager in the parts selection [Part selection].

    Part selection: Imported example part

    Part selection: Imported example part

  5. Open a project in the PARTdataManager in the parts view [Part view].

    All existing features were created and filled in the VDI 3805 classification, 3D view and line preview images were created automatically. If preview images were stored in the media directory [Media directory], these are used.

    Part view: Imported example part

    Part view: Imported example part

5.8.2.1.16.28.3. Expert settings

Process files are initially created during the first run of the wizard under $CADENAS_USER/vdi are created.

Settings files under $CADENAS_USER/vdi

Settings files under $CADENAS_USER/vdi

  • <Date>_<Catalog name>.csv: CSV showing import state. Here, you can quickly detect, which files have been successfully supported and for which the import failed.

  • vdi3805import.cfg

    Structure: The configuration file is divided into blocks with the corresponding sheet number as the designation. For example, the information in block 20 is relevant for sheet 20.[29]

    The sheet numbers are reflected in PARTproject and in PARTdataManager in the index structure.

    PARTproject

    PARTproject

    PARTdataManager

    PARTdataManager

    The names of the folder structure in PARTdataManager are given according to the information in the "_NAME" key or stored translations.

    Each block contains the following keys:

    • _PATH: The path to be imported.

      By default, the sheet number is given first, followed by a higher-level product description and then a description of the individual product.

      (Theoretically, most diverse attributes can be used in order to individually assemble an path with any depth.)

    • _NAME: The translation of the path. You can specify as many parts as are available under Path.

      Example:

      _PATH= $SA010ID02. /       $SA100ID04. / $SA110ID04.
      _NAME= Heizungsarmaturen / Ordner1/      Unterordner1

      In this example, the folder is internally named according to the value under $SA100ID04., but the user would see "Folder1".

      Normally only the translation for the sheet number is stated, so that the folder would not be named with "2" according to the sheet number, but with "Heating fittings".

      Sheet catalogs built in this way will be compatibly synchronized during a new import/update. Other sub-structures may not be created manually in order for updates to be working.

    • _SORT: Sorting the variables

      You can explicitly determine the variables' sort sequence as is should then be displayed in the characteristic attribute table.

      Note the following:

      • 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.

      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"}}

    • In each block there is a listing of the single variables (attributes). Attributes, which should not be visible can be commented out by "#".

    1. Make respective adjustments in desired keys.

    2. Run the import via wizard again.

      [Tip]Tip

      If you are only making changes that do not affect the geometry, you can also select the Skip geometry option under Mode.

      VDI Wizard

      VDI Wizard

  • vdi3805wizard.csv:

    Here, optionally translations can be saved.

    text;deu;eng

  • vdi3805wizard.pwp

    The .pwp file is an XML file with all pipeline settings. You can open it with PARTdataCenter or the pipe editor.

    By selecting individual nodes, you have access to a wide range of settings in the node editor. After making changes, save the file and run the wizard again.

    Settings in the node PARTsolutionsExporter:

    • Order number: Manufacturer order number is entered by default.

    • NB (standard description): Default value is "$HERSTELLER_BESTELLNUMMER. ($LOD.)".

      This value can be adjusted. If a part has an LOD (yellow field), the LOD must be entered in the NB.

    • LINA (parts list designation): Default value is "$HERSTELLER_BESTELLNUMMER."

    • Other attributes such as NT and NN can be set optionally.

5.8.2.1.16.28.4. Precondition for operation



[26] Technical building equipment

[27] https://www.vdi.de/fileadmin/vdi_de/redakteur_dateien/gbg_dateien/VDI_3805_Bearbeitungsstand-05-21-2015.pdf

[28] A Product Data Template (PDT) is a machine-readable template that is used to structure information in the form of characteristics for any type of building object and make it interchangeable.

[29] The sheet numbers can also be found at the very beginning of the VDI or PDT file.

See the 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;