Creating Object Relationships Using Federation IDs
If the "source" property contains a federation GUID instead of a user label, then the source of the relationship is loaded by the aid of the federation GUID instead of user label and EC class name.
Data
Tag | Class | UserLabel | LongDescription | FederationGuid |
---|---|---|---|---|
FQIT-11-01 | MiscEquipment | ACPPEQUIPMENT | NULL | 584b2150-8c78-4835-aaec-f211c2419ad6 |
11IA08 | Valve | ACPPPIPEINLINEASSET | Ball Valve, Long Pattern,800 LB, FPT, ASME B16.10 | f792f98a-204c-4897-ab71-5c88d09f3db1 |
T-1130 | Tank | ACPPEQUIPMENT | NULL | 9d0bb946-efab-4014-be15-a2aeba986c36 |
Configuration
{ "id": 5, "name": "mapping 5", "importType": "smartExcel", "classKey": "Class", "eCQuery": "Select acad.tag, acad.class, comp.userlabel, acad.longDescription, comp.federationGuid FROM nwddynamic.Autocad acad JOIN nwddynamic.nwdcomponent comp ON acad.element.id = comp.EcInstanceId WHERE Not acad.Tag is NULL AND Not acad.Tag LIKE '%?%'", "relationshipsColMap": [{ "source": "FederationGUID", "relationship": "StagingAreaPhysicalElementFulfillsFunction", "target": "EcClassId" } "data": [ { "sourceClass": "Valve", "targetClass": "CONTROL_VALVE", "mapping": [ { "source": "Tag", "target": "UserLabel" }, { "source": "LongDescription", "target": "DESCRIPTION" } ] } ],