This is an old revision of the document!
Table of Contents
TMSS10Page2CSV
TMSS10Page2CSV converts a page formatted report to a CSV file.
Synopsis
This program expects a variable number of arguments. Each argument is a string representing a filter, the first filter represents the string that should be considered a page break, while each subsequent argument represents a string that should be considered a record to be extracted.
Options
This program has no options.
Exit Status
- zero Program has ended successfully.
- non-zero Program has not ended successfully.
Environment
TMSSBEEP If defined the program will beep whenever an error occurs.
TMSSCHOMP If defined the program will remove the number of characters defined from the beginning of the extracted string.
Files
stdout: Output Reports.
stderr: Diagnostic messages.
stdin: Program input.
Example
Command Line Syntax
Define TMSSCHOMP to remove the first 32 bytes from extracted string
Set first argument (*=*“) to define page break, any string starting with character =
Extraction filter (“Media Status:*”) for field 1
Extraction filter (“Data Expiration:*”) for field 2
Direct input file media.txt to stdin
set TMSS10CHOMP=32 TMSS10Page2CSV "===*" "Barcode:*" "Volume Pool:*" "Vault Name:*" "Robot Number:*" "Media Status:*" "Last Written:*" "Last Read:*" "Data Expiration:*" < media.txt > media.csv
Sample Input File
Media.txt
Media GUID: afds5a1b-fb65-4bfb-4f38-07f7ds418074 Media ID: 101001 Partner: - Media Type: HCART Volume Group: Off_Site Application: Netbackup Media Flags: 1 Description: Scratch Barcode: 101001L5 Partner Barcode: -------- Last Write Host: NONE Created: 06/24/2018 16:11 Time Assigned: - First Mount: 07/05/2016 16:21 Last Mount: 05/09/2020 15:23 Volume Expiration: - Data Expiration: - Last Written: 06/01/2021 14:44 Last Read: - Robot Type: NONE Robot Control Host: - Robot Number: - Slot: - Side/Face: - Cleanings Remaining: - Number of Mounts: 116 Maximum Mounts Allowed: 0 Media Status: ACTIVE Kilobytes: 0 Images: 0 Valid Images: 0 Retention Period: - Number of Restores: 0 Optical Header Size Bytes: 0 Optical Sector Size Bytes: 0 Optical Partition Size Bytes: 0 Last Header Offset: 0 Adm Guid: 00000000-0000-0000-0000-000000000000 Rsm Guid: 00000000-0000-0000-0000-000000000000 Origin Host: NONE Master Host: sac100.gazillabyte.com Server Group: - Upgrade Conflicts Flag: Pool Number: 4 Volume Pool: Scratch Previous Pool Name: GazillaByte-1 Vault Flags: - Vault Container: - Vault Name: GazillaByte_Vault_Eject Vault Slot: 002 Session ID: 1322 Date Vaulted: 06/04/2021 18:05 Return Date: 06/04/2021 18:05 Media on Hold: 0 ==================================================================== Media GUID: afds5a1b-fb65-4bfb-4f38-07f7ds418074 Media ID: 101002 Partner: - Media Type: HCART Volume Group: Off_Site Application: Netbackup Media Flags: 1 Description: Scratch Barcode: 101002L5 Partner Barcode: -------- Last Write Host: NONE Created: 06/24/2018 16:11 Time Assigned: - First Mount: 07/05/2016 16:21 Last Mount: 05/09/2020 15:23 Volume Expiration: - Data Expiration: - Last Written: 06/01/2021 14:44 Last Read: - Robot Type: NONE Robot Control Host: - Robot Number: - Slot: - Side/Face: - Cleanings Remaining: - Number of Mounts: 116 Maximum Mounts Allowed: 0 Media Status: ACTIVE Kilobytes: 0 Images: 0 Valid Images: 0 Retention Period: - Number of Restores: 0 Optical Header Size Bytes: 0 Optical Sector Size Bytes: 0 Optical Partition Size Bytes: 0 Last Header Offset: 0 Adm Guid: 00000000-0000-0000-0000-000000000000 Rsm Guid: 00000000-0000-0000-0000-000000000000 Origin Host: NONE Master Host: sac100.gazillabyte.com Server Group: - Upgrade Conflicts Flag: Pool Number: 4 Volume Pool: Scratch Previous Pool Name: GazillaByte-1 Vault Flags: - Vault Container: - Vault Name: GazillaByte_Vault_Eject Vault Slot: 002 Session ID: 1322 Date Vaulted: 06/04/2021 18:05 Return Date: 06/04/2021 18:05 Media on Hold: 0 ====================================================================
Sample Output File
media.csv
101001L5,Scratch,GazillaByte_Vault_Eject,-,ACTIVE,06/01/2021 14:44,-,-, 101002L5,Scratch,GazillaByte_Vault_Eject,-,ACTIVE,06/01/2021 14:44,-,-,