Message
Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files
2009-09-24 by Spencer_Lists
I think I finally got all (ha ha) of the errors corrected in my listing. I found some inconsistencies on the Yam
site which caused me to make some errors and then made a nice bunch of my own in excel. Personally I can't imagine
why anyone would want to listen to the E-Comp files, many of which are excellent, without being able to know what you are selecting.
However I seem to be alone in what I think is important. I am thrilled that I have all 1340 titles in Itunes
as MP3 files with tags that display in the files window. Unfortunately I don't think that the DKV will reliably play MP3 files
due to the phase shift encoding. Since there is no standard way to add text tags to WAV files, it seems that the perfect
solution is the DKVBrowser.
I am not aware of how to upload files to Yahoo groups so I'll put the text file on my web site at:
http://spencerserolls.com/Files4Download.html will be about half way down the page and linked as E-Comp-text
the file name once downloaded will be yamtitle.zip and is a tab delimited text file that can be viewed in excel.
If anyone uses MIDI files and wants to add text keywords to them, I have a program that will do so using this
listing.
I have all of the files on the list in XP format when available. If anyone has files that are no longer available I will add them to the list
if the files can be gotten. There are a few which were withdrawn and there are a few dead links on the Yam site.
To eliminate ambiguity I have added the date to the file names as there are a few file names that exist in more than one year.
This means that to have a match between files and the listing, you need to add (year) to the end of the file name before the extension.
Wednesday, September 23, 2009, 6:56:16 PM, you wrote:
I think with a tiny bit of work, and the latest version of DKVBrowser this information can be made to import directly into a Mark IV, with information in the comments where it doesn't fit into the song title.
Any interest?
From: Spencer_Lists
To: Kay Gould
Sent: Wednesday, September 23, 2009 1:50:26 PM
Subject: Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files [1 Attachment]
Greetings Kay,
not planning on uploading it but can. i just merged your list with mine and made the formats uniform so we both have file
name with year appended to work with my programs. i forget what yamaha did from year to year but i thought that they always
had names first, last. at some point i switched them with a perl script and hand edited the stuff that was too strange to do
automatically. when i merge the lists i see that we have virtually the same data in every field so maybe you started with
something that i gave to someone at some point and might have been posted. it looks like both of our lists are too similar to
be a coincidence. i will be switching first,last to last first in the 2009 entries either with the script, if i can find it, or just by
copying yours over to mine. for now, here is the xls as it is now. you are welcome to use the 2008 data. at some point we should agree
on a format and make both of our lists the same. now that i think of it, i think i did share my list after i had done just years 2002 to 2006
which is probably what you got and might be why you are missing 2008. in this exs my stuff is the yellow highlighted.
Wednesday, September 23, 2009, 9:46:13 AM, you wrote:
I am planning to add the 2008 files, but haven't had the opportunity and time yet. But may be I can profit from your work. So, are you planning to upload your 2008 spreadsheet?
best regards
From: Spencer_Lists s.com>
To: gould2802 ups.com>
Sent: Wednesday, September 23, 2009 6:26:42 PM
Subject: Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files
Greetings gould2802,
what about 2008? wish i had found these files a few days ago. i separately extracted all the data from the Yamaha site and pasted it in to a spreadsheet. i also have 2008. i downloaded all the files that are still available in hi res format and added the year to the file name to distinguish some that would be ambiguous as the same performer was in more than one year of comps. my spreadsheet can be used to add MIDI keywords to the files and once converted to MP3 to play on the LX system, MP3 tags can be added.i will compare your list to mine as a check on accuracy of copying from the site. is this the way you did it? i also prefer your last, first name as opposed to the way it is on the site. i will probably convert mine as i have a script somewhere that converts first,last to last, first but it might not work with some of the hyphenated names.
is there some reason that 2008 is missing?
Wednesday, September 23, 2009, 6:52:04 AM, you wrote:
Find a combined spreadsheet of the midi files of the competitions of 2002, 2004, 2006, 2009 See in "Files > e-Competition" .
The midi files can be find here:
http://www.piano- e-competition. com/ecompetition /midi_2002. asp
http://www.piano- e-competition. com/ecompetition /midi_2004. asp
http://www.piano- e-competition. com/ecompetition /midi_2006. asp
http://www.piano- e-competition. com/ecompetition /midi_2009. asp
Downloading is quite easy using a download manager (like for instance Reget Deuxe)
--
Best regards,
Spencer_Lists Chase mailto:lists@ spencerserolls. com
67550 Bell Springs Rd.
Garberville, CA 95542 Postal service only.
Laytonville, CA 95454 UPS only.
Lists@spencerseroll s(dot)com
http://www(dot)spencerserolls .com
replace (dot) with a .
(707) 984-8356
--
Best regards,
Spencer_Lists Chase mailto:lists@ spencerserolls. com
67550 Bell Springs Rd.
Garberville, CA 95542 Postal service only.
Laytonville, CA 95454 UPS only.
Lists@spencerseroll s(dot)com
http://www(dot)spencerserolls .com
replace (dot) with a .
(707) 984-8356
--
Best regards,
Spencer_Lists Chase mailto:lists@...
67550 Bell Springs Rd.
Garberville, CA 95542 Postal service only.
Laytonville, CA 95454 UPS only.
Lists@spencerserolls(dot)com
http://www(dot)spencerserolls.com
replace (dot) with a .
(707) 984-8356