Product: | Elvis |
Booth: | 2004-11-26 |
Summary
When importing data into the data point list, it is checked whether the Name, Address, and Port columns together form a unique entry. Under certain circumstances, duplicate data points may be inadvertently created when importing data points. If, for example, a central address has already been added to the address of the existing data point, the new data point is created.
Details
Example:
In the data point table there is already the data point “DP1” with the entry 1/1/1;1/2/1;1/3/1 at the address and the connection “EIB”. The CSV file contains “DP1” with the group address 1/1/1 and connection “EIB”. When importing the CSV file, the data point table for the data point “DP1” contains an additional entry.
In order for Elvis to display the “Import Conflict” dialog, which determines what should happen with the same data points during the import, Elvis must first determine that the data to be imported already exists in the table. For this purpose, Elvis checks the columns name, address and connection in the case of the data point table. Only if the entries of these three columns are identical, Elvis detects a possible import conflict and asks the user how to proceed with it (overwrite, ignore, create new). Now, if more addresses separated by a simicolon are added manually to the Address column, the Address column will be different. Elvis does not recognize that this is an already existing data point and simply creates another data point with the same name and the same connection, but with a different address, without asking. There is a small macro Doppelte_Datenpunkte_entfernen.idm (Download Macro (2 KB)) that deletes the duplicate data points with the single address. Please be sure to back up the project database before running the macro. The macro searches for data points with the same names and removes all multiple data points that do not have a semicolon in the address.
Please note:
When you check your project (Tools/Run/General/Check Project), you will be notified of duplicate data point names.