Home

Eccairs 4 - User Manual

Contents

1. Grand total e See page 9 6 for details on the Occurrence Edit window User Manual MODIFYING OCCURRENCES o CICcurrence Lock Grecurrence Release Occurrence Print Preview Prime Cut Copy Paste Delete Select all State Filter by selection Filter excl selection FIOL Filter by Ramos Fitar Find Find hat Kenya Swutzerkand Venezuela Australia Congo the Dieamor india The ECCAIRS Browser CHAPTER An existing occurrence can be modified either selecting Occurrence gt Edit from the menu bar or pushing the corresponding icon button in the toolbar K It is also possible to select Right click menu Edit or just double click on an occurrence in the Occurrence List pane The Occurrence Edit window will be opened Once moditied the occurrence is always by default stored back in the originating source either the database or the E4F tile from which it was taken During editing the occurrence in the database is automatically locked for other users As long as the occurrence is kept locked nobody else can modity it except the locking user him herself A user can open an occurrence trom the database and keep it locked until he she has finished editing it even during various ECCAIRS Browser sessions For other details on occurrence locking see page 7 5 Editing occurrences 9 5 Q A new occurrence may already contain de
2. Logging options OPCW SE To set the system actions in case a duplicate occurrence is found the following options are available v Prompt user A dialog will appear informing the user about the situation and asking the user how to proceed M Overwrite occurrence in database The duplicate occurrence in the database is removed and the new occurrence from the E4F file is inserted Yl Keep occurrence in database The duplicate occurrence in the database is retained and the new occurrence from the E4F file is ignored M If occurrence in database is older overwrite If the occurrence from the E4F tile has a more recent date than the occurrence in the database then replace the duplicate occurrence in the database with the new occurrence from the E4F file I Stop uploading Stops the procedure User Manual The ECCAIRS Utilities DUPLICATE OCCURRENCES The ECCAIRS Reporting System offers specitic provisions in order to avoid that occurrences are inserted twice in an E4F file or database To understand how these provisions work it is necessary to know how occurrences are uniquely identified and when an occurrence is considered a duplicate The properties that make an occurrence unique are v The occurrence signature M State File Number State Reporting The occurrence signature A unique identitier is assigned to each occurrence whenever it is created This identitier the occurrence signature or occurre
3. 6 Grand total 5 Oo 5 THE AJC WAS ON A VFR FLHT THE BLOT FALE TO MANTAN THE PRESCRIBED DEPARTURE ROUTE AND FLEW HTO IMC HE PRESUMABLY TRIED TO CONTINUE THE FLIGHT IH IMC OM A DIRECT COURSE TO DESTINATION THE MINIMUM SAFE ALTITUDE WAS MOT REACHED AND THE ANC CRASHED ON THE SLOPE OF A MOUNTAT Aireratt collision with high terrain a hill or a mountain during Cruise Aircraft D ILTUY Flight crew s decision to continue fight Performed Fight crew s interpretation of the visual fight rules procedure Giaregarded Fiigh crew s navigation Unsuccesetul Flight crew s decisions Inadequate General weather conditions Weaiher conditions ite Light conditions Daylight Page ld 4 2 t RL o5 _ 2 NAVIGATION TOOLBAR 10 2 User Manual The ECCAIRS Browser By using the bottom navigation toolbar it is possible to navigate though all the pages also by entering a specitic page number Previous page Next page Page laja t P oE First page Last page The print preview menu bar allows to control all the preview and print functions preview zoom included and to recall intormation on the program via its Help gt About menu item see page 10 8 for details on the intormation displayed File View Print Help File View Print Help Exit First Page Report Abou Previous Page Current Page Mext Page Last Page The print toolbar allows to print the currently displayed page or all th
4. ECCA R T y European Co ordination Centre for Aviation Incident Reporting Systems ECCAIRS REPORTING SYSTEM USER MANUAL Copyright 1995 2005 Joint Research Centre of the European Commission ECCAIRS the ECCAIRS logo and the ECCAIRS products refer to a series of software applications developed by the European Commission in the context of the European Co ordination Centre for Aviation Incident Reporting Systems ECCAIRS All other trademarks are property of their respective owners Information contained herein is subject to change without notice All rights reserved SOFTWARE LICENSE AGREEMENT for ECCAIRS REPORTING SYSTEM The copyright holders are providing it under the following license agreement By obtaining using and or copying this software you agree that you have read understood and will comply with the following terms and conditions This software is provided FREE OF CHARGE to all Civil Aviation Authorities Aviation Incident Investigation Bureaus and Aircraft Traffic Management Bureaus of the European Union EU Non EU organisations are entitled to use this software under the same terms except that these organisations are not entitled to obtain technical and or user support EU commercial and non EU commercial organisations are not entitled to use his software except when explicitly authorized by the European Commission These organisations must contact the European Commission the Joint Research Centre of
5. Query libraries and queries are created edited and managed via the Query Builder dialog window see page 7 8 USER MANUAL The ECCAIRS Browser QUERY LIBRARIES ECCAIRS queries are organised and stored in libraries Each library can contain an unlimited number of queries Within the ECCAIRS Browser a query cannot exist stand alone but only defined within a Query library Queries in the currently opened query library are listed by name within the main pane of the Query Builder dialog window Query Builder H ECCAIR S workspace myquery_library e4g Ioj x Library Query Help ie dl gt K A BR SA with fatal injuries USA with fatal injuries and IMC Queries can be added edited and deleted trom the library Query libraries allow a better management of queries e g users can group queries of a specific type in libraries so that they can easily be retrieved tor specitic purposes Query libraries can be created opened closed and saved with user specitied names Libraries are saved in ECCAIRS 4 Query file format E4q_ file extension Hence query libraries also provide an easy mean to exchange queries between users and organisations since libraries are stored in tiles which can be easily sent and copied across The Query Builder main window functions are described in detail on page 8 Working with databases CHAPTER 7 G Stand alone queries i e not within Query Libraries can instead
6. Right click menu gt Send to Database if the occurrence was deleted trom the currently open database v Right click menu gt Export to export them in a new E4F file ort identification State file number Rep Recycle Bin usage The Recycle Bin behaviour is customisable through its Options tab x Gener _Owtions W Enabled Wam when size reaches fi 0 MBytes When purging keep last f Dats Purge now v The Warn when size reaches field allows to define a threshold expressed in MByte s which will trigger a warning message to the user prompting her him to purge the Recycle Bin Mi The When purging keep last field specifies the time range of last deleted occurrences to be preserved when purging the Recycle Bin v The Purge now button purges the Recycle Bin on user demand v The Enabled check box allows to disable enable The Recycle Bin The Recycle Bin is enabled by detault Working with the list of occurrences 6 9 The ECCAIRS Browser 7 WORKING WITH DATABASES OVERVIEW The ECCAIRS Browser can both work on occurrences stored into databases or tiles This chapter deals with ECCAIRS Browser operation on databases The first part is about basic operations needed to deal with databases i e connecting to the database locking and unlocking of occurrences to manage concurrent editing access to the same occurrence and saving occurrences into the database The second hal
7. Attribute definitions Attribute Attribute IH Operator Ok Cancel The Operators field in the Properties pane are used to provide the choice of operator when building criteria in queries See Criterion Builder page 7 13 or Setting variables and tracing the graph page 11 8 for details The attribute Id Short Description and its Definition are used for instance in the ECCAIRS Browser application to show tool tips about attribute definitions using the CTRL click on attribute name mechanism see page 10 6 for details both in the browsing and in the editing phases Oecunrence class Accident Decuneneat atirinute 431 Occurrence class The classification of the occurrence in relation to its severity The attributes also have an additional Values property at the very bottom of the Properties Pane Values Clicking on the corresponding button opens a specific attribute value browse dialog window see next section Dictionary Browser 17 9 17 10 PART 4 ATTRIBUTE VALUES BROWSE WINDOW The attribute values browse window accessible through the button of the Values tield in the main Dictionary Browser window has the same structure and functionality but applied to attribute values 1x oom cident Id Short Description 201 M ajor incident Description Major incident Definition Eurocontrol An incident associated with the operation of an arcat which safet
8. Thailand 7100303 Date entered Reporting org lO x 19 07 2002 THAI not coded Local date Local time 07 05 1971 12 35 00 UTC date UTC time gt Where State area Location Thailand MAE HONGSON A P Latitude Longitude 19 17 North 97 58 West r Classification Occurrence class Accident Occurrence category SWTZ THAI n UNKG UNKG UNKG UNKG UNKG UNKG not coded EEA not coded 19 07 2002 ot coded 19 not coded 19 07 2002 not coded 19 07 2002 not coded 19 07 2002 not coded 19 07 2002 not coded 19 07 2002 not coded 19 07 2002 Selected 1 Wisible 275 Total 275 see Switzerland Thailand United Kingdom Unknown United Kingdom United Kingdom United Kingdom United Kingdom MEE EEE gap See ara i State file number IRP a ZUERICH MAE HONGSON THURLEIGH A D POITIERS CHOU SOUTHEND AIR ORONSAY BOGNOR REGIS 7 MY REPOSITORY amp 10 09 2002 455 4 The ECCAIRS Browser To detach the list of occurrences use the View gt Detach occurrence list window menu item or the corresponding toolbar item in the main window WE Toolbar w Wiews Pane Options Detach occurrences window The selt standing occurrence list window can be made as large as needed so that the scrolling list can cover up to the whole desktop allowing easier browsing of long lists of occurrences It also has its ow
9. exclude list in the riaht oane A 4 Click on to OK button when the attributes to be removed in the export have been selected in exclude list in the right pane 18 20 User Manual The ECCAIRS Utilities CHAPTER 18 Specity using the Source pane tools either the Query to select the occurrences to be exported see page 18 4 or alternatively the E4F Filename with the occurrences to be exported see page 18 9 for details Source f Query instrument meteorological conditions tj ie all Occurrences where Weather conditions equal to IMC C E4F Filename ee Push the Execute button 9 The dialog window that shows up displays the list of the occurrences to be exported Complete de identified occurrences By right clicking on one of the columns it is possible to turtherly restrict the state file numbe g Occurrences to be exported by applying a 7100001 Lib filter on the corresponding attribute ee 7100005 Bwer 7100066 Germar ge 7100119 United Kir 7100125 Yugoslav Filter by D not coded 7100220 United Kir G not coded Remove filter 7101009 United Ste J Split destination file when it reaches j O00 Oecunrences Cance T not coded The number of occurrences to be exported in the E4F file can be limited by checking this box and entering the maximum number in the Occurrence field 10 To proceed with the actual exporting click
10. So to apply the sample settings described in the previous sections of this chapter and close the properties dialog window s 1 Confirm pushing the OK button in the Y Axis Properties window 2 Confirm again pushing on the OK button in the Chart Properties window The graph displayed will reflect the modified properties a e S a WEBMAaeH AI B Q 3 alaiekhe gt Distribution of Occurrences by Day of the Week mer gio a rS uk m uk G1 E oO E FS uk i Oo I prer pmr T vk E o 2 T B pur E C T T B E _ m E Local date As Day of week User Manual The ECCAIRS Grapher Saving the graph To save the graph with a more significant name select Graph gt Save Graph As Please note that there is no corresponding graph toolbar icon tor this command In the Set Graph Name window enter the desired name for the graph for instance Occ Distribution by Day of Week and push OK to contirm Set Graph Name x Graph Mame fce Distribution by Day ot vVeek Cancel The icon with the new name of the new graph will be listed in the open library window as soon as the graph is plotted or refreshed Graph gt Execute menu item or the corresponding toolbar icon Eccairs Grapher File Edit Graph Options Window Help D Halm Al l a e H ECCAIR S4 workspace mylibrary e4g Library Orr Distribution sett
11. The value can be proposed as new code FIND ATTRIBUTE VALUE BY BROWSING Lect departure poyini Clicking on the right button opens the hierarchy navigation window Clicking on a collapsed node E expands it into its branches Clicking on an expanded node E collapses its branches SPECIFY AN ALTERNATIVE VALUE It the value wanted is not included in the predetined multi level value tree in some cases a specitic alternative value may be entered using the Alternative Value tab Displaying hiding value explanations Multiple and Hierarchical selection dialogs have the Explanation button at their lett bottom edge to toggle on off display of value explanations Occurrence category GCOL Ground Collisiorg LOC G Loss of control ground RAMP Ground Handling CFIT Con Usage Notes includes collisions with an aircraft person animal ground vehicle obstacle buliding structure etc while Seley Occurrence class Accident Serious incident E Incident Major incident Significant incident QJecurence without safety effect Not determined Major incident Eurocontrol An incident associated with the operation of an aircrat have been compromised having led to a near collision between air Le safely margins not respected which Is not the result of an ATC elef Editing occurrences CHAPTER g The hierarchy navigation window is also opened if the user types any text in
12. 10 5 M File gt Send deidentified to see page 6 6 Save in Sy workspace de Er Ess My Computer gr m T laaa m File name sample E df hy Network F A Files Cancel Eccairs 4 Data Files i Eccairs 4 Compressed Data Files All Files Save as hype The choices available in Save as type are v The default tile format Eccairs 4 Data Files E4F tiles ending with the extension E4t Ml By choosing Eccairs 4 Compressed Data Files instead ending with extension E4z the tile is compressed to save space Each occurrences usually has a size between 10 and 50 kBytes The compression can reduce the file size as much as 10 times This may turn out useful when attaching occurrence tiles to e mail or saving them to a space limited device e g floppy disk small pen drives etc M All files just removes the filter to display only E4f or E4z files respectively within the dialog The tile is still saved in E4F format Working with occurrence files 8 5 The ECCAIRS Browser 9 EDITING OCCURRENCES ECCAIRS OCCURRENCE STRUCTURE In ECCAIRS 4 occurrence data is collected in hundreds of ditterent Attributes Some Attributes are valid for an Occurrence like the Date the occurrence took place others instead are valid tor a sub entity of the occurrence like the Model of an aircratt in particular when the occurrence involves two aircrafts For visualisation and editing
13. Attachments Bh OccurrenceFile E4f Subject E4F Files es Body Text Helvetica Arial E A A B I U This message has ECC AIRS occurrences attached by PETER JRC on 2005 10 11 18 12 20 For more info on ECCAIRS see HTTP Veccairs www jrc it it m Printing and other utilities 10 5 10 6 PART 2 FINDING DEFINITIONS AND DESCRIPTIONS ECCAIRS Browser provides a useful feature tor recalling ICAO section and attribute coding and definition both in the reading browsing and in the editing phases To display ICAO attribute sections codes and their definitions hold down the CTRL key while clicking CTRL click onto the section or attribute name in the Information Pane both in view and edit mode Attribute 433 Local date The focal date entered In the formal Which depends on the focal Insta lation Lise yyy eine othe ese To remove the pop up description just click onto it The same mechanism can be used to obtain descriptions and definitions of attribute values in view mode by CTRL click on already tilled in attribute values This holds for values chosen trom pre defined lists and not for text numerical values entered typed directly by the user Detailed intormation on topics sections and attributes including values allowed for the attributes can also be obtained via the Dictionary Browser which can be started selecting Help gt Dictionary Browser See page 7 1 f
14. Delete Clear Add open square Bracket Add criterion Copy cut Add open bracket Copy F D a CF J acon gt s K RA Exit Add closed bracket 4dd operator OR ECCAIRS 4dd closed square bracket Edit criterion Q There are wrong bracket combinations in the restriction part Possi b errors IN query syntax are indicated by suitable message windows for instance x because of Unbalanced number brackets A specific Criterion x Only a Criterion is admitted Following a Logical Operator 7 13 helping the user to build criteria is invoked by M Double clicking on an existing criterion VMI Selecting Edit gt Edit menu item or Right click menu gt Edit or even toolbar edit icon when focus is on a criterion IMI Selecting Edit gt Add Criterion or Right click menu gt Add Criterion or even toolbar add icon when the focus is on a logical operator or on after a left bracket USER MANUAL Builder window see page The ECCAIRS Browser CRITERION BUILDER The Criterion Builder dialog window allows to detine the 3 elements for a query criterion Criterion Uh zil Attribute definitions oi iwi jy i ATTRI BUTE Attribute Oecurence Seventy ae Id Injury level Operator Jequal to Value definitions OPERATOR Ask later M VALUE reference value Attributes A tull qualitied attribute identitication involves specitying the triplet Topic Sec
15. Drop down list The user chooses from one of the predefined attribute proposed in a drop down list values Multiple selection boxes Seton lancing ai H lectronic landing aids used ILS localizer only ILS back course ILS complete MLS MOB Bone Other PARIGCA Surveillance Radar TACAN Unknown VOR User Manual When more than one attribute value may be specitied ECCAIRS proposes a box dialog window where the user can add and remove attributes values to a selection list pane on the right There are also a value explanation and a value filter facilities which are described on pages 9 9 and 9 10 Hrerarchical selection boxes The ECCAIRS Browser When suitable ECCAIRS proposes a hierarchical selection box with display filter capabilities where the user can either Last departure point Coded Value Alternative Value Last departure point H 4 Alaska U S Coded Value Altemative Value Albania Algerie DAAD Amdat American samoa i F DAAK Andkhoi Angola amp Anguila I U K Benet cia Antigua and barbur OABG Badhl Antilles francaises 0 a kh Areas under the co ABN ae a sk Argentina OABR Bamar Armenia i Aruba Netherlands ie a Ascension U K DACE Charburiak trali PAARS DACC Chakhcharan Austria ADD Dawlatabad OADF Darra l Soof DADY Devar MAM be Peek iy
16. Local date Function definitions Layout Remove EER User Manual The next step is to define the occurrence attributes to be plotted on the axis and their format and aggregation mode In the tollowing sample graph we will plot the distribution of occurrences by day of the week This is done by _ selecting Graph gt Query Define X Axis or the corresponding graph toolbar icon In the Selection Builder dialog select the right arrow in the attribute pane to invoke the dictionary hierarchy and the tree navigation window Browse and choose the Local date attribute Choose Day of week as layout in the Function definition pane The ECCAIRS Grapher CHAPTER 11 Attribute Selection 4 View Definition mv ADREP Repeat the same procedure with Graph gt Query Define Y Axis with the state file number attribute Date entered Headline Choose Value as Layout and EA m Count as Aggregate function w Attribute definitions ___ Attribute Occurrence Define Y Axis Filing information gt Attribute Iq 10452 State file number ee Once the query and axes are set a il os the graph can be drawn by Save Graph As Template selecting Graph gt Execute or the corresponding graph toolbar icon ze Show Query Definition Default title and legends colours and graph properties are used Execute Eccairs Grapher File Edit Graph Options
17. Ml Top This allows to hide all columns or rows but the top n ones as specitied in the tield to the right of the Top radio button D Decimals os pi Not Normalized An invisible hidden or filtered out row or column can be recognised in the data grid since it has a grey colour The Data grid behind the graph CHAPTER 14 A Filter G The concept of filtering is very powertul but needs some exercises to get used to For optimal results it is recommended to go create some examples and analyze the results 14 7 PART 3 NORMALISING GRAPH DATA Normalisation often helps to gain a more significant perspective out of numerically inhomogeneous data sets For instance in our example the total number of incidents is clearly greater than accidents so direct day by day comparison does not give satistactory results Selecting the Normalise icon button displays a Normalise dialog which w offers four choices v Not normalised to remove LS x normalisation v Normalised by X axis label Local date in the sample v Normalised by Z axis label Lange Occurrence class in the sample v Normalised by all values Not normalized Tormalsed GY Local date The sample graph below shows Normalisation by Occurrence class cairs Grapher 3D occ class by d o w norm by o class 7 l ioj CHa E E Hrs j a amp W a E aa Gl a REl 3 m Inciderr H Accide O
18. Next Batch Save 45 7 19 Close 8 2 8 4 Send to K 84 Occurrence Send deidentified to 2 6 6 Mew a Recycle Bin 6 8 Duplicate Occurrence 9 12 Edit 9 5 Frink Occurrence List AG Delete pa a ee eaa 3 H ECCAIRS 4 Workspace sample E4F 8 2 E e lt 3 l ii 7 5 Frink Preview 10 2 Edit Frint 10 4 Cut i Copy 6 2 Paste a Help Select all 6 2 10 8 Eccairs 4 Browser Help Find Dictionary Browser 10 8 Find Mest 6 5 About 10 8 View w Toolbar ae wf views Pane 4 4 Show the Query Occurrence Lis 4 8 Detach occurrence list window 4 9 PEE Copy data window 9 12 Options On User Manual The ECCAIRS Browser THE INFORMATION PANE The Intormation pane is the area where detailed intormation about the occurrence can be viewed Another version of the information pane is opened as a selt standing window when entering edit mode This latter is editable so that topics and attribute values can be added or updated see page 9 1 Finland FINTIIO01 Filing information Finland FINTH001 Headline Air Trafic Incident Report Narrative Finnish Note 5 5 T oe By clicking on the left pane topic icons x Separation itl ic P hau the specitic topic information B5 AERO SPACELINES B 377PG 3 6 organised in sections pane boxes is Narrative f 7 3 Note displayed in the right data pane Ev
19. Prink firccurrence ist Database insertion report Wrong value for attibute Manufacturerrmodel child of Aircraft 1600200 Wrong value for attribute Operation type child of Aircraft 10700 sirana fcthribuke ld SR child af cunecrate GENERATING OCCURRENCE FILES FROM THE DATABASE Conversely although the E4 Generator see page 15 1 and or Exporter see page 17 12 ECCAIRS utilities are the suitable tools tor exporting occurrences into tiles the ECCAIRS Browser also offer the File gt Send to gt File function which allows to create an E4F tile out of selected occurrences originated trom a database query or even from another E4F tile see page 8 4 and 6 5 USER MANUAL The ECCAIRS Browser LOCKING AND RELEASING OCCURRENCES When creating or moditying occurrences see page 9 1 in the database ECCAIRS Browser automatically puts a lock on the occurrence The lock prevents other users to edit or delete the same occurrence at the same time State reporting State file number Aeparting Date entere The locked Occurrence IS marked En 2001 2172 Sweden CAA e by a special colour in the Sweden 2001 701 24 04 2002 Occurrence List pane Sweden 5 Sweden LAA 24 04 2002 Finland JKS Finland CAA 24 04 2002 United Kingdom 4 90 EWC1095 Sweden CAA 04 2002 Ciwecer A Flight 14217 Sweden a Pe Po PETER i JRC State reporting State file number Date entered Sweden 2001 21 72 Sweden L
20. Specitying attribute section on page 9 8 for details The ECCAIRS Browser CHAPTER The File menu in the Occurrence Edit menu bar allows to HE vV Save the data entered so far 9 n with the occurrences currentl Set Occurrence as default y Restore default occurrence in the Occu rrence List pane Send to E mail eee ay M Set and Restore default Check For duplicate occurrences Nakahase occurrence content template Exit see page 10 7 M Send to gt E mail gt File or gt database the occurrence The Occurrence Edit i ited window has a be g edited different default I Check for duplicate occurrences The check can be performed when o and 7 t editing occurrences stored in a database A check on duplicate State ree ee File Number and State Reporting attributes is in any case made when the browse Info Pane of the main saving the edited occurrence back in the database i a rowser WINQOW The View menu in the Occurrence Edit menu bar allows to nes v Copy data window take a snapshot exactly as eae with the Information Pane in the main window Sree M Toolbar toggle on off toolbar visibility v Options to customise display properties of the Occurrence Edit and other ECCAIRS windows and panes in particular its colour scheme see page 5 2 The same functions are available in the main window View gt Options menu item Check For duplicate occurrences Copy data window Most of the functions in the
21. Switzerland Joma 1 Switzerland AlB 23042002 Switzerland Switzerland Max Danielsson Other ar g 2002 Switzerland E Each occurrence in a row is displayed with a number ot relevant attributes columns The attributes are customisable see page 5 4 Clicking on the attribute column headers sorts the occurrence list accordingly Clicking toggles between ascending and descending sorting Columns are initially pre sorted according to a customisable set of keys see page 5 5 Occurrences from files or databases State file number Fea a CEN a ee ee T an FINTHOO1 Ti CA witze Serious incic Switzerland feinhard 1 Swizeriand my ar FRET Major pain None Switzerland Jorma 1 Switzerland AIB 23 04 2002 Switzerland TRA VOR Major incident None Switzerland Max Danielsson Other 23 04 2002 Switzerland Trasadingen Incident None J Dimaranan kehee MANNA NANAI Alamam IAAD AMINA JONG on cobes ool oan ol TF am n m alan mnan P mnnn seo ncdensh Alasan eN ia 3 The list above shows the occurrences included in the E4F file opened view if any Switching to the database query results w Toolbar can be done via menu or toolbar w Views Pane Show the Query Occurrence List Gopy date window Options D PEN gy URE ee Eat g E g Aen ise i User Manual The ECCAIRS Browser The Query Occurrence List will be filled provided that previously CHAPTER 1 a database connection has been provided and 4 2 a query has
22. The E4F Loader can also be quitted with either the bottom Exit button or the standard Windows top right close control of its main window Help menu The Help menu has two items vI Contents Fl invokes the standard Windows help support This support can also be started by the F1 keyboard key Fr a 2 gt amp Hide Back Forward Print Contents Index Search About E4F Loader 2 Release notes gt Using the application The E4F Loader is an ECCAIRS utility that serves to load ECCAIRS 4 Data Files e4f in a repository s database E4f files can be used to store exchange and backup occurrences in an ECCAIRS repository Though itis possible to manage ECCAIRS occurrences from within the Browser application in many cases using the E4F Loader is more efficient more clear less likely to generate problems and better documented in the form of extensive logging options Usage ofthe E4F Loader is mandatory when you migrate from one version of ECCAIRS to a newer version of ECCAIRS and the data format and or data taxonomy has been changed In this case passing your data via an e4f file guarantees you that all appropriate conversions and adaptations are performed Typical usage of the E4F Loader is for restoring the contents of your database from a series of e4ffiles itis recommended to perform backups regularly using the related E4F Generator application even if your database administrator makes back ups of your da
23. a 2 T D D 5 E ac E T E Z Mion Tue Wed Thu Fri Sat Suni Local date As Day of week u cm 2 Faje Vos if e oe ee Incider PA We Save Data MIE a a E u In the browse dialog that will be displayed locate the destination folder and enter a tile name for the data to be exported Click on the Save button data is saved in a TAB separated text file format Two save formats are available v Text Files default M Transposed Text Files Both of them save data in a TAB separated text file format with the txt tile extension The Transposed Text Files type is in fact a normal text tile format where row and columns data have been swapped The Data grid behind the graph 14 11 14 12 PART 3 It is now possible to import the graph for instance in Excel through the standard File gt Open command selecting Text file as tile type and then following the import wizard steps Ed Microsoft Excel mygraphdata_exported txt File Edit View Insert Format Sheet Tools Data Window Help obat JOS E S6RAYl BAS aA E es Z os S E om 8 3 yl z E HeD A i 53 BE ma 3 Accident Mon 11 30 30 20 P Graph Area cS ha Ea B 10 a a Mon Tue wad er Incident Sat Sun The data exported can be used for instance to create an Excel graph which may be pasted as object in any Windows application User Manual The ECCA
24. is a new occurrence with his own management history In particular the Date report created and the Report last modified attributes in the Occurrence Report section are set to the date and time when the duplication has been performed 9 1 1 PART 2 OCCURRENCE WINDOW SNAPSHOT To take a snapshot of the currently displayed Intormation Pane select View gt Copy data window menu item or the corresponding icon button in the toolbar VIEW Toolbar w Views Pane Copy data window Show the Query Occurrence List It is possible to take and manage more than one snapshot of any Information pane at pleasure Each snapshot is kept in a separate independent window and can be moved around resized etc Eccairs Browser File H ECCAIRS4 workspace new_EDF_file E4f File Edit View Database Occurrence Help HeiAal 6 e AA SSSR DHA AAB Narrative English E ADREP a As Narrative English DURING A NIGHT TRAINING FLIGHT UNDER amp TRAINING CAPTAIN WITH 4 SENIOR CO PILOT IN THE STAF SEAT THE AVC COMMENCED A SIMULATED SINGLE ENGINED APP WITH THE PORT ENGINE AT 60 LB TOF LANDING FLAP WAS SELECTED AT ABOUT 200 FT VVITH THE A C WELL POSITIONED ON THE CENTRELIt THE CORRECT VASI GLIDE PATH AT ABOUT 150 100 FT THE TRAINING CAPTAIN INFORMED THE CO F HE WAS GOING TO FEATHER THE PORT ENGINE THE TRAINING CAPTAIN HAS SAID THAT TO THE BES BELIEF HE PLACED THE PORT H P COCK LEVER IN THE F
25. the attribute field The text is automatically placed in the filter field at the bottom of the window see page 9 10 Ticking the The value entered can be proposed as new code check box allow to propose the value entered to be included as new standard code 9 9 PART 2 Altering values explanations in multiple and hierarchical boxes Multiple and Hierarchical selection dialogs allows to filter displayed values using the rightmost button at their bottom edge Filter On OfF Event type Aircraft operation general aircraft handling altitude related owwfiltitude bust l sern Too close to ground other altitude event A seen Abrupt manoeuvre l senene Environment manoeuy seseee Crew Maroeuyre oe ther abrupt manoeuwi Filter OnjOFE HUI anding SUITACE i ed nderzhogt Aircraft operation general A seen Aircraft collision obstacle sereen Collision a c on grounc et ircraft collision with be Collision a c mircrolight Type ENTER after ollision 44c dirigible the tilter word to afc lerrain run the filter af C object ground ollision a c structure Seley an i sey Aircraft handling Ewaming sys triggered mamenn ACAS TOAS triggered Ground prosimity wari seen Alrcratt collision obstacle A sete Collision moving aircraft Laine Collsinn hoth sincera al acas CAS nuisance alarm An event Involving d aavsance diarii fron the alncrgit alert and collision avoidance
26. 3rd party environments passing information to users of non compatible systems etc ECCAIRS overview CHAPTER 2 2 6 PART 1 ECCAIRS OCCURRENCES In ECCAIRS an occurrence is any type of accident or incident related to aviation operations The seriousness of an occurrence can range trom an event without a safety effect to a fatal accident The local policy of an organisation determines which type of occurrences are considered reportable and thus should be entered in the ECCAIRS system However in the European Union a Directive on Occurrence Reporting in Civil Aviation detines what is a reportable occurrence The classification of occurrences in ECCAIRS 4 complies at the highest level with ICAO s ADREP definitions as defined in Annex 13 of the ICAO convention Though in ECCAIRS the basic data records are called occurrences in reality what is stored in the ECCAIRS repository are Occurrence Reports Part of the intormation stored tor an occurrence for example the narrative and the event tree is in tact subjective of nature For practical reasons the term Occurrence in the ECCAIRS documentation is normally reterring to the Occurrence Report as stored in the system Ditterently trom some other aviation occurrence reporting systems in ECCAIRS an occurrence involving multiple aircratts is only to be registered once and not as a different occurrence for each aircraft An occurrence in ECCAIRS 4 is uniquely identitied by
27. 7 16 PART 2 When multiple values are required e g has at least one a specitic multi selection box is displayed within the Value definitions pane Criterion Builder l Ba Athibute definitions Attribute Oecurence Classification b Attribute Id 430 Occurence category Operator has at least one of E ADD VALUE Value definitions DEEE SSIS R EDIT VALUE Ask later D Cancel REMOVE VALUE Adding and editing values invokes ditterent type of dialog windows depending on the attribute values structure list or tree Multi value selection ist organised values Occurrence category i ATM ATMICNS List organised values are ARC Abnormal runway contact chosen via a floating ATM ATMICNS CABIN Cabin safety events dialog hosting the CFIT Controlled flight into or toward terrain drop down list EV AC Evacuation F E Firessmoke non impact Multi value selection tree organised values Tree organised values are Aircraft manufacturer model chosen via a floating dialog with an edit icon button vm AM ROE amp COMPANY nae pra AC INDUSTRIES CANADA which invokes a tree oe AAC AMPHIBIAN AIRPLANES OF selection search dialog ve AB RADAB ABS AIRCRAFT ps ABS AIRCRAFT AG Kag ACE ACRO SPORT i ae AD AEROSPACE LTD TS ADAM Cancel os AT Abd AITO AT TRIS USER MANUAL The ECCAIRS Browser CHAPTER Date range values grouping functions A spe
28. Connect Save Graph CY Mew Library Ctrl M Save Graph As ta Open Library trle Save Graph 4s Template lel Save Library Ctrl 5 W Save to Clipboard Save Library 4s Print E Close Library ELL vertical Grid i New Graph Horizontal Grid amp Open Graph Legend X Delete Graph S 3p i ri Import E Rokate i Export 4 Z Clustered A Font ae Ieee A Properties 1 HA ECCAIRS 4 workspace lmylibrary e4g 13 1 HH Datagrid hi Exit Q Zoom 2 Scrollbar Build Query a Edit Query tt Define Axis meee fe Define Y Axis Tile Horizontally TA Define 2 Axis Tile Vertically EX Show Query Definition Cascade P Execute H ECCAIRS 4 workspace lmyvlibrary e49 iw Graph 1 Pa Toolbar Options Edit Label Type d Extendes r EA A Cut Ctri B Copy Ctrl c fa Paste erly Help amp Eccairs 4 Grapher Help F1 Dictionary Browser About Rename Change Icon 11 2 User Manual The ECCAIRS Grapher CHAPTER TOOLBAR 1 1 The ECCAIRS Grapher toolbar provides shortcuts to the most used menu items related to the ECCAIRS Grapher Library see page 11 4 Positioning the mouse cursor over each toolbar item displays atter a short pause a short description tool tip In the picture below all these tool tips are shown at once New Library Save Library New Graph Delete Graph Copy Connect Export eee e x see Sl ual Open Library Close Library Open Graph Cut Paste Impart Eccair
29. HIDING ROWS AND COLUMNS To edit rows or columns select the item to be edited and either YA v Click on the Edit icon button on the toolbar Insert eee Insert row after M Right click menu Edit in the data grid a M Double click on the item to be edited Unie Also single cells may be selected edited see below The actions allowed vary according to the items selected vI Editing a single cell may allow to modify its value where applicable e g in a new row column added with the Threshold and None functions v Editing any normal row column i e not added to the data grid allows to modity the row column header M Editing added rows and columns allows also to modify the function used to produce them including its options Added rows and columns can be deleted by selecting them and using Insert row before M The two appropriate Remove icon buttons on the data grid toolbar on the toolbar M Selecting Right click menu Delete row and Right click menu gt Delete column Rows and columns resulting directly from the query cannot be removed trom the grid but they can be made invisible Insert row after Hide Delete row Any row or column in the data grid can be made invisible in the Graph This is done by selecting the row or column and either M Pushing the Hide Unhide icon button on the data grid toolbar M Selecting the m Right click menu gt Hide menu item P
30. Manual x The ECCAIRS Grapher RENAME GRAPH AND CHANGE GRAPH ICON Edi Each Graph when it is created is assigned an icon cut rts and a name Copy Chrl C It is however possible to change the Graph name Rename and or its icon at anytime Change Icon To rename a graph select it in the library and choose Edit gt Rename menvu item or Right click menu gt Rename contextual menu item Renaming can also be performed by clicking on the graph name below the icon rather than on the icon and typing over or moditying the name H ECCAIRS4 workspace aaa e4g E oj x Library Ctrl x Tain Copy Ctrl c Jay O EA Paste Ctrl Rename Change Icon ae Right click menu gt Rename or Right click menu gt Change Icon on the selected Graph in the Graph Library window To change a graph icon select it in the library and choose Edit gt Change Icon menu item or Right click menu gt Change Icon contextual menu item A Set Graph Icon dialog is displayed Using the horizontal scroll bar the available icons i e those used for the standard graph template s available can be previewed The OK button contirms the choice Cancel discards the choice Custom icons can be used by pushing the Browse button and selecting a suitable icon file ico files through the standard browse ok e dialog displayed 3D graphs and other functions CHAPTER 13 13 9
31. Serbia and Mont SUE 7100220 008 72 United Kingdom Copy 7101009 1 0002 United States Paste 7101010 1 0003 United States 7101011 1 0004 United States 7101013 1 0006 United States 7101053 3 0001 United States T1010 3 nnn lInited States Unknown Yugoslav United K i United St United St United 5t United St United St lInited St Delete Select all Filter by selection Et IRC celected O wif Filter excl selection Filter by PETER Remove filter To display only M Occurrences with the same ditterent attribute value as a reference one Click on an attribute column containing the reference value and choose the Right click menu gt Filter by selection menu item Conversely Right click menu gt Filter excl selection displays occurrences with attribute values different trom the reference one M Occurrences possessing a specific attribute value without referring to any attribute reference value in the list pane First click on any item of the attribute column wanted then select Right click menu gt Filter by and specify the attribute M All occurrences i e regain full visibility of the unfiltered occurrences Select Right click menu gt Remove filter Selected 1 Visible 385 Total 40 The number of occurrences selected visible a Ihe because of the possible filter applied and total State reporting Libyan Arab Jamahiriya are shown in the bo
32. THE SEALS SECURING RIVETS 2 GHANA AIRWAYS SHOULD HAVE THEIR OAN CREW TRAINING MANUAL xl gt MANAGING SCREEN SPACE EFFICIENTLY WITH SNAPSHOTS When minimising fo an icon the read mode main Browser window also the snapshots get minimised and are no more visible When wishing to use an occurrence snapshot as a fererence while editing it is advisable to resize rather than minimize the Browser window By doing so the user gains display space on the desktop for the coexistence of snapshot s with the edit occurrence window Editing occurrences CHAPTER g 9 13 The ECCAIRS Browser 10 PRINTING AND OTHER UTILITIES PRINTING FUNCTIONS AVAILABLE The printing related functions in ECCAIRS Browser described here are v Previewing Occurrence Printouts see page 10 2 M Printing Occurrences see page 10 4 and are both invoked from the Occurrence menu and from the corresponding toolbar items In addition there are two other functions which have been introduced in previous sections of this manual M Printing Lists of Occurrences see page 6 7 v Set Default Printer and Margins see page 5 9 The first is selected by the File gt Print Occurrence List menu item and corresponding toolbar item The second is selected by the View gt Options menu item both in the Occurrence Edit and in the main ECCAIRS Browser window OTHER UTILITIES Other utilities dealt with in this section include V
33. The Axes properties card allows to control display properties associated to each of the graph axes xi Some sample settings on the General Geres Axes 20 Y Axis selected by default TL are shown here Seconda Y ais I Show gins Click on the Details eman button which invokes in turn E A eis another multi tab window oe dedicated to Axis Properties Tick mark type None Outside i Inside Cross OK Cancel Apply Help _ a Pee a These IS for each OxIS Q MAIN Axes tab card plus 4 separate detailed setting cards see page 12 6 within the Axis Properties multi tab dialog window v General x VI Scale General Scale Labels Arid lines v Labels Y Axis E M Grid lines Flini fo Masimurmn En Select for instance the Scale unit li Scale card Format Eil Decimal places fo Logarithmic scale V Zero line Ages gt y Axis gt Scale Change the Decimal places attribute to O so that no Cancel App Hep decimals will be displayed This makes sense in the sample graph used in these chapters since the Y axis hosts occurrence counts which are of course integer values User Manual The ECCAIRS Grapher CHAPTER AXES PROPERTIES OTHER PANES In the Axis Properties multi oane window there are also a number of 2 other teature controls which allow to control of x y z axis properties Apart from what is shown on the previous page the grap
34. The specific information displayed form nodes at different level of the taxonomy tree topics sections attributes is different and is described on the next pages Dictionary Browser 17 9 17 6 PART 4 TOPIC IDENTIFICATION PANE Topics for example Aircratt Events are identified and described in the identitication pane right pane by MI Id the topic identification number used within ECCAIRS M Short Description which corresponds to the name of that topic actually displayed in the taxonomy tree Dictionary Browser E 5 x File wiew Definition Help MY ADREP VIEW Occurrence sera cate Filing information fi 040200 Everts ele wihen Description H Wwhere i vente Classification saad Severity nee Injury totals i vente ATM relation see Narrative Definition H E vents H S eparation i E Weather vee Aircraft eR Aircraft identification nai Aircraft Operation vee Aircraft descrip Toa Aircraft status PES marked with Narrative blue bold men Note ae x This holds for any level topics the root topic i e Occurrence second level topics for example Narrative or Aircraft third level topics for example Aircraft Events and so on User Manual The ECCAIRS Utilities CHAPTER SECTION IDENTIFICATION PANE 17 Sections for example Classitication are identitied and described in the identitication pane right pane by v Id the section identification number used within ECCA
35. Window Help be Graph 1 OS Q WEBR Tae AK BQ loB k e r The state file number attribute has been used to count occurrences on the Y axes since all occurrences have it defined because it is mandatory gt E m a o ke o a B gt o a o E o gt a T o a Oo 2 G a o 2 E 2 o en o E o O Wed Thu Local date As Day of week Creating graphs with the ECCAIRS Grapher 11 9 The ECCAIRS Grapher 12 SETTING THE GRAPH PROPERTIES GRAPH TITLE AND QUERY EXPLANATION In this chapter the visual properties of a sample graph will be retined This will allow to explore some of the ECCAIRS Grapher display functions and graph library close save functions Right click within the Graph 1 window or whatever graph window name was given to the sample graph illustrated on page 11 4 and select Right click menu Edit Title or the corresponding graph toolbar icon button the text cursor will be put on the title area in the graph Enter a suitable title for the graph for instance Distribution of Occurrences by Day of the Week 7 LE tevent bo lu asaw oh HIE B fa amp EEG EF Gallery j Distribution of Occurrences by Day of the Wee US sn nin Right click to display the YA 4 4 te gt i lt i viding the Point labels Font contextual menu E IA Properties Graph Build Query Clicking
36. been selected and executed and 3 the query returned at least one occurrence Operating on the occurrence list obtained from a database query or from an E4F file is identical apart two small details The first difference concerns the information related to locking of occurrences in the database when looking at the results of a query see page 7 5 The second difference concerns the initial sort made on the occurrences which is made only for the occurrence list from the database see page 5 4 Exploring the Browser 4 9 4 10 PART 2 Occurrence List as a self standing window The list of occurrences is detachable and then becomes a completely selt standing window toolbar inclusive Eccairs Browser E File Edit View Database Occurrence Help ee 7100303 E Narrative English ADREP Prel 25 MCDONHNELL DOUGLAS DC 3 DAKOT HEZ i E Narrative 0 Note g Events Hege Failures E History of flight Injuries QO Aircraft recordings F Aircraft meteo aa CFIT je Fire HEA Survival Ditch Air traffic services ATM Prel Eccairs Browser Query all File Edit Yiew Filter Database a v Toolbar Sweden currence w 7100064 Switzerland 7100005 Thailand Options 710 3 United Kingdom 7100053 United Kingdom 7100119 United Kingdom 7100167 United Kingdom 7100191 United Kingdom 7100193 United Kingdom 7100214 4 User Manual When Headline State reporting State file number
37. button or the open icon Alternatively it is possible to double click onto the Occ Distribution by Day of week icon The graph produced in the previous chapter of this manual is opened 3D graphs and other functions 13 1 13 2 PART 3 Since a number of features are going to be added here that will signiticantly transtorm the sample graph it is appropriate to save it as a new graph with a different name select Graph gt Save Graph As I Save to Clipboard EP Print In the Set Graph Name dialog that will be displayed enter the name Class Distribution by Day of Week Set Graph Name l X Graph Mame class Distribution by Day of wWieek Cancel Em Before getting the new icon and name actually Ponana displayed in the library window the graph must e Define Axis be plotted or refreshed by Graph gt Execute or fx Define Z Axis the corresponding toolbar icon button Occ Class Distribution Distribution User Manual The ECCAIRS Grapher DEFINING THE Z AXIS Select Graph gt Define Z Axis from the menu or its toolbar button the Z Axis Attribute window opens Click in the Attribute field and View Definition yy aore navigate the ECCAIRS data Occurrence definition hierarchy expanding Filing information Ee When and selecting topic Occurrence cada section Classitication and Occurence clasi attribute Occurrence class xj B1 Injury total
38. date I Include empty dates 7100019 Congo the Democratic Republic of Accident Congo the Democratic Republic of POI 7100030 1 3 71 India Accident India BOM 7100032 C 96 Ghana Accident Ghana ACCI 7100037 Canada Accident Canada ROF 7100053 004 72 United Kingdom Accident United Kingdom THU 7100064 Sweden Accident Sweden RON Germany Accident Germany Accident m4 ponnn PETER 2 IRC Selected 1 Visible 309 Total 309 MY REPOSITORY 53 2 Working with databases 7 21 The ECCAIRS Browser S WORKING WITH OCCURRENCE FILES CREATE A NEW OCCURRENCE FILE Occurrence tiles contain any number of ECCAIRS 4 occurrences in an encoded format They have an E4t extension and so we normally mention them as E4F files in this manual The number of occurrences in an E4F file is limited only by the capacity of your workstation Occurrences usually have a size between 10 and 50 kBytes 1000 occurrences will take up as an average 30 MBytes of disk space So for performance and maintainability reasons it is suggested to limit an E4F tile to approximately 1000 occurrences To do so one could create E4F tiles that cover a specitic time trame like a year or a month File Connect Save Save 45 lose Send to Send deidentified to Recycle Bin Print Qecurrence List H ECCAS workspace sample Ef Exit ov manen lel Eses 4 Dats Piles pt Files ruses Sirew at hppa To create a new occu
39. exporting graph datd cccccceecceecseeeeeceeeeaeeenees 14 10 Command is ierserire reekin iesi ENE EE EEEE 14 13 User Manual The ECCAIRS Grapher PART 3 Table of Contents The ECCAIRS Grapher 11 CREATING GRAPHS WITH THE ECCAIRS GRAPHER STARTING ECCAIRS GRAPHER The ECCAIRS Grapher application is used to produce intormation in a graphical form Information is taken trom the ECCAIRS database through a query and displayed on the screen in a graphical representation Starting the ECCAIRS Grapher see Starting an application page 3 2 its main window will show up The MENU BAR menus and menu items allows to access all the functions in ECCAIRS Grapher See page 11 2 for details Eccairs Grapher File Edit Graph Options Window Help Cae hal e x i gt elolaavle The TOOLBAR offers a quick visual access to a set of commonly used functions in ECCAIRS Grapher See page 11 3 for details This area is the WORKSPACE where the currently opened graph library and graphs will be displayed See page 11 3 for details Creating graphs with the ECCAIRS Grapher PART 3 MENU BAR OVERVIEW The six ECCAIRS Grapher menus in the menu bar are shown here File Edit Graph Options Window Help All the menu items are displayed below menu by menu The numbers reported side of each menu items refer to the main manual page s where the corresponding function is illustrated File Graph S2
40. field above the Count button Query Builder window Find all Occurrences where 1 Short tern conflicta The OK button executes 50 m the query and closes the Query Builder window The Cancel button closes the Query Builder without executing a query The Query Builder window closes and atter the execution of the query on the database the occurrences matching the query criterion criteria are shown into the Occurrence List pane The Count function invoked by the Count button see its caption in the picture above does not close the Query Builder window as the query Execution instead does Theretore the Count button can be suitably used to test a query before actually executing it USER MANUAL The ECCAIRS Browser CHAPTER QUERY BATCHES 7 It more than 500 occurrences result trom a query the resulting occurrences are handled and shown in the Occurrence List pane in batches of 500 occurrences 500 is the default size of the batch The size of the batches is customisable by the ECCAIRS system administrator The current batch number will be displayed in the status bar Database Switching between batches is done via Sill Esti Database gt Next Batch menv item Query by date Refresh Query QUERY REFRESH Since the content of the ECCAIRS database repository is dynamic and may be updated at the same time a user is executing a query query results may vary Database Build Query he suet Ds date Sel
41. icon button on saa Ss the toolbar to add a row after the last row of the grid v Alternatively select a row and use the D right click menu Insert row items Lm In this case it is possible to indicate exactly where the row is to be added since adding is relative to the currently selected row i e before or after Unhide Pelete raw Edit aN To add a column in the grid VMI Click on the Insert Column icon button on the toolbar to add a column atter the last column of the grid M Alternatively select a column and use the right click menu Insert column items In this case it is possible to indicate exactly where the column is to be added since adding is relative to the currently selected column i e before or after In the dialog that is consequently displayed the user can specify which function is used to populate the row column which row columns are taken into account and specify function options where suitable see next page for details iiiinsert Row eee xl Description Eum Fowl All items Select all Deselect all MovingAVerage Threshold T Consider a NULL value as a ZERO Cancel 14 4 User Manual The ECCAIRS Grapher The various functions that can be applied are v Sum Adds up the selected rows or columns vI Group Adds up the selected rows or columns and hides these rows automatically in the graph R Average Calculates the average of a selected col
42. is used when the lock has been put by a different user and hence cannot be released by the current user The ECCAIRS Browser provides the user facilities to build criteria see page 7 13 and queries see page 7 8 with ease without any need to be a database expert 7 6 PART 2 QUERIES Queries are commands sent to the ECCAIRS database server to identity a set of occurrences from the database based on a criterion or a number of logically combined criteria The basic building block of a query is a criterion A criterion is a requirement tor a particular occurrence attribute e g visibility Visibility less than 50 m Any of the attributes can be used to build a criterion Criteria can be combined logically by AND and OR operators and brackets can be used to indicate grouping Precipitation intensity equal to Heavy and Visibility less than 50 m Parametrical queries are also supported i e the value s of the attribute are not defined at design time but rather at run time When running the query the user is prompted with a dialog box to provide the actual value s of the attribute for the particular execution of the parameter query Injury severity level equal to Value to Ask ECCAIRS queries are organised and stored in libraries which can contain an unlimited number of queries In the ECCAIRS Browser a query cannot exist stand alone but only detined within a Query library see page 7 7
43. loading ciency agnascudty cn vaaseiateccabiueea OEE 16 7 Prompt on duplicate OCCUN ENCE ious car acansanadieceenanconenyandnewssbrcdbes 16 8 Loading TESCO SONIC sises iren E R taatncn 16 10 EAP Loader menu bar TEMS s essesssissresierisrrsrrsrrrrsrrsrrsreers 16 11 1 7 DICTIONARY BROWSER What is the Dictionary Browselr ccceccceceeeceeeceuceeeeeeeseneens 17 1 Starting the Dictionary Browser esessssssiesresrsersrrersrrerrereens 17 2 Using the Dictionary Browser ceisacestisevenseiendeersecveneioseramaenn 17 3 Browsing the Taxonomy Tree sssssssssesssssrsrrsrsrrsresrerrsrrererrs 17 4 PART 4 Table of Contents PART 4 Reading information in the Identification Pane cccecce ees 17 5 Topic Identification pane lt is cesdictiontessesrdecerevermpetswme naveienes 17 6 Section Identification pane s sss ssiissiessresirsrissrrerrrsrrerrrrrresn 17 7 Attribute Identification pane xcssctnesnoredreccnaassecdicccsnanenacnenecionceus 17 8 Attribute values browse window sssssisssesrsssissieeriresrerrerrren 17 10 View Definition File and Help menus ccccceccseeeeeeeeeees 17 12 1 8 EXPORTER Wraris the EPONE I sancnacegeatoerngeneniaranvnnennertensh Ea 18 1 Starting and operating the Exporter ccceccceeccseecseseeeeeeeees 18 2 Selecting the occurrences to expor anaeeiscnsemnerarimmoneorims 18 4 Selecting the attributes to export sssssessissiessrrsrirsrrrrrrsreren 18 6 Export se
44. logically organised in two tables in all the three export formats available one of the table contains the occurrences in Flat format and the second table in Expanded format see page 18 10 onwards for details User Manual The ECCAIRS Utilities Access and Excel output format The Access export generates an Access JET database where selected occurrences and attributes are stored in a pair of Access tables one named Flat and the other named Expanded The Excel export generates an Excel workbook where selected occurrences and attributes are stored in a pair of Excel spreadsheets one named Flat and the other named Expanded Text output format The text tiles export generates a pair of related text tiles where selected occurrences attributes are stored The names of the two files will be the name of the file as is displayed in the text box concatenated with expanded and flat For instance if the destination file name entered is IMC cloud txt the two export text files generated will be named IMC cloud flat txt and IMC _cloud expanded txt Pressing the Execute button displays a Text Export Wizard dialog Export Text Wizard x This wizard allows you to specify details on how Eccairs Export should esport your data Which export format would you like Choose the delimiter that separates your Helda i Tab C Semicolon i Comma Space Other Text Qualifier none r B2BDSC1 44402554CB E7 AFIFO EF DaF aay 436 71000
45. on OK to contirm it the password is not correct then the dialog is displayed again The Repositories dialog box is displayed again this time select the wanted repository trom the list of those available in the Repositories field and click OK to confirm The Logon dialog is displayed again this time the newly added repository is available in the Repository drop down list MY REPOSITORY in the example shown Running ECCAIRS applications CHAPTER 3 Apart from its name a repository may also be given an Alias An alias is mandatory when addressing repositories with the same name but hosted on different servers 3 9 PART 2 THE ECCAIRS BROWSER 4 EXPLORING THE BROWSER The Browser at a glance ccc cece cece eccceceueeceeeseesueseeseaeseneeseeeaes 4 The Menu BOr snrirrrsseernrietir eni e re ETIE E erences 4 2 Temor ONE e E T 4 3 The Views pane sinciecichcinwasvaniesnessdantaciad ievdunreiamonsranesmasievinneters 4 4 STO VS W E E E E O E 4 4 PTI VE Woe a N oe esti pe eye A eee 4 5 ADREF Preliminary ViCW snc cctnsccsaxatsvasematondsdbosiaatwectenedvassiaten 4 5 PIN WCW eaa O E AE EEEE 4 6 ATM Preliminary View cccccccceeceeececeeeeeeeeeeueeesaeeeeeeeeneeeenes 4 6 THe NOUS OI rense E 4 7 The ta BOW aro rar E E EEE E NAE E EEI S 4 7 Tne Occurence i PONS eee nee ene een nner ee ee ees eee neers ee 4 8 Occurrences trom files or databOseS cccceeecceeeeeeeeeeneees 4 8 Occur
46. on the Continue button Exporter 18 21 18 22 PART 4 THE EXPORTER FILE MENU The Exporter menu bar has only two menus available the File menu and the Help menu The Help menu items are discussed in section The Exporter Help menu page 18 24 File New Open Save Save as Execute HiECCAIR Wexporter File sampledl ede Exit The File menu hosts two kind of items functions v Menu items related to export configuration files New Open and open most recently used Save and Save as vI Menu items for functions also available from buttons as Execute to start the export Exit to quit the application E4E export configuration files are discussed in section E4E expor configuration files page 18 23 User Manual The ECCAIRS Utilities CHAPTER E4E EXPORT CONFIGURATION FILES 18 The ECCAIRS export configuration files use the E4e file extension and are also referred to as E4E files They allow to store 1 All the export file names and paths specified in the Destination pane 2 The currently selected export format choice in the Destination pane 3 The source E4F file name with paths and or the source Query as well as the template file if any name with paths currently specified in the Source pane 4 The query defined by calling the query builder or created on the spot This query contains restrictions and possibly see page 18 6 selections The File gt Open and File
47. page 16 10 is displayed User Manual The ECCAIRS Utilities gt Insert as new With this choice there are two possible and aa TER not mutually exclusive cases and corresponding actions to 1 6 be undertaken State file number 7 O0005 71 0000s State reporting s witzerland s witzerland If the combination of State File Number and State Reporting is identical i e the second and third row fields are highlighted in yellow then another dialog window is displayed Switzerland Filing information Headline State reporting Switzerland Date entered fi g z a002 State tile number 100005 Reporting org SwTZ not coded gt cred In this dialog the user can change one or both of the duplicated attributes in the occurrence trom the E4F tile as well as its Headline Date entered and Reporting organization attributes Once changes are confirmed with the OK button a new attempt is done to store the occurrence in the database ee Occurence signature Identical Identical It the Occurrence signature is identical i e the top row field is highlighted in yellow a new signature will be assigned to the occurrence from the E4F file and a new attempt is made to insert the occurrence in the database E4F Loader 16 9 PART 4 LOADING RESULT SUMMARY At the end of the loading process a window is displayed with an overview of the result Clicking on the View button opens the log tile if generat
48. purposes Attributes are grouped together in Sections An example of two Attributes grouped together in a section is the Latitude and the Longitude of the place an occurrence took place grouped together in Section Where For navigation purposes Sections can be grouped together in Topics A group of Topics placed in a particular sequence hierarchical tree can be made available to the users of a Repository as a View Though the ECCAIRS system comes with a set of standard views see page 4 4 an ECCAIRS 4 administrator can modity or add Views as required Topics can also be customised and or created by the administrator Sections and the related Attributes are instead fixed in the standard ECCAIRS 4 system and cannot be changed by the administrator All Topics together can form a hierarchical tree by which the user of the ECCAIRS Browser can identity the place to look for particular information To sum up we can say that Occurrences are described in ECCAIRS 4 by a hierarchical collection of topics sections and attributes Editing occurrences 9 2 PART 2 The hierarchy is explicitly displayed in the Occurrence Tree Pane of ECCAIRS Browser Topics are represented by icons see tigure below The root topic of the Occurrence Tree is the occurrence itself that when selected shows the Occurrence Identification data within the Information Pane Occurrence Tree E cceur ren e sn Mote 1
49. the Explanation icon or Le pease selecting Graph gt Show Query Definition in D hh E ene ras the menu bar an explanation of the current query associated with the graph is displayed in the Query Explanation box below the graph Hl Show Query Definition 5 10 00 This is the same natural language query explanation available in the Browser plus 2 0 00 the description of the attributes chosen for Mon Tue i graph variables axes and their format and grouping indications Quen Explanation Find all Occurrences where The file number allocated by the State providing the report has value and get Local date As Day of week order Ascending and Count of The file number allocated by the State providing the report order Ascending setting the graph properties Edit Title Explanation It Show Query Definition has been enabled the natural language explanation will be also included when printing the graph 12 1 a Toolbar YA Legend box E Point labels O E G Colour functions are not available in main menu items A i Font G Selecting any textual graph element with Right click menu gt Font brings up a different detailed Font dialog for that specific element 12 2 PART 3 TEXT FONTS AND GRAPH ELEMENTS COLOURS Select the drop colour palette at the right of be the colour icon and then pick a colour trom the IEM palet
50. the whole database content Bere Confirm by pushing the OK button ioj xi Library PP TCA installed amp visibility lt 50 An all query can be set easily by requiring that one of the occurrence mandatory attributes e g Date entered has been assigned a value Find all Occurrences where The file number allocated by the State providing the report has value S ince th is is true for each occurrence the query selects all the occurrences in the Date entered has value OPENING QUERY LIBRARIES lf you like the Query Builder to open another library select Library gt Open from its menu bar use the Open browse window to locate and select the file containing the requested library and click Save AS Clase on the Open button Sec enine eT ane et One of the most recently used libraries HECCAIRS4iworkspaceltest e4n listed in the Library menu can also be ae selected instead Creating graphs with the ECCAIRS Grapher 11 7 Define Axis 11 8 PART 3 SETTING VARIABLES AND TRACING THE GRAPH raph E Ja Build Query TA Define 2 Axis EA Shaws Query Definition on builder xj aute definitions bute Attribute Id K tion definitions wut move Cancel View Definition mv ADREP Selection builder q Attribute definitions Attribute Occurence v en Attribute Id 10433
51. to 1000 then E4F Generator will generate two files M IMC occurrences1 1000 E4f Ml IMC occurrences1001 1789 E4f User Manual The ECCAIRS Utilities CHAPTER DEFINE LOGGING OPTIONS In the Logging options pane you can enable the system to create a Log text 1 D file Since the loading process runs in background it is recommended to create such a tile and therefore logging is enabled by detault To explicitly enable disable logging check the Log Activity check box Once logging is enabled you can set options in the Logging options pane v All generates a log tile that will include all the events Vl User teedback Errors only generates a log of just user feedback and errors This option is enabled by default and is an alternative tor the All option enabling one disables the other v Append Date Time stamp to LOG file name automatically appends to the log filename the date and time the file is generated This option in enabled by default v Browse allows to specify the log tile name by typing it in the appropriate text box or interactively by browsing your system files Eccairs E4F Generator X File Help GIWery instrument meteorological conditions Load Query Destination JNECCAIRSdiworkspaceMC_occurrences E4t Browse I Split destination tile when it reaches fi 000 Occurrences Logging options W Log Activity C Al User teedbackErrors only V Append Date Time stamp to LOG file name JHIE
52. topmost item from the View Definition menu items Since the specific views available in the menu may vary so may the selected default view Dictionary Browser Fie View Definition Help a Filing infor The name of the currently selected view is PE ae hen ad Where displayed on top right of the Taxonomy Tree m Pane just below the menu bar File menu Fie The File menu has a single item Exit to quit the application when selected The Dictionary Browser can also be quitted with either the bottom right Exit button or the standard Windows top right close control of the Dictionary Browser main window User Manual The ECCAIRS Utilities Help menu CHAPTER The Help menu has three items 1 7 vI Contents Fl invokes the standard Windows help support This support can also be started by the F1 keyboard key E Dictionary Browser Help ro C gt Hide Back Forward Print Contents Index Search About Dictionary Browser About Dictionary Brows Release Notes gt Using the Application The Dictionary Browser is your standard reference dictionary It gives you a quick and complete view of the taxonomy used by ECCAIRS 4 ie all topics sections and attributes available For each item an ID and description even short is given For each section and attribute a definition is also available Moreover for each attribute its properties are listed including all the value choices avai
53. value for the attribute and operator chosen by v Entering a tree unconstrained value in an field box Value definitions mis See side box for measurement unit issues Ask later D M Choosing a value trom a drop down list Value definitions ADRM Serodrome a AMAR Abrupt maneuvre ARC Abnormal runvvay contact h ATM ATMICHS CABIN Cabin satety events CFIT Controlled flight into or toward terrain Ask later M Choosing a value from a hierarchical selection and search dialog window see page 9 8 for details Criterion Builder x Attribute definitions Attribute incraft incrart identification Attribute ld o024 Manufacturer model Operator Value definitions Ask later D Cancel oe ADAM a ADAM AIRCRAFT INDUSTRIES ae ADAMS INDUSTRIES INC Criterion Builder O Ed It two reference Attribute definitions values are required Attribute eather General weather conditions e g between not between Operator between 7 the Value detinitions pane is moditied to host them Ask later D Working with databases CHAPTER 7 Clicking with the mouse right button on any attribute measurement unit will display a set of alternate units available ECCAIRS also pertorms unit conversion calculations if the measurement unit is changed after a numerical value has been entered in the field box 7 19 Cancel
54. wanted repository on a Repository Server is established in a number of steps First click on the More button in the Logon form Three new buttons are displayed in the bottom of the dialog click on the Add button The Repositories dialog box requires the name of a Repository Server Either type in the Server field the name of the server something in the form DOMAIN SERVERNAME or much more conveniently click on the Browse button Find Computer DCOM Microsoft Windows Network 18 K1800DAW local Security Alert xi The system that hosts the repository you are trying to connect to requires a password Contact your ECCAIRS administrator to obtain the password for the repository server and type it in the text box below Password xxx x xx Cancel Server k1 s00D4AW K1800DAW Browse Repositories DCOM E4F DCOM MYREPOSITORY IRS Repository My REPOSITORY x Username Password More IL ox Cancel Zi Zi ECCAIRS Reporting System The Find Computer browse box allows to browse the local network and select a repository server from the available networked computers Once the computer hosting the wanted ECCAIRS server is selected click the OK button to confirm Once a valid Repository Server is selected the ECCAIRS Browser will ask a security password and test the connection ask your administrator for the password Click
55. when closing the ECCAIRS Browser File gt Exit menu item Working with databases CHAPTER 7 4 Connecting to a database does not automatically display occurrences To extract list information into the occurrence list pane a query must be created and executed see page 7 6 and following 7 3 G The File gt Send to gt Database menu item is enabled only if the Occurrence List pane displays occurrences from a file i e yellow Occurrence List pane by default You can use View gt Show the File Occurrence List or the corresponding icon to switch to File Occurrence display 7 4 PART 2 SAVING OCCURRENCES INTO DATABASES Importing occurrences into the database is achieved most conveniently using the E4F Loader see page 16 1 a stand alone ECCAIRS utility The E4F Loader offers the most suitable options and capabilities tor importing occurrences into the database However it is also possible to use the ECCAIRS Browser to save occurrences selected in the Occurrence List pane for instance loaded from an E4F file in a database repository To do this first select the required occurrences and then the File gt Send to gt Database menu item Connect Mew Open save Save a5 Close A consistency check is pertormed on the occurrences before inserting them into the database and it any error is detected a suitable report is displayed Recycle Bin
56. wuery Help CUpy Paste Delete isibility less 50 mt and heavy precipitation Right clicking within the query pane Right click menu gt New or Right click menu gt Edit Find all Occurrences where Weather conditions equal to IMC this latter requires previous selection of an existing query A Restrictions editing window i e the query editing main window shows up Restrictions STCA installed amp visibility lt 50 iol x The Restrictions window has a menu bar with a single menu Edit a toolbar a Query Detinition pane a white pane hosting the query being edited plus the standard OK and Cancel buttons J ano on b sb Se Short term conflict a RESTRICTIONS EDITOR anc MENU BAR AND TOOLBAR Visibility less than 5 gt QUERY DEFINITION PANE OF Cancel USER MANUAL The ECCAIRS Browser In the sample snapshot of a Query Definition pane shown below it is possible to identity the three basic elements of which a query is built Precipitation intensity equal to Heavy and Criteria Visit Logical Operators Brackets Criteria A Criterion is an expression involving 3 elements ATTRIBUTE OPERATOR REFERENCE VALUE FUNCTION xj Attribute definitions e g Attribute Oecurence l here State Area eq ua tO Attribute Id nasa Ghate area of occurence Operator equal to Andorra Value definitions Endorr
57. 01 Libyan Arab Jamahiriya SE1A62500 B95 FC40AD445004 DBOEDOCAZDSFFSF 7100005 229 Switzerland EC36140b044 1FD 449635464506307 32C0FE 783E r 100066 95 Germany 2064 900327F 1494942339066 3E 1080B6 538F013F r 100119 246 United Kingdom C30rE5FB621D 7647436135691544 AFE r 4203E r100125 264 Yugoslavia Federal Republic FoF 4ACAACBD2aC4 2oF 2E 1C ACSCCPAOS4CDASSCSF F100220 246 United Kingdom AE 4B 44404541 244791 20B2D0F 41 Sb 59F 30 SD 503 rigis 249 United States 4 592040341 53067408E 7FFAE 393091 47656451 SF r 101010 United States 5 Beek 93521 CES 445F 6207 E 44096041 00CF2DASE F101011 United States 5 Cancel This dialog allows to specify v the separator to be used between the different columns v the Text Qualifier to be used to encapsulate the various strings Pushing the OK button starts the actual export process Exporter CHAPTER 18 18 9 PART 4 FLAT ATTRIBUTE FORMAT The text Access or Excel export options all provide a pair of tables as output one of the table contains the occurrences with their selected attributes in flat format Its first tive columns contain the following values Where ee Row Number a sequential number identifying the row in the output table KEY arr Occurrence signature a code uniquely identitying an occurrence object in the universe SFNR V State File Number Value the unique identifier for an occurrence within a state s administration SR V ansci State Report
58. 1 2 SOHO enre e E Sera tanner O eed 11 3 Multiple document WorkspdCe cccccceceeceeceueeeeeeueeeueeeeeenees 11 3 Creating a new GRAD the aasceancssssectcienseninscasantacnaamraniehonetentosenbes 11 4 The graph WNdOW cerisier Eir se EN EE NA 11 6 Setting the graph QUETY cc cece cece sees cece eeeeeeu secu eeneeeeeeseseneens 11 7 Setting variables and tracing the graph ccceceeeeeeeee esse eens 11 8 1 2 SETTING THE GRAPH PROPERTIES Graph title and query explanation sssssssissiesssrsrreresrerrrrerren 12 Text fonts and graph elements colours cccccceeeeceeneeee seen 12 2 Graph lape Serseri EREE RE 12 3 Label Type Option ciscateece sane asesecent aces tecancctoaadscosestaeetus scenes 12 3 Chart properties Overview ccccecccecceeceeecceseueeeeeeeeseneeeeeenees 12 4 Chart properties general series cccccceccecceeeueseneceeeenees 12 5 Chart properties AXES sa sciactsaansadossreonossediandicnsoensbswenssneorebicnies 12 6 Axes properties Other DOMES ccccceccecceceeeceeeeeeeeeeseneeeeenes 12 7 Saving the graph and the library ccccceccecce cece eeeeeeeeeen eens 12 8 Applying chart settings cccccccccecccneceusceueceseeeeeeeeeeeenees 12 8 Saving the graph cessor gateeeatecar cance cite seennyesiedere ree rdanienarorenees 12 9 Saving and closing the graph library cccecceeeeeeeeeeeeees 12 10 1 3 3D GRAPHS AND OTHER FUNCTIONS Creating another gr
59. 2 HELP AND SYSTEM INFO The Help menu has three items Help Eccairs 4 Browser Help F1 Dictionary Browser Abou M Eccairs 4 Browser Helo F1 menu item and the F1 keyboard key both invoke the standard Windows help support Hide Back Print Options Contents Index Search About ECCAIRS Brc han Release Hotes H Introduction to ECCAIRS H Browser Quick Start The ECCAIRS Browser is used to enter modif H The User Interface applications available inthe ECCAIRS 4 Repo H Occurrence Lists Using the ECCAIR S Browser authorities can H Working with Databases consistency and efficiency atthe ECCAIRS net FQ Working with Occurrence Files EU authorities are also obliged to report seriol H Editing Occurrences Aviation Organisation CAC in a standardisec Eel Printing Occurrences Because ECCAIRS has adapted ICAO s ADRE H Other Utilities without the need for data conversion Fla ECCAIRS Query Builder Occurrences can be stored locally in an Eccair database when the Browser is connected to a v Dictionary Browser starts the Dictionary Browser which can be usetul while editing queries and selecting attributes See page 17 1 for details File View Definition Help iiis Id short Description H Filing information froooood Occurrence ee when Description Lies a here sete Classification kiani Severity o mrn Injury totals Definition cree ATM relation User Manual The ECCAIRS B
60. AA 24 04 2002 Sweden 2001 701 Other 24 04 2002 Sweden o z Sweden LAA 4 04 2002 JKS Finland CAA 24 04 2002 by PETER on 7 26 2002 3 11 02 PME gt en l4 2002 4 Positioning the mouse over locked occurrences PETER g JRC no clicking a tool tip displays the user who is locking the occurrence and the initial locking date and time Atter completion of the edit phase the ECCAIRS Browser automatically releases the lock on the occurrence Occurrence Occurrence locking can also be explicitly set by the Hew user even when no editing is in course to prevent other users from modifying the occurrence This is achieved by selecting the occurrence s and choosing Occurrence gt Lock Occurrence trom the menu bar The occurrence s remains locked until the user releases the occurrence even if the locking user Duplicate Occurrence Edit Lock Occurrence Print Preview Print disconnects trom the repository or logs off the system rccurrence Mew Duplicate Occurrence Edit Delete The locked occurrence can be released by the same user who put the lock by selecting the occurrence and choosing Occurrence gt Release Occurrence from the menu bar Prink Preview Print Working with databases CHAPTER 7 The colours used to mark the lock can be customised in the Appearance tab of the View gt Options dialog window see page 5 3 A different lock marking colour
61. AIRS 4 contain actually numbers that represent textual descriptions The user never sees the numbers but instead sees the descriptions This approach facilitates the implementation of nationalised versions increases the consistency of the data and reduces the storage requirements ECCAIRS 4 is implementing a very comprehensive catalogue of terminology and data tields and values owned by the International Civil Aviation Organization which is called the ADREP 2000 taxonomy User Manual ECCAIRS Reporting System ECCAIRS TOPICS SECTIONS ATTRIBUTES AND VIEWS In ECCAIRS 4 data is collected in hundreds of different Attributes The values of these Attributes are stored in the ECCAIRS repository in the database Some Attributes are valid tor an Occurrence like the Date the occurrence took place others instead are valid tor a sub entity of the occurrence like the Model of an aircratt in particular when the occurrence involves two aircratts For visualisation and editing purposes Attributes are grouped together in Sections In the standard ECCAIRS 4 system these Sections are fixed and cannot be changed by the administrator of the system An example ot two Attributes grouped together in a section is the Latitude and the Longitude of the place an occurrence took place grouped together in Section Where For navigation purposes Sections can be grouped together in Topics Unlike the Sections Topics c
62. CCAIRS4tworkspacelIMC_occurrences lag txt Start Pause Stop Exit Note that choosing the All option may increase significantly the size of the log tile Furthermore the log file is always a single text file and it is never split up even when the destination file is E4F Generator 15 5 PART 4 RUN THE GENERATION As soon as the input query and the destination tile have been detined the Start button on the main window becomes enabled To run the generation process click on the Start button Eccairs E4F Generator 5 x File Help GIWery nstrument meteorological conditions Load Givery Destination JNECCAIRSiworkspaceMC_occurrences E4t Browse M _Split destination file when it reaches fi 000 Occurrences Logging options M Log Activity All f UserfeedbackiErors only Append DateTime stamp to LOG Tile name JHNECCAIRS4tworkspacellMC_occurrences log txt Browse Start h Pause Stop Elapsed 0 01 W 0 Exi To temporarily interrupt To stop the process click the process click on the Pause button on the Stop button During the subsequent processing v The Pause button and the Stop button become enabled M An Elapsed processing time box and a Progress bar are displayed The latter displays the progress both visually with a blue bar and numerically as percentage and as traction 15 6 User Manual The ECCAIRS Utilities CHAPTER GENERATION RESULT SUMMARY At the end of the genera
63. Changing the target printer this way In addition the page works for the current ECCAIRS Browser margins can be specified session but also changes the system in mm default printer Contirm your ECCAIRS Browser printer choice with the OK button or discard it pushing the Cancel button Customising the Browser 0 9 The ECCAIRS Browser 6 WORKING WITH THE LIST OF OCCURRENCES FUNCTIONS AVAILABLE There are a number of functions operating on the list of occurrences PETER ay JRC Selected 0 Visible 40 Total 40 This chapter deals with the tollowing tunctions on lists of occurrences Editing the list of occurrences on page 6 2 Deleting occurrences on page 6 3 Selecting and Filtering occurrences on page 6 4 Searching for occurrences on page 6 5 Saving Selected occurrences on page 6 5 Saving de identified occurrences on page 6 6 Printing lists of occurrences on page 6 7 NANNNANARAAW Recycle Bin hosting deleted occurrences on page 6 8 Other tunctions are introduced in ditterent chapters of this manual v Display File or Query Occurrence on page 4 8 v Detach Occurrence List pane on page 4 8 MI Saving occurrences in compressed format on page 8 5 Working with the list of occurrences Note that the occurrences listed in the Occurrence List pane may come either from an E4F file page 8 1 or from a query to a database page 7 1 PART 2 EDITING THE LIST OF OCCURRENCES The contextual
64. E TAXONOMY TREE The taxonomy of the ECCAIRS Suite is the catalogue describing what information can be stored in the ECCAIRS Repository and how this information is possibly encoded in the data fields Fe Filing information H When H Where H Classification Severity AI jury tatale HATA relation Events Separation H General Distances _ Aircrafts Maverent Information HAT aspects i Actions Collapses the entire tree E Expands the entire tree x Toggles on off a filter on the tree view The filter is based on the text entered in the corresponding field on the right of the button displayed when activating the filter button The filter is applied by terminating the filter text with the ENTER key User Manual The Taxonomy Tree Pane is the area where all the attributes of an occurrence can be viewed Occurrences are described by a hierarchical collection of Topics and each Topic is organised in Sections and Attributes see pages 2 9 and 9 1 Clicking on a collapsed node pe expands it into its branches Clicking on an expanded node El collapses its branches At the bottom of the window three buttons help in the navigation of the Taxonomy tree setae Electronic landing aid keen Automatic landing ae Forced landing loc Type of landing Fy chee D pproach kinat landing proc Be erodrome E H elicopter landing area description Helicopter land area type The ECCAIRS Uti
65. EATHERED POSITION AND OPERATED THE FEA PUMP SWATCH ALMOST IMMEDIATELY THE AVC SAUNG VIOLENTLY TO THE LEFT AND THE SPEED FELL Ghana 7100032 Narrative English bo HAVVKER SIDDELEY HS748 4Y RO 746 Gt ion Events eee ALL ATTEMPTS TO CORRECT THE SWING WITH FULL RIGHT RUDDER AND AILERON WITH TAKE OFF PC ae oat History of flight THE STARBOARD ENGINE FAILED THE A C CRASH LANDED AFTER HAVING HIT A NUMBER OF SMALL FE Injuries AND NUMEROUS ROCKS INVESTIGATION COMPLETED THE ACCIDENT WAS CAUSED BY LOSS OF CO ADREP PREL FOLLOWING THE PORT PROPELLER NOT FEATHERING BUT THE BLADES MOVING TO THE FLIGHT FINE F STOPS WITH RESULTANT VVINDMILLING DUE TO THE PORT HIGH PRESSURE H P COCK LEVER NOT BE DE ACER REVOKIG THE FIEL FEY DACITION WHEN THE FEATHERING MPI WAWAS CARRIED ALT RY THE Aircraft recordings Aircraft meteo aS EA Survivi a Air tra Narrative English Sa Oj x Fa ale tien thle Wreck j Narrative English ajj Flight C DURING A NIGHT TRAINING FLIGHT UNDER 4 TRAINING CAPTAIN WITH 4 SENIOR CO PILOT IN THE STARBOARD a Pile SEAT THE A C COMMENCED A SIMULATED SINGLE ENGINED APP WITH THE PORT ENGINE AT 60 LB TORQUE RC Co LANDING FLAP WAS SELECTED AT ABOUT 200 FT WITH THE A C WELL POSITIONED ON THE CENTRELINE AND Ch ES Aerodrome THE CORRECT VASI GLIDE PATH AT ABOUT 150 100 FT THE TRAINING CAPTAIN INFORMED THE CO PILOT THAT Le Runwe HEWAS GOING TO FEATHER THE PO
66. Eccairs 4 Grapher Help 13 10 PART 3 GRAPHER HELP AND SYSTEM INFO The Help menu has three items Helo amp Eccairs 4 Grapher Help F1 Dictionary Browser About v i User Eccairs 4 Grapher Help F1 invokes the standard Windows help support This support can also be started via the corresponding icon button in the toolbar and by the Fl keyboard key He s g Hide Back Forward Print Contents Index Search About ECCAIRS Gra About the Gragher what i New Pann License Agreement E Grapher Application The ECCAIRS Grapher application is used to ex rx Graph Libraries repository and display itin a comprehensible gr m Graphs printed as a report and copied and pasted into a H Graph Data Grid data can be exported in a standard tab separate Co ECCAIRS Query Builder eee eee Specific features ofthe ECCAIRS Grapher are Graphs are taken dynamically from the re Graphs can be exchanged and thus re s Graphs can be customised and extende Dictionary Browser starts the Dictionary Browser which can be usetul editing queries and selecting attributes See page 17 1 for details Dictionary Browser File view Definition Help Id Short Description ce frooooon Occurence aa when Description R where Ba Classification ner Severity Injury totals Definition ven ATM relation aes Narrative Ee Narrative Niobe Note E E vents pe Events Manual The ECCAIRS Graphe
67. ING OCCURRENCES ECCAIRS roree lags glo u 0 6 0 ane eee ene ner renee etre arenes 9 1 Creating NEw OCCUMENCES ies sever cence ncteviosusnaseanuecotauniennesnoneusnent 9 4 Modifying OCCUME NCS S aie oiesctrestiesacasienenachuaes certian aeons 9 5 The occurrence edit WINdOW so sccctassaechir oe ghacre seen edee occennesnesencearaneess 9 6 Specifying attribute VONOE Sesececenceaneacunen deeentaneuceue te ntncees a teseuteat 9 8 Direct CGI IG i nesomencetentepsoteeesisioesiaeesiaunnsesevaesd mae eernreceoans 9 8 Drop down Si ci cassetscars cet etnsennnio omer EE E genes 9 8 Multiple selection boxes cise ccaiaac enema eeweicnawantaue aa dlaewautdenandannebanens 9 8 Hierarchical selection DORE onciescassncnsesna nian taanondannbatiennsndoeieces 9 9 Displaying hiding value explanations ccecceeecceeeeeeeeeeenes 9 9 Filtering values explanations in multiple and hierarchical boxes 9 10 UIC CIN CHOC GUNG MGS Seesacns sac aiesteanintantocaserceaccassenapeienenieueess 9 1 Occurrence window snapshot ccceececeeeeceueeseeeueseueeeeeeness 9 12 1 0 PRINTING AND OTHER UTILITIES Printing functions available saris Seats arcsien slanieisclas nro daccisieaculs nanaeaditesces 10 1 CHINE UNNOS 25 3422 nucra toa ones pinauntan eta EEEE 10 1 Previewing occurrence printouts c cece c ccc ec ee eec sence sense eeeenenees 10 2 PATO OCC UNENE oases seeec the ytsacge te ceteeseaeereeeuarecce sean 10 4 Sending occurrences as E MO
68. IRS M Short Description v Description M Definition x File View Definition Help MY ADREP VIEW Occurence Id Short Description fao Classification Description vse Filing information bac when vest Injury totala vee ATM relation aes Narrative Sections are marked with light blue Classification Definition The classification of the occurence in terms of its seventy frequency and according to accident incident eae tipes This information it based on the data at hand and os Events the judgment of the investigator ssn Separation oe Weather vee Aircraft s Aircraft identification pee Aircraft Operation ses Aircraft description Aircraft status In the Definition Pane there is an exhaustive explanation of the meaning of the current Section The section Id Short Description and its Definition are used tor instance in the ECCAIRS Browser application to show tool tips about section definitions using the CTRL click on section name mechanism see page 10 6 for details both in the browsing and in the editing phases ASection 40 Classification The classification of the occurrence in beens of Ss severity frequency and daccoming fo accidenhincident lees This Information is based on the data d hand and the dg ment of the Investigator Oecurence Dictionary Browser 17 7 17 8 PART 4 ATTRIBUTE IDENTIFICATION PANE Attributes tor example Occurrence class are identified and
69. IRS Grapher Command list All actions the user performs on a graph tor example adding rows and columns changing the visibility editing cells sorting the grid etc are maintained in a list of commands that will be applied every time the graph is executed or retresh Clicking on the Commands List icon button allows to view and modity this command list In the dialog window that shows up the user can remove any single or all commands that are attached to the core query of the Graph Commands List x did Apply To Position Function Description lites systema a AE SURREAL A SSE RS SRILA RR EE Shift Normalize Normalizedbyy Normalized by Occurence class Select all Deselect al Remove Cancel When the dialog window is closed the user will be asked if the changes are to be applied immediately on the graph Eccairs Grapher x Q Do you want to apply all changes coca CLEANING UP THE COMMAND LIST Every action done after creating the core graph will be registered as a command This implies that the command list can grow rather rapidly and might contain superfluous commands i e hide and unhide of the same row When the final result of the graph is satisfactory it is wise to evaluate if there are unused commands present in the command list and remove them Sometimes it maybe wiser to recreate the graph by hand avoiding unnecessary actions This will increase performance and reproducibility of the
70. LEVER INTO THE DETENTS SHOULD BE MADE MANDATORY gt B INSPECTION AT MORE FREQUENT INTERVALS SHOULD BE MADE OF THE GATES FOR WEAR FOR A DETERIORATION HARDENING OF THE RUBBER SEALS AND FOR User Manual The ECCAIRS Browser For instance the snapshot feature can be used to display an already tilled in narrative topic s and use it as reference when entering editing other topics sections attributes Occurrence Ghana 7100032 File View EAE Ghana 7100032 Simulated failure of a turbine engine during Final approach Aircraft 9G AB W Narrative English Flight crew s operation of powerplant Improper operation Simulated Events Deviation from intended flight path attitude other during Final approach Aircraft 9G ABW Weather Flight xew s operation of powerplant Improper operation HAVVKER SIDDELEY HS 46 4 VRO 746 9 j Narrative English O x r Narrative English DURING A NIGHT TRAINING FLIGHT UNDER 4 TRAINING CAPTAIN WAITH A SENIOR CO PILOT IN THE STARBOARD SEAT THE AIC a COMMENCED A SIMULATED SINGLE ENGINED APP WITH THE PORT ENGINE AT 60 LB TORQUE LANDING FLAP WAS SELECTED AT ABOUT 200 FT WITH THE A C WELL POSITIONED ON THE CENTRELINE AND THE CORRECT YASI GLIDE PATH AT ABOUT 150 100 FT THE TRAINING CAPTAIN INFORMED THE CO PILOT THAT HE WAS GOING TO FEATHER THE PORT ENGINE THE TRAINING CAPTAIN HAS SAID THAT TO THE BEST OF HIS BELIEF HE PLACED THE PORT H P COCK LE
71. Longitude of occ State area of occurence ist Deidentifiable attributes Events options External Page setup Clear the attribute s in the exclude Attributes 439 Latitude of occurrence 440 Location of occurrence 444 Longitude of occurrence 454 State or area of occurrenc Remove N Clear The contextual right click menu ma Classification also allows to locate in the s ii i el left pane hierarchical view the sve njury totals i ATM relation attribute selected in the riaht pane n Narrative Note amaaan Events Weather oo H General weather conditions M Clouds Use the 3 central icon buttons to sen Temperature X Add b Remove list in the riaht pane Wiew Definition TAXONOMY VIEW MYADREPYIE w MYADREPPRELIMVIEW MYATMVIEW MYATMPRELIMVIEW TASCINOMY VIEW seen All Attributes A al Narrative one All Attributes ee All Attributes A vee Aerodrome Weather Reports Bens All Attributes 2 peann ir Space BO Bj All Attributes seven Narrative ee All Attributes User Manual ancel The View Definition drop down menu includes also the TAXONOMY VIEW item This displays a list of all the topics and related attributes occurrence within the ECCAIRS own taxonomy The ADREP ATM and any other possible custom view in ECCAIRS is build out of sections composed with the attributes included in t
72. New Roman X 5 x m E A A E SE O E A Set a E a a E E E I L FA e LSR i Distribution of Occurrences Classes by Day of the Week Mon Tue Wed Thu Fri Sat Sun Local date As Day of week Count of The fle number allocated by the State providing the repo 1 As cambe se en in the graph above Bie 4 Page 1 Sec 1 1 1 Atitaem Ln 3 Col36 REC TRK EXT BYR EngishtuK GX 3D graphs and other functions CHAPTER 13 Save to Clipboard 13 7 New Graph 13 8 PART 3 GRAPH TEMPLATES New graphs can be created trom any of 15 predefined graph templates distributed with the application shown here on the left Also the user Graph can create and a Save Graph snare use its own Save Graph 4s Template custom templates Save to Clipboard Any graph can be transtormed into a custom template by selecting Graph gt Save Graph as template menu item Gantt Curve 4rea Curve Area Scatter Pie Doughnut fo cu ents amp e qu mo E th cu Fe ek Shep Pareto f d i Pyramid When a graph has been saved as a template it can be used as the basis for future new graphs by the user of the workstation When creating a new graph the user can click on the Custom Tab in the New Graph dialog and select the appropriate custom template General Graph 1 my templste User
73. Normalised ae i __ e __I8 ___ bn __ Sorting operates on the data values within the grid i e the white background cells It is performed by selecting a row or a column and clicking on the two appropriate icons on the toolbar Sort descending M Sort ascending M Sort descending Re ordering instead operates on the headers the column labels and labels of the columns and rows i e the grey background cells that are normally related to the meaning of the data values within the grid The value content of the grid is not taken into account in the ordering Re ordering is pertormed by clicking on the two appropriate icons on the data grid toolbar vI Reorder headers Reorder labels v Reorder labels Both tor headers and labels a dialog is displayed to allow for alpha numeric sorting as well as manually changing the order G In all cases the relation between the row labels column headers and the data is never changed since this would make the Sot ascending Sort descending data inconsistent carcar The Data grid behind the graph 14 3 PART 3 ADDING ROWS AND COLUMNS In addition to the data retrieved from the database by setting properties tor Query X axis Y axis and Z axis it is possible to add to the data grid rows and columns whose content is determined by simple calculations on the other existing data SA To add a row in the grid kt oO M Click on the Insert Row
74. Options trom the menu bar An Options dialog window is displayed Info pane edit Info pane wiew Background 0 M Background eer Foreground a Foreground Contral background OO m Contral background D Control foreground O D Control foreground ae Cantenl border le Cantenl border m Six different option panes are available through the upper tabs v v APPEARANCE tab pane which groups colour options used in all the ECCAIRS Browser window panes and some other display options LIST tab pane which allows to select attributes displayed in the columns of the occurrence list pane DEIDENTIFIABLE ATTRIBUTES tab pane which allows to specify the attributes to be omitted when saving de identified occurrences EVENTS OPTIONS tab pane which allows to select the display a short or detailed description for attributes and values in the event topic EXTERNAL tab pane which allows to specify parameters for interfacing the ECCAIRS Browser with external proprietary modules and applications PAGE SETUP tab pane which allows to specify the default printer and printing margins Customising the Browser 4 Some of the menu items and options including the View gt Options menu item itself might be disabled or not existing depending on the configuration set by the ECCAIRS Administrator in the repository manager 0 1 1 1 uj i ar 0 2 PART 2 APPEARANCE DISPLAY OPTIONS The Appe
75. RT ENGINE THE TRAINING CAPTAIN HAS SAID THAT TO THE BEST OF HIS A BM BELIEF HE PLACED THE PORT H P COCK LEVER IN THE FEATHERED POSITION AND OPERATED THE FEATHERING anageme PUMP SWITCH ALMOST IMMEDIATELY THE A C SWUNG VIOLENTLY TO THE LEFT AND THE SPEED FELL RAPIDLY ALL ATTEMPTS TO CORRECT THE SWANG WITH FULL RIGHT RUDDER AND AILERON WITH TAKE OFF POWER ON THE STARBOARD ENGINE FAILED THE A C CRASH LANDED AFTER HAVING HIT A NUMBER OF SMALL TREES AND NUMEROUS ROCKS INVESTIGATION COMPLETED THE ACCIDENT WAS CAUSED BY LOSS OF CONTROL FOLLOWING THE PORT PROPELLER NOT FEATHERING BUT THE BLADES MOVING TO THE FLIGHT FINE PITCH STOPS WITH RESULTANT VVINDMILLING DUE TO THE PORT HIGH PRESSURE H P COCK LEVER NOT BEING PLACED BEYONG THE FUEL OFF POSITION WHEN THE FEATHERING DRILL WAS CARRIED OUT BY THE PILOT IN EFFECT THE PILOT IN COMMAND PLACED THE HIGH PRESSURE COCK LEVER IN THE PROCESS OF FEATHERING THE PORT LEFT PROPELLER IN THE VWWRONG POSITION 4 CONTRIBUTORY FACTOR WAS THE APPLICATION OF FULL POWER TO THE STARBOARD ENGINE WITH THE PORT PROPELLER BLADES IN THE V4INDMILLING CONFIGURATION RECOMMENDATIONS FROM THE INFO GAINED DURING THIS INVESTIGATION IT IS State file number Report identificat 100017 7100018 7100019 7100030 9 12 CONSIDERED THAT THE FOLLOWING RECOMMENDATIONS ARE PERTINENT 1 4 MOD NO 1599 INTRODUCTION OF THE STEEL GATE TO ENSURE POSITIVE ENGAGEMENT AND LOCKING OF THE HIGH PRESSURE COCK
76. S S WEBVAOW AK BQ laBel e Y AXIS LABEL 44 00 40 00 36 00 32 00 28 00 24 00 20 00 16 00 42 00 4 8 00 4 004 0 00 X AXIS LABEL l e ount of The file number allocated by the State providing the report Local date As Day of week order Ascending Label Type option For those attributes where a multilevel value structure exists it is sometimes difficult to understand exactly the meaning of the value at the lowest level since it is normally derived from the hierarchical path leading to the value In these cases it is necessary even if it results in long strings to print in the graph the long description of the attribute not only the lowest level Options To force graphs to use long descriptions Label Type gt z Extended select Options gt Label Type gt Extended Compact Otherwise select Options gt Label Type gt Compact which is the default setting Setting the graph properties 12 3 The Chart Properties window can also be invoked by positioning the mouse on the graph background area and select Right click menu gt Properties Toolbar l Legend ve LU kar Gallery Color b ab Edit Title Point labels Font Double clicking On the graph elements also invokes the Chart Properties window 12 4 additional Axis Properties window PART 3 CHART PROPERTIES OVERVIEW The Gra
77. Search Lt Folders f Esl za A H xE Ea 6 Address E Hi ECCAIRS4 workspace Go a Size Modified Type IMC _occurrences E4 p 468 KE 13 01 2004 19 57 Eccairs 4 Data File Samy occurrence File E4f LEB o1FfMofeo002 17 17 Eccairs 4 Data File workspace IMC_occurrences 4f Eccairs 4 Data File Modified 13 01 2004 19 57 Size 467 KB 8 2 User Manual The ECCAIRS Browser CHAPTER O During the E4F occurrence file opening phase the occurrences will be loaded and the occurrence list pane will be accordingly Populating Occurrence list POPU lated her r This phase may take some time for large E4F files File To close the currently open Connect occurrence file select from the New F p gem File gt Close menu item Save Send to Send deidentified to F Recycle Bin Print Occurrence List HiECCAIRS 4 workspacelsample E4F Exit Working with occurrence files 8 3 If errors occur on saving the occurrences on file a log message window with actions warning and error messages is displayed PART 2 SAVING OCCURRENCE FILES O Connect Per Close Send to F Send deidentified to F Recycle Bin Print Occurrence List HiECCAIRS4 workspace sample E4F Exit O Connect New Open Send to Send deidentified to d Recycle Bin Print Occurrence List HiECCAIRS 4 workspace samp
78. T rant isiad UTC dwie UTC tone Laibath 344 South Lawagelucks fe 35 Baal ha ibi Ingay r Hong Hirde None Urknicewn Total li Ls li Li D 6 j Lij D 0 The ADREP Preliminary view is a reduced and simple view where the essential information is condensed and shown in a single pane to be used for a quick kind of preliminary report focused on flight operation occurrences The preliminary report to be produced using this view can be used to fill in the detailed report at a later time in the full ADREP view The Occurrence Window Snapshot feature see page 9 12 might be useful for this purpose Argentina 7100228 Fire biiir Repenling ong AROT read cohen Regeorl kirii Fie J where Sate regali Fugen Slaai ea Fagen Stabe fe featiser PUSS L cas SAH JUSTO Sereny feury eel Hora el ae Mine Third party damigi Deere 7 Nenativs Ergkih Senk Through surface during Tending fovtrom nurevey aircred OESSNA Caste ete eed TO no Fagat Hiart Pailinna y kir Lah date 1h 10a UTG daii p Danara Wesi Condora Viele Creat Ligh exareilions b GURING TAMI FROM THE APRH TOROS Avr 3c THE PLOT TURME HT TO AO PASSING ODER A SOFT RAAT OF GROUND THE ROHT GEAR WHH HAD PAW LMLMT Dl ed Bd m miai m mii m Exploring the Browser CHAPTER ADREP PREL ATM PREL The ADREP view organises the data according to the complete ADREP 2000 taxonomy The ADREP Preliminary view is a quick way to
79. T PROPERTIES 3D 13 A better view can be achieved using the 3D perspective view select Graph gt Z Clustered or the corresponding icon in the toolbar M class Distribution by Day of Week O x e coo S k amp WEB allen Kala i Gligikiev gt Distribution of Occurrences Classes by Day of the Week Mon Tue Wed Thu Fri Sat Sun Local date As Day of week Count of The file number allocated by the State providing the report Selecting Graph gt Properties menu item or the corresponding toolbar icon displays the Chart Properties dialog In its 3D tab pane there are a number of additional 3D view parameters which can be set Chart FX Properties x The 3D tab pane can also be invoked directly from the Graph toolbar icon button General Scenes Axes The Chart Properties window can also be invoked by positioning the mouse on the T Rotated view Depth graph background area and XAngle J either select oe Right click menu Properties Y Angle fo Perspective g p or just double click shadows Fixed angle Cancel Apply Help 3D graphs and other functions 13 5 Print Graph 13 6 PART 3 PRINTING THE GRAPH To print a graph open it and select Graph gt Print trom the menu bar or the corresponding icon button in the toolbar the graph and the query description if displayed is sent to the detault printer The default printer can be set by sel
80. VER IN THE FEATHERED POSITION AND OPERATED THE FEATHERING PUMP SWITCH ALMOST IMMEDIATELY THE AVC SWUNG VIOLENTLY TO THE LEFT AND THE SPEED FELL RAPIDLY ALL ATTEMPTS TO CORRECT THE SWANG WITH FULL RIGHT RUDDER AND AILERON WITH TAKE OFF POWER ON THE STARBOARD ENGINE FAILED THE A C CRASH LANDED AFTER HAVING HIT amp NUMBER OF SMALL TREES AND NUMEROUS ROCKS INVESTIGATION COMPLETED THE ACCIDENT WAS CAUSED BY LOSS OF CONTROL FOLLOWING THE PORT PROPELLER NOT FEATHERING BUT THE BLADES MOVING TO THE FLIGHT FINE PITCH STOPS WITH RESULTANT VINDMILLING DUE TO THE PORT HIGH PRESSURE H P COCK LEVER NOT BEING PLACED BEYONG THE FUEL OFF POSITION WHEN THE FEATHERING DRILL WAS CARRIED OUT BY THE PILOT IN EFFECT THE PILOT IN COMMAND PLACED THE HIGH PRESSURE COCK LEVER IN THE PROCESS OF FEATHERING THE PORT LEFT PROPELLER IN THE VWWRONG POSITION gt A CONTRIBUTORY FACTOR WAS THE APPLICATION OF FULL POWER TO THE STARBOARD ENGINE WITH THE PORT PROPELLER BLADES IN THE VVINDMILLING CONFIGURATION RECOMMENDA TIONS FROM THE INFO GAINED DURING THIS INVESTIGATION IT IS CONSIDERED THAT THE FOLLOWING RECOMMENDATIONS ARE PERTINENT 1 4 MOD NO 1599 INTRODUCTION OF THE STEEL GATE TO ENSURE POSITIVE ENGAGEMENT AND LOCKING OF THE HIGH PRESSURE COCK LEVER INTO THE DETENTS SHOULD BE MADE MANDATORY gt B INSPECTION AT MORE FREQUENT INTERVALS SHOULD BE MADE OF THE GATES FOR WEAR FOR A DETERIORATION HARDENING OF THE RUBBER SEALS AND FOR DAMAGE OR DEFORMATION OF
81. a ki Logical operators A Logical Operator is one of the 2 logical operators AND OR used to connect 2 or more criteria CRITERION AND OR CRITERION e g State Area equal to Andorra Edit AND DNE Local date equal to Current Year Add Operator OR Brackets Brackets are used to group logical expressions to build complex criteria curly brackets are used for normal grouping Edit 4dd Open Bracket square brackets are used to group criteria Add Closed Bracket feos A 4dd Open Square Bracket referring to a specific item of multiple ones tor add closed square Bracket instance to a specitic aircratt when more than one aircraft is involved in an occurrence Working with databases CHAPTER 7 G For details on the facilities available when building criteria see Criterion Builder window on page 7 13 EDITING TIPS Double clicking a left bracket collapses and expands the contained elements The query content can be completely cleared selecting Edit gt Clear menu item 7 12 PART 2 Query elements are added deleted and edited in the Query Definition pane using M The Edit menu and the Right click menu items v The toolbar icon buttons Restrictions STCA installed amp visibility 50 i Oo x alled has value Edit Add Open Bracket Add Closed Bracket Add Open Square Bracket Add Closed Square Bracket Add Crier Add Operator AND Add Operator OR Edit
82. a specitic View Definition and to invoke help cies File View Definition Hel f p and info tools Filing information fi OOO000 jo ccunrence trie when ore Wa here Classification Severity Injury totals ee ATH relation Narrative Nan we Description Definition Identification Pane It displays in several field boxes the properties associated with the item topic section attribute currently selected in the Taxonomy Tree Pane Note Events Taxonomy Tree Pane mie It displays a hierarchical g list of all the topics D sections and ultimately en A attributes that an occurrence description 4 A Can have for the selected i ane A view Using the Dictionary Browser requires two sort of actions 1 VIEW SELECTION Since there are different Views of the occurrence data structure available in ECCAIRS 4 see page 4 4 the first steo is choosing the appropriate view from the View Definition menu in the menu bar see next page 17 12 2 ITEM SELECTION The second step involves browsing trough the displayed taxonomy using the Taxonomy Tree Pane until the wanted item topic section or attribute is selected The Identification Pane will then display the properties associated with that item The next sections will describe in detail the layout and usage of the Taxonomy Tree Pane the Identification Pane and its sub panes and finally the menu bar Dictionary Browser 17 3 17 4 PART 4 BROWSING TH
83. acelIMC_htrol_template htm fad 0 a ICAO File 100001 Occurrence cass faece O Status OO oa Date e a e Occurrence categories CFIT Controlled flight into or toward terrain Harrative THE C WAS ON AN ADF FINAL APP AND STRUCK THE GROUND 7 EM FROM THE RWY THRESHOLD Sequence of events 1 Aircraft operation general Aircraft handling Undershoot during Powered aircraft Approach Final approach o Aircratt and operations Aircraft operation Flight crew procedures Interpretation lFR Improper use o Aircraft and operations Aircraft operation Flight crew op of equipmint Altimeter Incorrect setting o Meteorological info Weather conditions Atmospheric visibility Present Aircraft Information Registration SLU ALG UNITED ARAB AIR not coded Make Model HAWKER SIDDELEY COMET 4C Operation type ops Intemational Passenger Crew Ee a ee ee ee eee ee ae ICAO File 100005 Occurrence class accident Status Oat 4 E Done im 2 Internet E Exporter CHAPTER 18 Since ECCAIRS version 4 2 4 hot fix 3 onward the Tools Export sub folder of ECCAIRS installation folder hosts sample RTF and HTML template files E4ExportTemplate rtt E4ExportTemplate htm 18 19 PART 4 EXPORT DE IDENTIFIED OCCURRENCES INTO AN E4F FORMAT FILE This option allows to export de identitied occurrences into a new E4F file To de identity occurrences the specitic export attributes to be e
84. allery gt L Color b aT eee vr 3000000 00 abl Edit Title Point labels 200000000 4 Font 1000000 00 LIN Properties 0 00 The content and the aspect of the graph can be controlled via either v The Graph menu items of the ECCAIRS Grapher shown aside v The toolbar in the graph window shown below g S S WEBR TASHA KH a a le le i gt The Graph toolbar is normally shown in the top of the graph window but may be both detached from the graph window if dragged away and re docked subsequently and displayed or hidden through the main menu Graph gt Toolbar item or via the Graph window Right click menu gt Toolbar item In addition specific display properties can be set in a contextual way by right clicking on many elements of the chart and selecting items of the corresponding contextual menus displayed User Manual The ECCAIRS Grapher CHAPTER SETTING THE GRAPH QUERY The ECCAIRS Grapher application produces graphs out of intormation 1 1 extracted from the ECCAIRS database through a query Select Graph gt Query Builder from the menu bar or via the corresponding icon in the graph toolbar This invokes the Query Builder window that has graph already been described with the ECCAIRS Browser pie ecb see page 7 8 CQ Zoom 2 Scrollbar The Query Builder opens the last used query fal library K Query Builder For instance select the exemplary all query which selects
85. allow to select which attributes are displayed as columns in the Occurrence List pane i iOptions xl sesssssssssesssssns Appearance List Deidentitiable attributes Events options External Page setup Fesssssssssesssesen Occurrence list Checking the One row per occurrence option One row per occurrence CAUSES occurrences involving two or more aircrafts to be displayed in a single row Columns customisation id Attribute Entity Level Sot o oal 452 The file number allocated by the State providing the report Occurence 438 Report identification Occurence 453 The identification of the State that supplied the report Occurrence 431 Occurrence class Occurrence 454 State or area of occurrere Occurence 4 440 Location of occu The check boxes allow to select the M 433 Local date 71477 UTC date of the Attributes to be displayed as columns in M21 Aircraft manufact the Occurrence List pane see below M 34 Aircraft type desit M 244 Aircraft registration Aircraft M 215 Operator ai operation Aircraft F et ae mM i A fi State area TE Finland CAA j 2002 Switzerland itzerl reinhard 1 Switzerland AB 4 Switzerland Jorma 1 Switzerland AlE Switzerland TRA VOR Max Danielsson Other 33 04 2002 Switzerland Trazadingen Heer a ES A e a n Lip Elaran EAN Ta An Weel 4 Resende beeen Location Here is the list of the attributes see also side note which can be selected a
86. an be customised and or created by the administrator of the ECCAIRS repository All Topics together can torm a hierarchical tree by which the user of the ECCAIRS Browser can identity the place to look for particular intormation A group of Topics placed in a particular sequence hierarchical tree can be made available to the users of a Repository as a View Though the ECCAIRS system comes with two particular Views one for an ADREP and one for an ATM representation of the information an ECCAIRS 4 administrator can modity or add Views and Topics as required By default two particular Views exist which do not contain the navigation tree the ADREP Preliminary View and the ATM Preliminary View These Views do not contain Topics or Sections and the Administrator of the Repository cannot modity these Views It is important to understand that Views and Topics only change the way the data becomes visible Occurrences created in any view can be looked at in any other View since the Attributes that contain the intormation are always shared ECCAIRS overview CHAPTER 2 ECCAIRS Reporting System 3 RUNNING ECCAIRS APPLICATIONS THE APPLICATIONS SUITE ECCAIRS software is a suite of main applications i e the ECCAIRS Browser and the ECCAIRS Grapher plus a number of auxiliary applications or Tools je Accessories Fa Administrative Tools E Administration i a Eccairs MSDE j E Taxonomy a Hardware 7 ae Dictionary B
87. andard ECCAIRS logon see page 3 2 its main window will show up aes p The Menu bar whose menus allows to save and recall Exporter setup files and to invoke help and info tools Destination 0 Selecte hutes of occumences in a pair of text files C se The Destination pane allows both to select the wanted export format and f Se specify the output file name Occurences formatted according a predefined template Complete occurences expanded as a test tree amp Complete de identified occurences in E4F format The Source pane allows to specity the source occurrences and where applicable attributes to be exported Execute E xit The upper pane the Destination pane allows to specity the target output tile names and choose the specific export format v Export a number of specified attributes of the query selected occurrences from the database into text Access or Excel file s v Export whole occurrences either resulting from a query on the database or taken from an E4F file into output tiles either in a fixed text tree format or in a template driven HTML RIF TXT format or de identitied in an E4F tile The Source pane the lower pane allows to either specify the query on the database or the E4F tile where applicable providing the occurrences to be exported User Manual The ECCAIRS Utilities CHAPTER 18 Also where applicable the specitic attributes to be exported can be specified Export a numbe
88. aph cccccccceccecceeceeceeseueeseeseseneeeneeness 13 1 PART 3 Table of Contents PART 3 Defining la sa742c ca ae ee eden ee 13 3 Charn IIe AiG OO oh s agua icra asern ans ions ee yates oes 13 4 Chari properties 12 asttesensgeamteot aqcationsaadvaotemnermiendeenanenenidventions 13 5 F MMM Negra Mees ose laa eetaae r A 13 6 Copying and pasting the graph cccccecceeeceeeceneeeneceeueeenees 13 7 raph emplie sopr err rona a A A 13 8 Rename graph and change graph icon sssssssississseessissiessees 13 9 Grapher help and system into ccccceccsecccnceeeeeueeeueeeaeeens 13 10 Other graph TUN ONS as deers er tece entree ae oeerenicennets 13 12 Other graph mile cola sell o ote eee eee ee et 13 13 1 4 THE DATA GRID BEHIND THE GRAPH Data grid an OVervieW s ssissssissirerssrsrrerssrsersrrereersrrerrrrsere 14 1 Sorting graph data cesenevtntscarsonupssateees ssroasinesedademsssecatedimesseute 14 3 Adding rows and colUmMnS vticuistiectiorctnininancantadasectreaedireeen 14 4 Editing removing and hiding rows and COlUMNS 060cee es 14 6 Filtering dota for CISDIOY enccucteastoreantesencnedacieansamcasncidhacensuneke 14 7 Normalising graph data i nerve dnvseieeaacurmeemingioeecmenceometae 14 8 Additional data grid fUNnCHONS esssssessersererrerrerrrererrrrrren 14 10 Decimal PlaCes cccccccceccceeee eee eeeeseeeeeueseeseueeseseneeeneeas 14 10 OCI AO sess cernen tes E EEEE EEA 14 10 Saving
89. arance tab pane controls the display options grouped into sections related to different display windows or panes Information and Tree pane options The ECCAIRS Browser uses different information panes for its two operating modes Edit mode and View mode So their display options are separated accordingly Info pane edit Background Info pane wiew Background Foreground Foreground Control background Control background Control foreground Control foreground Control border 30 Control border 30 Hide empty sections Section title colour Section title colour Options for the Info pane separated for Edit and View mode include colour choice tor check boxes to enable disable v Background Foreground v Control Border I Control Background Foreground M 3D style display M Section Title v Hide empty sections Options for the Tree pane include Yl colour choice for its Tree pane Background O Jh Background and Foreground Foreground B vI There is also a check box to Occ tree show all nodes a select the display of either all the possible topics in an occurrence or if not checked only those containing some information Views pane options Options for the Views pane include Views pane Background em colour choice for its Foreground sd Background and Foreground User Manual The ECCAIRS Browser Occurrence List Pane options The Occurrence List pane Occurence list file Backgr
90. be emphasized gt Mono spaced for tile and path names gt Keyboard keys in square brackets with a plus sign separating keys that you press simultaneously For example oress Ctrl Alt Del to restart your computer gt Arrows gt to separate ordered selections in menus For example select File gt New form the main window Document conventions G Scattered through all the guided tour steps there are ADDITIONAL INFO BOXES Into boxes are placed either here within the left hand side grid or in coloured boxes across and along the right side margin line They contain notes on current actions being described or hints on alternative actions to take in case some options are not available or suitable to the user They may also host quick hints on more functions available or suggestions for user self exploration of program features 1 1 ECCAIRS Reporting System 2 ECCAIRS OVERVIEW ECCAIRS ACTIVITY To decrease the rate of commercial air trattic accidents the European Commission has introduced a regulation on occurrence reporting in civil aviation which collects and disseminates information on aviation incidents on a European scale so that we can learn trom events and produce a safer transport system In individual States the number of significant occurrences may not be large enough to give an early indication of a potential serious hazar
91. box and a Progress bar are displayed The latter displays the progress both visually with a blue bar and numerically as percentage and as traction Eccairs E4F Loader x File Help Modified Add an SIMC_occur 479RB 13701 2004 15 HECCAIL 2h my EDF file 43 KE 10 09 2002 10 H SECCAL Remove lear Count Total 4d Loader options M Autocorect inconsistencies IFoccunence exists then Prompt UZET Logging options M Log Activity All f User feedback Errore only i Append DateTime stamp to LOG file name HE CCAIAS 4 workspacee4iloader log tut Browse Start Pause Stop Elapsed 0 16 56 Coa Exit To temporarily interrupt To stop the process click the process click on the on the Stop button Pause button At the end of the generation process a window is displayed with an overview of the result E44F Loader 16 7 G The Apply to all items check box is not applicable for the Insert as new and Cancel buttons 16 8 PART 4 PROMPT ON DUPLICATE OCCURRENCE It the if occurrence exist Prompt user option has been set in the Loader options pane a Duplicate occurrence found dialog is displayed whenever the E4F Loader finds a duplicate occurrence during the load process see page 16 5 This dialog window compares the duplicate occurrences involved and the user can then decide the action to be undertaken for The correspondent occurrence to be loaded from the E4F
92. by Day of Week x Distribution of Occurrences Classes by Day of the Week I I Ved Thu Fri Local date 45 Day of week Count of The fle number allocated by the State providing the The Data grid behind the graph Datagrid G Part of the area used to visualize the graph will now be used to display the data grid 14 1 14 2 PART 3 In the data grid the first row and column define the labels to be used at the X axis and the Z axis or Legend Sc oy y F I T yY a if sla a Eg Decimals 0 H pi Not Normalised The white inner cells of the matrix contain the values linked to the Y axis values The data grid s toolbar offers tunctions to process the data retrieved trom the database Reorder labels Filter Sort descending acme fH h g wos fo 8 i he Eee Decimals 0 H pE Not Normalised aa Commands List Remove Column Remove Row Sork ascending Most of these functions will be demonstrated in this chapter User Manual The ECCAIRS Grapher CHAPTER SORTING GRAPH DATA 14 The data grid cells are filled exactly following the output of the database query It is likely that the order in which the columns or rows are presented needs to be moditied to obtain a clearer result To facilitate this it is possible to order the grid based on row and column headers as well as on the cell contents values soe A F bi G v it 3 l E P EB Decimals 0 H pi Not
93. ccurrence f Complete occurences expanded as a text tee H ECCAIRS 4 workspace IMCHexttree tet ore placed a hierarchical tree structure detined by Source f r the chosen view in their Query instrument meteorological conditions expan d e d textua fo rm Find all Occurrences where eather conditions equal to IMC Th e cod ed d ata ba se values of the attributes are not exported C E4F Filename e 18 14 User eee nes wetter Beemen Pecce Pea am 7100001 Libyan Arab J aoa eee not coded M ADREF WIE ad R a 7100005 Switzerland S O e002 i SWTZ inot coded Total 7100066 Germany 19 077 Filter by selection 7100119 United Kingd 19 077 Filer excl selection d 7100125 Yugoslavia F 19 077 d Visible 100220 United Kingd 19 07 D d 7101009 United States 19 07 emove filter il A nuibed li gn E OQ adeg bd Proceed as follows Select the Complete occurrences expanded as a text tree export format in the Destination pane Specify into the Destination pane the full file path and name for the output file by typing it into the corresponding text box or by clicking on the file open icon button to invoke the standard file browse dialog Specify using the Source pane tools either the Query to select the occurrences to be exported see page 18 4 or alternatively the E4F Filename with the occurrences to be exported see page 8 9 tor details Push the Execute button The dialo
94. ces to be extracted from the database 2 Detine the destination tile possibly splitting up the output in multiple tiles Set the logging options Start the generation procedure and exit on completion or Interruption User Manual The ECCAIRS Utilities CHAPTER SELECT YOUR OCCURRENCES 15 The first step to generate E4F tiles is to define which occurrences to extract from the database this means to select and load a query To load a query click on the Load Query button The Query Builder shows up here you can either define a new query or modity an existing query or just select an existing query Query Builder H ECCAIRS4 workspace myquery_library e4g f oj x Library Query Help De dl gt x BR G Refer to section Queries and subsequent in chapter Working with databases page 7 6 and following for details on queries query libraries and ECCAIRS Query Builder Find all Occurrences where Weather conditions equal to IMC Once the query is selected click on the OK button to go back to the E4F Generator main window The same action can be achieved by double clicking on the query to be executed in the Query Builder pane Eccairs E4F Generator x File Help uery jinstrument meteorological conditions i Note that the name of the selected query is now shown in the corresponding text box E4F Generator 15 3 15 4 PART 4 DEFINE DESTINATION FILE The second step c
95. ceueeeeeeaeseueeeeeaess 6 4 Searching for OCCUITENCES ceccececcceecceeeceeneceeneceeneceueeeeneeeenes 6 5 Saving selected OCCU ENCES anda dicaayscndisaminnriindteametent pipnamaneenmaienionaes 6 5 Saving de identitied OCCUIFENCES ccccceeeces neces eeeeeeeeseseeneseenes 6 6 Printing lists of OCCUM ENCES 1 c 5ccccsncacesancentaadesenradinzbosacestashnceades 6 7 Occurrences Recycle Bin cccccccceccceceeeceeeeseseueceseseseneeeeens 6 8 Recycle Bin Usage cccceccc cece cece seeeeee cece seseseeeseueeseeeneseneeas 6 8 Recycle Bin ICAO Cz can suxeoveauesiuecusseniacen E NREN EEREN AE EE 6 9 Fi WORKING WITH DATABASES SIC AE E E E Connecting to a database repository cccceeceeecceeeeeeeeeeeeeaeeens 7 2 Saving occurrences into data bOSeS cccecececee eee seeeseueseneenes 7 4 Generating occurrence files from the database 7 4 Locking and releasing OCCULENCES ccccceccecceseeeeeeeseueeeeeenees 7 5 eT E E E EE 7 6 Query libraries st aaecctess enateen sees cntcomneh aevsisaueanda asta ce uate nooataecseaaees 7 7 QUery Builder sorcerarsrr i iinr vee eens iat erences eee 7 8 Query Explanation Pane ccccccceccceccceeeceueceueeceueesaeseeneees 7 8 Editing query libraries 12x ssacssscudseesnons naenemeanebauhouredeeseannetanssentans 7 9 Creating and editing queries ccccc cscs eceecee eee eeueeeueeseenees 7 10 FATT Uae saree eet sens eis vette E cane eee 7 11 Logical Operil i cntrs
96. cial case in the specitication of date s which offers a Function check box that gives access to a drop down list of commonly used grouping functions to express date ranges Criterion Builder ES Attribute definitions Attribute Occurence hen b Attribute Id a33 Local date Operator equal to ud Value definitions Ask later D Cancel Run time specitied values Parameter Queries Alternatively and for each of the above cases by selecting the Ask later check box the user will be prompted to enter the reference value each time the associated query is executed Criterion Builder x Attribute definitions Attribute Occurence Seventy b Id Injury level Operator equal to Value definitions Ask later F This mode is also sometimes referred to as parameter query Working with databases 7 17 7 18 PART 2 EXECUTING AND REFRESHING QUERIES To execute a query MI Select the query to be executed with the mouse single click and then push the OK button VI Alternatively just double click directly on the query to be executed Query Builder H ECCAIRS4 workspace myquery_library e4g Z ioj x Library Query GDadl gt x ipe i The Count button checks how many i occurrences match the current query criteria without closing the Query Builder Double clicking on a window query name executes the The resulting number is displayed in the query and closes the
97. coded attribute with alternative text or 2 coded attribute with an alternative text proposed as an extension to the taxonomy Here is an example of the attribute columns of the flat format in Excel e D266 W Cloud 0266 VD Cloud 0310 WV 0310 YD amount amount Visibility Visibility amal 1 oky clear 1200 1200 rm 2 Few clouds 1 o 2 0 400 400 m 400 400 mi m 400 400 mi 4 Overcast 1200 1200 m 5 oky obscured 1200 1200 mi 5 oky obscured 400 400 m 5 oky obscured 3200 3200 m 3 Broken 5 5 to 7 5 3200 3200 m 4 Overcast 1600 1600 mi 5 sky obscured 1200 1200 mi 4 Overcast 1600 1600 mi 4 Overcast 1600 1600 mi 5 sky obscured OU m Jal NOT ALWAYS A SINGLE ROW PER OCCURRENCE Depending on the nature of the attributes exported there might be more than one row for each occurrence For instance when exporting the aircraft model if there are two aircraft involved in the occurrence two rows will be produced where the first five columns identifying the occurrence will be in any case identical Exporter 18 11 18 12 PART 4 EXPANDED ATTRIBUTE FORMAT The second table generated by the text Access or Excel export options contains the occurrences and selected attributes in expanded format Each row will include data related to each attribute to be exported Its first four columns contain the following tour values KEY Where KEY SFNR V SR V SR VD SFNR_V SR_VD Occurrence signature a code uniquely identif
98. currence class attribute shown here on the left So there might different levels of value specifications Sipma D ccident oo Serious incident be A iiaia ncident By default the Occurrence list pane displays the most detailed i e lowest level attribute value specified It is however possible to define any specific attribute value level to display by right clicking within the column customisation pane after selecting an attribute Columns customisation The file number allocated by the State providing the report Occurence 438 Report identification Occurrence 453 The identification of the State that supplied the report Occurence Occurrence class 454 State or area of occurence 440 Location of occurrence 433 Local de 477 uTCdat The specific value level to display for each multi level valued attribute can be selected Customising the Browser CHAPTER D 0 9 Most of the attributes in clued in Filing information section are automatically excluded They are greyed out in the left pane 0 6 PART 2 DEIDENTIFIABLE ATTIBUTES The Deidentifiable attributes tab pane allows to specify the attributes to be excluded when saving de identitied occurrences see page 6 6 The View Definition drop down menu allows to chose the specific view and its associated hierarchical tree structure View Definition MYADREPVIEW Latitude of oce Location of oce
99. d or to identity trends Access to a larger database would certainly improve the quality of the safety information Most aviation authorities in the EU have in differing ways collected intormation about aviation incidents and accidents Since these authorities had proprietary data tormats electronic or paper based mutual access to information was almost impossible To improve this situation the European Commission started ECCAIRS European Co ordination Centre for Aviation Incident Reporting Systems The objective of ECCAIRS is to contribute to aviation satety through early detection of potentially hazardous situations in an integrated EU wide collection of incident and accident reports ECCAIRS overview 2 1 PART 1 ECCAIRS NETWORK STRUCTURE At the heart of the ECCAIRS network an intormation system integrates disseminates and assesses data and intormation at European level At the other nodes the national Civil Aviation Authorities and or Accident Investigation Bureaus of the EU Member States data is collected and assessed locally Because of the compatible data tormats Member States can mutually exchange data on a peer to peer basis Information in the network remains property of the contributing organisations also when integrated in the central database ECCAIRS DATA TOOLS The ECCAIRS reporting system a tool made available free of charge allows the EU authorities to collect and exchange intormation on occurrence
100. d the tunctions related ie a a Grid displays a vertical to the grid of numerical data and or horizontal grid in the laying beyond the graph are graph dealt with in chapter 14 Y a SB ke amp H stl ow G7 A Zoom zooms in and out selected areas of the graph drag the mouse to define area Scrollbar adds horizontal and vertical scroll bars Done automatically when the graph exceeds the window display Graph Save Graph The same functions are also available in the Save Graph As Graph menu of ECCAIRS Grapher Save Graph 4s Template W Save to Clipboard g Print ELL vertical Grid Eira Legend a 20 E Rotate 0 Z Clustered A Font A Properties EBB Datagrid Ei 200m aj 3 Scrollbar 13 12 User Manual OTHER GRAPH LI The ECCAIRS Grapher BRARY FUNCTIONS The Graph Library functions that have not been introduced or used in the previous chapters of thi s manual are listed below associated to the corresponding Grapher toolbar items Delete Graph remove the selected graph from the library Cut Copy and Paste cuts copies and pastes graphs in the graph library Some Edit menu items in the Grapher also allows to rename graphs and change the icon associated Export exports to a new or existing library the graph s selected Import imports an existing library into the currently opened library If the selected Library contains a Graph wi
101. d you can set options in the Logging options pane vl All generates a log file that will include all the events Choosing this option may increase signiticantly the size of the log tile M User feedback Errors only generates a log of just user feedback and errors This option is enabled by default and is an alternative tor the All option enabling one disables the other Vl Append Date Time stamp to LOG file name automatically appends to the log filename the date and time the file is generated This option in enabled by default M Browse allows to specify the log tile name by typing it in the appropriate text box or interactively by browsing your system tiles LOG FILENAME IS MANDATORY WHEN LOGGING IS ENABLED If logging has been enabled as Peaona pion M Log Activity C Al i it is by default it is then x mandatory to specity the log file name either by typing it in the IN Please insert a LOG File name appropriate text box or though Start Pauze the Browse button ny Dre 16 6 User Manual The ECCAIRS Utilities START THE LOADING ae As soon as the input E4F files have been defined the Start button on 6 the main window becomes IY Log Activity Al i User feedback Erm enabled H MECCAIRS 44 workspace ed floader lag tet To start the loading process click on the Start button During the subsequent processing Vl The Pause button and the Stop button become enabled MI An Elapsed processing time
102. database him rif In the template document special Data Tags are placed at convenient places During the exporting process the content of each occurrence in input is fed into the template document The system interprets the Data Tags and substitutes them with the appropriate values taken from each occurrence In order to manage the hierarchical structure of the occurrences some special Control Tags are also defined and take care of producing loops and conditional formatting User Manual The ECCAIRS Utilities Full details and instructions on building and using template tiles are eae ee given in an specitic ECCAIRS White Paper available on Internet at 1 3 ECCAIRS web site http eccairs www rc it To export using a template proceed as follows 1 Select the Occurrences formatted according to a predefined template export format in the Destination pane 2 Specify into the Destination pane the full file path and name for the output file either by typing it into the corresponding text box or by clicking on the tile open icon button to invoke the standard tile browse dialog 3 Specity using the Source pane tools either the Query to select the occurrences to be exported see page 18 4 or alternatively the E4F Filename with the occurrences to be exported see page 18 9 tor details Occurences formatted according a predefined ter H MECCAIR S 44 orkepacelhC_htril_ template htr pE Source f Query instru
103. described in the identitication pane right pane by v Id the attribute identification number in the taxonomy M Short Description M Description v Definition M Properties Dictionary Browser Ioj x File wiew Definition Help My ADREP VIEW Occurrence ort L escriptor siete 431 Occurence class i when Description E wi here Oecunrence class BS cocurence class Bises Oecurence category Deni FS eye ee r ae ee i Attributes are The classification of the occurence in relation to its FT relation marked with Ml arrative baad black Mandatory Ho an Events Multiple Yalues No Text Alternative Ho Propose Text Ho Format List Code Operators equal to hot equal to seen Separation mE Weather l Aireraft Ha Aircraft identification wee Aircraft Operation none equal to Aircraft description has value has no value has at least one of doesn t have any of 7 keen Aircratk status The Properties Pane lists all the attribute properties and values such as operators applicable in a query for example equal to or value format tor example long integer measurement units usable to specity a value etc User Manual The ECCAIRS Utilities The attribute Id can be used in all ECCAIRS applications needing to e create and edit queries or to specify attributes Browser Grapher 1 Generator to directly select an attribute in the taxonomy tree by typing in its identifier Criterion Builder x
104. e document Printing and other utilities CHAPTER 10 10 3 Print The standard Windows print dialog is invoked so that any other installed printer can be specitied beyond the default ECCAIRS printer proposed as pre selected choice before actually issuing the print command with the Print button 10 4 PART 2 PRINTING OCCURRENCES Occurrence New Duplicate Occurrence Edit Delete Lock Occurrence Release Occurrence 1006 The menu bar item Occurrence gt Print allows to print all the occurrence sections that have been filled in for the currently selected occurrence The same tunction can be invoked by pushing the print icon button in the toolbar The detail level of event descriptions both to be printed and displayed is customisable see page 5 4 HEIEK in DOENGESSSS TAU wi Te T Flight plan Pile light tuk Piba tric ypt Plight l n type Flight vad al fucka Adla Qloared Ma ques bet Ce orditanled nin Ce ordirarled exit Wreckage poaljor Frici igo k iHi Dislaree fhreshcts Hearing Pay hearing Lesmal cen aero Leculicn along Langth WE ci ige trail Tarain at wreckage Termin amp pe Elevalicn lertain Rocovery of arora Ale Penman shah Graand imped Epos at impact Caan amp pod limpet argit lipidi angle pee Pe Flight crew member Age Might creme Gender Nighi tree Flight araw aparenta Th Akcii type All pti Wael gel i Curren Nigel ruben Cut
105. e World Wide Web http eccairs www jrc it This manual has been printed on October 2005 CONTENTS PART ECCAIRS REPORTING SYSTEM 1 Document CONVENTIONS ccccccceccecccecceecceeseecueeenens acd 2 ECCAIRS OVS GW tet nesesntcs nes none Sasa dcie nocnanuateeneses 2 1 3 Running ECCAIRS applications cceecceeees 3 1 PART 2 THE ECCAIRS BROWSER 4 Exploring the BrowSelr ccccseccecceeeeueceeeeseseneeseenes 4 5 Customising the Browser ccccccceceeceeeeseseueeeneeaees 5 1 6 Working with the list Of occurrences 6 1 I Working with databases cccceecceeeceeeeeeseeu secu seenes 7 1 O Working with occurrence files ccccceecceeeeeeeeee seen es 8 1 9 Editing OCC Ue GC oasccetuaecuaresrndateieeenernsuiaror nae 9 1 1 0 Printing and other utilities 10 1 User Manual Contents PART 3 THE ECCAIRS GRAPHER 1 1 Creating graphs with the ECCAIRS Grapher 11 1 1 2 Setting the graph properties ccccceeceeeees 12 1 1 3 3D graphs and other functions 13 1 1 4 The Data grid behind the graph PART 4 THE ECCAIRS UTILITIES 1 5 EAF CONOR GION srneeres ari rar snas EEE 15 1 1 6 Er LOGGET casetantanenmesanscacneteneseannteastnacncienest 16 1 1 I Dictionary Browser ata ce cerenwrasanehenioendeatamenainsens 17 1 1 O 010 OT Gee eee E R 18 1 At the beginning of each part there is a local detailed Table of Contents vi User Manual User Manual Contents v
106. e name Browse Start Pause Stap Exit Loading one or more E4F file into a database is a tour step procedure that will be illustrated in the next pages 1 Select the E4F files to be loaded into the database 2 Detine the E4F Loader options mainly regarding what to do when duplicate or invalid occurrences are found Set the logging options Start the load procedure and exit on completion or interruption User Manual TA l The ECCAIRS Utilities SELECT YOUR E4F FILES The first step is to select the E4F files you want to be loaded into the xl Remove database Click on the Add button to add new E4F files A standard Windows open tile dialog will be displayed allowing you to select one or more EAF files Look in E workspace a E Desktop My Documents a Ky Computer as H ai ork File name Files of type ey m F my EDF fe EAF IMC_occurences E4f Eccairs 4 Data Files Cancel Zi Once selected all tile details are presented in the top pane of the main window including the number of occurrences of each file Click on the Remove button to remove the curently selected e4f file ae from the list Y a h MC_occurre 2h my EDF file ee options Modified Occurrences c Path 479KB 13 01 2004 18 40 H SECCAL 43 KB 10 09 2002 10 4 H SECCAL Remove Clear Click on the Clear but
107. ect the required occurrences ae and select File gt Send to menu item and Bees the target in the sub menu Close v E mail see page 10 5 v File Refer to page 8 1 v Database see Page 7 4 for details on E4F gt q Recycle Bin E mail File Database H ECCAIRS4workspace new_EDF_File E4f H ECCAIRS4 workspace sample E4f Print Occurrence List files Exit If File is selected a standard Windows browse dialog is displayed to choose the target tile and folder The file can also be saved in compressed format see page 8 5 Working with the list of occurrences 6 5 6 6 PART 2 SAVING DE IDENTIFIED OCCURRENCES File gt Send deidentified to menu item allows to export de identitied occurrences into a new E4F tile This means that a number of specitic export attributes will be lett out during the save phase File Pane a The selected occurrences properly New de identitied can be saved in Open T different places according to the Save as specific the sub menu item selected Close ae v E mail Send deidentified to see page 0 5 for details Recycle Bin lV File Pring Occurrence List Hi ECCAIRS 4 workspace sample E4f Exit In case File is selected a standard Windows browse dialog is displayed to choose the target file and folder The file can also be saved in compressed format see page 8 5 My Computer A as File
108. ecting Database gt Refresh Query menu item will re Refresh Query run the last query ran on the database Next Batch SHOW CURRENT QUERY A text window with a natural language explanation of the currently TEA selected query may be recalled selecting Database gt Show current Query menu item or the corresponding icon button on the toolbar Build Query Query by date a T Query k i The same information is shown in the Query Explanation pane of the Query Builder dialog window see page 8 S The same function is available in other ECCAIRS applications which involve queries e g ECCAIRS Grapher and ECCAIRS Exporter Working with databases 7 19 The first choice of Q the drop down list a blank field corresponds to a default select all query built in the year month plot itself i e not taken from the current query library 7 20 PART 2 QUERY BY DATE YEAR MONTH STATISTICS The ECCAIRS Brower provides the facility to sort and plot the occurrences selected with a query EES in an year month table Proceed as follows Build Query Query by date Show current Query Next Batch Select the Database gt Query by date menu item The Query by date dialog opens Query by date Select a query among those listed Based on query DATA of Canada in the Based on query drop down A a list The list includes all the queries within the cu
109. ecting File gt Printer trom the menu bar and choosing it in the dialogue displayed Set default Printer File i Import iW Export Printer 1HAECOATO CA wale seat raulihr sru sda aar nt a eo e z Damu af Decane Cias by Day of tte Hei Eccairs Grapher Class Distribution by Day of Week Distribution of Occurrences Classes by Day of the Week mibe aocated by ihe State prowidhng the report tis nuy Count of The Thu Fri Lon date As Dey of week nd af Dooureices where Tie Tie number alhocated by ihe Sate prosideeg ihe report has vae 4 nee oe Local date As Day of week order Aacending md Count of The fil number alocati by hie 51 B ponding h pon d Arct wg and Occurence dest oder User Manual The ECCAIRS Grapher COPYING AND PASTING THE GRAPH The graph can also be copied to the Windows clipboard and pasted to any other application accepting bitmap graphics graphs are copied to the clipboard in raster format EFEX To copy the currently opened graph to the E Save Graph clipboard select Graph gt Save to Clipboard Save Graph As from the menu or the corresponding icon trom the toolbar Save Graph 45 Template Save to Clipboard It is now possible to paste the graph in another application for instance Microsoft Word H Document Microsoft Word Eile Edit View Insert Format Tools Taple sosunu sear et Normal Times
110. ed is maintained Related topics e Release Notes e Starting the E4F Generator The ECCAIRS Utilities a About displays information about the software version in use and can give access to the system information on the computer where ECCAIRS is currently running through the System Info button Eccairs 4 Grapher l alasan i my r elease 4 Eccars 4 release 4 2 Revision 6 Build 40 of 26 Oct 2005 Eccare 4 Grapher 4 2 502 The ECCAIRS reporting system is a set of tools that can be used to collect exchange and analyse aviation related accidents and incidents The system implements the ADREF 2000 standard taxonomy as defined by ICAO for storing information in its repository Warning This computer program is owned by the European Commission Ibis protected by copyright law Mon EU aviation authorities and other organisations interested in using ECLAIAS should System Info contact the JAC Eea ea Contact us Select OK to close this window E4F Generator CHAPTER 19 15 9 The ECCAIRS Utilities WHAT IS THE E4F LOADER The E4F Loader is a tool used to load ECCAIRS 4 Data Files E4f in a repository s database EAF tiles can be used to store exchange and backup occurrences in an ECCAIRS repository Though it is possible to manage ECCAIRS occurrences trom within the ECCAIRS Browser application in many cases using the E4F Loader is more efficient more clear less likely to gene
111. ed see note box below Clicking on the Exit button will return to the E4F Loader main window Eccairs E4F Loader l i x Summary Upload status Completed With warming errors Time elapsed 0 37 Count Total Processed Accepted Rejected Files Records Logging JH SE CCAIRS 4workspaceediloader log tet View The Summary pane displays v The Upload status at the end of the process v The Time elapsed for processing v A Records count i e an overview of the total number of occurrences processed accepted and rejected In the Logging pane the name of the log tile generated is shown see note box below Note that choosing the All option may increase significantly the size of the log file WHEN IS THE LOG FILE ACTUALLY GENERATED Note that clicking on the View button actually opens the log file only if the tile has been generated i e the log output was non empty If the All option has been specified in the Logging options pane of the main window then there will always be something to write to the log and so the log file will always be generated If the User feedback Errors only option has been specified the log file is generated only if errors or warnings were generated during the processing 16 10 User Manual The ECCAIRS Utilities E4F LOADER MENU BAR ITEMS The E4F Loader has a menu bar with two menus File menu The File menu has a single item Exit to quit the application when selected
112. edsbicustdvetmveuass 3 4 PART 1 Table of Contents ECCAIRS Reporting System 1 DOCUMENT CONVENTIONS MANUAL ORGANISATION This user manual is organised as a reference to the functions included in the ECCAIRS Reporting System software Here and there we also suggest or demonstrate exemplary actions useful to explore system capabilities and options The exemplary data sets and samples used are not real and this manual is intended only to demonstrate the usage and user interface of ECCAIRS client software Beyond this manual there is the Software Installation Manual aimed at the system administrator and a number of white papers and technical support documents available on the ECCAIRS web site This manual is divided into several pars the first introducing the ECCAIRS Reporting System itself and all the other dealing with its main applications and utilities smaller applications Each chapter within a part is dealing with a specific set of program features Chapter numbers are shown in red in the upper right corner of each odd right page and as first figure of the page number Each chapter is in turn divided into sections organised as a one rarely two page self standing unit of information auxiliary TYPOGRAPHICAL CONVENTIONS The following typographical conventions are used gt Blue and Bold to indicate selections e g buttons or menu or menu items specitic dialog window names or simply other important text to
113. een changed Do you want to save the changes The same applies to graph libraries see No Cancel related bottom picture on the right 12 10 User Manual The ECCAIRS Grapher CHAPTER 12 Setting the graph properties 12 11 The ECCAIRS Grapher 13 3D GRAPHS AND OTHER FUNCTIONS CREATING ANOTHER GRAPH In this chapter we will extend the sample graph built in the previous chapters to include a third dimension by further distinguishing between the class of occurrences accidents incidents fe First open the previously detined graph z 2 Connect in the main Grapher window select File gt Open Library or push the Open Library lt E eed open library icon in the toolbar Save Library 4s es In the browse window displayed locate i Close Library the destination workspace folder you wish to use and select the previously saved graph library see page 12 10 Contirm by pushing the Open button pivEccairs Grapher eee File Edit Graph Options Window Help accessed graph Cela M K t aQa Sl oa Se libraries up to 4 H ECCAIRS4 workspace mylibrary e4g can also be quickly G The previously opened by selecting them directly among the Most Recently Used file list in the lower part of the File menu Occ Distribution Now inside the library window displaying the graph library select the graph Occ Distribution by Day of week and press the Open
114. ences or all those selected in a layout similar to the occurrence list itself Each occurrence gets printed with its main attributes i e those listed in the tirst columns of the Occurrence List pane The choice of attributes tor columns to be both displayed and printed is customisable see page 5 4 Working with the list of occurrences CHAPTER 6 If there are too many attributes selected some of them will not be printed because of the limited print line length available 6 7 The Recycle Bin is enabled by default within ECCAIRS Browser However it can be disabled and re enabled within the Recycle bin dialog Options tab PART 2 OCCURRENCES RECYCLE BIN Deleted occurrences are automatically stored in the Recycle Bin see side note In case of need it is possible to restore occurrences in the currently open file or export them in a new E4F file To open the Recycle Bin select the File gt Recycle Bin menv item This will display the General tab of the Recycle Bin dialog with the list of occurrences that have been deleted organised in delete batches Recycle Bin usage It is possible to customise the view of deleted occurrences by selecting occurrences deleted Between a defined time interval rather than ey Options All in the View pane Yem E Between 200509722 and 200smana The upper list white background lists the delete batches i e the list of dele
115. ents 2 gt Failures History of flight State area Switzerland Latitude Injuries Location Longitude Q0 Aircraft recordings amp Aircraft meteo r Classification za CFIT Occurrence class Serious incident FEl Fire EA Survival Occurence category amp Ditch Air traffic services di WWreckage impact S it Flight Crew aiba Member Damage aircraft None Damage aerodrome None Other Personnel Third party damage No Injury level None Member B Sector r Injury totals Z Aerodrome Fatal Serious Minor None Unknown Total Narrative Total on ground el Total on aircraft a Lf of Grand total gt 0 E TOPIC DATA PANE hosting the topic data organised as attribute values grouped in sections TOPIC TREE PANE hosting the topic hierarchy of the occurrence The intormation is structured as a topic hierarchy where each topic is represented by an icon on the left sub pane Information related to and determined by any aircraft or ATS unit is located in the appropriate corresponding hierarchy tree branch In the topic tree M Separate aircraft branches in the occurrence structure tree may be used when more aircrafts are involved in an occurrence The same applies in case multiple ATS units are involved M Multiple narratives i e using different languages may exist and are displayed as multiple nodes in the occurrence tree Exploring the Browser CHAPTER 4 Some other specific views use instead a s
116. er application usage of the E4F Generator is mandatory when you migrate trom one version of ECCAIRS to a newer version of ECCAIRS and the data format and or data taxonomy has been changed In this case passing your data via an E4F file guarantees you that all appropriate conversion and adaptation is performed The E4F Generator has a peer utility called the E4F Loader which has the opposite functionality namely storing occurrences from an E4F file into an ECCAIRS repository database see page 16 1 E4F Generator G It is important to know that the E4F Generator always respects the security settings of the repository s security profile so that confidentiality if applied is maintained 15 1 15 2 PART 4 OTARTING AND OPERATING THE E4F GENERATOR Start the E4F Generator by selecting Start gt Programs gt Eccairs 4 gt Tools gt E4F Generator from the Windows task bar and performing the standard ECCAIRS logon see page 3 2 its main window will show up Eccairs E4F Generator q x File Help RUErY Load Query Destination Browse M Split destination tile when it reaches fi 000 Occurrences Logging options M Log Activity All User feedbackErrors only V Append Date Time stamp to LOG tile name Browse Start Fause Stop Exit The approach for generating an E4F tile trom a database consists of four steps which will be illustrated in the next pages 1 Select the occurren
117. exist within other applications e g Exporter page 18 4 7 7 PART 2 QUERY BUILDER Selecting Database gt Build Query from the menu bar or the corresponding icon button in the toolbar the Query Builder dialog window will be displayed Query Builder H ECCAIR S4 workspace myquery_library c4q o x Library Query EE SST Ged r a ABA QUERY BUILDER MENU BAR AND TOOLBAR D QUERY LIBRARY EDITING PANE QUERY EXECUTION AND CONTROL PANE Find all Occurrences where The file number allocated by the State providing the report has value QUERY EXPLANATION PANE It a query library has been previously opened it is automatically re opened Alternatively a new empty library is implicitly created and opened The menus and toolbar items allow to pertorm v Query library editing see page 7 9 M Query editing see page 7 10 v Query execution see page 7 18 Query Explanation pane The Query Explanation pane displays a natural language explanation ot the currently selected query The same intormation can be shown without having the Query Builder dialog open by selecting the Database gt Show current Query menu item of the main Browser window see page 7 19 USER MANUAL The ECCAIRS Browser EDITING QUERY LIBRARIES Query libraries can be edited in the Query Library Editing pane using M The Library and Query menus and the Right click menu M The toolbar icon buttons Quer
118. fault attribute values if any has been defined and saved as template see page 10 7 The user can also set ECCAIRS Browser to show all the nodes in the topic tree also if empty see page 5 2 PART 2 THE OCCURRENCE EDIT WINDOW aw Occurrence Occurrence File View Headline When Narrative Mote Events Separation Weather Aircraft Aerodrome Airspace 475 Unit Recommendations Remove current topic Events Failures History of Flight Injuries Aircraft recordings Aircraft mekeo FIT Fire Survival Bitch Air traffic services Wreckage impact User Manual Filing information State reporting State file number Local date Local time An Occurrence Edit window is opened both when creating a new occurrence and when editing an existing one The Occurrence Edit window is based on the Info pane of the main ECCAIRS Browser window However it is a separate independent window and thus co exist with the main window To fill in data for an occurrence first define the first level topics by M Selecting the top root Occurrence node v Then choosing the topic to be added trom the right click menu To add further level topics to a Ist level one select it and again choose the topic to be added trom the right click menu Once the occurrence tree leaves are reached it is possible to fill in attributes within the sections of the Into pane Reter to the
119. file database is displayed on the right The duplicate occurrence each case already existing in the database is displayed on the lett Duplicate occurence Found Existing Hew Oecurence signature identical identical State file number jroo Moon State reporting Switzerland Switzerland Date entered haoz ae Date last modified 202A17061618 o Aeee Hippi to all items Only If Newer Overvarite Keep Insert as new Cancel The uniquely identitying attributes see page 16 5 having identical values are highlighted with a yellow tield background All the 3 identitying attributes are duplicated in the picture shown above The Apply to all items check box when selected allows an automatic re application of the action associated to the button being selected to all the subsequent duplicate occurrences possibly detected The buttons at the bottom allow to select the action to be undertaken MI Only if Newer If the occurrence from the E4F file has been moditied at a more recent date than the occurrence in the database then replace the corresponding occurrence in the database by the one trom the E4F tile M Overwrite The duplicate occurrence in the database is removed and the new occurrence from the E4F file is inserted v Keep The occurrence trom the E4F file is ignored and the occurrence in the database is retained M Cancel The Loading process is stopped and the tinal overview window see
120. fill a preliminary report focused on flight operations information ATM PREL ADREP PREL ATM PREL The ATM Preliminary view is a quick way to fill a preliminary report focused on ATM specific type of information A Th PREL PART 2 ATM view The ATM view focuses on the Air Traffic Management issues of the occurrence using a compound tree amp data display for the information pane Argentina 7100228 p Fiare ineen Herrira Shale repeving r ii Dye entered TT Me Shate fle number Tiea Fleporting g ARGT ret coded aie Local date TOBA UTE date Local ime 10 UTE time yp Where Sisto as Fugentrus Lotituaiies HM South Lissar SAN JUSTO Loirg 5a 36 Eat r liria Oecutence cla Ireber Dotun cabapiy arai aaa Mira Danag siidrit T Fard ganat clingy Iry levered Honi Inguny totals Fatal Smt Min Newer i Total Total on ground a a i a Talal ori amarah a i a i xj tered balal a i a i a x ATM Preliminary view The ATM Preliminary view is a reduced and simple view tocused on ATM specitic type of occurrences with the information condensed and shown in a single pane The preliminary report produced using this view can be used later to fill in the detailed report at a later time in the full ATM view The Occurrence Window Snapshot feature see page 9 12 might also be useful for this purpose Argentina 7100228 p Filing Informations Stale reperting Argentini leidis Shae f nuir Pia Repo
121. g window that shows up displays the list of the occurrences The View Definition drop down menu allows to chose the specitic view and its x associated hierarchical tree structure By right clicking on one of the columns it is possible to turtherly restrict the occurrences to be exported by applying a filter on the corresponding attribute Manual The ECCAIRS Utilities 5 To proceed with the actual exporting click on the Continue ala button 1 3 UNST inotcoded J Cancel In the picture below a sample of the text tree output file using an ADREP 2000 view is displayed F IMC texttree txt Notepad gq 5 x File Edit Format Help F Libyan Arab Jamahiriya FLoOoooL Filing information Roan ae org LIBY not coded state Tile number 710000l State reporting Libyan Arab Jamahiriya Date entered 19 07 7 2002 Local date 02 01 1971 Local time 2 25 00 Location of occ TRIPOLI INT L State farea of occurrence Libyan 4rab Jamahiriya Classification occurrence class Accident occurrence category CFIT Controlled flight into or toward terr seyerity Injury level Fatal Damage aircraft Destroyed Injury totals Total fatalities a c 16 Total fatalities 16 Total injuries 16 Total injury aircraft 16 harrative Cenglish Narrative Narrative text THE A T WAS ON AN ADF FINAL APP AND STRUCK THE GI Narrative language English WWEVENT S Events Event Type Aircraft operation gene
122. graph The Data grid behind the graph CHAPTER 14 a Commands Lisk The command list is saved with the graph So remind that if no explicit saving of the graph is made by the Graph gt Save Graph gt Save As etc all changes to the graph and to the command list will also be lost 14 13 The ECCAIRS Utilities PART 4 THE ECCAIRS UTILITIES 1 5 E4F GENERATOR What is the E4F Generator s sssssssssisssesrsrrrrsrrrrsrrererrerrerrere 15 1 Starting and operating the E4F Generator 15 2 Select your ole 16d c 961 lt ce ee ee 15 3 Define destination TG soiceiscsrcdeyauseiduocdiwducaw Sicueenstensaniwsndwedenivess 15 4 Define logging Options accsocncticendnaneusiueeansroimetoenemenenaiaaetiweds 15 5 Run the generation cassacnasse sco vectnsentnsensieraassehandeetansentnrveiearivnss 15 6 Generation result SUMMAN s ss ssssssissrssrssrsirsrssrsrreresrsrrsrrere 15 7 E4F Generator menu bar items ccccccecce cece eeceeeeeseueeneeenes 15 8 1 6 E4F LOADER What is the E4F Loader as sont acest ees cnatacetietcsectestasaenenteninsesen 16 1 Starting and operating the E4F Loader 16 2 Select your E4F files ox cneras cp ictearteseu cas Gtasnessintene aden dsiesatessersacecees 16 3 Define E4F Loader options xc scsccsssacezeanrataedaseatonencntesaomatanters 16 4 Duplicate OCCUrrencesS cote eee nn eaten en eee mere ee ere 16 5 PS Tie logging Options sec okesceee hata cucu ne iiini an E Eie 16 6 Sar WAS
123. gt most recently used menu items are used to open previously saved ECCAIRS export configuration files The File gt Save and File gt Save as menu items are used to save the current configuration into ECCAIRS export configuration files File JEW Open Save Save a5 Execute HiECCAIR Wexporter File sampledl ede The File gt New menu item does not actually create a new contiguration file but rather cleans all the current contiguration items form the Exporter main window i e choices file names queries attributes selected etc Exporter 18 23 PART 4 THE EXPORTER HELP MENU The Help menu has three items Help Contents F1 Dictionary Browser bout vI Contents Fl invokes the standard Windows help support This support can also be started by the F1 keyboard key a e gt amp Hide Back Forward Print Contents Index Search About ECCAIRS 4 E ae Release Notes Ee Starting the Application H Using the Application The ECCAIRS 4 Exporter is an ECCAIRS utility m i ECCAIRS Query Builder variety of diferent formats respecting the secu repository Itis Up to the user ofthe Exporter to determine of some possible usage are Creation of proprietary customised repre Analysis of sub sets ofinformation in 3 Free text searches on all attribute value Passing information to users of non co Creating de identified E4F files ECCAIRS 4 Exporter make use of
124. h teature controls will not be described but they are reasonably selt descriptive so we just show them below and encourage the user to experiment General cale cener spat Labels Grid lines Gene Ii Scale pbs Grid lines X Axis IV Visible X Axis Major unit Auto I Show gridlines ee fi Maximum 100 Tick mark type C None Outside Inside Cross Scale unit Poo Format None Minor unit Auto I Show gridlines aE pieces TEE Tick mark type C None Outside Inside Cross J Logarithmic scale IV Zero line Cancel Apply Help Cancel Apply Help Labels Grid lines General Scald Labels Gfid lines General Scale Labell Grid ires X Axis X Axis Fiati M Show labels Major gridlines Minor gridlines 7 2 Levels I Rotate with chart Color x Color CE Style Style Weight v Weight m a Degrees 4 Text IV Align with labels me I Interlaced Local date As Day of week a Cancel Apply Help Cancel Apply Help Setting the graph properties 12 7 12 8 PART 3 SAVING THE GRAPH AND THE LIBRARY Applying chart settings The Apply button of the Chart Properties window is used to contirm the choices without closing the Properties dialog The OK button also confirms the choices made but closes the Properties or Axis Properties dialog window I Sample Weight 7 Cancel Apply k Help
125. he ECCAIRS own taxonomy The ECCAIRS Browser CHAPTER EVENTS OPTIONS 5 The Events options tab pane allows to select the display a short or detailed description for attributes and values used within the events topic By default the Detailed description is selected Appearance List Deidentifiable attributes Events options External Page setup Viewer Editor Report Description type Detailed Detailed Detailed The choice of display short detailed descriptions of events is made separately for the three main display modes Viewer chapters 4 to 7 Editor see page 9 6 Report see page 10 1 Restore defaults Cancel Selecting a Detailed description for attributes and values in the events topic will produce descriptions like Events Undershoot during Final approach Aircraft SU ALG seenen Flight crew s interpretation of the instrument flight rules procedures Improper use ae Flight crew s operation of altimeter Incorrect setting Atmospheric restrictions to visibility Present Selecting a Short description will instead produce descriptions like Ue eet values and related short and detailed descriptions can be looked up using the Dictionary Browser see page 17 1 Customising the Browser O 0 8 PART 2 EXTERNAL API PARAMETERS The ECCAIRS Browser can interface in various ways to external proprietary sottware modules and applications On this form the
126. hich IS not the result ofan ATC insituction Value tool tios are invoked by holding down the CTRL key while clicking on the attribute value in the value tree pane Criterion Builder x Attribute definitions Attribute Oecurence l Classification Attribute ld 0431 Occurence class Operator equal to se a definitions Ei Classification ey k po OS Dictionary Browser CHAPTER 17 Selecting a value is done in the Browser in edit mode and with queries and in all the ECCAIRS applications allowing to edit a query hence specifying a value definition i e Grapher Exporter E4F Generator 17 11 17 12 PART 4 VIEW DEFINITION FILE AND HELP MENUS The Dictionary Browser has a menu bar with three menus Vew Definition menu The View Definition menu allows to select the appropriate view over the occurrence data structure trom those available in ECCAIRS 4 for display and browsing in the Taxonomy Tree Pane see page 4 4 view Definition The view selected either by default or by user Ui HEHA MEW choice on the menu is marked with a leading tick MY ADREF PREL VIEW A i E sign in front of the corresponding menu item MY ATM PREL VIEW The name number and actual definition of the views as well as their order in the menu may vary according to specific settings in the Repository the user is connected to The default view used in the Taxonomy Tree Pane is the first view i e the
127. ibute as stored in the ECCAIRS Repository optional Attribute Value Type O coded attribute 1 coded attribute with alternative text or 2 coded attribute with an alternative text proposed as an extension to the taxonomy Attribute Value Description the expanded readable version of the attribute value as generated by the installed version ot ECCAIRS optional The measurement Unit in which the attribute value is expressed Here is an example of the additional columns of the expanded format Attribute Attribute Attribute Attribute Attribute nit IL Description Value WaluelType YalueDescriptioa i z266 Cloud amount 0 Sky clear 310 Visibility 1200 0 1200 rm mi z266 Cloud amount 2 0 Few clouds 1 8 2 310 Visibility 400 0 400 m mi 266 Cloud amount 0 310 Visibility 400 0 400 rm mi bb Cloud amount 0 310 Visibility 400 0 400 rm mi bb Cloud amount 0 310 Visibility 0 mi bb Cloud amount 0 310 Visibility 0 mi 266 Cloud amount 4 A 4 x O Overcast S Exporter CHAPTER 18 4 In the expanded format you will see almost always more than one row per occurrence since there is a row for each attribute exported To fully appreciate the export formats it is best to experiment with various queries and analyse the results 18 13 PART 4 EXPORT OCCURRENCES AS TEXT TREE The text tree export format generates a single output file where the attributes of the o
128. ii PART 71 ECCAIRS REPORTING SYSTEM 1 DOCUMENT CONVENTIONS Manual organisation cccccccceccs cece eeeeeeeeseu ees seueeeueeseeeneeeeeaes 1 1 Typographical CONVENTIONS secssinsvccnsansinsirncessurseorevnsatinsenssnewenads 1 1 2 ECCAIRS OVERVIEW ECCAIR O OCV Y aeea i N T 2 ECCAIRS network structure c cccscecececcececececesceceencuseseeenecuees 2 2 ECCAIRS data tools 20 0 0 ccececececceeececcuceeeececucusateectcusaeavenenens 2 2 Assessment of data collected cceceecececcececeececuceecuceseeceseees 2 2 Occurrence reporting System srancdecasenucseesd eioncharisiagudsenuenconeseaues 2 3 BG GIR DROW GO ocicaccasctccsteceast aunt EERE ENOTE 2 3 OO Noe CE clo glo gear aren ete ere ernest nen EAE 2 4 ECCAIRS Utilities eateries tea ect dais sacuaeseucancceenedos 2 5 ECCAIRS occurrences cececececececcctcteeeeeeecececsceesereeetcesesees 2 6 ECCAIRS repositories cicuscsvasearennentressaneatountuesssatusavere se ninuisess 2 ECCAIRS TOXONOMY soscsnc iene eanan ceca eeana tates daaeuewieaetndenant tea ease 2 8 ECCAIRS topics sections attributes and ViEWS c0ccseeeeeeee ees 2 9 3 RUNNING ECCAIRS APPLICATIONS The applications SUITE 0 cccecc ccc eccceeeceeeeeeeeaeeeueeeeseaeeeeenees 3 1 Starting an application seanesnsvrecqescscene eerie dessnpe ano setesnadeniesteuedses 3 2 Changing the logon password ges petetee cece oars 3 3 Finding a repository lt nccxsesadesutwenctcunddvatitsrunsexdensev
129. il cece ceccceeceeeceueeeceseeeeeeaees 10 5 Finding definitions and descriptions ccccesecceeeeceeeseeneeeenes 10 6 Occurence Tem ING serorrsrrsisi vereor iann eE Ea EEA iii 10 7 Help and systemi MAIO senirereriienern n EE NEE 10 8 PART 2 Table of Contents The ECCAIRS Browser 4 EXPLORING THE BROWSER THE BROWSER AT A GLANCE The ECCAIRS Browser is the application used to enter modity view and print occurrences aircratt incidents and accidents Atter starting the ECCAIRS Browser see page 3 2 its main window will show up The VIEWS PANE The MENU BAR menus and The TOOLBAR offers a quick selects a specitic menu items allows to access visual access to a set of view for the data most of the functions in commonly used functions in stored for each ECCAIRS Browser ECCAIRS Browser occurrence See page 4 2 for details See page 4 7 for details See page 4 4 E on ee fxs eens alee ee ON a Finland FINTIOO1 Occurrence Tree X Tree eo FINTHOO1 Filing information Headline Ait Trafic Incident Report E Narrative Finnish Note State reporting Finland Date entered 23 04 2002 Events State file number FINTIO01 Reporting org Finland CAA ADREP Prel When 3 AERO SPACELIHES B 377PG PREG GI Local date 13 09 2000 UTC date 13 09 2000 S im erative Local time UTC time 11 40 00 Q Failures Where nat History of flight State area Switzer
130. implified structure where a sub set of the information is condensed and shown in a single pane e g ADREP and ATM preliminary views By default all topic icons are shown Non empty topics are marked with their name in bold By setting the Hide empty sections option see page 5 2 only icons whose topics contain any data are displayed 4 3 PART 2 THE VIEWS PANE The VIEWS PANE hosts a number of possible views Wes upon the data stored for each occurrence HEZ A view reflects a particular way the data is observed ADREP The ECCAIRS Browser comes with four predetined views optimised for typical flight operations and ATM ATM users oe IV ADREP view VM ATM view ADREP PREL v ADREP preliminary view poe v ATM preliminary view ATM PREL Custom views For several reasons an organization using ECCAIRS might have the need to eae add to or replace the standard views A Repository administrator has the possibility to do so using the Repository Manager application on the Repository Server bine TE E E Bee maenna This means that a user might find in the ECCAIRS menu item the view pane can be toggled Browsers views pane additional or different views not on visible and off When the Views Pane described in the standard documentation is set visible a tick is displayed in front of the menu item These additional ditterent Views might contain a subset of the data available in the standard ADREP view and
131. ine the most common statistical graphs Though the Grapher is not a full featured data analysis tool this application allows to produce a large range of graphs that can illustrate trends in the occurrence data The user can show the relation between 2 or 3 data fields in various 2D or 3D graphs Most of the more common graphs can be made in a very simple way Graphs can be made visible on the screen or printed in a report These graphs are created once and can then be applied to any other subset of the local or compatible database The subset of occurrences to consider in a database can be identified easily with the Query Builder which allows a user to compose queries based on a combination of criteria using any of the ECCAIRS data tields Queries and graphs can be stored in tiles that can be easily exchanged with other ECCAIRS users User Manual ECCAIRS Reporting System ECCAIRS UTILITIES A number of other applications either as tools or for administration are also included in ECCAIRS software standard installation gt Repository Manager administration _ECCAIRS 4 uses repositories a collection of data objects and rules to access the data warehouse based on a database or a file The Repository Manager allows the administrator to manage centrally also all user specitic settings related to security access methods database and application properties The use of Repository Manager is described in ECCAIRS 4 Softwa
132. ing Value the code for a specific state in the ECCAIRS Repository SR _VD State Reporting Value Description the expanded readable version of the State reporting the occurrence Here is an example of the first five columns of the flat format in Excel EW export sample excel xls E Ee eee en a eae KEY 0452 W State 0453 Vo State 0453 VD State U2 file number reporting repoting att b2BDeC 144 7100001 136 Libyan Arab Jamal 361 Ab250DE 7 100005 229 Switzerland BC361 400A F 100066 95 Germany 2064900327 7100119 246 United Kingdom AFABAIACS 7101009 249 United States 5920403415 7101010 249 United States Br o0E9352 7101011 249 United States D 6D41 1755 7101013 249 United States S03 C9966 7101055 249 United States S545EC7E 101054 249 United States DCDIB 5 7101055 249 United States 0540740162 7101056 249 United States Cr919F3EFI 101057 249 United States 54175201 25F 7101066 249 United States 18 10 User Manual The ECCAIRS Utilities Additional attribute columns corresponding to the attributes chosen tor ao export might be added up to a maximum of three for each attribute 1 3 ATTR V ATTR VD ATTR_VT Where ATTR _V Attribute Value the value of the attribute as stored in the ECCAIRS Repository ATTR_VD optional Attribute Value Description the expanded readable version of the attribute value as generated by the installed version of ECCAIRS ATTR VT optional Attribute Value Type O coded attribute 1
133. ing the graph properties CHAPTER 12 12 9 Save Library Close Library PART 3 Saving and closing the graph library To save and close the currently open graph library select File gt Save Library and then File gt Close Library menu items or their corresponding icons in the toolbar in the main ECCAIRS Grapher window i e not in the graph window Eile Ele Connect Connect E New Library Ckrl annen Lies Open Library Ctrl o el Save Library Chrl 5 ave Library AS z close Library Close Library In case the library has never been Savein workspace o saved before a New file browse dialog e heii opens Locate the folder where the amp library tile will be saved e g Desktop C ECCAIRS 4 workspace all In the File name field type in a sound E name for the new graph library for LE instance mylibrary KE ames ou a Confirm by pushing the Save buton ECCAIRS will save the file appending automatically the E4g extension SAVE GRAPH AND SAVE LIBRARIES ALERTS If the graph window is closed without x before saving any modification made ECCAIRS Grapher displays an alert dialog 2 Graph Graph 2 has been changed Do you want to sawe the changes to remind the user to QO Save the changes Yes button No Cancel O Discard the changes No button E4Grapher i X O Cancel the exit action and keep the graph open Cancel button Q Library has b
134. l Sending occurrences as E mail see page 10 5 M Finding definitions and descriptions see page 10 6 M Occurrence template see page 10 7 IVI Help and system info see page 10 8 Printing and other utilities 10 1 PART 2 PREVIEWING OCCURRENCE PRINTOUTS Bere The menu bar item Occurrence gt Print Preview or 7 New the corresponding icon button on the toolbar ee Duplicate Occurrence ii allows to preview the printout of all the occurrence LEs sections that have been filled in for the currently Lock Occurrence selected occurrence Release Occurrence A Print Preview window allows to control both the preview and the printing via a specitic menu bar a simple top print toolbar and a bottom navigation toolbar PRINT PREVIEW MENU BAR Print Preview File View Print Help BS PRINT TOOLBAR Ecc AS Filing information Headline State reporting Senmany Date entered Tor aoe Siate Tile number T1O0056 Reporting org GEERF reat coded When Local date 220171971 15 21 00 UTE date Where Statelarea of Senmany Latitude of occ OSC TShte Location of oct DoEMSESBERG TAUMLS Longdude of oc Classification Doturrence cages Aocident Cecurrente category CFT Cortroled fight inba or toward terrain Severity Damage aircrafi Destroyed Damage aerodrome Third party damage fo Injury level Fatal Injury totals Fatal Serious Minor Hone Unknoven Total Total on ground 0 Oo o o Total on aireraft 6 o
135. lable operators applicable to that attribute in a query etc Help This application is your on line Dictionary that will help you understanding the standard ICAO Garant Fi nomenclature and will drive you little by little when compiling an occurrence OCENE Dictionary Info Abant Dalatad tanicre lr vI Dictionary Info shows information about the Dictionary in use Eccairs 4 Dictionary Information X Hame ADREF 2000 Description ADREF 2000 Version 402 0402 Language English Organisation ECCAIRS Last modification date 12 7 272003 11 10 00 Authorised True Authorisation date 1571272003 15 14 46 v About displays information about the sofware version in use and can give Eccairs 4 release 4 2 Revision 6 Build 40 of 28 Oct 2005 P 2 ae Eccairs 4 Dictionan Browser Librar 4 2 502 access to the system The ECCAIRS reporting system is a set of tools that can be used to information on the collect exchange and analyse aviation related accidents and Incidents The system implements the ADREF 2000 standard com puter where tazonomy as defined by ICAO for storing information in its repository ECCAI RS IS currently Warning This computer program if owned by the European Commission lt is protected by copyright running th rough the law Non EU aviation authorities and other organizations interested in using ECCAIRS should System Info System Info button contact the JAC Select OK to dose it Co
136. land Latitude ATM Prel E Injuries Location Longitude di rt Aircraft recordings Aircraft meteo sification oo wa CFIT ed The INFORMATION PANE is the area A Dich where detailed information about the s Air traffic services ties Wreckagedimpact occurrence can be viewed E E Flight Crew io Member 5 a Other Personnel i Q Member Foe Q Sector Z Aerodrome i E Narrative See page 4 3 for details None Unknown Total Serious Total on ground Total on aircraft Grand total 0 xl Visible 57 Total 57 The OCCURRENCE LIST PANE displays a list of either the results of a query to the database or the contents of an E4F E4f file The STATUS BAR displays summary information on the current user occurrences time and database connection status See page 4 7 for details See page 4 8 for details Exploring the Browser DAW 53 20 07 2002 16 55 7 4 1 4 2 PART 2 THE MENU BAR The Menu Bar hosts menus and menu items used to access most of the functions available in ECCAIRS Browser Fie Edit View Database Occurrence Help All the menu items are displayed below menu by menu The numbers reported side of each menu items refer to the main manual page s where the corresponding function is illustrated File Database 7 2 7 8 Connect Build Query 8 1 Query by date _7 20 a 7 1 Open 8 2 resh Query 19 Save 8 4 Show current Query 7 8
137. le E4F Exit oO File Connect New Open Save Save 5 Close Send deidentified to Pies velo Bin Pring Occurrence List HiECCaIRS4 iworkspacelsample E4 Exit User Manual E mail Database To save the occurrences in the currently open occurrence file just select the File gt Save menu item or the corresponding icon button in the toolbar The File gt Save as menu item saves all the occurrences in the occurrence list to a different tile trom the one currently open There is no corresponding icon in the toolbar When the occurrence list has not been modified e g no occurrences have been added deleted moditied the File gt Save menu item is disabled while File gt Save as is always enabled Also the File gt Send to function allows to save occurrences The option sends the currently selected occurrences i e not all as does the File gt Save menu item either to a tile a database see page 7 4 or as an attachment to an E Mail see page 10 4 The File gt Send to option can be used when only some of the occurrences loaded need to be saved on tile The ECCAIRS Browser CHAPTER SAVING COMPRESSED E4F FILES 8 The user can choose between two formats with the Save as type drop down list whenever a save file dialog is invoked to save occurrences in an E4F file i e using v File gt Save as see page 8 4 v File gt Send to see pages 6 5 7 4 8 4
138. lected attributes in Text Access or Excel format 18 8 Flat attribute format 5 nae piviewsiee seuntenqenAcnniaamiarariontteerncaen 18 10 Expanded attribute format ns icciodencous Hes srecuiedounsedenariaosevibenedes 18 12 Export occurrences AS TEXt TES 0 cee cec ccc ec nec eec sense essen eeeen ees 18 14 Export occurrences using a template HTML RTF TXT tormat 18 16 Export de identitied occurrences into an E4F format file 18 20 The Bporer File menu aucancernscconcgrertienoutastenteneeesi eens 18 22 E4E export configuration Tiles cccccceecceeeceeeeeeeeeceueseeneees 18 23 The Exporter Tiel Ot ng5crscnancenicaneraeatmatsnsaaraenannaasazenanan 18 24 User Manual The ECCAIRS Utilities PART 4 Table of Contents The ECCAIRS Utilities WHAT IS THE E4F GENERATOR The E4F Generator is a tool used to generate ECCAIRS 4 Data Files E4t trom a repository database E4F tiles contain any number of encrypted ECCAIRS occurrences in an XML based format and can be used to store exchange and backup occurrences in an ECCAIRS repository Typical usage of the E4F Generator is tor backing up the contents of your database in a series of E4F files It is recommended to perform such a backup regularly even if your database administrator makes back ups of your databases in the specitic database management environment Though it is possible to manage ECCAIRS occurrences trom within the ECCAIRS Brows
139. level topics are represented by icons that do not have me ff Events further branches in the tree i e with no sign on its left hg Separation tastes ies Weather Sel Aircraft F age Airspace ATS Unit Topic icons that have furter branches in the tree i e with Recommer the sign on its left will have sub topics 2 and nt level fines TP Manageme topics Each topic has an associated page displayed in the Intormation Pane which is displayed when clicking on the topic icon Each intormation page is then structured into sections which are sets of related occurrence attributes see page 2 9 taken trom the ADREP 2000 taxonomy Filing information Headline Air Trafic Incident Report State Date entered 23 04 2002 State 5 E CTI O N S red Reporting org Finland CAA l When Local date 13 09 2000 UTC date 13 09 2000 gt Local tim UTC time 11 40 00 ATTRIBUTES blue Where State area Switzerland Latitude Location Longitude Classification Occurence class Serious incident Occurence category User Manual The ECCAIRS Browser Subsequent level topics in the ADREP 2000 View are shown in the o picture below They are sub topics of the first level topics vI Aircraft v Aerodrome vI Airspace v ATS Unit if hee Yke Eh x Separation B5 Weather SS Aircraft H nye Airspace H ATS Unit stiles a Hi
140. licable to that attribute in a query etc This application is an on line Dictionary that will help the ECCAIRS 4 user to understand the standard ICAO nomenclature and ultimately provides a guide to fill in data tor an occurrence Dictionary Browser 17 1 17 2 PART 4 STARTING THE DICTIONARY BROWSER Start the Dictionary Browser by selecting Start gt Programs gt Eccairs 4 gt Tools gt Dictionary Browser trom the Windows task bar and performing the standard ECCAIRS logon see page 3 2 its main window will show up Dictionary Browser O x File View Definition Help Id Short Description Filing information j OOOO00 jo CCUMEnTE i a when Description at ae here Classification Severity Injury totala Definition HAT relation Separation General Distances sai Aircrafts Movement Information ae ATM aspects ee Actions The Dictionary Browser can also be invoked more directly while using the main ECCAIRS 4 applications i e the Browser the Grapher and the Exporter EE The Help menu of these applications includes a Contents F1 specific menu item so that the Dictionary Browser Dictionary Browser Pai can be started by selecting Help gt Dictionary Browser User Manual The ECCAIRS Utilities CHAPTER USING THE DICTIONARY BROWSER The Dictionary Browser window is divided into three main sections 7 identitied in the picture below Menu bar Its menus mainly allows the choice of
141. lities CHAPTER READING INFORMATION IN THE IDENTIFICATION PANE 1 The Identification Pane displays the ID description definition properties and values an item can assume As you move up and down the tree node of the Taxonomy Tree Pane the Identification Pane will display all the attributes associated to each level of the tree node Dictionary Browser kK Shot Description F ng reformation fios weathe When 0 oe Where Ciges icstion a Severny t a Inaay totals Dictionary Browser ATM selabors Pie Wier Deefindtion Pep a Nanalewe i ADAP View Nole H SPa Debinigtion Events n General weas oordihond Separation a ABc Cereal megha conditions A Aerodrome f Amspece a limpa igisa Deiri ATS Unit 7 Recommendations a a perii T Pei iidem piirab be mierraleon on the gariad i iida Teea Contre HATHI kai com ot veel ot Menegement 3 Hole ahea phata of ght of the sirciatt ba mihech the vetathas Evers miom aion piana Tepian Washa eee Dictionary Browser hud Pie vea Definition Elel zi Temperature r HT ADREP YE w a Peecipahstiony ord pha wenta ao Weather gaia 3 Amral a fonninloimr 3 Amn J ATS Umt 3O Ingay iisa 3 Al eebbbors 3 Haorabwe 2 Hole x Everts Separation Weather Generel weather condor 2 2 7 Light conditions hea veld Speed masnad al Wired adap Lil lenges aue
142. m Exit to quit the application when selected The E4F Generator can also be quitted with either the bottom Exit button or the standard Windows top right close control of its main window v The Help menu has two items Q Contents F1 invokes the standard Windows help support This support can also be started by the F1 keyboard key E E4F Generator Help Bo gt Hide Back Forward Contents Index Search Release notes gt Using the application Ga ECCAIRS Query Builder User Manual About E4F Generator The E4F Generator is an ECCAIRS utility that serves to generate e4ffiles from a E4F files contain any number of encrypted ECCAIRS occurrences in an XML bas used to store exchange and backup occurrences in an ECCAIRS repository Typical usage of the E4F Generator is for backing up the contents of your databa files Itis recommended to perform such a backup regularly even if your databas makes back ups of your databases in the specific database management envirc Though itis possible to manage ECCAIRS occurrences from within the ECCAIR usage ofthe E4F Generator is mandatory when you migrate from one version of version of ECCAIRS and the data format and or data taxonomy has been change passing your data via an e4f file guarantees you that all appropriate conversion performed Note It is important to know that the E4F Generator security settings of the repositor s secur confidentiality if appli
143. ment meteorological conditions g all Occurrences where Weather conditions equal to IMC C E4F Filename C 4 Prepare the template file use the above mentioned White Paper and select it by either using the open file icon button or typing in the tilename and path in the Template pane lemia C Program Files E ccairs4 Tools E sport 4E sport a Execute Exit Exporter 18 17 18 18 PART 4 5 Push the Execute button 6 The dialog window that shows up displays the list of the occurrences to be exported Occurrences formatted according a predefined template x Repottife l Talis 7100001 Libyan Arab d 19 07 2002 By ine Miter by selection 7100005 Switzerland 19 07 2002 9 SWTZ Filter excl selection 7100066 Germany 19 07 2002 GERF t Filter by net 7100119 United Kingd 19 07 2002 1 Remove kilker By right clicking on one of the columns it is possible to furtherly restrict the ded occurrences to be exported by applying a filter on the corresponding attribute ie Cancel button User Manual The ECCAIRS Utilities The picture below shows an exported file generated using the sample HTML template available in the installation folder see side note OCCURRENCE REPORT Microsoft Internet Explorer O x File Edit View Favorites Tools Help deBack mp amp fat Gisearch ejFavorites Media 4 Sy Sf p Address E Hi ECCAIRS4worksp
144. menu offers the standard editing tools for the list of occurrences Right click menu gt Cut Copy Paste and Delete uk Copy Paste Delete Right click on the Je Select all State file number file number Report identific Occurrence List piter by na ee Staterare 7100119 003773 pane to get its C Filter excl selection Unknown 7100125 contextual menu hia andi Filter by Yugoslav 7100220 O08 72 i Remove filter United Kii 7101009 1 0002 United St 7101010 1 0003 United States Find United St 7101011 1 0004 United States Find Next United St 7101013 1 0006 United States ela United St 71010543 3 0001 United States Accident United St TUM ARA 3 nnn lInited States Accident lInited St PETER Er JRC Selected 0 Visible 40 Total 40 Selecting is done in the standard way i e using the mouse also with Ctrl and Shift keys for multiple not contiguous selections The selection of all the occurrences in the list pane can be performed in one go through either Right click menu gt Select all or the corresponding item in the Edit menu Almost all these functions can be invoked also from the Edit menu in the menu bar Edit Select all Find Find Mext USER MANUAL The ECCAIRS Browser DELETING OCCURRENCES Deleting the selected occurrence s can be pertormed either by selecting Occurrence gt Delete in the menu bar or Right click menu gt Delete within the Occ
145. n menu and toolbars with tunctions directly related to the occurrence list see page 6 1 and following and database query management see page 7 1 and following Eccairs Browser Query all File Edit view Fiter Database E E d w Toolbar eee i oz State report Show the File Occurretposieli tote be NN Renoting og Date entered Shate are Sweden Dock Occurrence windi 7100064 SWED not coded 19 07 2002 Sweden Switzerland S 7100005 SRT not coded 19 07 2002 Switzerlat d 100303 THAI not coded 19 07 2002 Thailand e 100053 UNKG not coded 19 07 2002 United Ki Options United Kingdom United Kingdom 7100119 UNEG not coded 19 07 2002 Unknowr United Kingdom 7100167 UNEG not coded 195 0772002 United Kir United Kingdom 7100191 UNEG not coded 19 07 2002 United F i United Kingdom 7100193 UNEG not coded 19 07 2002 United F i United Kingdom 7100214 UNEG not coded 19 07 2002 United Kir PETER i JRC Selected 1 Visible 275 Total 275 The detached occurrence list can be re linked to the main window by using the corresponding menu or toolbar items Exploring the Browser CHAPTER 4 4 11 5 The ECCAIRS Browser CUSTOMISING THE BROWSER USER SETTABLE OPTIONS VIEW w Toolbar The user can control a number of options of the ECCAIRS Browser by selecting Views Pane Show the Query Occurrence List Detach occurrence list window Copy data window View gt
146. name sample deidentified E 4 My Network F Save as type JEccairs 4 Data Files Cancel EZ The attributes to be excluded for de identitication are set in the View gt Options menu item Deidentitiable attributes tab pane described on page 5 6 USER MANUAL The ECCAIRS Browser PRINTING LISTS OF OCCURRENCES The menu bar item File gt Print Occurrence List allows to print the list of either vI The selected occurrences vI The whole of occurrence list if no occurrences are selected in the Occurrence List pane The standard Windows print dialog window is invoked so that even it the detault ECCAIRS Browser printer is proposed as the pre selected choice any other printer can also be selected List ef Chereerreor EAE F j a herr lary fie empl abi iila aiir Di a if hate ijan 4 ket m m hate viar ut Pairi mii Monai daa Ph j I GET ead kmph Acc ST WAWKIE SINH LEY TROAN SLE HI O AWLA Mamit kippa mE wT Cid Kangke Accel eT MAGLE ATA ADT 1 oo DAYA tasi 4 10 TAT min cd k mk a LT WETER LA HLAS AKAT AAT FI A vires Lamhag Hm ditimi Eimi Kongo Acris digart ESS A T A LASE CANAS bakini a Tasi fini sod kompim icid kitapti HAWKER SY CAET a EATE Sone i ford Tic Ld Parim Unned Kingdom Achias SMT CESTNA ii TAWH kn J Take off TIETE os L kul Rone as beh MANEA ACA CO C1 AAA ot eur Eh imir TE CA laani kapka A HT APER PARTS ANTEU GAFN rd si rava TAS A iri The printout includes all the occurr
147. nce key never changes it remains independent trom any type of change that can be made to the occurrence by a user or system If two occurrences have the same signature it is 100 sure that the origin of the occurrence is the same even if all attributes of the occurrence including State File Number and State Reporting are different State File Number State Reporting For each occurrence there are a number of mandatory attributes namely Organization State Reporting and State File Number The latter two State Reporting and State File Number are both considered a unique identitier for the occurrence based on the assumption that each state has unique identitiers for their own occurrence reports If two occurrences have the same combination of State Reporting and State File Number then the ECCAIRS system considers these reports to reter to the same occurrence E44F Loader CHAPTER 16 16 5 PART 4 DEFINE LOGGING OPTIONS In the Logging options pane you can enable the system to create a Log text file Since the loading process runs in background it is recommended to create such a tile and therefore logging is enabled by default To explicitly enable disable logging check the Log Activity check box eee ee ee eee ee ee eo bat l Bo sepen ara J Logging options W Log Activity C Al w Append Date Time stamp to LO file name HE CCAIR S 4 workspacee4tloader log tst Browse ml Once logging is enable
148. nd in the Selections Editor toolbar r i BB The Selections editing functions are a subset of the standard editing functions available tor queries in the Restriction pane for details see page 7 9 onwards User Manual The ECCAIRS Utilities In addition to the pure selection of attributes to be exported it is also possible to change their Layout determine their Order apply an Aggregate function or Group their values These options are available a in the Function Attribute definitions definitions pane of Attribute teu the Selection Attribute Id 0266 Cloud amount builder dialog Function definitions which is invoked Layout whenever Order adding editing an eee Ceia attribute in the Selections edit pane Be aware that certain rules apply when combining different functions for the selected attributes For example when one attribute is used for grouping the other attribute must also have specific functions applied count for instance ioixi Edit o xX t R BB Restrictions Selections j he amount of cloud Cancel Once the attributes and related tunctions are specitied the Selections Editor can be closed by clicking its OK button at the bottom right corner Closing wit with the Cancel button discard any moditication made in the editing session l Source e Ha all Occurrences where Weather conditions egual to IME get The amount of cloud The lower box of the So
149. ntact us arsen omaa Dictionary Browser 17 13 The ECCAIRS Utilities WHAT IS THE EXPORTER The ECCAIRS 4 Exporter is a tool used to export subsets of data trom the database in a variety of different formats It is up to the user of the exporter to determine the tinal usage of the data which is exported Examples of some possible usage include MI Creation of proprietary customised reports v Analysis of sub sets of information in 3rd party environments v Free text searches on all attribute values v Passing information to users of non compatible systems G Most probably as a user you will find that many if not all of your requirements regarding the extraction of data for your particular lt is important to know that the purpose will be met Exporter always respects the security In fact though the Exporter allows to export data in many different settings of the formats the way this is achieved is very much consistent with the other ooe N D a protile so tha ECCAIRS applications confidentiality if a ae applied is The application makes use of the same basic building blocks Query maintained Builder logons user interface elements etc as the standard ECCAIRS applications Exporter 18 1 18 2 PART 4 STARTING AND OPERATING THE EXPORTER Start the ECCAIRS 4 Exporter by selecting Start gt Programs gt Eccairs 4 gt Tools gt Exporter trom the Windows task bar and pertorming the st
150. o I I I I I I I bion Tue wed Thu Fri Sat Sun Local date As Day of week 14 8 User Manual The ECCAIRS Grapher This means that for each found Z axis value blue and red incident and accidents the total of the various X axis attributes Monday Tuesday etc is set to 100 Instead of absolute values the resulting percentages are given This way it is possible to compare the trend of the accidents incidents during the week if the absolute values are disproportionate In addition to normalisation by Z axis ECCAIRS Grapher offers v Normalisation by X axis label i e by Local Date in the exemplary graph tor each found X axis value Monday Tuesday etc the total of the various Z axis attributes blue and red is set to 100 and instead of absolute values the resulting percentages are given This way it is possible to compare the contribution of each colour tor each day of the week M Normalisation by all values the sum of all found values on the Y axis are set to 100 and each bar in the graph is then expressed as a percentage of this total This way it is possible to assess the contribution of each measurement point to the total In the data grid toolbar at the right of the Normalise icon button ECCAIRS Grapher displays a current fii Normalised by Localdate normalisation status message PE Mot Normalised WHAT IS NORMALISATION Normalisation is the process where the sum of all val
151. on the graph window background 13 4 PART 3 CHART TYPE AND 3D Now a line chart is probably not the best choice to present the information in the exemplary graph built up to now IR al p E To change the graph type select the graph gallery icon and then pick the Bar graph type from the palette showing up SERE po foe i qe k B a fir fe mn cu E 101x aS S WEBTaACHAKB Q 3 l obke g e d Distribution of Occurrences Classes by Day of the Week jj We can now add some visual impact to the graph by selecting Graph gt 3 D trom the menu bar or the corresponding icon in the toolbar M Class Distribution by Day of Week 45 00 45 00 42 00 39 004 36 00 4 33 00 30 00 27 00 24 00 21 00 18 00 15 00 12 00 9 004 6 00 4 3 00 4 0 00 i i i i Mon Tue Wed Thu Local date As Day of week WB incident E Accident Count of The fle number allocated by the State providing the report M Distrib Occ Class E CIE SE CA ARN E EE EAA Distribution of Occurrences Classes by Day of the Week 46 45 42 39 36 33 30 I Accident Mon Tue Ved Thu Fri Sat Sun Local date As Day of week Tr t o Qa o o f pe B gt o te a o pi aA o gt a2 T o T o 2 5 o 2 E gt 2 o w o o oO User Manual The ECCAIRS Grapher CHAPTER CHAR
152. onsists in defining the destination filename and folder for the output E4F file s You can either specity them by typing in the full output file path name in the Destination text box or by browsing in your tile system using the Browse button and the standard Windows open tile dialog that will be consequently displayed Eccairs E4F Generator q X File Help Query instrument meteorological conditions Load Guerry Destination H ECCAIRS4workspacelMC_occurrences E4t I Split destination tile when it reaches fi 000 Occurrences Logging options M Log Activity C Al User feedbackErrors only V Append Date Time stamp to LOG file name Browse Start Fause Stop Exit Optionally it is possible to split the output in multiple tiles each limited to a specitic number of occurrences It is recommended to have no more than about 1000 occurrences in a single E4F tile since larger files would slow down significantly the performance of your ECCAIRS applications Therefore the Split destination file when it reaches check box and an 1000 Occurrences split threshold are enabled and set by default When the output is split into multiple tiles each file will have its base name i e not the E4t tile extension extended with the particular range of occurrences generated For example if the destination file name is IMC_occurrences E4f and the query returns a total number of 1789 occurrences with the split threshold set
153. or further details Dictionary Browser File View Definition Help ADREP Id Short Description h o00000 Occurrence E when Description PE ae here sean Classification RONE 5 everity a bles call Definition or ATM relation User Manual The ECCAIRS Browser OCCURRENCE TEMPLATE Whenever you are editing an occurrence you can decide to save it as your personal detault occurrence This is the most convenient way to set for example your organisation as the default organisation or your country as the default state reporting Every time a new occurrence is created see page 9 4 the attributes values saved in the occurrence template are pre set in the new occurrence by default To set an occurrence as the default occurrence select File gt Set occurrence as default while editing an occurrence in the Occurrence Edit window see page 9 6 a Occurrence Occurrence File view Filing information Headline State reporting State file number Check For duplicate occurrences when Eaj Local date Local time To step back to the system default occurrence template empty template no attributes pre set select File gt Restore default occurrence menu item within the Occurrence Edit window File Save Restore default occurrence Send to Gopend to current hile Check For duplicate occurrences Exit Printing and other utilities CHAPTER 10 10 7 10 8 PART
154. or they might contain just the standard Sections organised in a ditterent topic tree i e they can be mapped into user defined chapters tollowing some basic guidelines Should any non standard view be included in the ECCAIRS Browser we suggest to ask the ECCAIRS administrator within your organization for specitic details VIEWS PANE DISPLAY view Database Occurrence Help Toolbar Show the Query Occurrence List Detach occurrence lisk window Copy data window Options By default the Views Pane is visible 4 4 User Manual ADREP view The ECCAIRS Browser The ADREP view organises and displays the occurrence data according to the complete ICAO ADREP 2000 taxonomy The intormation pane is composed by a tree and a data display Argentina 7 100228 S mean tate reporting Aganda i Events Suse fies reari Bii irc a Seperation Vinal ki CESSHA ddd LY Lora date That I Mannie a E Mein Lonel ima 10 00 F venis l Fee p Faia Hisy of ighi Sellar Augentens ee Locale SAN JUSTO a Ariran riti VE Avera melee Classification tarry Occunarce diii Wrciderd BE Fre Bd Survival Dinni category a Dich Ai bole stra ae Vr eckegeeect gt ht Fight Crew Simi l D kanis Dani aiiai Hras D Other Personnel Thed paty damage D Manie BB aegre qe pee JL Mannative Fake SJ mete Total on ground 0 E Events F Tn Total on aort li Arie x Grand total ADREP Preliminary view Chats entered 107200 Aap g ARE
155. orter 18 25
156. ossible to create edit a query on the spot without resorting to the whole Query Builder i e without opening any query library and selecting any of its existing queries This is the only way to edit a query which was stored in a E4E export tile and is not available anymore in a Query Library Clicking on the pencil icon button opens a Restriction Editor window see next section page 18 6 The query specitied on the spot with the Restriction Editor is automatically saved in E4E export configuration tiles see page 18 20 User Manual The ECCAIRS Utilities CHAPTER 18 Exporting specitic attributes In addition only the first three choices of export format text Excel and Access also require the Destination j usutsaeape Selection of the attributes to be exported Selected attributes of occurences in an Access Databaze See next section page 18 6 for details Selected attributes of occurences in an Excel Spreadsheet Occurrences trom E4F file In the case ot tree text formatted via template and Complete occurences exnanded as 4 text tree de identitied E4F export format choice the last three in the list the source occurrences to be exported can also in alternative oe to the query on the database ee be provided by an E4F tile Select the E4F Filename choice in the Source pane whose text box has yellow background to distinguish it at a glance from a the query text boxes pale blue Oecu
157. ound fT IH may display either rea a ken f occurrences taken trom an Occurrence list query EAF file or selected from a Background nr E database specified by a Occa locked by current user re posito ry Occa locked by other user Their display options are separated accordingly Occurrence List File pane options Occurrence List Query pane database mode options v Background colour v Background colour v Foreground colour v Foreground colour v Locked Occurrence Background v Locked Occurrence Foreground Specifying colours Color Basic colors Gi Cl ee sate ee ie Ee Clicking on any ipa EER of the colour ETEEN selectors EERE eee displays a Color IEEE wm control window Custom colors In the Color EEEL Hue i60 Red 255 control window it Sat f 0 Green 255 Define Custom Colors gt gt Colors olid Lum 240 Blue 255 s possible to PE OF Cancel Add to Custom Colors choose one of the Basic colours or define specific colours to be added to the Custom color palette Clicking OK contirms and applies the choice Customising the Browser CHAPTER D 0 3 The list shown is the default list after installation and initial configuration But it might actually be much smaller or even not modifiable by the users The attributes available are determined by the ECCAIRS Administrator 5 4 PART 2 OCCURRENCE LIST ATTRIBUTES The List tab pane options
158. ph gt Properties menu item and the corresponding icon in the toolbar open the Chart Properties window Chart properties are divided in tour different groups indicated by the four cards in the properties window General Series Axes and 3D Users are encouraged to experiment with all these four chart aspects Some examples of their specific usage can be found on v page 12 5 General and Series v page 12 6 Axes v page 13 5 3D x x Genera eis Axes 3D Gendt Series Ahes 3D Effects Colors e 4 Markers 5 Gallery ke M 3D Palette m Marker fill I Cluster Z Axis Color ee Shape Eo fe e Stacked dfh BET ae Lines ee mm Same color as markers Size 3 pane Lae ai f C Custom Show point labels Chart box Style Weight Cancel Apply Help Sample Title Distribution of Occurrences by Day of the Week Cancel Apply Help Chart FX Properties Xx Gears x General Seifs Aves p lv Axis IV Visible Major unit Auto M Show gridlines Tick mark type C None Outside Inside Cross Minor unit Auto M Show gridlines Tick mark type x Angle pa None Outside Inside Cross C Uo OA Y Angle jo Perspective Details Shadows Fixed angle The Details button gives access to an Cancel Apri Hep General Series mel o E Rotated vie
159. r v About displays a dialog whose upper pane contains ae TER information about the software version in use 1 3 ECC IRS Eccars 4 release 4 2 Revision 6 Build 40 of 23 Oct 2005 Eecare 4 Grapher 4 2 502 The ECCAIRS reporting system is a set of tools that can be used to collect exchange and analyse aviation related accidents and incidents The system implements the ADREP 2000 standard taxonomy as defined by ICAO for storing information in its repository Warming Thi computer program i owned by the European Commission Ibis protected by copyright law Nor EU aviation authorities and other organisations interested in using ECCAIRS should System Info contact the JAC Contact us OK closes this dialog window System Info recalls the system application which gives information on hardware and software configuration of the user computer Contact us allows to send mail to the ECCAIRS development team by invoking the user mail client program i e the program currently defined as the default mailer e g Outlook Express Eudora Pegasus Mozilla Netscape Mail Thunderbird etc with the correct address already tilled in 3D graphs and other functions 13 11 PART 3 OTHER GRAPH FUNCTIONS The Graph tunctions that have not been introduced or used in the previous chapters of this manual are listed below associated to the corresponding graph toolbar items Vertical Grid and Horizontal Datagri
160. r of specified attributes of File Help the query selected occurrences from the Se ay asian 7 a database into three file formats f Selected attributes of occurences in a pair of text files Selected attributes of occurences in an Access Database E Selected attributes of occurences in an Excel Spreadsheet Decurences formatted according a predefined template l Complete occurences expanded as a text tree Export whole occurrences either resulting from a query on the database or taken C Complete de identified occurences in E4F format from an E4F file either as a text tree file or as a formatted file using a template or as a de identitied E4F tile M Source The general operating sequence to run the Exporter is 1 Select the desired export format in the Destination pane 2 Select the destination file name and folder 3 Select the source occurrences to be exported using the Source pane tools 4 According to the specitic export tormat choice either a Select the specitic attributes to be exported only for text Excel and Access export format or b Prepare and select the template tile only for tormatted via template export format or c Select the attributes not to be exported only for de identitied E4F export tormat 5 Push the Execute button 6 According to the specitic export tormat choice other dialog boxes may be displayed tor additional choices 7 The export output file is genera
161. ral Aircraft handling unde Phase Powered aircraft Approach Final approach Descr factor subject Aircraft and operations aircraft Df modifiers Improper use Descr factor subject Aircraft and operations Aircraft Df modifiers Incorrect setting Descr factor subject Meteorological info weather cand OF modifiers Present weather General weather conditions Exporter 18 15 18 16 PART 4 EXPORT OCCURRENCES USING A TEMPLATE HTML RIF TXT FORMAT The export using a template generates a single output tile where the attributes of the occurrence are placed following a formatted template detined by the user The limitation for using this exporter function is that the template provided and thus the final document must be based on normal text In practice this makes the exporter usable for TXT files HTM files and RTF files As in the text tree export format case the coded database values of the attributes are not exported The RTF and HTML formats open up the application of this export method tor complex pre formatted documents i e the possibility to produce custom reports trom an ECCAIRS 4 data source query or E4F file Moreover because ECCAIRS 4 exporting scripts can be saved as EAE tiles see page 18 20 these document generation templates can be exchanged in the ECCAIRS community and re applied anywhere Eecairs 4 ECCAIRS 4 2 Resulting Exporter E4F file Template Eeeairs 4 txt
162. rate problems and better documented in the form of extensive logging options Usage of the E4F Loader is mandatory when you migrate trom one version of ECCAIRS to a newer version of ECCAIRS and the data format and or data taxonomy has been changed In this case passing your data via an E4F file guarantees you that all appropriate conversions and adaptations are pertormed G It is important to Typical usage of the E4F Loader is tor restoring the contents of your know that the database trom a series of E4F files It is recommended to perform E4F Loader always A respects the security backups regularly using the related E4F Generator application even settings of the if your database administrator makes back ups of your databases in repository s security profile so that confidentiality if applied is maintained the specific database management environment E4F Loader 16 1 16 2 PART 4 STARTING AND OPERATING THE E4F LOADER Start the E4F Loader by selecting Start gt Programs gt Eccairs 4 gt Tools gt E4F Loader trom the Windows task bar and performing the standard ECCAIRS logon see page 3 2 its main window will show up Eccairs E4F Loader gy x Fie Help Modified Add Remove lear Count Total 0 Loader options IY Autocorect inconsistencies IFoccunrence exists then Prompt UZET Logging options M Log Activity C Al User feedback Errors only V Append Date Time stamp to LOG fil
163. rators proposed varies according to the attribute selected Some samples of operators available are shown below greater than or equal to less than or equal to greater than ess than greater than or equal to ess than or equal ta equal to ot equal to o value The operators may require as reference value none equal to has at least one doesnt have any of none equal ta v No specific value i e the has value has no value M A single value e g equal to less than v Two values e g between not between M Multiple values e g has at least one Attributes which have the possibility to be has atleast one of assigned alternative values i e not yet sprains eg er value equal ta coded values see page 9 9 for details _ cther value not equal to r other value none egual to also allow a set of operators referring tO oiner value has value the alternative values either as other other value has no value j j other value like value or as to be coded for those ioe conem Sauelis alternative values which have been to be coded not equal to proposed a new code to be coded none equal ta to be coded has value to be coded has no value to be coded like USER MANUAL The ECCAIRS Browser Values reference values The value definitions box allows to specify the reference
164. rc ns ext trsni ii eT OEE EEEE EENES 7 11 BOEKO einir EER 7 11 Criterion Builder snsaaescsseausensaessaet oncouasacenesenusesastsseetoncouaiecaes 7 13 AUNOU ee ane een en en eee oe mee 7 13 KS OI P EE E E 7 14 Values reference values cccecceccceeceeeeceeeseecseseeeeeness 715 Two values range Selection cccccccceceseceeeeeeeeseseueeeneenes 7 15 Multi value selection list organised values 00c0eeee 7 16 Multi value selection tree organised values 7 16 Date range values grouping TUNCTIONS cccceeceeeeeeeeeee ees Run time specified values Parameter Queries 00cce8ees 7 17 User Manual The ECCAIRS Browser Executing and refreshing queries ccccceeccseeceeeeeeseeu essa eeeaes 7 18 Juey ole ala ee eee ne nee ne ee er TAY PS iy SSS Oe ciocterse es ier ce asec esc aes aed eee bon dina auaceasecte nee deceeeniace 7A 9 Show current GUSTY cz cresreroctessasesciaceecaaersqesenieacenaienendienaen 7 19 Query by date year month statistics ccccceccseceeeceeeeeeeenees 7 20 8 WORKING WITH OCCURRENCE FILES Create a new occurrence file 0 0 cee ceccceccc cece ee ceeeeesueeeueeeueeeneeees 8 Opening closing occurrence files ccccccceeceeeeeeeseeeeeeueeeneeens 8 2 Saving occurrence Tiles aacteseceesecastacentento sent zeuseaaiecnstineentnatenessaces 8 4 Saving compressed EAF files ccccccccecceeeceeeeeseeu secu eeeneeenes 8 5 9 EDIT
165. re Installation Manual E4F Generator tool This is a utility used to generate ECCAIRS 4 Data Files E4t trom a repository database E4F files contain ECCAIRS occurrences in an XML based tormat E4F tiles may be used to store exchange and backup occurrences in an ECCAIRS repository EAF Loader tool This is a utility used to load E4F files in a repository s database It is also useful for restoring the contents ot a database trom E4F backup files Usage of the E4F Loader is mandatory when upgrading to a new version of ECCAIRS and the data tormat and or data taxonomy has been changed Test ECCAIRS 4 Installation tool This utility is used after an installation to detect possible incompatibilities with specitic Operating System components which may be not up to date Refer to ECCAIRS 4 Software Installation Manual for details Dictionary Browser tool This utility is an on line Dictionary that will help the user understanding the standard ICAO nomenclature and drive him her little by little when compiling an occurrence It gives a quick and complete view of the taxonomy used by ECCAIRS i e all topics sections and attributes available Exporter tool This is a utility used to export subsets of data trom the database in a variety of different formats respecting the security profiles tor the current user as defined in the repository Possible usage include creation of customised reports analysis of sub sets of information in
166. rence List as a selt standing Window c06ceeeeeeee es 4 10 5 CUSTOMISING THE BROWSER User settable Options ccccccssccssccsscceseessctesceesseesseessenseeneuss 5 1 Appearance display Options vscceaceercaacdevoncsawissatimenceudiversiate 5 2 Information and Tree pane Options ccccceecceeeeceeeeeeneeeenes 5 2 VIEWS pane OPTIONS aica cudcdenideriegaves gancwwssonsseasaanisvaenesesedineynes 5 2 Occurrence List Pane GONOR Sav ncn dcunintayercedewecnansenvamnneeetenats 5 3 DS Cle IONS ra tern ta vere coesnie eeeewicseutter seed onc eosin edad eos 5 3 Occurrence List AOU ICS aera pce dined ac capper veaaese a 5 4 Defining the initial sort order Of occurrences 5 5 Selecting display level of multi level attribute values 5 5 Deidenifiable dii ol cio eee eee anata nee een tanta enn ere rere ae ert 5 6 Eveni OOM aese eE E EE ee ONE 5 External API parameters sos cnsveonrneesrasnatarsinnisaienieneesnnmnnentouess 5 8 Page printing Setup ct nisi 225 so an ccspacnescsaunhasne peueanoeapaneseatusscobaens 5 9 PART 2 Table of Contents PART 2 6 WORKING WITH THE LIST OF OCCURRENCES Functions available esx ccoxeraccaveuevaeveaencrnedonevncoeusieesteeayen untae neers 6 1 Editing the list Of occurrences 0 cceccceccceseceeceeeeeueeeeeceeeeeseeness 6 2 Deleting OCCUMPENCES orcx sscccsssncessesanrsnacdenetterteianssavesesuossenssetnans 6 3 Filtering OCCUITENCES cecc cece ccc eeceeececeu eee ceee
167. rences formatted according a predefined template Complete de identified occurences in E4F format Then either type in the full path to the output export tile in the yellow text box or click on the open tile button to invoke the standard Windows tile browse dialog for selection A 0 E4F Filename H ECCAIR S 4workspaceSIMC_occurrences E 4 PE Execute Exit Exporter 18 5 Er Mer Edit Delete Clear Move Up Move Gown Cut Copy Paste 18 6 PART 4 SELECTING THE ATTRIBUTES TO EXPORT When choosing either text Excel or Access export formats in the Destination pane of the Exporter main window it is also necessary to specify the specific attributes to be exported To select attributes click on the pen icon in the Source pane to edit the currently selected query with the Restrictions Editor of the Query Builder r The Restrictions edit pane is the gt K ER one normally used to edit queries used to find specific occurrences Click on the Selections tab to switch to the Selections edit pane instead e E E E a Selections K Weather conditions equal to IMC i fiefs eee Edit N A e elit SE Riddd Selection slections Selection builder i l Attribute detinitions Clouds Attribute Id 0266 Cloud amount Function definitions Layout Order Aggregate function Group by Attributes can be selected using the functions available both in the Edit menu a
168. ributes as the original see the exceptions below and opens the Occurrence Edit window on it Eccairs Browser File C Documents and Settings enzo Documents ECCAIRS 4 workspace IMC_occurrence File Edit View Database Occurrence Help Es 1 E hi SDREP Filing information Yugoslavia Federal Republic of Serbia and hon Headline Marrative English EI Lenaia State reporting Yugoslavia Federal Republic of fae a Events Serkhia and Mantenecarcl ea ea Weather State file number 7100125 of amp Occurrence Yugoslavia Federal Republic of Serbia and Montenegro File w EN In the duplicate occurrence the State File Number attribute field is cleared since this is supposed to be a unique identifier for Occur each occurrence and needs to be set to a g t403 new value WAT nas Yugoslavia Federal Republic of vents lontenegro ee Weather State file number bel TUPOLE TU 134A4 68 8 1J6 3 YU AHZ aw Ff Everts 44 _ _ ApS History of tlight Local date UTE c an Injuries Local time 19 56 00 UTC t eG Aircraft recordings le Aircraft meteo Where State area of Yugoslavia Federal Republic of t i Latif Location of occ RECA AIRPORT Lone r Classification Editing occurrences CHAPTER g Duplicate Occurrence In the duplicate occurrence the Management topic does not get anything inherited copied from the source occurrence as this
169. rom the Windows Start button A office select Fa OpenOffice org 2 0 e Programs gt Eccairs 4 gt Browser in Startup igrapher LEA Startup Backup 5 Uninstal The system proposes a Logon fl ka window The user must logon by first choosing among the list of different repositories configured cA Repository MY REPOSITORY x Username EAF Password The Repository is a place where all the data the occurrences and all A user specitic settings related to z security access methods database Repository MY REPOSITORY i and application properties are eerste My REPOSITORY l stored and managed Password To complete the logon type in the Username and the Password that z have been setup by the ECCAIRS system administrator and push the H OK button or type the RETURN key Usemame PETER after the password Once the user has successfully logged in the system the Application main window shows up User Manual ECCAIRS Reporting System CHANGING THE LOGON PASSWORD I ECC AIRS dl _ Repository MY REPOSITORY Usemame PETER Cancel blogon Repository MY REPOSITORY x Username PETER Password Delete x Repository My REPOSITORY 7 Username PETER XXXXXXX New password Confirm new password To change the user logon password provided this function has been enabled for thi
170. rowser r M5 Warks ae Browser oe E4F Generator FI OFFICE Grapher a E4F Loader 5 pen ffice org 2 0 B Uninstall Exporter in Startup faa ka The rest of this chapter describes the Logon sequence and repository selection and or search which is exactly the same for all the ECCAIRS applications and tools except those mentioned in the note box below PRE REQUISITES AND ADMINISTRATIVE TOOLS The ECCAIRS applications suite can run only after a successful installation and after the configuration and definition of users and repositories The Repository Manager and Test Eccairs 4 Server Installation both in _ Programs gt Eccairs 4 gt RI iip manager Administration are aimed at this T onomy gt Repository Manager aa d are deser be d n Te z CCAI RS 4 a ae gt Test Eccairs 4 Server Installation Software Installation Manual we crapher together with all the installation and Uninstal configuration instructions for the ECCAIRS system administrator Running ECCAIRS applications 3 1 Should the list of Repositories be empty then the user cannot logon Repository To add a repositories follow the instructions on page 3 4 i e turn next page 3 2 PART 1 STARTING AN APPLICATION Let us have a look at how to run an ECCAIRS Application or Utility tor a Accessories gt instance the ECCAIRS Browser fea Eccairs 4 Fz Administration Fy Eccairs MSDE Taxonomy F
171. rowser v About displays a dialog whose upper pane contains cae TER information about the software version in use 1 O Pecc AIRS elease 4 Eccairs 4 release 4 2 Revision 6 Build 40 of 23 Oct 2005 Eccars 4 Browser 42 502 The ECCAIRS reporting system is a set of tools that can be used to collect exchange and analyse aviation related accidents and incidents The system implements the ADREP 2000 standard taxonomy as defined by ICAO for storing information in its repository Warning Thi computer program i owned by the European Commission Ibis protected by copyright law Nor EU aviation authorities and other organisations interested in using ECCAIRS should System Info contact the JAC Contact us OK closes this dialog window System Info recalls the system application which gives information on hardware and software configuration of the user computer Contact us allows to send mail to the ECCAIRS development team by invoking the user mail client program i e the program currently defined as the default mailer e g Outlook Express Eudora Pegasus Mozilla Netscape Mail Thunderbird etc with the correct address already filled in Printing and other utilities 10 9 The ECCAIRS Grapher PART 3 THE ECCAIRS GRAPHER 1 1 CREATING GRAPHS WITH THE ECCAIRS GRAPHER Starting ECCAIRS grapher sscciswsccncascusuncctmboossonvawnnepersonecnsatesons 11 1 Menu Bar overview geen ene ne oe ee en en 1
172. rren Fali pE SSA cack S58 nadt The printout includes all the Heighl Areler PPE Allude amp Eireeler i sections that have any _ attribute filled in the currently selected occurrence e CT waid 10 bre Mkiri rete Source by pe Fiidid tia Oren asd mi Prater deplh e a e Eol anget Bol alice Pach ailucde Pich angle Orhak wp on bripact SS Yidi Cateeory ight cit Fihr mand Lii Sh Pasi Lisi 22 Siyi Tehal S0 He ur a ta Delt P f User Manual The ECCAIRS Browser CHAPTER SENDING OCCURRENCES AS E MAIL It is possible to send selected occurrences also as an attachment to an 1 O E Mail To do this select the required occurrences and select File gt Send to gt E mail menu item or the corresponding toolbar item FE The MAPI compliant mail Connect client program currently New detined as detault within in ee the operating system e g ave Outlook Express Eudora Pegasus Mozilla Netscape are Mail Thunderbird etc is i invoked Jave as Database Recycle Bin The message body is filled with a pre typed test including date time current ECCAIRS operator and related organisation and the selected occurrences are grouped and attached as an E4F file Print Occurrence List HiECCAIRS4 workspace sample E4F Exit Compose E4F Files E 0 x File Edit View Insert Format Options Tools Help Send Select SMTP Contacts Spell Copy Cut Paste Attach Security Save
173. rrence file select the File gt New menu item or the corresponding icon button in the toolbar fai 3 This will bring up the standard file selection dialog window to specity the location and name ot the occurrence tile to create te Working with occurrence files 3 To save disk space occurrence files can be saved ina compressed format see page 8 5 The compressed format will not however affect positively the system performance Q 8 1 PART 2 OPENING CLOSING OCCURRENCE FILES oF Connect To open an existing occurrence file select File gt Open from the menu bar or the equivalent icon button in the toolbar Save a5 Hose Send to This will bring up the standard file ees selection dialog to specify the Recycle Bin location and name of the file to open with E4t extension Pring Qocurrence List HiECCAIRS 4 workspace sample E4f Exit z Connect To directly re open any of the most New recently used files select it from a those listed in the bottom part of Save a5 the File MENU Close ae An E4F file can also be opened by Send deidentified to double clicking onto its name in any Recycle Bin Windows explorer view e g browsing Print Occurrence ist the tiles trom My Computer icon HiECCAIRS 4 workspacelnew EDF file E4f See picture below H ECCAIR S4 workspace File Edit wiew Favorites Tools Help d Eack p E
174. rrently open query library plus a built in Select All query see side note The related year month plot is immediately displayed point 3 below Query by date Oj x GN feb MDE ar SDR EA az RR ser of poy ome Total 1 i a i i s ols nts tsetse a tq 4 11 i te Select Include empty dates to 1 The date to be used for i include also occurrences with z4 the query can be either the an empty date attribute 1 Local date or the 3 An additional row with empty 79 6 19 UTC date ra year label will be displayed USER MANUAL The ECCAIRS Browser Pushing the Query details button displays a dialog with a natural oa language explanation of the currently selected query 7 Query by date iol x 4 3 may g dk x otal Query details Date entered has value Clicking on a specitic cell i e on a specitic month and year combination and then clicking on the OK button the related occurrences are loaded into the Browser occurrence list pane Eccairs Browser Query Select All File Edit View Database Occurrence Help Jat dea St Pe As S aaae DEA ASEZ EQ Colombia 7100067 Es z piamen zA Colombia 7100067 Headline i E Narrative English L Events State reporting Colombia Date entered 2002 07 19 Query by date JE joj xj OLM not coded Based on query Select All Query details MY ADREPVIEVY 8 pearance C UTC
175. rting ong ARGI feat ote whe i riwha LTE daia labea mn argentine LITE teas Lecanto SAN METO p Evert Hatata Engish Sank rough surfece during Texding iaeo runway Arero CESSMA DURING TAM FROM THE ARRON TOWARDS Fei X THE PLOT TURNEU FIGHT TO AWD PASSING OVER A SOFT PART OF GROUND THE RIGHT GEAR DROPPED INTO A PTT YWITH A METAL COWER WHICH HAD SERVED AS FUEL STORAGE BUT WAS CURRENTLY N DISUSE THE METAL COVER HAD GIVEN WaT UNDE THE WEHT OF THE AUC AHD THE PROPELLER STRUCK THE PAVEMENT PATS Urk r Sechu r dinpace ATS urd ree Sector name Tepe Seren printed gt Ground bared safety nasty aleeting STEA alerting T MEANY alerting Workiond controller Claes APY batig OFT Mra uncer S A User Manual The ECCAIRS Browser CHAPTER THE TOOLBAR The Toolbar offers a quick visual access to a set of commonly used 4 functions in ECCAIRS Browser The usage of each icon button will be illustrated in this manual when dealing with the tunctions involved Stopping the mouse pointer over the toolbar icons causes the display of a brief description of the actions tunctions associated Show the Query Occurrence List Detach occurrence lisk window Copy data window Options Using the View gt Toolbar menu item the toolbar can be toggled as visible default choice or invisible A tick is displayed in front of the menu item currently selected THE STATUS BAR The Status Bar displays current intormation on
176. s Grapher Help MULTIPLE DOCUMENT WORKSPACE The ECCAIRS Grapher application can manage several documents at a time It is actually its Workspace which may host Multiple Documents i e the currently opened Graph Library as well as all the Graphs opened trom this Library Eccairs Grapher iol xil E E eee e U The windows can be Da ea amp Tile Horizontally i i 1 Tie Vertically Tiled horizontally or vertically H ECCAIRS 4 worksp e Cascaded automatically from the various Window menu items Library Graph 1 lv HiECCAIRS 4 workspace mylibrary e4g Graph 1 loxi a elr Each window can be minimised maximised or restored to the original size following standard Windows controls for multiple document windows MDI multiple document interface nt of The file number all Mon Tue Wed Thu Fri Sat Local date As Day of week order Ascending Creating graphs with the ECCAIRS Grapher 11 3 New Library G The Grapher will 2 ask the user to save the newly created library when either the Lirary window is closed or the Grapher itself is closed See page 12 8 for details Newsy Graph 11 4 PART 3 CREATING A NEW GRAPH If not yet connected connect to a database File gt Connect see page 7 2 File CONNEC D ixe livay THES Save Livary As Me chee Livan The ECCAIRS Grapher application organises its graphs in graph libraries j
177. s Attribute definitions ATM relation f Narrative Attribute Occurence Classification H Note Attribute Id 0431 Occurence class H E vents Separation Function detinitions ET ow Gainer Layout Aurcraft Aerodrome Airspace Remove The lower Function definition pane allows to display the values of the selected attribute in a specific Layout the default choice Layout value is appropriate Contirm the choices with OK Populate and draw the graph by the Graph gt Execute menu item or the toolbar icon button The curves traced are now 2 automatically drawn in ditterent colours The graph title can be modified to reflect its actual content e g Distribution of Occurrence Classes by Day of the Week M Class Distribution by D oo Bb 5 Distribution of Occurrences Classes by Day of fhe Week o 2 48 00 4 a 45 00 eed Incident 5 eoo o J Z 33 00 4 30 00 4 27 00 3 24004 To add a legend select Graph gt Legend 8 21 00 or the corresponding icon 18 004 l p 15 004 2 E 12 00 4 T 9 00 S Accident j 6 00 4 3 3 004 5 0 00 I I I I I I 5 Mon Tue Ved Thu Fri Sat Sun Oo Local date As Day of week 3D graphs and other functions CHAPTER 13 Define Z Axis 13 3 G The same result may be obtained via Graph gt Properties and the Shape field in the General graph properties card or Right click menu gt Gallery
178. s columns in the Occurrence List pane Vv State tile number v Manufacturer model Vv Fatal crew total Y Report identification Type designator Y Total fatalities Vv State reporting v Aircraft registration v Damage Aircraft Y Occurrence class v Operator VY Report status Y State area v Operation type VY Flight phase v Location Y Call sign VY Reporting org v Local date v Injury level v Report moderator v UTC date v Fatal passengers User Manual The ECCAIRS Browser Defining the initial sort order of occurrences The user can specity the attributes to be used as sorting keys three at most in the initial display of the Occurrence List pane pd Columns customisation Occurence Occurence Occurence Primary Ascending Occurrence Occurence Occurence Occurence Each attribute can be selected as Primary Secondary or Tertiary sorting key The correspondent sort order can be also specitied 433 Local date 477 UTC date of the occurrence Secondary Ascending e Tertiary Ascending i Level 21 Aircraft manufacturer model ig 34 Aircraft type designator assigned by air traffic management Primary 244 Aircraft registration Aircraft Sarandary 215 Operator airline operation Aircraft 7 mIa n MO At i v Tertiary g a Ascending Descending Selecting display level of multi level attribute values Some of the attributes have values specified through a tree hierarchy e g the Oc
179. s in a standardised way Resources previously invested to create and maintain local reporting tools can now instead be allocated to the analysis of the collected information Within the reporting system a graphic tool is provided allowing to produce easily quickly and on line the most common statistical graphs ASSESSMENT OF DATA COLLECTED Assessment of the integrated information can be done by all contributing organisations following agreed procedures The co ordination of the analysis and the dissemination of the results are under control of a steering committee The objective is to arrive at a reliable and common methodology to assess the development of aviation satety in the EU The results can provide intormation to national and EU policy makers in the aviation transport domain User Manual ECCAIRS Reporting System OCCURRENCE REPORTING SYSTEM The ECCAIRS occurrence reporting system is a set of software applications that provide together a complete solution to organisations that want to collect aircratt incidents and accidents occurrences in an ICAO compatible format The system includes tacilities tor easy electronic contributions to the ECCAIRS central office The reporting system can be made available after a translation of its internal dictionary in any of the official languages of the European Union ECCAIRS 4 is a completely overhauled version of the previous ECCAIRS 3 reporting system It is based on a new taxonom
180. s user by the ECCAIRS Administrator click on the More button in the Logon form Three new buttons are displayed in the bottom of the dialog click on the Change Pwd buton In the Change user password dialog which shows up type in the Old password then the New password and repeat it in the Confirm new password field Click on the OK button to contirm The Cancel button discards any change possibly made Running ECCAIRS applications CHAPTER 3 Q G PART 1 FINDING A REPOSITORY Q G The Repository is a place where all the To be able to use a database the ECCAIRS applications must access a suitable repository and therefore establish a link between the workstation and the Repository Server ee The repository and database server part of the ECCAIRS system may occurrences and all also be installed on the same computer Any standalone system may user specific settings related to security access methods access local occurrence files database and also use a local detault simplitied repository E4F usable only to application Repositories are created and managed by the ECCAIRS system properties are stored and managed 2 Logon _ Ecc AIRS Repository E4F ba Username Zi ne es Repositories Server Repositories Alias OK Cancel 3 4 User Manual administrator designated see ECCAIRS Software Installation Manual The link to the
181. story of flight Flags Airspace LDF Injuries a a E Narrative i Aircraft recordings a Note RR Aircraft meteo bese i Everts fk tata CFIT a EE Fire El ATS Unit ofl Survival es E Narrative ee Ditch AE Mote gt ajr traffic services oe i Events vee di reckagesmpact D ATM recordings 6 A GE Flight Crew HB Sector a Member El ATM Personnel e Other Personnel n Member wo Member Editing occurrences 9 3 PART 2 CREATING NEW OCCURRENCES A new occurrence can be created by either selecting Occurrence gt New from the menu bar or pushing the corresponding icon button in the toolbar Edit Delete Lock Grecurrence Release Occurrence Print Preview Print This creates a new occurrence in the working environment i e in a temporary space not yet in your current tile or database repository and opens a separate Occurrence Edit window Occurrence Occurrence O Xx File View Aa geal om r Filing information Bee Occurence bade Coo S E Bi Manooomert statereporing O Pate rte C OS U r When Loot CB ee al Loeki A i The newly created occurrence will r Where A D e contain some default attribute Location CiN oe values if any have been defined r Classification see age l O K 7 Occurrence class jf O p g r Severity r Injuries Fatal Serious Minor None Unknown Total Total on ground a Total on aircraft e
182. system EELE g 9 10 User Manual FILTER VALUES To filter values by a specific word click on the Filter On Off button a filter text field will appear on its left Slel l Had the user typed any text in the attribute field of the editing pane the filter would be toggled on and the text would be copied in the filer field Type in the filter field the word or part of it to be used as a display filter followed by the ENTER key Only branches lines in which one of the values contains the specitied text are now displayed The first occurrence of the filter word found is automatically selected FILTER VALUES AND EXPLANATIONS It the Explanation button has also been pressed the filter will operate also on the short and detailed descriptions So if the tilter word is found among the explanations the corresponding value branch line will be displayed also if the value itself does not contain the tilter word The ECCAIRS Browser DUPLICATING OCCURRENCES A copy of an occurrence can be created selecting the occurrence to be copied in the Occurrence List pane and then either Occurrence gt Duplicate Occurrence menvu ifem in the main ECCAIRS Browser window or the pushing the corresponding icon button in the toolbar Occurrence Duplicate Occurrence Delete Lock Occurrence Release Occurrence Prink Preview Print ECCAIRS creates a new occurrence containing exactly the same att
183. t of this chapter is about the core database access method the query and its related tool the Query Builder The ECCAIRS Query Builder is an integrated tool where queries and query libraries are created edited and managed It provides the user facilities to build queries without any need to be a database expert The ECCAIRS Query Builder described here in detail tor ECCAIRS Browser application is also used in other ECCAIRS applications and utilities which need to modity create or execute queries on the database Working with databases 7 1 PART 2 CONNECTING TO A DATABASE REPOSITORY File Select File gt Connect from the menu bar or push the corresponding icon button in the toolbar Mew Open Save Save a5 Close Send bo b Send deidentified to Connect l Recycle Bin Print Occurrence List H HECTAR SHworkspacetsample E4 Exit To logon v Choose among the list of configured repositories Repository MY REPOSITORY x usme Vl Enter the Username and the Password that have been setup by the ECCAIRS system administrator FAAN l i v Click on OK to confirm WHAT IF THE DATABASE REPOSITORY IS NOT LISTED XI Ifthe database repository is known to exists see below but it is not listed Eec A IRS E in the repository drop down list of the logon dialog refer to Finding a Repository on page 3 3 to add it Repository E4F A specific database repository act
184. tabases in the specific database management environment v About disploys ESSET information about the D An m T ECC ABS sofware version in P use and can give Eccairs 4 release 4 2 Revision 6 Build 40 of 28 Oct 2005 access to the system Eceairs 4 E4F Loader 42 502 information on the The ECCAIRS reporting vstem is a set of tools that can be used to collect exchange and analyse aviation related accidents and computer where Incidents The system implements the ADREF 2000 standard n taxonomy as defined by C40 for storing information in its repository ECCAIRS is currently running through the Warming This computer program iz owned by the European Commission tis protected by copyright System Info button law Non EU aviation authorities and other organisations interested in using ECCAIRS should System Info contact the JAC Select OK to close it Contact us E44F Loader CHAPTER 16 File Exit Help Contents bout 16 11 Fl The ECCAIRS Utilities WHAT IS THE DICTIONARY BROWSER The Dictionary Browser is the standard reference dictionary for ECCAIRS 4 users It gives a quick and complete view of the taxonomy used by ECCAIRS 4 i e all topics sections and attributes available For each item an ID a description short and long and a definition are given For each attribute its properties are listed including all the value choices available operators app
185. te The Right click menu gt Color menu O m I also allows to select a colour mimp imi Select the drop colour icon showing the currently chosen colour and drag and drop it onto any of the graph item for instance the graph title Marana O E E a amp xe amp H E amp 2t ga The same colour drag and drop action 2 etitation of Occurrences by Dev dr Cm Oe applied to all the elements of the 60 00 ee ae graph bars background legend etc i AN ERA To change the font and style of text items select X either the Font icon button or Graph gt Font ee menu item In the Font dialog window first 612 z chuchone choose the target label or legends and then Af the text properties to associate Contirm the choice with the Apply button Label Axis Label r Axis Left iz Right a A legend displays the text for A label displays a each tick mark at the generic text close to a particular axis of the graph specitic axis See page Click on Exit button 12 3 for details ia en zab dom to close the Font Local date 42 na Week dialog It Apply has not been selected before then all the choices made are ignored User Manual The ECCAIRS Grapher CHAPTER GRAPH LABELS A label displays a generic text close to a specitic axis 1 2 ECCAIRS Grapher automatically build descriptive labels trom the attributes and layout function definition chosen for each axis 5 xi a O
186. te actions performed each delete involved either a single occurrence or Multiple Occurrences 2005 09 29 13 42 52 5 30 2005 09 29 13 42 59 5 32 Remove ASE PPA Remove All Empty recycle bin 7100088 Unknown Accident New Caledonia 7100105 Indonesia Accident Indonesia Indonesia Accident Indonesia The lower list yellow or pale blue background lists the occurrences deleted within the delete batch selected in the upper list Removing occurrences trom the Recycle Bin with the mouse over the upper list M Right click menu gt Remove removes the selected occurrences delete batches M Right click menu gt Remove All removes all the occurrence delete batches listed in the upper list M Right click menu gt Empty recycle bin removes all the delete occurrence batches even those which are not listed in the upper list because out of the date range view tilter possibly set USER MANUAL The ECCAIRS Browser Clicking on a specitic delete batch in the upper list causes the related ae eR delete batch occurrence s data to show up in the lower list 5 Both the delete batches in the upper list and the delete batch occurrences in the lower list can be sorted by clicking onto the column headers To restore selected occurrence s select in the lower pane either M Right click menu gt Append to current file if the occurrence was deleted trom the currently open E4F tile or
187. ted 8 When done push the Exit button to close the Exporter Exporter 18 3 T G Note that the actions performed up to here do not yet execute the selected query a 18 4 PART 4 SELECTING THE OCCURRENCES TO EXPORT Selecting the occurrences to export is achieved by specitying a query on the database Also for some of the export formats available the occurrences to be exported may be taken trom an E4F tile Occurrences from database The ECCAIRS Query Builder is used to select the occurrences and the attributes with applicable export formats to be extracted from the database Click on the open file icon button in the upper left of the Source pane to invoke the Query Builder Query Builder H ECCAIR S4 worksp See The Query Builder window is displayed the last query library used is automatically opened and its queries are available for selection and or editing As usual it is also possible to open or create other query libraries or create new queries for details see page 7 6 onwards SOUE instrument instrument meteorological conditions conditions A Find all Occurrences where ee eaaa SS er a a aaae conditions equal ta IMC Once the query has been created or selected and the Query Builder closed the name of the query is displayed in the upper text box of the Source pane and its logical description in the lower text box On the spot queries It is also p
188. th the same name as one already existing in the current Library then the new Graph will have a number between parenthesis concatenated to its name to make it unique The same functions are available in the File and Edit menu of ECCAIRS Grapher File Edit S Connect at uk Ctrl Co Ctrl D Mew Library Ctrl M os z A Brat pes cli rice i Open Library Chrl o m Save Library Ckrl S Rename Save Library 4s i Close Library Change Icon fy New Graph Me Open Graph X Delete Graph i Import i Export Printer 1 HA ECCAIRS 4 workspace mylibrary e4g H exit 3D graphs and other functions CHAPTER 13 eo 13 13 The ECCAIRS Grapher 14 THE DATA GRID BEHIND THE GRAPH DATA GRID AN OVERVIEW The data grid is the spreadsheet like matrix of values which is ted by the queries on the database and possibly completed by additional processing of the data series e g adding rows or columns hiding and filtering data sorting and ordering information normalisation etc The data grid has then a direct link to the visualised chart in the graph This flexibility allows to prepare a number of useful standard graphs that can be re executed easily on the data and provide directly a set of satety indicators Graph To make the data grid visible select Graph gt Datagrid when a graph is open or use the corresponding icon on the graph toolbar A Eont M Class Distribution
189. the ECCAIRS Browser status MY REPOSITORY G2 2005 10 28 04 26 Current repository name Database connection icon and Current date and time PETER i JRC Current user and Current organisation PETER ER URC Selected 3 Visible 275 Total 275 MY REPOSITORY amp 2005 10 28 04 26 7 G Selected 3 Visible 275 Total 275 If more than 500 Number of occurrences currently Ree en ae selected from a query the visible query result batch total number will also be displayed This is because query results are handled by default in batches of 500 occurrences see page 7 19 Exploring the Browser 4 7 When operating on EAF file occurrences the background colour of the list pane is yellow The list of occurrences resulting from the database query is displayed over a pale blue background 4 8 PART 2 THE OCCURRENCE LIST PANE The Occurrence List pane displays a list of either the results of a query to the database or the contents of an E4F file and can be used to browse sort search or print them See page 6 1 for available functions on list of occurrences Clicking with the mouse on a row selects the corresponding occurrence and its data is then displayed in the occurrence pane above State reporting State file number Date entered State area Finland FIM THO01 Finland CAA af 04 2002 Switzerland Switzerland reinhard Switzerland AIB 73042002 Switzerland
190. the European Commission prior to installing and using the software Permission to use copy and distribute this software and its documentation for any purpose and without fee or royalty is hereby granted provided that the full text of this license agreement appears on ALL copies of the sottware and documentation BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE THERE IS NO WARRANTY FOR THIS SOFTWARE TO THE EXTENT PERMITTED BY APPLICABLE LAW THE COPYRIGHT HOLDERS AND OR OTHER PARTIES PROVIDE THIS SOFTWARE AS IS WITHOUT WARRANTY OF ANY KIND EITHER EXPRESSED OR IMPLIED INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THIS SOFTWARE IS WITH YOU SHOULD THIS SOFTWARE PROVE DEFECTIVE YOU ASSUME THE COST OF ALL NECESSARY SERVICING REPAIR OR CORRECTION IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW WILL ANY COPYRIGHT HOLDER OR ANY OTHER PARTY WHO MAY REDISTRIBUTE THIS SOFTWARE AS PERMITTED ABOVE BE LIABLE TO YOU FOR DAMAGES INCLUDING ANY GENERAL SPECIAL INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THIS SOFTWARE INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THIS SOFTWARE TO OPERATE WITH ANY OTHER PROGRAMS EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES ECCAIRS on th
191. the combination of two attributes State Reporting and State File Number User Manual ECCAIRS Reporting System ECCAIRS REPOSITORIES The concept of an ECCAIRS repository has been introduced in ECCAIRS 4 to distinguish it trom the traditional database approach The Repository is a place where the manager of an ECCAIRS intormation system stores and manages centrally not only all the data but also all user specitic settings related to security access methods database and application properties When a user establishes a connection to a Repository the working environment and the user privileges as set by the Repository administrator in the Repository Manager application are transterred to the user s workstation Only then he she is able to access the database in the Repository This implies that user specific settings can be managed centrally and are applied anywhere from which the user makes the connection It is possible to have a Repository without a database In such a case the connected user can still access occurrences in an E4F tile applying the settings as detined for the specitic Repository but will not be able to access a database for this repository ECCAIRS overview CHAPTER 2 PART 1 ECCAIRS TAXONOMY The Taxonomy of ECCAIRS 4 is the catalogue describing what information can be stored in the ECCAIRS 4 Repository and how this information is possibly encoded in the data fields Most of the Attributes of ECC
192. the same ba elements etc as the standard ECCAIRS appl Related topics Release Notes 18 24 User Manual The ECCAIRS Utilities M Dictionary Browser starts the Dictionary Browser which can be a ER usetul while editing queries and selecting attributes 1 3 File view Definition Help ADREF Gecunrence Id Short Description senn Filing information i oo0000 lo CcUnence i When Description where sss Classification meas 5 everity vee Injury totals ATM relation Definition ee Separation ee a General senes Distances vey Aircrafts oe Movement v About displays information about the software version in use and can give access to the system intormation on the computer where ECCAIRS is currently running through the System Info button Eccairs 4 Exporter i as ni Pal GEGEE Eccais 4 release 4 2 Revision 6 Build 40 of 26 Oct 2005 Eccairs 4 Exporter 4 2 502 The ECCAIRS reporting system is a set of tools that can be used to collect exchange and analyse aviation related accidents and Incidents The system implements the ADREF 2000 standard taxonomy as defined by ICAO for storing information in its repository Warning Thi computer program i owned by the European Commission lt is protected by copyright law Mor EU aviation authorities and other organisations interested in using ECCAIRS should System Info contact the JAC Contact us Select OK to close this window Exp
193. tion Attribute This can be entered either gt Using the ECCAIRS standard Attribute Selection dialog window O cCurrence El Filing information Siete see also side note Once Hekate He number State reporting selected both the Id field and the Date entered L eadine triplet Topic Section Attribute get El When completed tilled in Local date LTC date nee gt Entering directly the ICAO Attribute UTC time ld numerical code in the ld field Where Latitude of occ Location af occ s state area of occurence oe po Lanatua hoe Attribute Occurence E Classification Severity a Occurence class Attribute Id joast Injury level Bese Occurence category Henen Saali El Severity TTT age definitions aA W_ _ Damage aerodrome Ask later 7 o C iniur totals e Working with databases CHAPTER 7 More options for the ECCAIRS standard Attribute Selection dialog window are given in Specifying attribute values page 9 8 within the Editing occurrences chapter 7 13 7 14 PART 2 Operators This can be chosen from the drop down list proposed in the dialog Criterion Builder fa Attribute definitions Attribute Oecurence Severity Attribute ld 0451 lnjury level Oprator pL Value definitions E egual to none equal to has value Ask later has no value has at least ane of doesnt have any of not equal to The type of ope
194. tion process a window is displayed with an 1 s overview of the result Clicking on the View button opens the log file if generated see note box below Clicking on the Exit button will return to the E4F Generator main window Eccairs E4F Generator l x Summar Upload status Completed l Time elapsed 0 02 Count Total Processed Accepted Rejected Records Logging H SECCAIRS 44workspace IMC occurences log tet View In the Summary pane you find vi The Upload status at the end of the process v The Time elapsed for processing v A Records count i e an overview of the total number of occurrences processed accepted and rejected In the Logging pane you find v The name ot the log tile generated WHEN IS THE LOG FILE ACTUALLY GENERATED Note that clicking on the View button actually opens the log file only if the file has been generated i e the log output was non empty It the All option has been specified in the Logging options pane of the main window then there will always be something to write to the log and so the log file will always be generated lf the User feedback Errors only option has been specified the log file is generated only if errors or warnings were generated during the processing E4F Generator 15 7 ie Exit Help Contents Fi bout 15 8 PART 4 E4F GENERATOR MENU BAR ITEMS The E4F Generator has a menu bar with two menus v The File menu has a single ite
195. ton to ount T otal remove all e4f from the list 14 In the Count Total field the total number of selected occurrences is shown E44F Loader CHAPTER 16 Nerselect E4F files you can also directly drag and drop them from any standard explorer window opened on your desktop into the file list in the top pane of E4F Loader 16 3 An example of inconsistencies detection is checking that Total injuries attribute value in the Injury totals section of the Occurrence root topic corresponds to the sum of values for the Injuries grand total attributes of each aircraft involved in the Injuries section of each of the specific Aircraft Injuries topics 16 4 PART 4 DEFINE E4F LOADER OPTIONS Once the E4F tiles are selected you must set the Loader options Check the Autocorrect inconsistencies box in the Loader options pane to allow the E4F Loader to automatically detect and inconsistencies Eccairs E4F Loader File Help Modified Add Sh IMC_occurre 479RKB 137 0172004 15 H SECCAL 2h my EDF_file 45KB 107 0972002 10 H SECCAL repair x Remove Clear Count Total Ad Loader options M Autocorrect inconsistencies IF occurence exists then Prompt user Prompt user Overnarnite occurence in database Keep occurence in database IF occurence m database ts older overnite Stop uploading IM Log Activity C All User feedback Erors only
196. ttom status bar 1971 4 Switzerland Germany Yugoslavia Federal Republic of S 1 0002 TE AES United States af United GULFPORT MISS United States i United States JACKSON LMS United States Z Lek lInited States United States NFw YORK NY gt PETER Tan JRC Selected 1 Wisible 38 Total 40 MYREPOSITORY amp 2005 10 28 04 26 7_ United States NEW HAVEN CONN USER MANUAL The ECCAIRS Browser CHAPTER 6 SEARCHING FOR OCCURRENCES To search and select an occurrence containing a specific string select vi Edit gt Find from the menu bar or M Right click menu gt Find in the Occurrence List pane Enter the search string in the Search dialog Edit box displayed and hit OK to search Edit om Only the first occurrence matching the string eal E Copy Copy is found and selected if any p Faste Paste au Delete Cancel Select all Select all Find Find Next ste Filter by selection L od Filter excl selection Libyan Arab Jamahiriya a Filter by oe iad aWwitzelar IOC Remove filber Toe 10C T Australia 10C Congo the Democratic republic of lO India To find and select the next matching occurrence use v Edit gt Find Next from the menu bar or M Right click menu gt Find Next in the Occurrence List pane SAVING SELECTED OCCURRENCES It is possible to send selected occurrences either to an E Mail address to an E4F file or to a database rahe To do this sel
197. two menus are available also in the toolbar hal MINIMUM NUMBER OF ATTRIBUTES REQUIRED The minimum number of attributes that need to be filled to be able to save the occurre in the File Information section within the main root occurrence occurrence tree nod gt State Reporting gt State File Number gt Reporting Organization If any of them is missing an error message is issued on saving exiting Editing occurrences 9 7 4 Data type errors are notified to the user by removing the incorrect input data and issuing an alarm sound bell sound G Also ICAO attribute section codes and their definitions can be displayed Just hold down the CTRL key while clicking onto the section attribute name in the Information pane See page 10 6 for details 9 8 PART 2 SPECIFYING ATTRIBUTE VALUES There are different ways to fill in occurrences attributes FR Unit conversion calculations are performed if the h measurement unit Mach number j ais is changed after a mph numerical value has been entered Severity Damage aircratt Destroyed Substantial Minor Direct editing The user types in the value needed terminated by the RETURN key of by moving to another attribute either with the TAB key or by moving the mouse pointer Clicking with the mouse right button on any attribute measurement unit will display a set of alternate units available
198. ually exists if it has been created and lt n a configured on a repository server by the ECCAIRS system administrator Password Note that the repository E4F does not support database access The E4F repository is pre detined by default in the Repository Manager and your ECCAIRS system administrator might make it available to the users 7 2 USER MANUAL The ECCAIRS Browser For a short time a splash screen may be displayed while the connection is being established Connecting to Repository i When either the main window is displayed if connecting at start up or the control is released to the ECCAIRS Browser main window when switching trom one repository to another the system is ready to start working with the database lajxi File Edit Yiew Database Occurrence Help MYADREPVIEVY EE MY ADREPPRELIM E al MYATMYVIEYY The Occurrence List pane is automatically switched to the Show the Query Occurrence List View mode ditferent background colour pale blue by default The connect icon in the status bar bottom right will be turned active and the changed repository name will be displayed MY REPOSITORY 52 2005 10 28 0426 2 PETER amp JRC Selected 0 Wisible 0 Total 0 MY REPOSITORY amp 3 2005 10 28 04 26 4 The connection with the repository in use is automatically closed either by connecting to another repository File gt Connect function or
199. ue name is proposed Graph n with n 1 Press OK to confirm Eccairs Grapher File Edt Graph Options Window Help Dao dali e xt Bel Sl aw eS H ECCAIRS4 workspace mylibrary e4g a Press the OK button to confirm Library aja The new graph window is displayed with a sample graph already traced 7000000 00 6000000 00 4 5000000 00 4 The sample graph has the given new graph name shown in its caption 4000000 00 4 Creating graphs with the ECCAIRS Grapher CHAPTER 11 G In addition to the general standard graph templates proposed the user can define his own custom graph templates See page 13 8 for details 11 5 Graph Save Graph Save Graph 4s Save Graph As Templat 03 Save to Clipboard 48 Print ELLI vertical Grid E Horizontal Grid B Legend a 30 Rotate 67 2 Clustered A Eont IN Properties i i Datagrid Q Zoom Scrollbar a Build Query Edit Query Define X Axis e Define Y Axis TA Define Z Axis 2 Show Query Definition p Execute Pi Toolbar PART 3 THE GRAPH WINDOW Initially betore any query has been run to extract data to be plotted the graph window contains only exemplary curves or other plots already traced Eccairs Grapher File Edit Graph Options Window Help ja aswa UEBA AmQ aeg r 7000000 00 6000000 00 4 vY 5000000 00 Legend box 4000000 00 E G
200. ues in a series is set to 1 Each value is then recalculated appropriately In ECCAIRS Grapher normalisation is implemented by expressing each value as percentage of the total The Data grid behind the graph CHAPTER 14 14 9 14 10 PART 3 ADDITIONAL DATA GRID FUNCTIONS Decimal places In many cases the data grid and the graph should display the numbers using a specitic number of decimal places e EN This preference can be set from the toolbar by CIMAS operating on the Decimals control Load data It is also possible to load external data in the data grid from a TAB delimited text file To do so click on the Load Data icon button in the data grid toolbar and browse to select the text file with the external data In such a case the graph will have no link with the database It could be used for simple visualisation purposes Saving exporting graph data There might be cases where the pure graph plotting data rather than the graph itself may be useful for further processing Let us suppose for instance we wish to import the graph data in Microsoft Excel Open the data grid and select the Save Data icon button in its toolbar User Manual The ECCAIRS Grapher CHAPTER 14 MClass Distribution by Day of Week et coo S inl e E a lor a REl Distribution of Occurrences Classes by Day of the Week i T 2 ce a o Inc T ii jh aa T va T
201. umn or row vI Moving Average Calculates a moving average over the data series indicated i e the average over a column and its n preceding columns i Function parameters The value of n can be set in Ntare OOO the Insert Row Column dialog R Min Calculates the minimum of a selected column or row R Max Calculates the maximum of a selected column or row M Threshold Inserts a new row or column with a constant value for Function parameters Threshold all the cells The constant value can be set in the dialog window v None Inserts an empty row or column The user can type in values for each cell Consider a NULL value as ZERO check box allow the user to specify if empty cells must be interpreted as ZERO fe Incident Select all Accident L sum Deselect all Moving Average Threshold For instance Consider a NULL value as ZERO option would not be appropriate when dealing with an average age ot pilot data grid a zero value influences the average age during the computation The correct use of the Consider a NULL value as ZERO check box must be evaluated on a case by case basis The Data grid behind the graph CHAPTER 14 14 5 Remove Column HidesUnhide Adding new rows columns with the Group function see page 14 4 automatically hides the rows columns used for grouping 14 6 PART 3 EDITING REMOVING AND
202. urce pane of the main Exporter window will also display the choice of attributes to be exported with the query Exporter CHAPTER 18 It is best to practice with various options to understand the rules for combining different functions for the attributes selected The system will give you appropriate hints when combinations not allowed are chosen 18 7 18 8 PART 4 EXPORT SELECTED ATTRIBUTES IN TEXT ACCESS OR EXCEL FORMAT The first three choices in the Source pane allows to export query Destination selected occurrences F Selected attributes of occurences in a pair of text files H ECCAIRS 4 workspacesIMC feloud tet trom the database with Selected attributes of occurences in an Access Database a specified set of their attributes into text Selected attributes of occurences in an Excel Spreadsheet Access or Excel file s Proceed as follows 1 Select one of the three export formats in the Destination pane 2 Specity the tull tile path and name for the output file by typing it into the corresponding text box or by clicking on the file open icon button to invoke the standard tile browse dialog 3 Specity the query to select the occurrences to be exported see page 18 4 and specity the attributes to be exported see page 18 6 through the Source pane 4 To start the export procedure press the Execute button The occurrences exported and their selected attributes are always
203. urrence List pane Occurrence New Duplicate Occurrence Lock Grecurrence Release Occurrence Print Preview Print Edit uk Copy Paste Select all Right click on the State file number Report ident g A Filter by selection State are 7100119 00373 Occurrence List Filter excl selection Unknow r 100125 ane to aet its Serbi Filker by Tugoslay 7100220 oo72 P g CE ee ear eee United Kit 7101004 1 0002 contextual menu United St 7101010 1 0003 United St 7101011 1 4 1 States i United St 7101013 1 0006 United States Find Next United St 7101053 3 0001 United States Accident United St TU 7 Ann lInited States ccident lInited St PETER rah JRC Selected O Visible 40 Total 40 The occurrence s is are not actually deleted but are moved into the Occurrence Recycle Bin so that they can be recovered if needed see page 6 8 At least this is the default behaviour for the Browser unless it is intentionally disabled see page 6 8 Working with the list of occurrences CHAPTER 6 PART 2 FILTERING OCCURRENCES Occurrences in the Occurrence List pane can be filtered i e only those satistying some criteria will be displayed This is done through the contextual menu Right click menu which is invoked by right clicking on an occurrence in the Occurrence List pane Edit State reporting 7100119 003 73 United Kingdom 7100125 Yugoslavia Federal Republic of
204. user can define which programs to activate when attributes are changed when certain additional menu items are selected and when certain events take place i Options r ctivating Attributes Attribute Prog id Changes data One instance per event Activating menus Name Progld Available in One instance per event Name Progld Changes data One instance per event Depending on the specific repository configuration set the editing of external interface parameters could be available only to the administrator on the server system MORE INFORMATION ON ECCAIRS BROWSER API A detailed description on the use of these API functions can be obtained from your ECCAIRS administrator The ECCAIRS 4 Browser API white paper is available on the support section of the ECCAIRS web site http eccairs www jrc it User Manual The ECCAIRS Browser CHAPTER D PAGE PRINTING SETUP All print output in the ECCAIRS Browser i e File gt Print Occurrence List and Occurrence gt Print is normally directed to the default system printer i e the one set either via the Windows Control Panel Printer item or via START Setting gt Printer Windows menu selection Whatever the detault printer is through the Page Setup options tab pane a specitic printer can be chosen tor ECCAIRS Browser Options Peo l By pushing the Setup button the user can select specific printer preferences using the Windows Print dialog
205. ushing the icon button again or agai selecting Right click menu gt Unhide a toggles the visibility status User Manual The ECCAIRS Grapher FILTERING DATA FOR DISPLAY It is likewise possible to automatically hide information by applying a filter on the data grid Filters can be applied and based on any type of row and column those generated directly by the query as well as those added in the data grid To filter a data grid push the Filter icon on the toolbar The dialog window showing up allows to identity the various parameters for the filter zi iiFilter n v Show only those Show only those C Rows Columns Rows Columns Selects fi lte ri ng by rows or Ww here row Incident Select item columns Greater or Equal to v Where column row Less or Equal to Not equal to Selects the column row to be used for the filtering based on the EE operator described in the Din Select item field Column Top It rows are to be filtered then the specified column will be used for the comparison Vice versa happens when filtering columns M Select item Selects the operator to be used for the comparison v The bottom box in the Filter dialog allows to specify the reference value for the comparison which can be M Value a constant value M Row the corresponding value of a specific row M Column the corresponding value of a specific column The last choice Top is not a reference value see below
206. ust as queries are organised in query libraries To create a new graph library either M Select File gt New Library from the menu bar or v Push the corresponding icon button in the toolbar H ECCAIRS4 workspace mylibrary e4g Ioj x Library Lom Bar Stacked Bar Stacked Preview 100 x 6000000 00 Curve 4000000 00 Pa 2000000 00 0 00 i i i Area wm z KT x User Manual A Library window appears inside the main window To create a new graph within the library either M Push the New button in the Library window or v Push the New Graph toolbar icon in the Grapher window v Select File gt New Graph menu item in the Grapher window The New Graph window allows to select the type of graph needed from a set of templates listed as icons and names in the left pane A preview of the currently selected graph is shown in the right pane Three icon buttons on top of the preview pane allow to display the graph template list with different views The ECCAIRS Grapher For instance select the Line graph template from those listed in the General tab then contirm by either double clicking onto it or pushing os the bottom OK button 4000000 00 General Custom w l W Bar Bar Stacked Bar Stacked Preview 100 A Gantt Curve After selecting the graph template mne o a _ECCAIRS Grapher asks for the new ial graph name A default uniq
207. w Depth displayed in page 12 6 User Manual The ECCAIRS Grapher CHART PROPERTIES GENERAL SERIES Chart FX Properties f x General Series Aves 30 Effects Pole r 2p Set for instance Axes style T Cluster Z Axis to Math through the icon drop down visual list Stacked een L Da Scheme Ames style jl je JEM Grid lines a O round E Math 4 oeececs mm M TTE Bm io misimisi Iie ooo Set for instance both the Background and the Chart box colour to white Appl On ee Original Color Set for instance the Shape attribute in the Markers box General Series to a round dot through the icon drop down visual list C Marker fill Coor T Show ewer f f Same color at markers Size 3 D C Custom Set for instance the aia Show very attribute to 1 Style The graph will display a weir marker for every value E Cancel Apply b Help The General properties card is used to change effects and colours Some sample settings are shown here The Series card is used to set features for each particular or all data series Some sample settings are shown here Remember to confirm the choices by pushing the Apply button Setting the graph properties CHAPTER 12 General Sereg 12 5 Aves Scale 12 6 PART 3 CHART PROPERTIES AXES
208. xcluded must be specitied before the proper export phase To export using a template proceed as follows 1 Select the Complete de identified occurrences in E4F format in the Destination pane 2 Specify into the Destination pane the full tile path and name for the output file either by typing it into the corresponding text box or by clicking on the tile open icon button to invoke the standard tile browse dialog f Complete de identified occurences in E4F format H MECCAIR S 4workspacesIMC_de identified g Bila 3 On the same row click on the mask icon button to invoke the Selected Attributes will not be exported dialog a The View Definition drop down menu allows to chose the specitic view and its associated hierarchical tree structure View Definition TREET 4 i 3 r eR fe ptt i Remove gt a Clear Occurence tr eu The contextual right click menu G ee Date entered f n Headline also allows to locate in the eR eporting org lett pane hierarchical view the Most of the attributes in clued in Filing information section are sent State file number hee beahe reporting attribute selected in the t i i a iat a seal Latitude of oce aetan kmt Location of occ excluded They are ro Use the three central icon buttons to greyed out in the oo Shatevarea of occurence Add left pane Remove Clear the attribute s in the
209. y ADREP2000 uses new data tormats XML based has a new user interface tree structure instead of tabs and in addition to the improved Flight Operation domain supports now also Air Traffic Management occurrences ECCAIRS BROWSER Occurrences are entered moditied viewed and printed with the ECCAIRS Browser Authorities can start exchanging compatible data electronically with peer organisations and the ECCAIRS central office Data consistency and efficiency at the network level is thus guaranteed EU authorities are also obliged to report serious incidents and accidents to the International Civil Aviation Organisation ICAO in a standardised format ADREP Because ECCAIRS has adopted ICAO s ADREP format these reports can now be sent electronically without the need for data conversion Occurrences can be stored locally in an ECCAIRS Data Format tile and can be stored in a relational database when the ECCAIRS Browser can be connected to the database server Occurrences are retrieved from the database through queries built by the users Queries can be constructed easily without any knowledge of the used technology e g SQL language ECCAIRS overview CHAPTER 2 PART 1 Common queries can be stored in libraries exchanged with other users and re executed any time ECCAIRS GRAPHER In addition to the ECCAIRS Browser application there is also an ECCAIRS Grapher a graphing tool which produces easily quickly and on l
210. y Builder H ECC AIRS 4 workspace myquery_library e4g Select All ae Remove Copy ASK injury severity level lt lt instrument meteorological condi tiog d me e I Z ABA SA with fatal injuries Ten SA with fatal injuries and IMC isibility less 50 mt oe isibility less 50 mt and heavy p uk Copy Paste Delete From the Library menu it is possible to v Create a New query library Hi ECCAIRS4 work yquery library e4g v Open an existing one M Save it with the current name ae Vl Save as saves it with another name Close M Close the library Iv Directly select and open any of the most recently used libraries v Exit the Query Builder Exit From the Query menu it is possible to MI Create a New query Edit M Edit the selected query in the list a v Cut Copy Paste a query Paste M Delete the selected query from the Delete current query library Working with databases CHAPTER 7 G By right clicking in the Query Library Editing pane the contextual menu is invoked The Right click menu has the same menu items as the Query menu 7 9 7 10 PART 2 CREATING AND EDITING QUERIES Creation of new queries or editing of existing ones can be achieved within the Query Builder main window by Selecting Query gt New or Query gt Edit menu items this latter requires previous selection of an existing query Query Builder He O x
211. y of aircraft may have been compromised having led to a near collision between aircraft with ground or obstacles Le safety margins not respected which i not the result of an ATC instruction On the left side the values tree pane there is a hierarchical list of all the values which can be chosen for the attribute previously selected in the main window The attribute value currently selected in the values tree pane for instance Occurrence class Major incident are identitied and described in the identification pane right pane by v Id the value attribute identification number in the taxonomy M Short Description M Description M Definition User Manual The ECCAIRS Utilities As usual in the tree pane a single node can be collapsed expanded Three buttons also help in the navigation of the attribute values tree _ Occurrence class Collapses the entire tree Serious incident Expands the entire tree ca is Toggles on off a filter on Somer the tree view The filter is applied by terminating the filter text with the ENTER key Sle The attribute vale Short Description and Definition provide the text to be displayed in tool tios available in ECCAIRS applications when selecting a value trom a hierarchical selection and search box see page 10 6 for details Occurrence class E Ed iam Pa ccident bDehreen dicra iiA ground oF obstacles pe safety margins not respected W
212. ying an occurrence object in the universe State File Number Value the unique identifier for an occurrence within a state s administration State Reporting Value the code for a specific state in the ECCAIRS Repository State Reporting Value Description the expanded readable version of the State reporting the occurrence Here is an example of the first four columns of the expanded format in Excel E export sample excel_xls E2BDAC 144A E2BDEC14AA 36146250055 3612625005 6 EC361400441 6C36140DA41 amp 2064900327 F S 2064900327 F C307 ESF B62 C307 E5F B62 7BF42CA2CB 7BF42CA2CB AEABAAACAS State file State State reporting number reporting Description r 100001 138 r 100001 138 Libyan Arab Jar Libyan Arab Jar r 100005 229 Switzerland r 100005 229 Switzerland r 100066 g5 Germany r 100066 g5 Germany 7100119 246 7100119 246 7100125 264 r 100125 264 r 100220 246 100220 246 r 101009 United Kingdorr United Kingdorr Yugoslavia Fedi Yugoslavia Fedi United Kingdorr United Kingdorr 249 United States User Manual The ECCAIRS Utilities There are then six other columns which are used to describe each single attribute on Where ATTR_ID a line Identifier of the attribute following the ECCAIRS coding of ADREP 2000 ATTR DESCR Textual description of the attribute as generated by ATIR V the installed version of ECCAIRS Attribute Value the value of the attr

Download Pdf Manuals

Related Search

Related Contents

1º Etapa  取扱説明書 （施主様向）  Sony Walkman NWZ-S544BLK User's Manual  Untitled - 1st-line Equipment, LLC  取扱説明書 - イメージニクス  Aspectos Conceituais da Regulação Econômica  SPECIFICATIONS, INSTALLATION, OPERATION AND SERVICE  AQT0206G.取扱説明書UTL コピーx  Mode d`emploi STAROS  Rust-Oleum Automotive 253438 Use and Care Manual  

Copyright © All rights reserved. Failed to retrieve file