I-Data Integrator - Intergraph I-Data Integrator - Help - Hexagon PPM

SmartPlant Isometrics I-Data Integrator Help

Language
English
Product
Intergraph I-Data Integrator
Search by Category
Help
I-Data Integrator Version
7.1(2014R1)

SmartPlant Isometrics I-Data Integrator reads many of the report files that are produced by software that supports Isogen, such as SmartPlant Isometrics and SmartPlant Spoolgen, and consolidates all the data for transfer to a downstream system. I-Data Integrator can access data in external spreadsheets or databases to supplement what is created by Isogen, and script files can be executed to provide sophisticated data manipulation functions. In its simplest mode, I-Data Integrator can transfer these report files to a database.

When multiple datasets exist in the Isogen data, which can happen if the same pipeline is repeatedly run through Isogen, I-Data Integrator only processes the most recent dataset found in the file. I-Data Integrator works with a project and style created by I-Configure, a SmartPlant Spoolgen .opt file, or a PDS .def (PD_ISOGEN Definition) file.

For example, when a batch of data is processed through Isogen, the Material Control file can have the structure shown below:

However, the exact format is user-defined.

reference = pipeline1

 

 

pipespec = spec1

 

 

pipeline

item_code

part_no

quantity

description

pipeline1

ic1

1

2

flange

pipeline1

ic2

2

10

bolt

pipeline1

ic3

3

4.5M

pipe

reference = pipeline2

 

 

pipespec = spec2

 

 

pipeline

item_code

part_no

quantity

description

pipeline2

ic1

1

4

flange

pipeline2

ic2

2

25

bolt

pipeline2

ic3

3

3.5M

pipe

pipeline2

ic4

4

2

gasket

pipeline2

ic5

5

1

valve

pipeline2

 

 

I-Data Integrator then produces two output datasets from this data, either as tables in a Microsoft Access database or as text files. The first output dataset contains pipeline level data:

reference

pipespec

pipeline1

spec1

pipeline2

spec2

The second output dataset contains component data:

pipeline

item_code

part_no

quantity

description

pipeline1

ic1

1

2

flange

pipeline1

ic2

2

10

bolt

pipeline1

ic3

3

4.5

pipe

pipeline2

ic1

1

4

flange

pipeline2

ic2

2

25

bolt

pipeline2

ic3

3

3.5

pipe

pipeline2

ic4

4

2

gasket

pipeline2

ic5

5

1

valve

Data is output in one of the following formats: an Access database (.mdb), a Microsoft Excel spreadsheet (.xls), Delimited or Fixed text file, or as an XML file.

  • You can configure the delimited format as a comma delimited (.csv) for compatibility with spreadsheets and databases, or as a tab delimited file, such as the PDS .b file.

  • Fixed format files have fixed starting columns and can be used to replicate legacy output files from a number of systems.

  • Two types of XML data are supported. The first type is suitable for loading into the AES/32 application (see ). The second type is an Alias-developed format.

I-Data Integrator files contain whatever data is in the Isogen Material Control, Welding, Spool Information, Bending, Centerline, Repeat, or Cut List report files. This is the data that is reflected in the I-Data Integrator output files. Furthermore, you can use information from external sources such as databases, spreadsheets and other text files to supplement the standard ASCII Isogen output report file data in order to provide one complete set of data in the format that you require.

I-Data Integrator does not automatically accumulate material. This is done by adding queries to the configuration file or by using the reporting tools in other software products, such as Microsoft Access.

  • I-Data Integrator includes a template database. This database includes a number of predefined reports that you can use to accumulate material over a project, area, or pipeline basis. However, these reports should serve only as a guide for helping you to develop your own.

  • Although I-Data Integrator is not a material control system, the software can provide information about the material used in a set of isometrics.

Key Features

I-Data Integrator has the following key features:

  • By default, the software strips out all but the most recent dataset for each pipeline encountered.

  • Interactive, command line, or Automation execution. For more information, see Process Pipeline Files.

  • Mandatory, user-configurable XML options file. The file consists of the two sections. The first section contains user settings, including those displayed in the interface, and a few additional settings, such as controlling the log file. The second section describes the output options. For more information, see Appendix: XML Configuration File Syntax.

  • Data from Isogen can be integrated with external data, including Microsoft Access databases, Excel spreadsheets, or any ODBC compliant data source, such as an Oracle or SQL Server database. A further option for external data is to extract a set of data from PCF, IDF or POD files.

  • You can generate new datasets from the Isogen data and the new external data sources using SQL statements to manipulate them. For more information, see <GENERATED-DATA> .

  • Isogen or generated data can be further processed using scripts.

  • Output datasets can be re-named or suppressed. For more information, see <OUTPUT-CONTROLS> .

  • When using Excel output formats, you can specify the spreadsheet to write to and in which sheet and cell to start writing the output.

  • When using delimited output formats, you can specify the delimiter character, an optional quote ( " ) character, and the file extension. For example, it is possible to output data in Intergraph PDS Tab delimited format, such as the .b file. For more information, see <OUTPUT-FORMATS> .

  • You can specify the template database used by the Microsoft Access output format so that predefined reports are automatically available in the output database.

  • I-Data Integrator reads the Isogen Bending file and can create datasets for cut pieces, pipe (pulled) bends, and holes. For more information, see Bending file .

  • I-Data Integrator reads the Isogen CenterlineLength Summary and user-defined cut list report files. For more information, see Centerline Length file.

  • I-Data Integrator reads the Repeatability Return file if it is specified in the .fls or .opt file. For more information, see Repeatability Return file .

  • Recordsets can be split using a nominated field, for example, to split a component's recordset by pipeline into separate output files or tables. For more information, see <OUTPUT-CONTROLS> .

  • Recordsets can be merged into Master/Detail outputs (delimited format only), where a record in the Master recordset is followed by all records in the Detail recordset that meet a user-specified criterion. For more information, see OUTPUT-FORMATS><OUTPUT-FORMATS> .

  • Generated recordsets are stored as queries in the temporary database.

  • I-Data Integrator stores/restores all your choices to the Main window each time it opens up, as defined by the settings in the XML options file. For more information, see The I-Data Integrator Interface.