Programmatic Access to Rig/Performance Data of RigManager

    Dear all,



    in the private forum there has been a thread about accessing the contents of the RigManager database ("Manipulation of RigManager Data Programmatically...") to do some automated tasks.


    This has been discussed and refuted for apparent reasons of data integrity.


    Nevertheless some programmatic access to the RigManager rigs would be helpful. E.g.

    • a search could be done using more complex search criteria than in the RigManager (read access) or
    • tags could be automatically adapted to individual naming conventions (write access).


    When providing a functional interface the Rig Manager still has complete control on the data integrity. For Windows an ActiveX API should be fine, for Mac OSX the AppleEvents protocol could be used.


    A super-simple API could be for example:

    • connect (databasePathInRigManager : String)
    • getRowCount(tableName : String) : Integer
    • getFieldValue(tableName : String, id : Integer, fieldName : String) : String
    • setFieldValue(tableName : String, id : Integer, fieldName : String; newValue : String)
    • disconnect


    This is a crude and inefficient interface, but it would allow the desired access. But I am sure you are able to provide a much better one...



    Best regards,


    DrTT

    Quote from Michael_dk

    iTunes has the ability to change the tags of several songs at once, allowing one to set the same artist, album etc etc with just a few click. Maybe something like this would be possible for rig manager - would this give you what you need?


    I guess DrTT thinks about more developer's approach.