I have a customer whose old system is in Omnis. I need to get their data into the new FMP solution but I'm quite ignorant about Omnis.
How can I get their table data out of Omnis and into a file format that I can import into FMP?
Thanks philmodjunk, beverly, and fmpdude
What I was really looking for was a step-by-step process from someone who had done this before. I should have been more explicit in my original post - sorry about that.
I figured out how to do it, and thought it may be helpful to others, so I wrote a step-by-step process, along with screenshots (34 of them!). My disclaimer is that the attached process is a one that worked for me for a particular Omnis db. It is the only Omnis file I've worked with, so your mileage may vary.
You will need to get Omnis Studio. I don't know how much it costs as Tiger Logic Corporation (owners of Omnis) would like you to talk with a sales person. There is a download on the Omnis home page (Google for Omnis Studio download). There is a 90 day trial period. I wrote to the US sales office for a trial serial number and the sales rep was prompt to reply.
From what I can tell, the latest version of Omnis Studio at the time of this writing is 8. I used Omnis Studio 6.1.2.
And with that, here are the attached files: the written process, the Omnis export screenshots, and the FMP import screenshots. Hope it is helpful.
Investigate what formats might be used to export data from this other application. Excel, tab, csv are very common formats for such data exports and are just some of the file types supported for importing into FileMaker. Thus, you export into such a file format, then import that file into FileMaker.
ODBC data bridge, perhaps?
Sent from miPhone
I saw these links after a quick search:
Omnis Downloads - Tools & Updates
Mac ODBC: Omnis Studio connectivity for Mac OS X by Actual Technologies
Didn't see any JDBC driver, however.
HOPE THIS HELPS.
Thank you Daniel. Those of us who share what we know probably had to do the same (research, decipher, devise a plan, work through bugs, etc.) and then we present the results so others. Not all our questions have answers until we find it.
Very cool. Great job!
Thank you for sharing something that you research and found a solution.
Retrieving data ...