Need advice: Copying large CSV report files off SCO system


 
Thread Tools Search this Thread
Operating Systems SCO Need advice: Copying large CSV report files off SCO system
# 1  
Old 07-12-2011
Need advice: Copying large CSV report files off SCO system

I have a SCO Unix server from 1999 running SCO 5.0.5 and some ancient accounting software called Real World

A report writer program on the system is used to generate CSV files from accounting that we write with DOSCOPY commands to 3.5" floppies

In the next 60 days we will be decommissioning this system and I need to generate many CSV files that are too large for the floppies

The system has USB ports but I've been told that the SCO 5.0.5 does not support USB (It did in the next version of SCO?)

There is no external SCSI port on the box.

How can I hook up a large DOS formatted drive of any sort to write these files to that can then be plugged to a Windows machine to access the CSV files?

Any help or advice would be greatly appreciated.

Thanks
This User Gave Thanks to magnetman For This Post:
# 2  
Old 07-12-2011
Do you have the host or enterprise version. Enterprise has tcp, host does not.
If you have enterprise, you can ftp the files.
If you only have host, then download them using kermit.
Do you have access to another Unix system? If so you can use diskettes and create multi volume tar files.
You can install and mount a DOS hard disk, and copy the files to it, and then move the disk to another machine.
I need to know the root disk controller, and, if it is SCSI, will the BIOS allow you to boot from it if there is an IDE drive installed in order to tell you how to install a DOS hard disk.

Last edited by jgt; 07-12-2011 at 06:43 AM..
This User Gave Thanks to jgt For This Post:
# 3  
Old 07-15-2011
I'm not sure if this is host or enterprise. Have no access to another unix system on site.
This machine is not connected to internet. It's just connected to 5 other PCs through a digiboard and we use terminal emulation software on PCs

Preferred method to copy off large reports from this system would be if I can install another HDD on the SCSI chain, copy the reports to that and then remove the drive and hook to a Windows PC somehow

How do I find out what is the root disk controller?

If I acquire a SCSI HDD and just install to the chain will the system just recognize it? If not, what is the procedure to make the new drive an active device on the system?

Thanks

Last edited by magnetman; 07-15-2011 at 12:18 PM..
# 4  
Old 07-15-2011
Step 1.
signed on as root
#custom
This will the display the software installed, (and allow you to add/delete)
One of the items will be OpenServer Enterprise or Host.

Although the fact that the terminals are attached through a multi serial port card strongly suggests that you have host.
The 'hw' command will display the hardware installed.
Use the "mkdev hd" command to add a hard disk.
If you add a SCSI disk, you will also need either a second computer with the same SCSI controller, or a way of booting this machine from diskette or cd.
Add an IDE disk, if the BIOS allows you to boot from SCSI ahead of IDE.
# 5  
Old 07-16-2011
There is a possibility that your terminal emulation software has a file transfer capability. Which one do you use?

I have, in the dim past, used a program in basic to capture stuff coming in on a serial port that was generated by cat and redirected to the connected serial port.

telnet question deleted.

Last edited by edfair; 07-16-2011 at 02:44 AM.. Reason: not a solution
# 6  
Old 07-16-2011
We use Omicom or Alphacom I think it's called

Someone gave me a Zip command today that worked great. I can fit 8 - 9 mb files on a floppy so this should work to solve my problem without messing with an additional HDD

Only problem I have now is the 3.5" FD is having some problems. Have not used it in a few years so it may just be dirty. It's running but I'm getting read and copy errors.

Going to try and blow it out first. There's a few SCSI 3.5 FDDs on ebay for $25 if cleaning doesn't work.

Are all SCSI FDDs the same?

Last edited by magnetman; 07-16-2011 at 10:17 AM..
# 7  
Old 07-16-2011
What kind of system has a SCSI diskette drive? A standard (34 pins) floppy drive is about 15 dollars.
I am not surprised that the floppy doesn't work, its usually the intake for the cooling fans.
In order to read the floppy diskettes on a DOS/Windows system, first format them using "dosformat /dev/rfd0135ds18" or "dosformat a:"
Zip the file.
Use "doscp file.zip a:" to copy the file to the diskette.
You could always use the "split" command to break up really large files into sections.
Are you creating DOS or UNIX csv files (crlf or lf line endings)? If you create UNIX files, you can copy them and then read them using notepad++ and save as DOS by changing Settings->Preferences

Last edited by jgt; 07-16-2011 at 02:47 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Copying large files in a bash script stops execution

Hello, I'm new to this forum and like to first of all say hello to everyone. I've got a really annoying problem at the moment. I'm trying to rsync some files (about 200MB with one file of 120MB) from a Raspberry PI with raspbian to a debian server via rsync. This procedure is stored in a... (3 Replies)
Discussion started by: wex_storm
3 Replies

2. Shell Programming and Scripting

Comparing two large unsorted csv files

Hi All, My requirement is to write a shell script to compare two large csv files. I've created sample files for explaining my problem i.e., a.csv and b.csv contents of files: ----------------- a.csv ------ Type,Memory (Kb),Location HD,Size (Mb),Serial # XT,640,D402,0,MG0010... (2 Replies)
Discussion started by: vasavi
2 Replies

3. Shell Programming and Scripting

Merging Very large CSV files in Unix

Hi, I have two very large CSV files, which I want to merge (equi-join) based on a key (column). One of the file (say F1) would have ~30 MM records and 700 columns. The other file (~f2) would have same # of records and lesser columns (say 50). I want to create an output file joining on a... (3 Replies)
Discussion started by: student_007
3 Replies

4. Red Hat

Advice regarding filesystems handling large number of files

Hi All, I have a CentOS operating system installed. I work with really huge number of files which are not only huge in number but some of them really huge in size. Minimum number of files could be 1 million to 2 million in one directory itself. Some of the files are even several Gigabytes in... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

5. Shell Programming and Scripting

Copying multiple csv files

Hi, I have mutiple csv files at server1 at /apps/test/data. I needed a script that would copy these csv files from server1 at /usr/data, put them in server2,archive the earlier files that were present in server2 before removing those already present. Kindly help. (2 Replies)
Discussion started by: Alok Ranjan
2 Replies

6. Shell Programming and Scripting

Copying of large files fail

Hi, I have a process which duplicates files for different environments. As the files arrive, my script (korn shell) makes copies of them (giving a unique name) and then renames the original file so that my process won't get triggered again. I don't like it either, but it's what we were told to... (4 Replies)
Discussion started by: GoldenEye4ever
4 Replies

7. Programming

Is there a system call other than 'open' for opening very large files?

Dear all, Inside a C program, I want to open a very big file (about 12 GB) in order to read its content. Here is the code: /* argv contains the path to the file. */ inputFileDescriptor = open(argv, O_RDONLY); if (inputFileDescriptor < 0) { ... (6 Replies)
Discussion started by: dariyoosh
6 Replies

8. Shell Programming and Scripting

Sed or awk script to remove text / or perform calculations from large CSV files

I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in... (6 Replies)
Discussion started by: metronomadic
6 Replies

9. Web Development

Content Management System for uploading large files

Hi everybody, I am currently trying to develop a simple content management system where I have an internal website for my users to upload large files onto the server. The site is password protected and my users won't be trying to hack into the system so security is a non-factor (as least for... (3 Replies)
Discussion started by: z1dane
3 Replies

10. UNIX for Dummies Questions & Answers

copying .profile files to a new server (SCO)

Hello Intelligent Life Forms (I hope) This should be a snap for some of you. I need to copy the /usr .profiles from 1 sco system to another. Migrating to a new server. I've tried a recursive copy to the target system with a NFS mount point from the source. Wouldn't do it permissions... (2 Replies)
Discussion started by: sighbrrguy
2 Replies
Login or Register to Ask a Question