You can manage the database externally using Microsoft Excel.
Editing the Database with Excel
(1) Copying from the database to Excel
a) Select the tag or tags 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 correct device address format.
(2) 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 | String Length |
| |
J |
|
|
|
| Unused |
K |
|
|
|
| Unused |
L |
|
|
|
| Unused |
M |
|
| Scale Mode |
| 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 |