I-Data Integrator can create the output data formats listed below.
-
Delimited (.csv)
-
Alias .xml (a special version of XML)
-
Microsoft Access database tables
-
Fixed Text
-
Microsoft Excel spreadsheets
-
AES/32 .xml
AES/32 is a third-party application that supplies costing data for projects. For additional information, see www.nhd.com.
All output data is created in the same format.
Intrinsic data outputs
Internally, the data from the Isogen files is loaded into a series of recordsets, as shown in the table below.
Isogen Report File |
Section |
I-Data Recordset Name |
Material Control |
Pipeline header data (Titles) |
Pipelines |
Material Control |
Component data (Data) |
Components |
Spool Information File |
Spools |
|
Weld Summary |
Welds |
|
Bending File |
Bend |
Bends |
Cut Pieces |
CutPieces |
|
Holes |
Holes |
|
Repeat File |
Component data |
Components_2 |
Weld data |
Welds_2 |
|
Cut Piece List |
CutListSummary |
|
Centerline Length |
CentreLineLength |
|
Drawing Cross Reference |
Drawings |
You can use SQL statements in the output options configuration file to process these recordsets or output them into the specified output files. To distinguish them further, these recordsets are known as the intrinsic recordsets, which can be created by SQL statements or by linking to external data sources.
External data outputs
External data, such as data contained within linked tables or read from batches of PCFs and IDFs, is never output.