Export a BI Gateway model
- Last UpdatedFeb 12, 2024
- 5 minute read
You can export an existing AVEVA BI Gateway Model to a .json file. The export considers the latest version of objects.
Export a BI Gateway model
-
From the AVEVA BI Gateway Model Builder Home page, click the Export All
icon from the main menu. A confirmation message appears.
-
Click Done to finish exporting the Model. The Exported Model is saved at the default location with a file name Data.json.
Note: You can also export an individual model object using the Export
icon available in the Object editor.
Edit the .JSON file
You can edit the exported file in any notepad editor to modify the AVEVA BI Gateway Model as per the requirement before importing it into a new setup and create a fresh AVEVA BI Gateway Model. However, it is recommended that you should avoid editing the .json file.
Sample exported model file format
{
"Settings": [
{
"SettingUID": 1,
"Name": "Schema.Version",
"Value": "3.5.0",
"DateEntered_UTC": "2020-07-07T12:34:41.6338496"
},
{
"SettingUID": 2,
"Name": "PurgeEventLogRefreshIntervalInMinutes",
"Value": "1440",
"DateEntered_UTC": "2020-07-07T12:34:44.6494679"
},
{
"SettingUID": 3,
"Name": "EventLogRetentionPeriodInDays",
"Value": "7",
"DateEntered_UTC": "2020-07-07T12:34:44.6494679"
},
{
"SettingUID": 4,
"Name": "ErrorEventLogEnabled",
"Value": "1",
"DateEntered_UTC": "2020-07-07T12:34:44.6494679"
},
{
"SettingUID": 5,
"Name": "WarningEventLogEnabled",
"Value": "1",
"DateEntered_UTC": "2020-07-07T12:34:44.6494679"
},
{
"SettingUID": 6,
"Name": "TraceEventLogEnabled",
"Value": "0",
"DateEntered_UTC": "2020-07-07T12:34:44.6651191"
},
{
"SettingUID": 7,
"Name": "InfoEventLogEnabled",
"Value": "1",
"DateEntered_UTC": "2020-07-07T12:34:44.6651191"
},
{
"SettingUID": 8,
"Name": "CustomEventLogEnabled",
"Value": "0",
"DateEntered_UTC": "2020-07-07T12:34:44.6651191"
},
{
"SettingUID": 9,
"Name": "Current Version",
"Value": "2021.4.0",
"DateEntered_UTC": "2021-07-05T09:03:43.0804354"
}
],
"Calculations": [
{
"CalculationUID": 177,
"Id": "a1917775-f65c-4ac9-a2f6-8eceed75e145",
"MeasureDataItemUID": 4,
"MeasureDataItemVersion": 1,
"Name": "Max",
"Function": "Max",
"FunctionFieldMapping_MappingTypeUID": 0,
"FunctionFieldMapping_SourceFieldName": "Value",
"PeriodFieldMapping_MappingTypeUID": 0,
"PeriodFieldMapping_SourceFieldName": "DateTime",
"ModificationPeriodFieldMapping_MappingTypeUID": 0,
"ModificationPeriodFieldMapping_SourceFieldName": "<None>",
"ModificationPeriodInterval": null,
"ModificationPeriodUnit": null,
"ReturnDataTypeUID": 4,
"FilterExpression": null
}
],
"CalculationSourceDataItemMappings": [
{
"CalculationSourceDataItemMappingUID": 177,
"CalculationUID": 177,
"SourceDataItemUID": 178,
"Priority": 0
}
],
"DataItemType": [
{
"DataItemTypeUID": 1,
"Name": "DataSource"
},
{
"DataItemTypeUID": 2,
"Name": "Dimension"
},
{
"DataItemTypeUID": 3,
"Name": "Measure"
}
],
"DataSources": [
{
"DataSourceUID": 8,
"Version": 1,
"DeployStateUID": 0,
"IsDirty": false,
"Id": "9e6f1dab-e543-4382-943f-84279c4e8dde",
"Name": "InsightDatasource",
"NodeName": "localhost",
"Port": 8732,
"ConnectionInfo": "",
"DataSourceType": "Online Insight",
"LastUpdate_UTC": "2021-09-02T12:47:23.075327",
"Description": "Insight BI Gateway DataSource Object",
"SerializedTimeZone": "UTC;0;(UTC) Coordinated Universal Time;Coordinated Universal Time;Coordinated Universal Time;;",
"UseDaylightSavingTime": false
}
],
"DataType": [
{
"DataTypeUID": 0,
"Name": "Boolean"
},
{
"DataTypeUID": 1,
"Name": "Byte"
},
{
"DataTypeUID": 2,
"Name": "DateTime"
},
{
"DataTypeUID": 3,
"Name": "Decimal"
},
{
"DataTypeUID": 4,
"Name": "Double"
},
{
"DataTypeUID": 5,
"Name": "Guid"
},
{
"DataTypeUID": 6,
"Name": "Int16"
},
{
"DataTypeUID": 7,
"Name": "Int32"
},
{
"DataTypeUID": 8,
"Name": "Int64"
},
{
"DataTypeUID": 9,
"Name": "Other"
},
{
"DataTypeUID": 10,
"Name": "String"
}
],
"DeployStates": [
{
"DeployStateUID": 0,
"Name": "NotDeployed"
},
{
"DeployStateUID": 1,
"Name": "Deployed"
}
],
"DimensionAlias": [
{
"DimensionAliasUID": 19,
"Id": "3f787c3a-d057-4ecc-bb6c-73ba85b2336b",
"MeasureDataItemUID": 4,
"MeasureDataItemVersion": 1,
"Alias": "FK_Tags_01",
"DimensionDataItemUID": 17,
"DimensionDataItemVersion": 1,
"ContextLink": false
}
],
"DimensionDataItems": [
{
"DimensionDataItemUID": 17,
"Version": 1,
"DeployStateUID": 0,
"IsDirty": false,
"Id": "aeafaae5-b1ed-4d15-ae59-893a97351ed3",
"Name": "Tags",
"Description": "Insight BI Gateway Dimension Object",
"RefreshRateInterval": 1,
"RefreshRateOffset": 0,
"RefreshRateUnit": "Day",
"TimeDefiningEnabled": false,
"TimeDefiningType": null,
"TimeDefiningStart_DimensionFieldUID": null,
"TimeDefiningEnd_DimensionFieldUID": null,
"TimeDefiningDuration_DimensionFieldUID": null,
"TimeDefiningDuration_Constant": null,
"TimeDefiningDuration_MappingTypeUID": null,
"TimeDefiningDurationUnit": null,
"FilterExpression": "",
"UpdatePeriodEnabled": false,
"UpdatePeriodStartDate": null,
"UpdatePeriodTime_DimensionFieldUID": null,
"UpdatePeriodInterval": null,
"UpdatePeriodUnit": null,
"DeploymentTimestamp_UTC": null,
"LastUpdate_UTC": "2021-09-02T10:20:51.5122759"
}
],
"DimensionDataItemFields": [
{
"DimensionDataItemFieldUID": 122,
"Id": "6beeb6bb-00ee-4688-980a-54a2c72776d2",
"DimensionDataItemUID": 17,
"DimensionDataItemVersion": 1,
"Name": "FQN",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": true
}
],
"DimensionDataItemFieldMappings": [
{
"DimensionDataItemFieldMappingUID": 392,
"DimensionDataItemFieldUID": 122,
"DimensionDataItemMappingUID": 71,
"FieldMappingTypeUID": 0,
"Constant": null,
"DimensionFieldName": "FQN",
"SourceDataItemFieldUID": 1156
}
],
"DimensionDataItemLinks": [],
"DimensionDataItemLinkMappings": [],
"DimensionDataItemMappings": [
{
"DimensionDataItemMappingUID": 71,
"DimensionDataItemUID": 17,
"DimensionDataItemVersion": 1,
"SourceDataItemUID": 179,
"Priority": 1
}
],
"ExpressionCalculations": [],
"MappingType": [
{
"MappingTypeUID": 0,
"Name": "SourceField"
},
{
"MappingTypeUID": 1,
"Name": "Constant"
},
{
"MappingTypeUID": 2,
"Name": "NULL"
},
{
"MappingTypeUID": 3,
"Name": "Skip"
},
{
"MappingTypeUID": 4,
"Name": "DimensionField"
}
],
"MeasureDataItems": [
{
"MeasureDataItemUID": 4,
"Version": 1,
"DeployStateUID": 0,
"IsDirty": false,
"Id": "d0f70b62-f544-4749-9635-37918522962c",
"Name": "Measure1",
"Description": "Insight BI Gateway Measure Object",
"RefreshRateOffset": 0,
"RefreshRateInterval": 1,
"RefreshRateStartDateTime": "2021-01-01T00:00:00",
"UsePeriodValues": true,
"Period": 1,
"PeriodUnit": "Hour",
"RefreshRateUnit": "Day",
"UpdatePeriod": 1,
"UpdatePeriodUnit": "Day",
"ServerFileGroupEnabled": false,
"ServerFileGroupName": null,
"LastUpdate_UTC": "2021-09-02T10:51:42.8978179"
}
],
"Relationships": [
{
"RelationshipUID": 2977,
"CalculationUID": 177,
"DimensionAliasUID": 19,
"RelationshipDimensionReferenceUID": 2113,
"RelationshipSourceMappingUID": 2113,
"MapType": "Key"
}
],
"RelationshipDimensionReferences": [
{
"RelationshipDimensionReferenceUID": 2113,
"DimensionDataItemFieldUID": 122,
"DimensionDataItemLinkUID": null
}
],
"RelationshipSourceMappings": [
{
"RelationshipSourceMappingUID": 2113,
"SourceDataItemFieldUID": 1151,
"SourceDimensionAliasUID": null,
"Constant": null
}
],
"SourceDataItems": [
{
"SourceDataItemUID": 178,
"DataSourceUID": 8,
"DataSourceVersion": 1,
"Id": "db223916-91d8-47c6-9a7d-87534e1bc503",
"Name": "ProcessValue",
"Description": null,
"Namespace": null,
"ObjectName": null,
"IsCustomQuery": true,
"CustomQuery": "{\n \"QueryName\":\"ProcessValues\",\n \"SelectColumn\": [\"*\"],\n \"Tag\": {\n \"Filter\":\"startswith(FQN,'PLP')\",\n \"Select\":\"FQN\"\n },\n \"StartDateTime\":\"[RequestedSartTime]\",\n \"EndDateTime\":\"[RequestedEndTime]\"\n }\n",
"DateEntered": "2021-08-09T06:08:30.6437897",
"DateModified": "2021-09-02T12:48:49.3064322"
},
{
"SourceDataItemUID": 179,
"DataSourceUID": 8,
"DataSourceVersion": 1,
"Id": "b81440e7-1a0c-4abb-aef4-120afe6e0ba5",
"Name": "TagMetadata",
"Description": null,
"Namespace": null,
"ObjectName": null,
"IsCustomQuery": true,
"CustomQuery": "{\n\"QueryName\": \"TagMetaData\",\n\"SelectColumn\": [\"*\"],\n\"DistinctColumn\":[\"BIGateway_PlantID\",\"BIGateway_AssetID\",\"BIGateway_Dimension\",\"BIGateway_MeasureCalculation\",\"FQN\",\"Description\",\"EngUnit\",\"EngUnitMin\",\"EngUnitMax\",\"GeoLocation\"],\n \"Filter\": \"startswith(FQN,'PLP')\"\n}",
"DateEntered": "2021-08-09T06:08:30.6437897",
"DateModified": "2021-08-09T06:08:30.6437897"
}
],
"SourceDataItemFields": [
{
"SourceDataItemFieldUID": 1147,
"SourceDataItemUID": 178,
"Id": "fc0f23f9-d85b-4540-a275-14b5544b276d",
"Name": "Value",
"FieldDataTypeUID": 4,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1148,
"SourceDataItemUID": 178,
"Id": "1e1fb708-19a7-43ff-b5bd-3e3afbc14ebb",
"Name": "Unit",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1149,
"SourceDataItemUID": 178,
"Id": "934725cf-2158-4cda-8394-7ccfdfc63e5a",
"Name": "DateTime",
"FieldDataTypeUID": 2,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1150,
"SourceDataItemUID": 178,
"Id": "0626b750-395b-48c1-be2c-95a11be1090b",
"Name": "Text",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1151,
"SourceDataItemUID": 178,
"Id": "ab4d5f22-3ccd-4b5f-a0b2-c030ed93edc3",
"Name": "FQN",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1152,
"SourceDataItemUID": 178,
"Id": "fa889679-de3d-4171-95eb-d61a2a195085",
"Name": "OpcQuality",
"FieldDataTypeUID": 7,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1153,
"SourceDataItemUID": 179,
"Id": "498f51ab-1907-4c74-beb5-08168169e776",
"Name": "EngUnitMax",
"FieldDataTypeUID": 4,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1154,
"SourceDataItemUID": 179,
"Id": "bb582691-bf02-4880-921d-0d8a885d2747",
"Name": "EngUnit",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1155,
"SourceDataItemUID": 179,
"Id": "d735bfdd-2e90-45dd-9cbc-24e4a4a78711",
"Name": "InterpolationType",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1156,
"SourceDataItemUID": 179,
"Id": "13836cfe-7afe-4505-8a1b-2b4c49ab1508",
"Name": "FQN",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1157,
"SourceDataItemUID": 179,
"Id": "048ecf0f-d277-4f1b-9045-4c89dcb95d01",
"Name": "Description",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1158,
"SourceDataItemUID": 179,
"Id": "70abde39-e8aa-483d-9642-52dfb1c89071",
"Name": "EngUnitMin",
"FieldDataTypeUID": 4,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1159,
"SourceDataItemUID": 179,
"Id": "e2366b41-79a4-4014-85ea-5bede5e1ebfe",
"Name": "MessageOn",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1160,
"SourceDataItemUID": 179,
"Id": "7c852221-4878-40b2-8749-893e93c9754b",
"Name": "TagName",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1161,
"SourceDataItemUID": 179,
"Id": "c2e2528d-1540-474d-b102-9522d5d43b9e",
"Name": "TagType",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1162,
"SourceDataItemUID": 179,
"Id": "845bfff2-f658-497b-960c-b26d5554b30a",
"Name": "Source",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
},
{
"SourceDataItemFieldUID": 1163,
"SourceDataItemUID": 179,
"Id": "ce22184c-5eca-40b9-8b6c-efab70b268a2",
"Name": "MessageOff",
"FieldDataTypeUID": 10,
"Active": true,
"KeyField": false
}
],
"UserDefinedFunctionCalculations": [],
"UserDefinedFunctionParameters": []
}