Yahoo Groups archive

Disklavier

Index last updated: 2026-04-28 23:20 UTC

Message

Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files [1 Attachment]

2009-09-24 by Kevin Goroway

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 <lists@...>
To: Kay Gould <disklavier@yahoogroups.com>
Sent: Wednesday, September 23, 2009 1:50:26 PM
Subject: Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files [1 Attachment]

  
[Attachment(s) from Spencer_Lists included below] 


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 <lists@spencerseroll s.com>
To: gould2802 <disklavier@yahoogro 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

Attachments

Move to quarantaine

This moves the raw source file on disk only. The archive index is not changed automatically, so you still need to run a manual refresh afterward.