Query related to Thingworx Apps - Core Configurations V4.1.0

Question

Hi,

I have successfully installed Thingworx AMU Application in my local system for exploration. After installing AMU, I'm trying to do the thingworx app core configuration by the given link Core Functions - Process the JSON File.

In this process, I have filled all required sheets & mandatory columns in the spreadsheet with the demo values as per the instructions. After that successfully generated the JSON file with the help of the README file. But when executing that SQL query in database of thingworxapps with generated JSON string, I'm getting some error message - Error, Parent Equipment Type Hierarchy is not respected.

Can anyone please help me to out for continuing further exploration.

FYR, I'm here sharing the below documents,

Demo value filled Spreadsheet.XSLX
Generted JSON Source File

Thanks in advance.

Constantine · Accepted Answer

Hello Arun,

If I understand the instructions correctly,

Equipment must also have a Parent Equipment, except for Equipment that are part of Equipment Type Level 1. The Parent Equipment must be exactly one level higher in the hierarchy (cannot skip hierarchy levels).

then the parent equipment for machines 1 and 2 should be empty, i.e. this JSON:

"equipments":[
	{
	 "name": "TWApps_Machine1",
	 "displayName": "Machine1",
	 "enabled": true,
	 "equipmentTypeName": "TWApps_Electrical equipment",
	 "parentEquipmentName": ""	},
	{
	 "name": "TWApps_Machine2",
	 "displayName": "Machine2",
	 "enabled": true,
	 "equipmentTypeName": "TWApps_Electrical equipment",
	 "parentEquipmentName": ""	},
	{
	 "name": "TWApps_Machine3",
	 "displayName": "Machine3",
	 "enabled": true,
	 "equipmentTypeName": "TWApps_Diving equipment",
	 "parentEquipmentName": "TWApps_Machine2"	}
]

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded