Hello, I am using an Emerson/GE PLC connected to Cimplicity SCADA. I am looking to export data from a specific point or object to a CSV file and then import the CSV file back into the same point or object. While I am aware of the export function, I am specifically interested in extracting data for a particular point or object, rather than retrieving all points in the system. Do you have any tips on how to achieve this task effectively and efficiently?
This seems like a job that could be accomplished with a script.
I decided that the best approach would be to use scripting, although I'm uncertain about the exact method to do so.
The scripting language includes a PointGet function for retrieving point values and a PointSet function for assigning values to points. Additionally, there are various file operations for managing files such as opening, reading, and writing. You can schedule script calls in the Event Editor to automate tasks.
Steve Bailey explains the use of scripting functions in Cimplicity for manipulating point values and performing file operations. By utilizing the PointGet and PointSet functions, users can easily retrieve and write values to points. Additionally, various file operations are available for working with files within the script. The timing of script execution can be specified in the Event Editor. Here is an example of a Cimplicity script that retrieves the value of a virtual point, performs a calculation, and sets the result to a PLC register. For more information on scripting in Cimplicity, refer to the Basic Control Engine/Scripting section in the Cimplicity help guide. Code: Sub Main() 'Error Handling On Error GoTo ErrorTrap 'Variables Dim MyStationTotalDownTime As New Point: MyStationTotalDownTime.Id = "MyVirtualStationPoint" Dim TotalDownTime As New Point: TotalDownTime.Id = "MyStopTime" Dim RunBit As New Point: RunBit.Id = "MyRealRunBit" Dim MyStationDownPercent As New Point: MyStationDownPercent.Id = "MyRealStationPoint" 'Retrieving Values PointGetMultiple RunBit, MyStationTotalDownTime, TotalDownTime 'Calculating and Setting Real Point Values If ((TotalDownTime.Value(1) <> 0) And (RunBit.QualityIs_Available = TRUE)) Then MyStationDownPercent.SetValue = ((MyStationTotalDownTime.Value / TotalDownTime.Value(1)) * 10000) End If Exit Sub 'Error Handling ErrorTrap: Resume Next End Sub
I successfully created a script to save data to a CSV file and restore it. Currently, the filename is set in the code. How can I allow users to select the file using a file open dialog? In Visual Basic, you can easily add a fileopendialog element to the form, which allows users to choose the file. However, in Cimplicity, I can't seem to find a similar element. Is there a way to implement this feature in Cimplicity or am I overlooking something?
For a more targeted extraction in your Emerson/GE PLC, instead of exporting all data points, I would recommend creating a script inside Cimplicity SCADA to read the data from the specific point or object you want. You can then export this data directly to a CSV file. Use the same script with small modifications to read the CSV file and write the data back to the target point or object. This method could be more efficient and tailored to your needs compared to a full data dump. Just make sure your data syntax aligns between the imports and exports to prevent any errors.
Hello, your project sounds fascinating! Based on my experience, you may want to look into logical scripting in Cimplicity, which should allow you to extract data from a specific point. Using its syntax, you could write a script to select the values from your desired object and export it to CSV. Afterward, when it's time to import the data back, make use of the import function available in Cimplicity to upload the CSV file into the desired point or object. It may take a bit of time to get the hang of scripting, but it can give you the pinpoint control it sounds like you're looking for.
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: - To export specific data from a particular point or object in Emerson/GE PLC connected to Cimplicity SCADA, you can utilize custom scripts or functions within the SCADA software to extract and save the data to a CSV file.
Answer: - Yes, it is possible to import a CSV file back into the same point or object in Cimplicity SCADA by developing a data import function that can read the CSV file and update the desired point or object accordingly.
Answer: - To ensure that only data for a particular point or object is exported to the CSV file, you can customize the export functionality by specifying the criteria or filters based on the desired point or object's unique identifiers.
Answer: - Utilize the scripting capabilities of Cimplicity SCADA to create tailored export and import functions, optimize the data extraction process by selecting only necessary information, and thoroughly test the import functionality to ensure seamless data transfer between the CSV file and the PLC objects.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.