ASCII to DBF converter for SCO

[Brian K. White]

----- Original Message ----- 
From: "Georgio Caponera" <georgio at worldest.com>
To: "filePro List" <filepro-list at lists.celestial.com>
Sent: Friday, December 10, 2004 1:53 PM
Subject: OT: ASCII to DBF converter for SCO


> filePro 5.0.08
> SCO 5.0.5
>
> I have a customer that wanted server side ODBC.
> Obviously, that is not an option.
>
> I've tried creating an alien filePro file and
> placed the key on an NFS partition and named it
> 'key.csv'.
>
> Now, when I try to link a table (in access), I'm
> getting some problems with trying to link an ODBC
> data source using a text driver.  (I must not have
> the correct driver version).

A key file (alien or not) is nothing like a csv file, of course the driver 
didn't work.
You could generate a real csv file very easily though, and that would 
probably work.
or, a text driver for fixed-length might work as long as you do this one 
little trick:
make a filepro or non-filepro file and add one, 1 or 2-byte field to the 
end.
*always* fill that field with chr("10") or with chr("13") & chr("10"). I 
suggest put it right in auto processing and to hell with the processing 
overhead since it's most important that it never slips through the cracks 
and a record gets created without that line-ending.

This would be like exporting or printing-to-file all the data, except it'd 
always be live since it's really the key file instead of running a report 
periodically.

dos/windows apps that read "fixed-length" are sometmes actually technically 
broken in that they still expect the records to be seperated by LF or CR+LF

> In any event, he suggested that he may be able to
> work with the data if it was in an dbf format.  I
> guess I would just do a system in filePro and try
> to convert to dbf upon the user saving the record.
>
> Is there something out there that can convert ASCII
> to dbf for SCO?

Brian K. White  --  brian at aljex.com  --  http://www.aljex.com/bkw/
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx  Linux SCO  Prosper/FACTS AutoCAD  #callahans Satriani