User Manual

3.6.1 Workflow – Import an ADP archive
1.) Delete table archiv.val (ADP version > V1.8 delete table archiv.archivvalue)
Make sure that the table archiv.val
/ archiv.archivvalue does not exist. To do this,
use the SQL script with SQL Plus below.
drop table archiv.val;
Commit;
ADP version > V1.8:
drop table archiv.archivvalue;
Commit;
2.) Read the individual archive files.
The command line is in the entry prompt. Adjust the archive name. Migrate each
archive file individually.
imp73 archiv/rachiv@orcl file=e:\landis\archiv\00072016.pav full=y
commit=y ignore=y log=f:\archivimp.log
imp73 archiv/rachiv@orcl file=e:\landis\archiv\01061516.pav full=y
commit=y ignore=y log=f:\archivimp.log
3.) Migrate archive.
Start to migrate the archive using the ADP2IC tool.
4.) Archive report.
For the archive report, execute SQL script Archiv_Report using the toolbox.
The report file is named SELOUT.txt and is located in folder pdm-adp\sql.
select id,min(valtime),max(valtime),count(*) from archiv.val
group by id;
ADP version > V1.8:
select id,min(valtime),max(valtime),count(*) from archiv.archivvalue
group by id;
5.) Other archive files.
After you complete migration, proceed to the next archive file. Begin at step 1.
For internal use only 31/47
Building Technologies Migrating ADP to InfoCenter CM110773en
Building Automation Operation 07.10.2006