80 likes | 160 Vues
Access and export MILS metadata using RESTful interfaces, HTML queries, DB2 SQL commands. Save results as Excel files and display visually. Two tools available: graphical web-based query and command-line tool.
E N D
Overview • MILS UI • Export to Excel file • Limited information available • RESTful interface • HTML query • All information available • XML return, easy to display visually • DB2 SQL commands • Not recommended
Metadata Types • Alert Record • Event Record • Summary • Track • Event / Alert thumbnails • Background images
MILS UI Export • Save results of any search as Excel spreadsheet • Use “Export” option • Data limited to what is available via UI
RESTFUL API Overview • Queries structured as HTML • http://p-mils1a-1.phoenix.local/mils/content/alerts_external/(AND(EQ(view_id,1),GT(alertstart,2012-06-07-11.35.00.000000),LT(alertend,2012-06-07-12.35.00.000000))) • Results in XML format
RESTFUL cont. • HTML/XML makes suitable to manage via web browser • e.g. XML can be displayed graphically
Tools available 1 • Graphical web-based query • Easy to use query interface • Some limitations on types of query • Ability to play video clips
Tools available 2 • Command-line tool • Different set of limitations than graphical tool • No video playback • Same metadata display, but more steps involved