1 Title: AbeMusiQ User Guide Date: September 3, 2006 updated
Contents
1. Composer Aaquist Johansen Svend 1948 Morgensange 1970779 5 Aarflot Andreas keis Chase for Big Band Aaron Bemard 1939 Auztian Dance 1996 Abaco Evarista Felice dall 1675 1742 Op 4 11 Sonata d Abazis Theo 1967 Pas de deux 1997 Abbott Alain 1938 2 Pr ludes 3 The result area becomes visible as soon as the database is selected Output of every query is alphabetically per composer Within a composer the sort order is ascending per title When pointing to the Composer title bar the number of displayable entries in the area will be given as a tooltip The Date field is replicated per composer The input does not have the date field defined for each entry Therefore the first non space date field for a composer is replicated to the other date fields which are space Date conflicts per composer are not signaled The space of the Title field is temporarily used for a roll out list when setting a display filter During this time the Composer and Date field are invisible 4 3 Control frames There are three control frames Display filter Record positioning and Current record Properly speaking the latter frame only gives detailed query results while the first two control the queries 4 3 1 Display filter The data to be queried can be narrowed down to a subset of the total number of records This process is called filtering which is provided per Location Instrumentation or Code When no filtering2. AU el che ce i a ec a a cence cctv cet ct sce cet cate vd cee cate dvd cen de dvds ces noc e ssn nce ce dene 7 TSU UCC sss SLL PPP PIPPI III IIIA IIIS lela eel 8 Cac Olt oe eee ee nn 8 9 Doc ment ehans ehi Storys EE EEEE E EEEE EREA aE eR ARRE a Ra A kiari 9 1 Introduction AbeMusic is a database of music for guitar and lute in chamber music and with orchestra It has currently more than to 30 000 entries The database is originally designed for use with MS Works To work with MS Works you need the license and knowledge of that database in order to make queries AbeMusic is supplied and copyrighted by Abel Nagytothy Toth AbeMusiQ allows you to query the AbeMusic database without MS Works It is a self contained program which runs on any modern Windows installation without the need for an MS Works license or another database tool No knowledge of a database program is required The query capabilities of AbeMusiQ on the data supplied by AbeMusic are superior to those of MS Works while manipulation is intuitive The AbeMusiQ program is freeware The user can add private information which is stored separately At startup time the user selects to show either AbeMusic data or private data or both 2 Environment A modern Windows system is required AbeMusiQ runs on Windows98 Windows2000 and WindowsXP The AbeMusiQ panel can optionally use the full vertical space of the screen size excluding the toolbar There is no need for any other software l
3. user wants to be able to distinguish his private data when the display combines both a specific string can be added to for instance the title An example would be Concerto in D jdk 6 Installation There are two sources which you need to tap AbeMusic is distributed on CD which can be ordered with Abel Nagytothy Toth AbeMusiQ must be downloaded from www dekloe be then installed according to the installation procedures explained in the accompanied file README TXT Move the files mentioned in chapter 3 from the CD to a folder of your choice ie AbeMusic The first execution of AbeMusiQ requests to provide the path to this folder A sample menu looks thus SIP Select folder 1 05 S Select Cancel Select drive Select folder E c EJEA E3 Program Files E3 Microsoft Visual Studio ME KEEL Select ie Cancel Once the path is established the program remembers it for a subsequent execution You can have more than one version of the data when stored in different folders Use the File gt Select path to switch between the versions When you have additional needs conversion from the Works data base to data files or when modules are missing from the delivery contact the author 7 Profile A small file is maintained which keeps the information between sessions It is not necessary to understand the contents of this file named ABEMUSIQ PRO This is where the program remembers the setting of the langu
4. 178 Concerto C 14 Abel Karl Friedrich 1723 1787 Sonata G Search in Instumentetion Abel Karl Friedrich 1723 1787 Sonate A 1759 Search in Codes Abel Karl Friedrich 1723 1767 Sonate Aj 1759 Abel Karl Friedrich 1723 1787 Sonate A 1759 m Current Record 1 Abel Karl Friedrich 1723 178 Sonate A 1759 Abele Alexander 136 Open Strings a Voyage of Discovery 1999 Composer Aa Michel van der Abell n A G xx Aires Murcianos Abell n A G x Introducci n y divertimento Date 1970 Abell n A G x Pep n Liria Abels Michael 1962 Gospel Arrangements 1991 2 Title Auburn 1994 10 Abeltshauser J G xIx 24 Valses Ablinger Peter 1959 1 127 2002 80 Publisher Don Aboulker Isabelle 1938 Arabesque Abrahamsen Hans 1952 Aria Version 1979 7 Location Abrahamsen Hans 1952 Autumn 1972 7 5 net teti Ea Abrahamsen Hans 1952 Concerta 1990 15 BA ilo cule a Abrahamsen Hans 1552 Concerto 1999 2000 16 bu EGt tt t i i S OO Abrahamsen Hans 1952 Double 1975 4 eae Ma hal Abrahamsen Hans 1952 Efter r 1970 77 5 Donemus Abrahamsen Hans 1952 Slumgange 1972 7 Paulus Potterstraat 14 NL 071 CZ Amsterdam NL gt gt Prs Abrahamsen Hans 1952 Winternacht 1976 87 13 www muziekgroep nl Abrahamsen Hans 1352 WoT Abram John 1959 2 Ethe R 1990 20 Abram John 1359 Aeneid Music Opera 1998 165 Abram John 195
5. Display filter Aa Michel van der 1970 Auburn 1994 10 D a ae A ev Riicheiwamdor 1970 Dormant 1993 7 No filtering Total entries in database 31711 Number filtered 31711 Aaquist Johansen Svend 1948 Op 35 Morgensange 1970 9 5 gees o e Aaquist Johansen Svend 1948 Op 44 Historien om Malinche 1982 3 Aaquist Johansen Svend 1948 Op 4 Malinche Symfonisk fortaelling 1984 37 C Instrumentation none Aaquist Johansen Svend 1948 Op 8 Dans de til Romeo og Julie 1971 13 Aaquist Johansen Svend 1948 Op 8a Romeo og Julie 1971 Film C Code none Aarflot Andreas 1954 Chase for Big Band Aaron Bernard 1939 Austrian Dance 1996 AVIS Abaco Evaristo Felice dall 1675 1742 Op 4 11Sonata d p Record positioning Abazis Theo 1967 Pas de deux 1997 AILBICIDI E FIGIH i K UCIEKA Abbott Alain 1938 2 Pr ludes 3 7 z Abbott Alain 1938 2 Pr ludes Plalr y HAE o Abbott Alain 1938 Cosmogrammes 30 Abbott Alain 1938 Trio Abbott Alain 1938 Electronique Il 8 45 Abecassis Eryck 1956 Zeitlupe 1999 M Search in Composer Abeille Johann Christian 1761 1838 Fernim Haine Ti Abejo M Rosalina 1922 1991 Recuerdos de Manila 1972 search next lv Search 4 Title Abel Karl Friedrich 1723 1787 2 S tze Search in Date Abel Karl Friedrich 1723 1787 Allegretto Search in Publisher Abel Karl Friedrich 1723 1787 Allegretto Nee Search in Location Abel Karl Friedrich 1723
6. Lament 1986 8 Abram John 1959 Snoods 1992 7 Abram John 1959 The Rocky Moon 1986 91 32 Abreu Zequinha de 1880 1935 N o me toques Choro Abreu Zequinha de 1880 1935 Tico Tico no fua Abreu Zequinha de 1880 1935 Tico Tico 4 1 Menu line The left part of the title bar and menu line are shown here w AbeMusi v1 00 Build 000 File View Options Help Info The menu functions can be called for specific actions 4 1 1 File There are three sub functions here Select path Maintain private database and Exit The Select path command is basically needed only when the user moves his data to another folder than where it was originally placed or when he has more versions of the database simultaneously in different folders and wants to switch between them The first time the program is executed the user establishes the path to the folder which contains the data files as mentioned in chapter 3 The path is remembered for subsequent executions In theory the database can be on a removable medium but it is suggested to copy them to a hard disk folder first as this is remarkably faster With Maintain private database the user comes to the maintenance panel for entering updating and deleting private items The submenu Export selection will create a text file from the current selection There is a practical limit of 250 items which can be exported per selection The format of one entry in a selection is demonstrated
7. Title AbeMusiQ User Guide Date September 3 2006 updated October 2 2008 Document version 2 05 Program conformity Build 008 Author Jan de Kloe Table of contents Le HAI FOCIMICUION E E E A 1 De HENNA E ONIME Eb ae A AAAA enc canaaaaaaaaainaans duce uueee nn eea ee nanaaa ana a aaa aaaaaeaaaaaaaan ease 1 I MY AN Aha EEE da Aaa AAAA 1 3 1 AbeMusic data wo ccceccccsecsssseeeeeseseseeseeeeeceseeeeeeeeeeeseeeeeseseseeeeeeeeeeeeeeeececeeeeeecececececeeeeeeeeeeeeeceeeeeeeceececeeeeeeeeeeceeeeeeeeecececeeeeeeeeeeeeeeess 1 32 Le MBL AN ee VAL GN cd CCC EE EEEE EEEE EEEE 2 4 The graphical user interface atc sec cee ccc cue canuuss cca casas cacuucccauuuccdauuuscacasuucceisuuccacasiucceiueuccacumiscccisuucceusmisacasisceiuuesecucies 2 7180 Menue eee mC e AANA E AEEA EEEE AEEA EEEE EACEA EAE EE AEAEE AEAEE ECCERE AEEA AAAA ERE R EERE EERE EERE ERE R EET 3 A EE e taal aoe lt ete eae ll ll ll ou a oll lle ees RS 3 2 SN Ea co rr 3 PSION Sienn aaan E AAA AAEE OAOE OOOO AOAIE OOOO REAO OOOO IOO OOO AAA AAA 3 A Mh S a C iO 4 A P ES E DY KO add Ftd ELE ELLE HELLA IAAI AIAIIIEI AATAL 4 A 2 E LADU SU A hee 4 A os OUT Ol AMES E 4 Aol Displayer E a ee ee enn en 4 4 3 2 Record positioning ia iccaise dese caidas ca icc dc cae dase ace dace dace ce de cede cae aac cca ce dcnanen cated 6 rls Ime Wee GU ENE TE CONIA Ree ee eee ae ODE ODE DO OOOO EEEE ESEE 0000000000000 0 00 OOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOROOOOORRS TCC eT ee eo 6 OS SN AM Wel EVN PEL
8. age the vertical screen selection and the path to the preferred folder 8 Document change history Updated images November 20 2005 Online consultation two sets of data cosmetic changes September 3 2006 Provide date time stamp of Works file in Info menu build 008 October 2 2008 This document was created with Win2PDF available at http www win2pdf com The unregistered version of Win2PDF is for evaluation or non commercial use only This page will not be added after purchasing Win2PDF
9. ain click the Publisher field The title may be longer than can be contained in the field reserved for it Click the field to see the full title in a larger area Click on the Location field to see the full name of the references The number in the frame title reflects the sequence number of the filtered subset 5 Maintaining private data The strength of this program is that the user can add private data without interfering with the AbeMusic database This is because the private data is kept physically separated from the AbeMusic files At startup the user needs to specify whether he works with one or both sources of data When both are selected the information from both sources is merged for display purposes only The panel for maintenance of private data is shown here ia AbeMusiQ Maintain private database e loj x Return Il Clear input Person Date Title Publisher Location Instrumentation Code Add Update Delete This shows the empty private database and the top line can be used to enter own data The fields for Publisher Location Instrumentation and Code may be used as they are by AbeMusic Click the field to obtain a selection list The button Add moves the item from the top line to the private database Once there are items in the table you can select one for Update or Delete by clicking it in the white list Sort the displayed information by clicking on the buttons Person Date etc If the
10. by this example Been nn nn nr nnn nn nnn nn 007 99 9999 nnn COMPOSER Cazzati Maurizio DATES 1620 1677 TITLE Op 35 3 Sonate PUBLISHER Potter 1677 Sil 1665 LOCATION I Bc Bsp BLi B Br INSTRUMENT Tp V1 2 Va Th PUBL DETAILS Luca De Potter XVII Antwerpen BE F Silvani IT This text file is called ABEEXPRT TXT and is shown on the screen immediately It can be cut and pasted to any application The Exit command terminates the program and is equivalent to the terminate button in the right of the title bar or Alt F4 4 1 2 View With the submenus the contents of the four tables can be inspected Publications Locations Instrumentations and Codes The user will in practice not need to consult these tables 4 1 3 Options This button opens a small option screen shown here AbeMusiQ Options Return Language tor Instruments Screen size ertical Minirauen C Maximum Espa ol Deutsch Frangais talang Magyar Hededands Coen 6 E E mie Swahili Current folder 4hehdusic tiles The panel is self explanatory The language support is currently only for instrument names and will be extended to the user interface when so requested 4 1 4 Help The Help menu allows the user to consult explanatory information from the internet 4 1 5 Info Information on the current data base is given in size date number of records number of composers etc 4 2 Tabular result area
11. e in the selected folder If both are present a message is given to delete one of the sets It is not necessary for the user to understand the structure or contents of these files The user should however recognize that there is a clear difference between the data which is the responsibility of the AbeMusic supplier and the program which processes whatever the data represents AbeMusiQ is not responsible for the quality of the data it processes When the program starts the database the collection of the above files needs to be opened with a single button The first time the program is used the path to the folder with these files is to be established but subsequent executions do not require this as the program remembers the path in a profile When a user has MS Works he may export the AbeMusic database to these text files himself 3 2 Private data This data is kept in a text file by the name of AbeMusiQPrivateDB TXT When it does not exist this file will be created The internal structure of this file is comparable but not identical to the AbeMusic MASTER file 4 The graphical user interface The panel which interfaces with the user has a menu line on top a tabular result area and three control frames The color codes indicate the function of a field white fields can be set by the user amber fields are for display only The full panel 1s shown here AbeMusiQ v1 00 Build 004 Fie View Options Help Info Composer Date Title m
12. gram will interpret this as F Pn and F Pc Also since the filter selection rolls out with full details there is only a minimal learning curve for working with AbeMusiQ Selecting an instrument is visualized by this list Select an Instrument Ag Small guitar Saw Musical saw Sha Shakahuchi Japanese flute Sham Japanese guitar Shawm Sham Si Sitar Sk Sinka Sm Sistrun Snaredrum Snaredrum The selected instrumentation filter is shown with the full text in brackets Display filter No filtering Total entries in database 17323 Number filtered 1 Location none instrumentation Saw Musical sav none Selecting codes is likewise Select a Code Duo Mr fey Vil Gt asd Duo Glassh Gt adb Duo Ac Gt adb Dua Chr Gt adr Duo Cone Ban Gt asd Quo Hmc Gt a33 Duo Ci Gt The selected code is given with its explanation Note that while the input file for codes does not replicate the type such as Duo but AbeMusiQ does this for clarity Display filter No filtering Total entries in database 17323 Number filtered 35 Location none Instrumentation none Code a35 Duo Ac Gt 4 3 2 Record positioning With the commands available in this frame the user can walk through the database in either direction and search for particular character strings On modern equipment query results are shown instantly As soon as the tab
13. icense You do not need MS Works if you have AbeMusiQ 3 Data There are two groups of data the AbeMusic data which you need to have to be able to use the program and private data which is optional The two data sources are physically separate and only at display time will the information be combined if the user desires to show the contents of both sources 3 1 AbeMusic data Input to the query program are five files These files are available on the AbeMusic delivery CD for processing with AbeMusiQ These are named MASTER2 TXT master data one record for every entry in the AbeMusic database PUBLI2 TXT table of publication reference ie Ri means Ricordi Address information is provided LOCAT2 TXT table of location reference libraries collections INSTR2 TXT table of instrumentations 1e Ac means Accordion There are full texts in six languages CODES2 TXT table of configuration codes ie a35 means Ac accordion with Gt guitar Or MASTER TXT master data one record for every entry in the AbeMusic database PUBLI TXT table of publication reference ie Ri means Ricordi Address information is provided LOCAT TXT table of location reference libraries collections INSTR TXT table of instrumentations 1e Ac means Accordion There are full texts in six languages CODES TXT table of configuration codes ie a35 means Ac accordion with Gt guitar As of Build 006 the program checks which of the sets ar
14. is applied queries span all available data No filtering As soon as a filter 1s selected by radio button the list of options rolls out Part of the Location filter selection list Select a Location F Lm France Lille Bibliotheque municipale F Pa France Paris Biblioth que de lArs ngal F Pc France Paris Biblioth que Nationale Fonds du Conser F Ph France Paris Bibliotheque Nationale F Po France Paris Biblioth que Mus e de l Op ra F Psg France Paris Bibloth que Sainte Genevi ve F TLe France Toulouse Biblioth que du Conservatoire FY O France Versailles Biblioth que municipale GB B4 Great Britain Bath Municipal Library Select one of the entries or the top entry which 1s none The filter will be set accordingly the list closes and the tabular result area will give the entries which respond to the intended subset The frame shown next filters all records which are located in the Paris Biblioth que Nationale Display filter after selection of F Pn Display filter No filtering Total entries in database 17323 Number filtered 219 Locatior sz Instrumentation 0 fore Code Poo ee Pointing to the field with F Pn will give the full name France Paris Bilbliotheque Nationale as a tooltip The total number of records in the database and the number in the subset are provided One of the strong features of AbeMusiQ is that while a Location for a record is specified as F Pn Pc the pro
15. ular results area is shown a series of rapid access buttons is generated with initial letters Clicking on a letter causes the first composer with that initial letter to be shown as first in the result list The details of the top of the list entry is given in the current record frame Pointing to a letter button will provide a tooltip with the number of entries for that letter Record positioning FA BY CTOYET FT GyHYy ly vy Reel PlajAls tilujvi wix vy zal prey page M Seach in Composer My A Oo P eet W Search in Title Search in Date prey litte Search in Publisher Search in Location Search in Instrumentation Search in Codes nest line With the buttons on the left one can advance pages and lines or position to the end of the data A specific string can be searched in any of the data portions of the database The search is case insensitive A word of caution including fields other than Composer Title or Date requires knowledge of the file contents the string F Pe will not be found in the record which has F Pn Pe In such case it is better to work with a filter 4 3 3 Current record The details for the record which is at the top of the tabular result area are given in this frame The sequence number of the found record is given in the frame title By clicking on the Instrumentation field an explanation of the abbreviations is shown in the selected language To show the Publisher details ag
Download Pdf Manuals
Related Search