Skip to main content

system.mes.material.importMaterialsFromCsv

Description​

Imports Materials from a CSV file provided as a string or as raw bytes. The service layer will parse the CSV content and create or update material entities based on the 'name' and 'location' columns.

Recommended to export at least one pre-existing material to CSV using the Export Materials functionality to ensure the correct format of the CSV file.

Syntax​

system.mes.material.importMaterialsFromCsv(importString)
system.mes.material.importMaterialsFromCsv(importBytes)

Parameters​

Either a string or bytes array representing the CSV content.

ParameterTypeDescription
importStringStringThe CSV content as a string.
importBytesPyArrayThe CSV content as raw bytes.

Returns​

The number of materials successfully imported or updated.

Code Examples​

Here is an example of how to use the importMaterialsFromCsv method in the context of a Perspective File Upload Component onFileReceived event handler. Reference Perspective - File Upload Scripting for more information on the onFileReceived event handler.

Bytes​

def runAction(self, event):
	csvBytes = event.file.getBytes()
	system.mes.material.importMaterialsFromCsv(csvBytes)

String​

def runAction(self, event):
	csvString = event.file.getString()
	system.mes.material.importMaterialsFromCsv(csvString)