Exporting Data to other formats (dbf, asc, access) (OpenInsight Specific)
At 30 MAR 1998 02:57:36PM Yarone D. Goren wrote:
One of our clients uses OpenInsight to manage all of their data.
They've hired us to do some consulting work, some of which requires us to convert the OpenInsight database tables into a more standard format, like comma delimited text file, dbf file, MS Access, etc.
Does a tool exist that will automate the conversion of data?
Thanks in advance.
Yarone D. Goren
Software Development Engineer
Sophisticated Technologies, Inc.
At 30 MAR 1998 03:43PM DSig (SigSolutions) wrote:
No .. I don't beleive there is a standard export process as there used to be in Advanced Revelation.
You could try to use the 'Data Warehouse' to do the processing. But
I would suggest that you simple write an Ascii export as everything will import from ascii. Just be aware of multivlued structure. These extract nicely into secondary tables
Dsig
David Tod Sigafoos ~ SigSolutions
[email protected] 70302,77 503-639-8080
At 31 MAR 1998 08:55AM Bryan Feddish wrote:
If you want real-time access to OI tables AND you are still running OI on the same machine I can email you an OLE server that can be used via Visual Basic, Delphi, Access, etc. that can transfer data.
Bryan
At 31 MAR 1998 12:16PM Gregg Tate wrote:
Bryan:
I would like a copy of this OLE server if you please. My bosses are threatening me with having to come up with a real-time connection between our OI app and some unknown external database.Thank you
Gregg Tate [email protected]
At 31 MAR 1998 02:34PM Bryan Feddish wrote:
You got some mean bosses….
It's been emailed to you.
Bryan
At 01 APR 1998 11:46PM Bizsoft Corp. wrote:
Actually we have a 32-bit utility called LH2TXT that exports OI tables from outside of OI (no ODBC, OLE, etc). It reads the data tables raw and spits them to delimited files very, very rapidly.
The demo can be found at www.bizsoftcorp.com
We created the demo some time ago but did not release the final product because we did not get the response that we had thought we would. If enough want it we will finish the documentation and release it.
At 02 APR 1998 01:05PM Fuji wrote:
Hi,
Would you please send me the component to access data realtime?
Thank you much,
Fuji
At 07 APR 1998 02:51PM Van Eash wrote:
Bryan,
Please send me the OLE server also.
Thanks in advance!
Van Eash