API to GoldMine CRM/SAF System? 12
saulgood asks: "My company has
made an investment in GoldMine,
a customer management and sales automation software package. It seems
to have some really cool features and sound business ideas underpining
it, but the interface is lacking and, of course, only runs on Windows.
I would like to find/build a simple interface to pine/elm for the tech
department folks who don't need all the features, just mail and maybe
the calendar. Has anyone tried such a thing? I believe it has a vCal
interface, and the DB can either be SQL Server or Borland so connecting
to the DB should be easy enough."
It's just a database. (Score:2)
Good luck... (Score:2, Informative)
We had a consultant who was pretty knowledgable about the internals of GM and he had moved us to the version that supported SQLserver, so we looked into building a simple front end. The consultant had a really hard time getting information about the structure of the DB and it was clear there were some really weird things happening between the client and the DB... the more we looked the more we realized there were dependies between fields that weren't in the DB, but managed by the client.
We gave up and just used email. A really great example of why closed systems suck.
Good luck!
Re:Good luck... (Score:1)
I haven't really dealt with GoldMine myself, but apparently we just like acquiring really fancy but utterly propetary software here, as we have three customer databases, each updated by a different department which is only responsible for keeping their database up to date. I heard several people before me have attempted to create a linking, but they don't want "bad data" from one database "infecting" the others, so no department will let you play with their database.
But then again, our IS department still swears by MS, even though they have to put all of their work on hold for a few weeks every time a new Outlook bug shows up. Someone get me outta here!
GoldMine Everywhere (Score:2, Informative)
http://www.frontrange.com/goldmine/fo2000_gmes.
You can then use PalmPilots, or a web browser to access your customer data ANYWHERE.
API (Score:2, Informative)
Some problems you may encounter is generating a "RECID". Goldmine has a proprietary way to generate unique identifiers for db records. Last time I knew the only way to do it was through their COM API or they have some SQL Server Stored Procedures that can do it as well.
Also, the DB structure is not exactly straightforward. Fields mean different things depending on what type of record it is. Address1 could mean "PC Type". The only way to know is to look at the documentation.
GM has some documentation on this stuff. Check their FTP site.
More GM Support links (Score:1)
COM interface (Score:2)
We use it, it's ok, but watch how big it gets (Score:1)
worked ok for a while, but with 70-80 exmployees in it with around 300,000-400,000 contacts it's starts crapping out on you, even if you upgrade the hardware.
As well, there tech support is only so so.
For some of our issues, they told us to upgrade to newest version, so we asked them if the issue was fixed in it.
nope they said.
otherwise thogugh, it is not bad contact management software.
just make sure your not to big:)
Just took a look (Score:2)
From what I can tell, there is a COM API but it's not really stable or fully intended for 3rd party developers. We decided to avoid a maintenance nightmare and not use it, and instead read the data out of the SQL tables.
Even though the thing is on MS-SQL, the database is pure flat file -- it looks exactly like the DBase tables I was looking at for similar sales tools 10 years ago. Given that it uses something called "BDE" (Borland Data Engine?), that's probably exactly what it is.
After that it was read-only access was straight forward -- just figure out the user-defined field mappings and you are there. Really the biggest problem was escaping out their phony primary key which uses every code-unfriendly character you can think of. And the fact that there is no clustered index so lookups are sloow. I haven't needed to add or update records yet - that might be more complex due to the fact that uses another goofy field called RECNO (?) as replication sequence. For that you might need to go to the API or their stored procs.