You can manage the database externally using Microsoft Excel.
Copying from the database to Excel
a) Select the tag to be copied to Excel. You can select multiple tags using [Shift + Left-click] or [Ctrl + Left-click]. When you select a group tag, the subordinate tags are also selected.
...
b) Copy (Ctrl + C) the selected tags to the clipboard.
c) Paste (Ctrl + V) the contents directly into Excel. Each column stores a different tag attribute. Please refer to the table in the next section for details.
...
d) Edit the database in Excel. You can automatically create consecutive tags with Excel’s increment/decrement feature. Note: Excel’s auto-increment feature does not work for hexadecimal values. Please double-check that bit addresses for real tags follow the device address format.
...
Pasting from Excel to the database
a) Select the rows to copy.
...
b) Copy (Ctrl + C) the rows to the clipboard and paste (Ctrl + V) them to the XpanelDesigner Database manager. Tags with the same name will be replaced by the pasted contents.
...
Excel Column Tag Attributes (based on tag type)
Column | Group Tag | Digital Tag | Analog Tag | String Tag | Note |
A | Tag Name | Tag Name | Tag Name | Tag Name |
|
B | Tag Type (0) | Tag Type (1) | Tag Type (2) | Tag Type (3) |
|
C | Description | Description | Description | Description |
|
D |
| Real/Virtual Tag | Real/Virtual Tag | Real/Virtual Tag | Real Tag = 1 |
E |
| I/O Device | I/O Device | I/O Device | Stored as a string |
F |
| I/O Address | I/O Address | I/O Address | Stored as a string |
G |
| Initial Value | Initial Value | Initial Value |
|
H |
|
|
| Unused | |
I |
| Data Type 0 : INT8 1 : INT16 2 : INT32 3 : UINT8 4 : UINT16 4 : UINT32 4 : BCD8 7 : BCD16 8 : BCD32 9 : UBCD8 10 : UBCD16 11 : UBCD32 12 : Float | String Length |
| |
J |
|
|
|
| Unused |
K |
|
|
|
| Unused |
L |
|
|
|
| Unused |
M |
|
| Scale |
| Scale/Offset=1 Min./Max. = 0 |
N |
|
| Eng. Data Min. Value |
|
|
O |
|
| Eng. Data Max. Value |
|
|
P |
|
| Raw data Min. Value |
| SCALE value if SCALE/OFFSET is applied |
Q |
| Raw data Max. Value | OFFSET value if SCALE/OFFSET is applied |