djc728 Posted March 27, 2012 Posted March 27, 2012 Has anyone done any Filemaker to Goldmine integration. I'd like to be able to pull data from Goldmine into Filemaker and was wondering if there is a plugin out there or someone can give me a high level view of the difficulty involved. Thanks. Dom
Walter-MainFrame Posted April 17, 2012 Posted April 17, 2012 Im trying to do the same with Goldmine but still looking for the solution.
djc728 Posted May 7, 2012 Author Posted May 7, 2012 Walter: I'm trying to pull data into Goldmine and give the end users the ability to modify records BUT I think there may be some issues with record validation, record locking, record field types and I'm trying to find out what the inherent issues might be from someone who has either tried this or is doing it now. Since Goldmine is a SQL backend - I would imagine records should be able to be modified using Filemaker but I don't want to go down that road if someone tells me different. Walter if you find anything out please post it here. Dom
Adam Dempsey Posted May 9, 2012 Posted May 9, 2012 Not sure what you mean by integration, if you mean 2 way then this is useless to you, but we migrated 3 Goldmine databases into an existing FileMaker database last year, I did it a bit of a long winded way but it worked for me: Exported the entire goldmine SQL DB to an Access Database. Used VBA within Access to export each table to a CSV. I made a VB6 app to create a FM file with matching table + field names Did a scripted imported of all of the CSVs into their matching tables. I then processed each record and looked up related data from different tables. It took some work getting the process working and figuring out which bits of data were stored where, but got there in the end. Attached is some documentation of the SQL database format which might be useful to you. GMTableDefinitions.pdf
Recommended Posts
This topic is 4589 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now