Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

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
0
calvinjs
Asked:
calvinjs
  • 3
  • 2
1 Solution
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
tfewsterCommented:
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
 
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now