User Manual

4.2 CSV file
General When migrating ADP data, csv files are created that are then provided for import in the
InfoCenter database. The csv file does not exceed 50 MB. The csv files are saved to
the folder set in the preferences.
CSV and MD5 file
The csv files can be moved to any folder
together with the associated MD5 checksum
files. The checksum information for the MD5 file checksum test continues to be
available.
# Export program: 'ADP2IC',Version = 'Version 1.0'
Example for csv header
# Export Type: 'ADP to InfoCenter migration'
# User: 'YATES\Desigo' at: '17.06.2005 13:25:12'
# Export File Definition = ''
# Export Description = ''
# Connected to ADP = 'DB=adp Version=2.3001 Rel=9709'
#
@DECIMAL_SYMBOL=<.>
@THOUSANDS_SEPARATOR=<,>
#
Monitoring:M:$d111'000.AI;"M'6G1'L601'MS565'IT10 ZL-Temperature Room
6.111";0;"°C";
#................: Oldest entry: 19.04.2000 17:00:00
#................: Newest entry: 15.07.2001 16:30:00
#................: Number of entries: 21696
#
Monitoring:M:$d111'001.AI;"M'6G1'L601'MS565'IF10 ZL-Humidity Room
6.111";0;"%rF";
#................: Oldest entry: 19.04.2000 17:00:00
#................: Newest entry: 15.07.2001 16:30:00
#................: Number of entries: 21696
#
Monitoring:M:$d113'010.AI;"M'4G3'L405'EL202'IT10 ZL-Temperature Room 4.134-
4.138";0;"°C";
#................: Oldest entry: 19.04.2000 17:00:00
#................: Newest entry: 15.07.2001 16:30:00
#................: Number of entries: 21696
#
Monitoring:M:$d105'032.AI;"M'2G2'L302'HR001'IT02 Temperature
HochregallagerEbene10/Gasse3/Platz168";0;"°C";
#................: Oldest entry:
#................: Newest entry:
#................: Number of entries: 0
#
Monitoring:M:$d105'041.AI;"M'2G2'L302'HR001'IF05 Humidity
HochregallagerEbene5/Gasse2/Platz91";0;"%rF";
#................: Oldest entry:
#................: Newest entry:
#................: Number of entries: 0
#
<>;;;;
#
42/47 For internal use only
Building Technologies Migrating ADP to InfoCenter CM110773en
Building Automation Files 07.10.2006