OpenBridge Modeler

Exchange List in dBASE-Format

As an option to the processing possibilities of this function, the exchange lists can also be created and processed with the help of any other programs being able to read and write dBASE files. This method is recommended in case of more important modifications because programs such as Microsoft Office Excel® have been optimized with regard to working with lists.

First, you can create a new list in this function to obtain the internal names. Then, you save these names as dBASE file which is processed with the help of the foreign program and re-import the file into ProSteel afterwards to save the list in the internal *.exm format. Please note that this list has to be available as *.exm file for use with ProSteel.

Data Fields of dBASE File

The dBASE-file has to contain the following fields, which in general are chains of signs. The fields 0-5 are absolutely necessary, the fields 6,7 etc. can be used as an option.

Since the dBASE-file only has a sequential structure of data records, whereas the exchange lists are organized in a tree structure, this tree structure has to be simulated by means of group-lines. Group lines only contain the fields 0-2, shape or material lines contain only the fields 0 and 3,4,...

Field Field Name Content
0 TYPE line type, (F) group line (S) shape entry (M) material entry
1 FAMILY

shape type when shape group or "Material" when material group

2 FILE

ProSteel shape file (when material group: no entry necessary)

3 METRIC Internal ProSteel designation metric
4 IMPERIAL

Internal ProSteel designation imperial (for material like field 3)

5 EXCHANGE exchange designation (1st list entry, is also export name)
6 IMPORT1 if need be, further exchange designation (2nd list entry)
7 … n IMPORT2 … N if need be, further exchange designations (next list entries)
(shape file) The dBASE-file with the shape data of the data directory of ProSteel. Here specified without path with name and extension.
(shape type)

Type designation (e.g. DIN_HEA); the different sizes are the shape entries up to the next group line.