Hiya,
I have Goldmine 8 premium with about 30 users (most undocked laptop users) runinng on SQL server 2005 (Express on the laptops).
I have found out from our reseller that the groups will not syncronise down to the laptops - either new groups or alterations to existing group membership. This is apparently a bug within Goldmine, due to be fixed sometime in 2009.
But....
I have a large (and growing) remote workforce with a relatively high rate of attrition (sales reps!) and therefore the group settings are very, for want of a better word, fluid.
I have looked in the "users" table and can see an encrypted field called "USECURITY". May I assume that group membership is held here? Also, is there any way, within SQL or VB.net to create these user groups and move members around within them?
I cannot have the users logging on as master to create their own, and would like ideally to create a script that I can email to them and they can run on their laptops. I know the SQL instance name and local access credentials.
I know of APIs that will poke into the app, but have no idea as to where to get them, or how to use them at the moment.
Any ideas/web links/possible solution gratefully received
I have Goldmine 8 premium with about 30 users (most undocked laptop users) runinng on SQL server 2005 (Express on the laptops).
I have found out from our reseller that the groups will not syncronise down to the laptops - either new groups or alterations to existing group membership. This is apparently a bug within Goldmine, due to be fixed sometime in 2009.
But....
I have a large (and growing) remote workforce with a relatively high rate of attrition (sales reps!) and therefore the group settings are very, for want of a better word, fluid.
I have looked in the "users" table and can see an encrypted field called "USECURITY". May I assume that group membership is held here? Also, is there any way, within SQL or VB.net to create these user groups and move members around within them?
I cannot have the users logging on as master to create their own, and would like ideally to create a script that I can email to them and they can run on their laptops. I know the SQL instance name and local access credentials.
I know of APIs that will poke into the app, but have no idea as to where to get them, or how to use them at the moment.
Any ideas/web links/possible solution gratefully received