Exporting Data Through TinyTERM
Friday, April 13th, 2007You may need to get data from your server to your PC for another application. For example, you may need to import a UNIX report into a spreadsheet.
There are three possible ways to do this. The one to choose depends on your particular environment.
- File transfer
If the data is in a file on the server, you can use TinyTERM’s file transfer function to download the file to your PC. This requires that you first start the transfer on the server. After that’s done, the steps in TinyTERM are:- On the Tools menu, click Get File.
- In the File transfer protocol list, choose the protocol the host system is using.
- If you want to save the file to a directory other than the current directory on your machine, enter the destination directory in the Local destination directory box.
- Under Transfer type, choose ASCII.
- In the Source files to get box, type the name of the file on the host.
- Click Receive File to begin receiving.
- Data capture
If you’re working with a report from a database, you can display that report to the TinyTERM window and capture the information. To set that up, do the following:- On the Edit menu, click Session Properties.
- Click the Data Capture tab.
- In the Capture device list, click FILE.
- In the Capture file or device name box, type the name of the file you want to create.
- Click OK.
That configures the data capture. Next, in the server database set the report up, but do not start it. Go to TinyTERM’s Tools menu and select Capture File to start the data capture. Start the report on the server. When it finishes, select Tools | Capture File again to stop the data capture. You will probably need to edit the final file with Notepad to clean up information at the beginning and end.
- Transparent printing
If the server application allows transparent printing, you can print the data to a file on your PC’s hard drive. To set that up, do the following:- On the File menu, click Printer Setup. The Printer Setup dialog box appears.
- Click the File radio button.
- In the File Name box, type the name of the file you want to create.
- Click OK to close the Printer Setup dialog box.
Once that’s done, start the print job on the server. Nothing will print at your printer. Instead, the file you need will be created on your PC’s hard drive.
The preceding instructions are for TinyTERM 4.x. Similar capabilities exist in most Century Software, Inc., products. Regardless of which method or product you use, you’ll have a text file on your PC that you can then import into any application.