Rig Manager data export Excel or CSV would be very helpfull to store together with other music production documentation like track sheets, wich sounds used etc..
Rig Manager data export Excel or CSV
- Tantrum
- Thread is marked as Resolved.
-
-
+1
-
Yes, good point. +1.
-
Strongly agree----I'd like to be able to open the rig data from my Profiler in Excel, for example.
-
I think with a MIDI connection to a PC, it would be pretty easy to create a librarian in Excel. I was just reading through the MIDI spec to do this and got sidetracked by a typo in the doc. Back to work!
-
Got all the tables and messages mapped out. I'll try to get the coding started tomorrow.
-
I exported data from rig manager to Excel using Windows 7 64 bit as follows.
Go to /Users/<yourname>/AppData/Local/Kemper Amps/RigManager.
I created a back up at this point and used the back up files to export to Excel as follows:
Within the RigManager folder you will see two .db files one is the Rig Exchange database and the other is your profiler database.
I used a "sqlitebrowser" this is a freeware database browser that will open the underlying table and allows you to export tthe file to a ,csv format which Excel can read and you can save as an excel file.
I believe you can also use MS Access 2010 or later but I only have an older version.
Within the RigManager folder you will also see a Local Library folders. This is where I keep my Amp Factory rigs with separate folders for each bundle.
Each underlying folder contains the relevant .db file which can be exported to excel as above. -
I have Excel able to send CC and NRPN messages. Next I'm working on receiving messages back from the KPA. It's pretty cool on a Surface Pro 3 touchscreen! Great for studio/home use. Stack all the commands you want and click a button.
-
Great effort guys
-
The Windows MIDI routines need to be multi-threaded, so I've given up on an Excel interface. I would have stopped there, but Microsoft has made Visual Studio free, so I now have a Windows app that can send and receive MIDI messages to the KPA. I'm trying to decide what to do next... I don't think I mind the coding, but just figuring out the data structures of which parameters are valid for the 100 or so effects does not sound like a ton of fun. I've started looking at the format of the backup files to see if I can get the details easier that way. I'm open to suggestion on what the community might find useful.