Very Computer

Any advice or leads to pursue on this would be greatly appreciated.

TIA,
Stu
--

---------------------------------------------------------------------
O   N   T   A   R   I   O       Stu Miller - Data Management Tech
   _/_/_/    _/_/_/_/  _/_/_/   MNDM - GEOSCIENCE LABS


_/   _/_/ _/        _/    _/    voice:(705)670-5635  FAX:(705)670-3047
_/_/_/_/ _/_/_/_/   _/_/_/  S  E  R  V  I  C  E  S    C  E  N  T  R  E
----------------------------------------------------------------------

Application uses Informix for DOS v4.10 SE.

Stu

Hi,
Bit of a newbie question for you.  First of all, I am not a programmer but
I am responsible for installing and configuring (basically writing a bunch
of ACE reports and database definition) a "mission critical" application (a
Laboratory Information Management System or LIMS) sold to us by a 3rd
party in the U.S.
One of the requests from our clients is for data files (reports) from the
system in Lotus .WK1 format.  Remembering that I am not a programmer but
an adept hacker, is it possible to create a report that writes output to a
file in .WK1 format or does this require some fancy C application(s)?

Any advice or leads to pursue on this would be greatly appreciated.

TIA,
Stu
--

Stu and all,

You don't have to go to C. Instead, you should consider the following
options:

1.- Put your output into a "simple" comma-delimited ASCII file. Lotus (and
most) spreadsheets can "easily" import this format.

2.- Use a Microsoft Access front-end, and attach your database to it.
MS-Access provides a "TransferSpreadsheet" action as part of Access Basic.
Use this to export your attached data to an appropriate spreadsheet file.

3.- If you prefer, you might also look into Visual Basic. You might be able
to provide something a little smaller and faster, but at the expense of
more development time.

Hope this advice is helpful.

Dave Finley

Quote:>Stu Miller wrote ....

Quote:>One of the requests from our clients is for data files (reports) from the
>system in Lotus .WK1 format.  Remembering that I am not a programmer but
>an adept hacker, is it possible to create a report that writes output to a
>file in .WK1 format or does this require some fancy C application(s)?
>Any advice or leads to pursue on this would be greatly appreciated.
>TIA,
>Stu

That said, how tough is it to create a native format Lotus .WK1 file?  If
any of you have tried to do this please let me know if you have had any
success.  Also, if you know of any source code (ACE or C) available to do
this I'd be greatful for any info.

Thanks again,
Stu

IM>One of the requests from our clients is for data files (reports) from the
IM>system in Lotus .WK1 format.  Remembering that I am not a programmer but
IM>an adept hacker, is it possible to create a report that writes output to a
IM>file in .WK1 format or does this require some fancy C application(s)?

We use ODBC to extract data from an ODBC source (our accounts package
database) directly into Excel and Lotus under the Windows environment.
It works great, and is very flexible.

The opinions stated are not necessarily those of the Houston BBS, or
Houston Crest, or of the person stating them. Everything is relative.

You can also use the DataLens feature of 1-2-3 for Windows to read in the
Informix file and spew out a .WK1 format file.

You could also use Approach for Windows from Lotus with the correct ODBC
driver.  It's a Windows database for end-users that is ODBC compliant and
can SaveAs a file into just about ANY file format.  I think that Q+E can
do this too...

--Doug