GDPR Cookie Consent by Free Privacy Policy Generator
post thumb
Asset Control
by Matthias Hanitzsch-Moonlight/ on 11 Apr 2019

Exporting static data of ADOs with ac_dump_ado.pl

There is a very convenient script which does not come in the standard AC server package, but chances are the AC will have provided it to you (usually installed by one of their consultants).

This script is ac_dump_ado.pl and it will take ADO IDs as input and produce ACBL representing their static data as output.

Here is how to use it:

acdba@acbox:~$ echo C0.ISS.1 | ac_dump_ado.pl -l -
TRANS NOFAIL
OBJECT ADO ADD symbol="C0.ISS.1" longname="TERRAFINO INDUSTRIES COR-7.25% PFD" template="C0_IN_T001_LSA"
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="C0_I0003" date="1521495107000" value="BB" status=1
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="C0_I0014" date="1521495107000" value="N" status=1
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="C0_I0020" date="1521495107000" value="E" status=1
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="C0_I0022" date="1521495107000" value="US" status=1
...
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="C0_SRC28" date="-2208988800000" value="US3704427588=I|ISS|1" value="370442758=C|ISS|1" status=1
OBJECT ADO_ATTRIBUTE ADD symbol="C0.ISS.1" attrid="PC_ADOS" date="-2208988800000" value="PC.00-01" status=1
acdba@acbox:~$ 

Redirect the output into an ACBL file so you can use it as a backup of the static data of ADOs or if you want to copy ADOs from one environment to another. Just load the file later with ac_bl.

comments powered by Disqus