Disklavier

Well, I uploaded the alpha release.

Please try it out and let me know how it goes.  This is my first ever java app, and getting these things into a working jar file was an experience!  The uploaded rar file includes the swt.jar for windows, with instructions for where to find it for other operating systems.

It's pretty crude at the moment, and doesn't yet support exporting the data.  There's probably lots of other things it doesn't support as well, since I have limited experience with the piano itself.  It also has only been tested against my piano which has very little data, so I don't know how well it behaves with HUGE databases.  Okay, enough disclaimers...Have fun!

-Kevin

----- Original Message ----
From: Matthew Teeter <mrmuk7@...>
To: disklavier@yahoogroups.com
Sent: Friday, November 9, 2007 6:00:48 PM
Subject: Re: [disklavier] Re: Alternative to tablet and PDA for MKIV









  


    
            I believe <remake_db/> is sent when a usb drive is inserted or removed.  There may be some attributes on there that tell you which db, or it might be something like "Update your local cache of the db now".  

If you make a query while the software is building the table, you will see the songs that have been added at that point in time.  This shouldn't be of much concern; it usually only takes 30 sec to add everything to the songs table, even for large amounts of files on a drive.


I don't think there was a column for artist.  If there was, I think it contained the same info as the title.  But yes, Yamaha seems to put the artist within the title.  I believe you can set the comment on the song and album using the PRC's keyboard.  Hardly anyone would want to though - quite a laborious task poking tiny buttons.  I also seem to remember being able to set the songs rating from 1 to 5 stars using the PRC/TRC.  Never investigated that much personally though.

Matthew


On 11/9/07, Kevin Goroway <kgoroway@yahoo. com> wrote:













  


    
            
Matthew,

I'm at work, so I can't check now, but does the piano send any notification of when it has finished building the table?


I've seen <remake_db /> come out for both the CD and the FD even though there was nothing mounted.

Any way to query for what is already mounted?


Otherwise...

There had been a request for the ability to search by artist, but I don't see anything explicit in the schema for artist.  It looks like it is normally stored as part of the song title (judging from the demos).  This will work fine with my current search.


The fields which might be interesting to
 search by are as follows:
song filename (already done)
song rating (is there any current way to give a song a rating?  If not, I wouldn't want to assume one and break a future release.)
song "your_record" (No idea what is here, maybe nothing, and no way to set it?

song comment (is there any way to enter this currently?)
song title (already done)
song subtitle (already done)
song genre (is there any way to enter this currently?)
album rating (see song rating)
album comment (is there any way to enter this currently?)

album title (already done)
album subtitle (are these used?)

Anyway, adding others is trivial at this point.  So, I'll have to investigate what is in the database when I get home.

-Kevin


----- Original
 Message ----
From: Matthew Teeter <mrmuk7@gmail. com>
To: 
disklavier@yahoogro ups.com
Sent: Friday, November 9, 2007 10:27:19 AM
Subject: Re: [disklavier] Re: Alternative to tablet and PDA for MKIV









    
            The tables for each media (ex. usb_album and usb_song) are only created when that media is inserted.  It takes a few seconds for the software to create the table, so if you insert and immediately query, you will miss results.  The tables are recreated each insertion.  This is discussed more in our paper.

Matthew


On 11/9/07, Kevin Goroway <
kgoroway@yahoo. com> wrote:













  


    
            
I made a bunch of progress last night.  Search is fully implemented, and works great (and FAST).  Of course, my database is tiny compared to some of yours, so I'll have to get some feedback from those of you who try it.


I did expect the USB and FLOPPY tables to exist in the database even when they weren't mounted...but that turned out not to be the case.  So, tonight I have to work on some code to understand when those are mounted and when they aren't.


I have no plans to support the copying of files between the sources, especially the protected ones.  

Release this weekend (as an alpha version) is looking quite likely.

-Kevin



----- Original Message ----
From: Tom Wheeler <tnwheeler@nc. rr.com
>
To: 
disklavier@yahoogro ups.com

Sent: Thursday, November 8, 2007 6:29:46 PM
Subject: Re: [disklavier] Re: Alternative to tablet and PDA for MKIV










    
            Kevin,


It is scenario no. 3 below that describes how my Mark IV is connected.


Again, thanks for working on this and I look forward to ultimately trying out your work when you are ready to release it.  



Tom

On Nov 8, 2007, at 4:17 PM, Kevin Goroway wrote:



Well, one of things
 everyone will need to understand is the requirements for using it...so no harm in leaving it in this thread for now.

I still think we have some confusion over what you are seeing on wireless.  So, let me try again.


Scenario #1) You have a wireless card on your computer, you have nothing connected to your DKV's ethernet port.

In this scenario, your wireless card might tell you that there is a wireless access point out there, and you can hop on it, but there is nothing to be found.  And, you have no access whatsoever to the To/From PC folder.


Scenario #2) Like #1, but you have a hard wire connection to your router/switch from the DKV's ethernet port.

Like the first scenario, but now you have access to the To/From PC folder.

Scenario #3) Like #1, but you have attacted wireless hardware to the DKV's ethernet port, turning it into a wireless device.


In this situation, your wireless card has 2
 choices.  One is the access point connected to the DKV's ethernet port, the other is the access point that the PDA/Tablet use.  If your wireless card attached to one, you'll see the To/From PC folder, if it attaches to the other...there' s nothing to be found.


Just to be clear, in all 3 of those cases you can use the software, just as long as you can convince your wireless card to hop onto the access point that is there for the PDA.

Your wife can certainly contact me directly.  I plan to put the searching in this weekend, and have the source code ready for release before Monday.  (although you threw in the new feature of being able to search by artist which I hadn't considered. :-)  )


-Kevin







    
  









____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 


http://mail. yahoo.com 

    

  

    
    






















    
  








____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

http://mail. yahoo.com 


    
  

    
    























    
  

    
    




<!--