Title: How to import and export user data to/from Twido PLC
Description:
- This paper describes a workaround that allows exporting and importing user memory data from/to Twido controller using Twidosoft/Twidosuite animation table editor and an external spreadsheet with XML support.
Hardware any Twido controller
Software Twidosoft 3.5 or Twidosuite 1.2
MS Excel (tested with Excel 2003 SP2)
1. Export of data
1.1. In your application create an animation table containing addresses you want to export values from.
1.2. Copy current values to retained
Twidosoft:
Twidosuite:
Figure 1: Copy current values to retained
1.3. Save/export your animation table to disk
Figure 2: Saving *.tat animation table file to disk
1.4. Open the *.tat file in MS Excel as XML list
Figure 3: opening of the animation table file in MS Excel
1.5. The file is displayed in Excel in form of a table, very similar to animation table in Twidosoft/Twidosuite
Figure 4: Data exported from Twido PLC displayed in Excel
2. Import of data
2.1. Go through steps 1.1, 1.3, 1.4 and 1.5.
2.2. Modify values in “RetainedValue” column of the table.
2.3. Save the file as XML data to keep the structure of your file
Figure 5: Saving of modified animation table
2.4. Rename the file from *.xml to *.tat
2.5. Open/import the modified animation table in Twidosoft/Twidosuite
Figure 6: loading/import of animation table
2.6. Use the button to copy retained values to current values
Figure 7: copying retained values to current values
3. Summary
This procedure can be used to get values from/to Twido PLC. Manipulation with a table in spreadsheet is more convenient than manual modification of animation table in Twidosoft/Twidosuite..
Length of animation table is restricted to 64 rows. It’s possible to have multiple animation tables in Twidosuite. Trying to write retained values to objects that are not writable will result in a non-critical error.\
All information provided in this document is correct to the best knowledge of the author. This approach was designed and tested in laboratory conditions. The environment influences behaviour of electronic devices and therefore the user takes full responsibility for applying presented solutions.
Description:
- This paper describes a workaround that allows exporting and importing user memory data from/to Twido controller using Twidosoft/Twidosuite animation table editor and an external spreadsheet with XML support.
Hardware any Twido controller
Software Twidosoft 3.5 or Twidosuite 1.2
MS Excel (tested with Excel 2003 SP2)
1. Export of data
1.1. In your application create an animation table containing addresses you want to export values from.
1.2. Copy current values to retained
Twidosoft:
Figure 1: Copy current values to retained
1.3. Save/export your animation table to disk
Figure 2: Saving *.tat animation table file to disk
1.4. Open the *.tat file in MS Excel as XML list
Figure 3: opening of the animation table file in MS Excel
1.5. The file is displayed in Excel in form of a table, very similar to animation table in Twidosoft/Twidosuite
Figure 4: Data exported from Twido PLC displayed in Excel
2. Import of data
2.1. Go through steps 1.1, 1.3, 1.4 and 1.5.
2.2. Modify values in “RetainedValue” column of the table.
2.3. Save the file as XML data to keep the structure of your file
Figure 5: Saving of modified animation table
2.4. Rename the file from *.xml to *.tat
2.5. Open/import the modified animation table in Twidosoft/Twidosuite
Figure 6: loading/import of animation table
2.6. Use the button to copy retained values to current values
Figure 7: copying retained values to current values
3. Summary
This procedure can be used to get values from/to Twido PLC. Manipulation with a table in spreadsheet is more convenient than manual modification of animation table in Twidosoft/Twidosuite..
Length of animation table is restricted to 64 rows. It’s possible to have multiple animation tables in Twidosuite. Trying to write retained values to objects that are not writable will result in a non-critical error.\
All information provided in this document is correct to the best knowledge of the author. This approach was designed and tested in laboratory conditions. The environment influences behaviour of electronic devices and therefore the user takes full responsibility for applying presented solutions.