Data Transfer and Conversion

CSV and XML File Production › Data Transfer and Conversion

Data Transfer and Conversion

After CSV data for CA NSM Performance Management has been created, it must be downloaded to the CA NSM machine where CA NSM Performance Management is installed. Furthermore, CSV data for Performance Management must be converted into the Performance Management CUBE format before it can be processed.

The RMWSXfr program supports CSV data conversion and data transfer. To install a copy of RMWSXfr on your workstation, complete the following four steps.

Download CAJROPTN.
To use FTP (File Transfer Protocol) to transfer RMWSXfr to your Microsoft Windows workstation:
- Open a DOS command window.
- Start the FTP program using the following:
```
FTP <hostname>
```
  where <hostname> is the machine name or the IP address of the z/OS system.
  
  Supply the host userid and password as prompted.
- Set binary transfer mode by entering the following command (in lower case):
```
binary
```
  Note: This FTP command and those that follow must be entered in lower case.
- Set the name of the host data set with the following:
```
cd 'hlq.CAJROPTN'
```
- Set the directory name of the workstation directory to hold RMWSXfr with the following command:
```
lcd <directory>
```
  where <directory> is a directory on the workstation which will contain RMWSXfr. Generally, this is a temporary or working directory (e.g., C:&bslash.&bslash.TEMP).
- Transfer the RMWSXfr to the workstation with the following command:
```
get RMWSXFRZ RMWSXFRZ.EXE
```
  This will copy RMWSXFRZ to the directory that you specified and rename it to RMWSXFRZ.EXE.
- Once the transfer is complete, exit FTP by entering:
```
quit
```
  While this example uses FTP to perform the actual transfer, other utilities (such as IND$FILE) can be used. The utility being used must be able to transfer from the host to the workstation without performing any character translation (i.e., EBCDIC to ASCII).
Run RMWSXFRZ.EXE by double-clicking on the file name. This starts the self-extracting process. You will be prompted for a location in which to store the unzipped files.
Run the setup.exe by double-clicking on the filename. Follow the prompts to complete the install.
After the installation is complete, read the README.TXT in the program directory for detailed instructions on how to use RMWSXfr. The README.TXT is applicable to both CA JARS and CA MICS.