Parse Error in Script Transform After List of Dictionaries Manipulation

Ignition
1

I have data from a Query Binding being sent as JSON to a script transform. I can run the following in the Script Console successfully.

value = [{"rowindex":0,"projectid":"U8","description":"32 project","plmt":"controller"},
		{"rowindex":1,"projectid":"U9","description":"b project","plmt":"controller"},
		{"rowindex":2,"projectid":"U10","description":"m project","plmt":"controller"}]

rowIndexColumn_ASLIST=[row["rowindex"] for row in value]

projectList=[]

for x in rowIndexColumn_ASLIST:
	projectItem={
		"target":"/"+value[x]["projectid"]+"/0",
		"label":{
			"text":value[x]["description"]
		}, 
		"visible": True, 
		"enabled": True, 
		"showHeader":True
	}
	projectList.append(projectItem)
	projectItem={}

print (projectList)

The result I get is this, which is exactly what I want:

[{'visible': True, 'showHeader': True, 'label': {'text': '32 project'}, 'enabled': True, 'target': '/U8/0'}, 
{'visible': True, 'showHeader': True, 'label': {'text': 'b project'}, 'enabled': True, 'target': '/U9/0'}, 
{'visible': True, 'showHeader': True, 'label': {'text': 'm project'}, 'enabled': True, 'target': '/U10/0'}]

It seemed to be working so I copied the script over to the Binding window, and adjusted a couple lines so I’m pulling in the query’s value instead of defining it and returning ProjectList instead of printing it. In the end, I get the Error_Configuration: Parse Error in Script Transform.

The error seems similar to the one in this post but my script doesn’t modify the value passed in.

2

ParseError means exactly that: There’s a problem parsing your code.

Post the exact, actual code you have in the script transform here.

3 
rowIndexColumn_ASLIST=[row["rowindex"] for row in value]
	
projectList=[]

for x in rowIndexColumn_ASLIST:
	projectItem={
		"target":"/"+value[x]["projectid"]+"/0",
		"label":{
			"text":value[x]["description"]
		}, 
		"visible": True, 
		"enabled": True, 
		"showHeader":True
	}
	projectList.append(projectItem)
	projectItem={}

return projectList
4

Hm, nothing obviously wrong with your script. If you hover over the ‘ParseExpression’ error, is any more information displayed in the tooltip?

5

I’m using version 8.1.15 and I mocked up a Named Query and used your transform code and it seems to be working fine. Check your spacing or indentation maybe?

If you don’t indent properly you might see a Parse Error in the Error_Configuration message.

1 Like
6

That was it. I wasn’t indented under the def function. Thank you!

2 Likes
7

It's important to note that the dataset passed to the script is an Ignition dataset, which is immutable and presented as an enumerator. To manipulate the data, you need to convert it to a PyDataset using the system.dataset.toPyDataSet(value) function. This conversion allows you to work with the data in a more flexible format, enabling you to perform any desired manipulations. I know this was not your issue, but this was the issue for me.

8

A PyDataset is a thin wrapper around a general Dataset, and is therefore also immutable. But it presents a dataset in jython as a python-like list of lists, which is quite handy when constructing a new dataset with modified content.