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