sco-unix 5.04 file conversion

I am using sco-unix 5.04, and a program called CIA, a business quote/management program. I need to convert the quote data file from the unix to windows/nt environment. The file is over 11 meg in size, and the program has no export funtion for this procedure. I am new to sco environment, and would appreciate a detailed method of doing this download and conversion.
          Calvinjs
calvinjsAsked:
Who is Participating?
 
tfewsterConnect With a Mentor Commented:
One way of doing this intercept is to set up a new printer and specify the "port" as e.g. /tmp/CIAdata.txt instead of the usual /dev/ttynn.

At the command line, do "touch /tmp/CIAdata.txt" to create the "port". Make sure the "port" is writable by user "lp" but not readable by unauthorised people!

Use the printer interface "standard", so no control codes get written to the file.

When you print to that device, the output will just get written to the text file. You can then run unix2dos on the file and ftp it to windows, to be imported to your database there. Delete the contents of the file with "> /tmp/CIAdata.txt" if you need to run multiple exports.

I expect the main problem will be in developing reports in CIA that output all the data in a "flat file" format. If CIA is a relational database, you'll need one report to export the "master" records, then another for the sub-records (e.g. the components of the quote).
0
 
fredericoCommented:
Although you have told us the name of the manufacturerof the program you are using,, you failed to tell us to what program/database/filesystem type you intende to convert to.
It would also help to know the language/filesystem used by "CIA".
Once we have these details, we may be able to help you.

Regardless of that, and if the unix you are using is NOT the host system, then you can connect through FTP from one workstation in windows, to the Unix server, and download the file.
0
 
tfewsterCommented:
One of the most common problems with moving text files from Unix to Windows is that the usual End Of Line marker in Unix is Linefeed, whereas DOS/Windows expects LineFeed AND Carriage Return.

The SCO unix2dos command will convert the EOL marker (& character sets if required).

Have a look at the file using "more" - if it's text, with the end of record delimited by Linefeed, moving it should be straightforward. If it's binary, or encrypted, you'll need to go back to the supplier for help.

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
calvinjsAuthor Commented:
frederico & tfewster
 I want to eventually get the file into a dbf, and use NT windows based programs to deal with our quote system. The CIA program will not print to file or export the data in another format. I will check to see what format it is using on monday. The CIA program will print a report in the unix system, is there a way to intercept it, and move it as a text file, even though the program does not give you this option?
             calvinjs
0
 
calvinjsAuthor Commented:
tfewster really knows unix, and for me just knew to the environment, he is better and a text book.
           Calvinjs
0
 
tfewsterCommented:
Thanks Calvin!

BTW, I'd be quite happy to continue this "discussion" if you have problems with any of these steps - Just add a comment to this thread.

Cheers, Tim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.