Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / July 2005

Tip: Looking for answers? Try searching our database.

needs to convert omnis7 data to access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shahshop - 29 Jun 2005 22:08 GMT
anybody know how to convert omnis7 data base file into access file or even
into a flat files (text)
Van T. Dinh - 30 Jun 2005 02:24 GMT
It is about 13 years since I last used Omnis7 (Windows version).  However, I
remember importing data from flat files (Text) into Omnis7 so I am sure you
can export data from Omnis7 to a text file and then use the text file for
importing into Access.

Of course, this only works for data.  The GUI design will have to be done
from scratch in Access.

Signature

HTH
Van T. Dinh
MVP (Access)

> anybody know how to convert omnis7 data base file into access file or even
> into a flat files (text)
jerichar99 - 14 Jul 2005 09:36 GMT
I am wondering if a solution was ever discovered. I have the sam
problem with this 12 year old program (which is still working fine)
However, I would like to migrate the data into something lik
Access

I have Omnis7 1.20, and I can't find any export menu item. Yes, yo
can import data, but nothing about exporting.  I can't open th
datafile (.df1) with the latest Omnis program (demo on their site
because the datafile is too old.  However, they say you have t
convert the datafile to Omnis7 version 3, then from there you ca
open it with the latest omnis program.  Does anyone have Omnis
version 3 (or any Omnis 7)?  It's not for sale anywhere I can find
so it's not a matter of just buying it. It's a matter of finding it

I'm assuming that if I open it in Omnis 7 version 3, I may be able t
export it from there

Can anyone shed any light on this? I've honestly spent a lot of tim
on this and I am truly stumped. :-

My email is jerichar99@yahoo.com. Thanks
Van T. Dinh - 14 Jul 2005 10:58 GMT
If you use the Windows version (there is a Mac version which Omnis was
developed for), the Export Data Menu is a Sub-Menu of the Utilities Menu.
According to my old book, you can export to the following formats:
* Dif
* Sylk
* dBase
* Delimited commas (CSV)
* Delimited tabs
* One field per line
* Omnis data transfer

My book is published in 1991 by Blyth Software, the creator of Omnis and
IIRC, it was the first version of Omnis-7 for Windows (Omnis-5 was ported to
Windows 3 originally).

Signature

HTH
Van T. Dinh
MVP (Access)

>I am wondering if a solution was ever discovered. I have the same
> problem with this 12 year old program (which is still working fine).
[quoted text clipped - 17 lines]
>
> My email is jerichar99@yahoo.com. Thanks!
jerichar99 - 18 Jul 2005 09:35 GMT
Thanks for the info about the Utilities->Export menu.  Why I neve
saw it was because the application I used to open the data file woul
remove the utilities menu.  Thus, I never knew such a menu existe
until you mentioned it

I doubt anybody will ever the problem like I had, but I'll explain i
in the hopes it may help someone in the future.  The application
inherited (ri.app using ri.df1 as the datafile) would load up an
remove all menus that allow modification of the program itself (suc
as the design menu).  The Achilles' heel, as I learned, was to ope
the app as normal but lock ri.df1 (I had it open in a hex editor).
This would throw an error, bringing up the debugger screen, an
viola, I can edit the app's code.  I eventually found the line tha
removes the utilities menu, and I thus removed that line.  I save
the application, unlocked ri.df1, and reopened the application, no
with the utilities menu.  Then from there it was easy; I jus
exported the data to a csv file

I should mention a couple of things about exporting.  It's ver
annoying how you have to type out every field you want exported. I
would have been better if checkboxes or something were used, but thi
program is about 13 years old.  Also, "file" in omnis really mean
table (on the export screen, it asks for "main file" which means fro
what table do you want data)

As pathetic as it sounds, I wrote a visual basic program that emulate
a user exporting the data (pretty much just mouse clicks and keyboar
emulation).  Why?  Because the app had about 40 tables, some table
had 3 fields and others had over 200!  I would have to type all thes
by hand; why not write a program that does it?!  Anyway, it worke
well.  It takes about 15 minutes to do a full export, and no use
intervention is required (the visual basic program even opens an
closes omnis7)

Well, thanks again for this thread.  It's amazing people still us
this program

-Jami
Van T. Dinh - 18 Jul 2005 11:46 GMT
I was very impressed when I first saw Omnis-5 and later Omnis-7 (for
Windows).  The technical contents were impressive and IMHO, was well ahead
of Access 1.0 which came out later.

Pity about the marketing power of Blythe Software.  In Australia, a company
in Gold Coast (more or less a holiday area) had the exclusive marketing
right to the software while the main markets are Sydney, Melbourne and
Canberra.  I knew straight away the penetration would be small and if I
concentrated on it, I wouldn't have enough jobs to keep me going.

I actually surprised that Omnis-7 is still going and there is Omnis-7
(version 8).  7 was the version number previously.  They should have named
it Omnis-14.  It sounds exactly Pentium IV ( "Pent" means 5, i.e. 8086
architecture chip version 5).  Perhaps, the chip should be renamed "Nonium".

Signature

Van T. Dinh
MVP (Access)

> Thanks for the info about the Utilities->Export menu.  Why I never
> saw it was because the application I used to open the data file would
[quoted text clipped - 34 lines]
>
> -Jamie
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.