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 program, which supplies costing data for projects. For additional information, see .
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.