I do a lot of transcriptions using Photoscore Ultimate either from original scores or PDF’s to transfer the notes etc. into Dorico as MusicXML files.
One of the frustrations is that random words, which might be techniques (arco/pizz), no of players (a2), instruments (piccolo) and so on, although present in the MusicXML as the subcategory , never make it into Dorico. I can understand the reasons for this (for instance techniques are all classified by type in Dorico) and started thinking how I could list the occurrences to manually add them to Dorico later.
I thought that the solution might be to store the music in a database created from the MusicXML and whilst looking for an easy way to parse such content came across a very powerful (open source and free) product to do this called BaseX. With a user friendly GUI this can open your MusicXML file and store it as a database. It incorporates the industry standard XQuery language, an sql type language, which operates on the database and allows you to analyse the music to you hearts content. I display below a part of the listing from one of my scores which shows where I have to add the missing text to my Dorico score.
Measure 1 Tuned Percussion - Chimes
Measure 2 Trumpet in Bb 2,3 - Bell-like a2
Measure 2 Horn in F 1, 2 - Bell-like a2
Measure 5 Horn in F 3, 4 - Bell-like a2
Measure 5 Trombone 1,2 - Bell-like
Measure 5 Euphonium - Bell-like
Measure 5 Alto Saxophone 1, 2 - a2
Measure 6 Keyboard - Piano sound
Measure 7 Piccolo (Flute 3) - Flute
Measure 7 Trumpet in Bb 1 - play
Measure 7 Trumpet in Bb 2,3 - play
Measure 7 Flute 1,2 - a2
Measure 7 Tuned Percussion - Crotales
Measure 7 Clarinet in Bb 2, 3 - a2
Measure 9 Double bass - arco
To those who might be daunted by the thought of any kind of computer coding I attach a file of the XQuery routine to produce the result above.
For those familiar with the idiom it should be relatively easy. For other why not have a go!
Words.zip (596 Bytes)