Goldmine 6 to Filemaker
Has anyone migrated Goldmine to Filmaker?
No, but you can export from GoldMIne in ascii (with delimeters), sdf (fixed width columns), and dbf.
An ascii with comma delimited export can be opened in Excel, saved as spreadsheet, the spreadsheet can opened in Filemaker which will create a database with the field names from the top of the spreadsheet.
I have been exporting using dbf and the first digit in every line of the "notes" field gets cut off. As well, some of my dbfs, are too large for excel, as they more 65,536 rows or 256 columns.
I created a work around for the notes, by syncing my Goldmine 6.7 contacts and calender to Outlook 2003, then running a pc program O2M then I delete all contacts in MAC Address Book, import the O2m version and create a new Calender in Ical. Next, I import and merge the contacts data from the Bento Data Source (this has a good copy of the notes, without the first digit of each line cut off) into FM and I get most of the notes, up to 9999 characters. I just wish I could send out my Goldmine data without the extra process involving Bento so that I don't lose notes that are beyond the 9999 characters.
The dropped letter from memo fields is a known issue for importing from DBF files.
For More Information see: Bug importing dBase data into File Maker Pro 10 Demo (OSX)
This is one of many acknowledged bugs that can be found in the Known Bugs List here in the Report an Issue section of the forum.
It can also be downloaded as a database file from: http://www.4shared.com/file/8orL8apk/FMP_Bugs.html
Retrieving data ...