powered by CADENAS

Manual

Manual

5.8.2.1.15.22. VDI 3805 Importer
5.8.2.1.15.22.1. Scope of application

With the help of VDI 3805 importer, manufactures from the TGA field [35] (building services for heatings, pipes, pumps, etc.) can import their VDI catalog and create a PARTsolutions catalog, which then can be provided on PARTcommunity portals. Provided download formats currently 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 range of sheets. Details on this are available on request.

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

VDI 3805 data sheets

VDI 3805 data sheets

5.8.2.1.15.22.2.  VDI Wizard

In the following you can find a description on how to simply create your own VDI catalog with the help of the VDI Wizard.

  1. Open the Wizard in PARTproject, in the Project selection via 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: Determine the directory of the VDI files to be imported via search button ....

    • PDT file [37]: When specifying a PDT file you can enrich the classification subsequently. For this, under Mode, select the option Enrich classification.

      Enrich classification

      Enrich classification

      Classification data is shown in PARTdataManager under Part information.

    [Note] Note

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

    Translations:

    Single attributes in the PDT file can also be translated.

    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:

    #gbr#Pressure reducer#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.

    Translating of single attributes in the PDT file should only be used if translating via configuration file doesn't make sense. The configuration file (CADENAS_USER/vdi/vdi3805import.cfg) is written in the first run of the VDI Wizard.

    • Media directory (optionally): If no preview images (png format) are provided, they will be automatically generated (as with Quick & Simple or PLMsynchro as well).

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

      This concerns quality and structure of geometry to be imported. Default is Both. Depending on how complex data are, with Low Quality more data can be imported as with High Quality (tolerances, accuracy, compatibility).

    • Mode: Determine the import mode:

      • Default: Catalog creation by importing a VDI or PDT file (one of the two has to be specified).

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

      • Skip geometry: Same procedure as under "Default", but when importing into already existing catalogs, in no case correct 3db files can be overwritten (and in error case no dummy.3db files will be created and attached). Furthermore the process is faster.

      • Enrich classification: With this option, values of a PDT file can be written into the classification of an already existing catalog, (which then are also shown in the 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).

    • Processing settings –> Conversion strategy:

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

      • Q&S: From the start the Quick and Simple method is used.

      • Feature-based: There is only an attempt to create standard 3db files. This is meant as premium method. Possibly same geometries cannot be created, the rest however, is of the highest quality (3db). If the scope is on just producing content, select Default).

    • Catalog name: Catalog name is automatically set on that catalog where the Wizard had been started from, however, it can be changed (...), whereby a new catalog is created or the import goes into another catalog. If the Wizard started on the root node the field remains empty.

    • Catalog author:

    • Catalog license: As usual when importing a catalog a license has to be inserted, if required:

      Example:

      CNS2009*CATALOGS*CATALOGNAME

    • Catalog Language: For VDI in most cases this will be German. Other languages have to 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 features have been inserted under Classification (VDI 3805) or Attributes (VDI 3805).

    Dialog box "Class variables" with classes and features

    Dialog box "Class variables" with classes and features

  4. Open the VDI catalog in PARTdataManager, in the Part selection.

    Part selection: Imported sample parts

    Part selection: Imported sample parts

  5. Open a project in PARTdataManager, in the Part view.

    All existing attributes have been applied and filled in the Classification VDI 3805, 3D view and line preview images have been automatically created. If preview images had been stored in the Media directory these are used.

    Part view: Imported sample part

    Part view: Imported sample part

5.8.2.1.15.22.3. Expert settings

Process files are initially created during first start of the Wizard under $CADENAS_USER/vdi.

Setting files under $CADENAS_USER/vdi

Setting 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 subdivided in blocks showing the corresponding sheet number as name. For example, block 20 is relevant for sheet 20.[38]

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

    PARTproject

    PARTproject

    PARTdataManager

    PARTdataManager

    The names of the folder structure in PARTdataManager correspond to the statements in the key "_NAME" or other translations.

    Each block contains the following keys:

    • _PATH: Import path

      Standard at first position is the statement of sheet number, then superordinate product description, then description of a single product.

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

    • _NAME: Translation of path. As many parts can be stated as available under path.

      Example:

      _PATH= $SA010ID02. /       $SA100ID04. / $SA110ID04.
      _NAME= Heating fittings  / Folder1/      Subfolder1

      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: Sort sequence of 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 only make changes which do not affect geometries, you can select Skip geometry under Mode.

      VDI Wizard

      VDI Wizard

  • vdi3805wizard.csv:

    Here, optionally translations can be saved.

    text;deu;eng

  • vdi3805wizard.pwp

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

    By selecting individual nodes in the Node Editor, you can access multiple settings. After changes save the file and execute the Wizard again.

    Settings in the node PARTsolutions Exporter:

    • Order number: By default, the supplier order number is entered.

    • NB (Standard name): Default value is "$HERSTELLER_BESTELLNUMMER. ($LOD.)".

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

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

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

5.8.2.1.15.22.4. Precondition for operation
  • Standard eCATALOGsolutions/PARTproject system requirements. See Chapter 2, System requirements in Installation Manual.

  • License: ECAT/DEV_IMPORT_VDI3805_CATALOG



[35] Technical building services

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

[37] A Product Data Template (PDT) is a machine-readable template, which serves to structure information in the form of attributes for any kind of objects in the building sector and make it exchangeable.

[38] The sheet numbers can also be found 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;