how to convert an Omnis .df1 datafile to SQL?

We have a client who is looking to transition from one manufacturing vendor software (Omnis.net) to another. Their current database is housed in .df1, .df2, .df3, etc files. I can't find any literature on this company's website that would help me convert to a different database. I need a technical support contract in order to get any one on one time with their support team. The vendor that they're going with uses SQL and has never even heard of Omnis.
database.JPG
LVL 11
Forrest BurrisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James MurrellProduct SpecialistCommented:
might not help but this company can convert

http://www.faulknerdatabasedev.com/Omnis%207.html
0
Jim P.Commented:
If you try opening them with a text editor, what do you see? Any kind of readable data?

Failing that, is there anyway to open the data in the old app and do an export?

Another possibility is to get PDFCreator and dump it to reports that you can then turn in to CSV files.

The only other option is to go back to the original vendor and ask for assistance.
0
Forrest BurrisAuthor Commented:
1. Text editor yields garbage with occasional text.
2. No export options what so ever
3. This won't work as the file opens in ASCII dump
4. Sounds like a plan
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Forrest BurrisAuthor Commented:
I figured this out. Omnis has an ODBC driver on it's website I installed. I ran a query through MS Excel and exported all the data to .csv files. Took awhle but I have my method of extraction. Thanks for your help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
h3rm1t9536Commented:
Hi Forrest,

I am trying to export the contents of a DF1 file from Access Accounts which uses Omnis. I have the ODBC driver in Excel and the connection string but I needed the the query to pull all the info from the file. Do you remember what it was?

I know its a long time ago but if you can remember it would help. Happy to setup a question for the points too.

Regards

Chris
0
Forrest BurrisAuthor Commented:
Wowzers this is an oldy. I vaguely remember doing this but there would be no way I could drum up the query. It's possible Omnis provided me with that query after hitting up their support. Or maybe I wrote it. I can't remember. Sorry Chris wish I could be more help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.