Importing Generic Backup Data > CSV Format Specification
  
Version 10.2.01P10
CSV Format Specification
Using the backup software, create a comma-separated file that contains the following 15 data elements from the backup/restore job(s). Note that each field must have an entry, even if it is a null entry within the commas. Field values cannot contain embedded commas. All string fields must be enclosed within single straight quotes.
Note: The CSV file must be UTF-8 encoded, however be sure to remove any UTF-8 BOMs (Byte Order Marks). The CSV cannot be properly parsed with these additional characters.
 
Name
Type
Value
VendorName
STRING
The name of the backup application used to perform the backup, enclosed in single straight quotes.
ClientName
STRING
The host name of the machine being backed up, enclosed in single straight quotes.
ClientIPAddress
NUMBER
The IP address of the machine being backed up. If an IP address is not available, simply use two single straight quotes ('') or 'null' to indicate a blank/missing value.
VendorJobType
STRING
Valid values include: BACKUP or RESTORE—enclosed in single straight quotes.
StartDateString
DATE
The start date and time of the backup job in the format: YYYY-MM-DD HH:MI:SS (enclosed in single straight quotes).
Note: Adhere to the specific date format—number of digits and special characters—as shown above.
FinishDateString
DATE
The end date and time of the backup job in the format: YYYY-MM-DD HH:MI:SS (enclosed in single straight quotes).
Note: Adhere to the specific date format—number of digits and special characters—as shown above.
BackupKilobytes
NUMBER
The numeric size of the backup in kilobytes (otherwise use 0). Remember APTARE IT Analytics uses 1024 for a KiB.
NbrOfFiles
NUMBER
The number of files that were backed up (otherwise use 0).
MediaType
STRING
The type of media that was used: T for Tape or D for Disk, enclosed within single straight quotes.
VendorStatus
NUMBER
A numeric job status: 0=Successful, 1=Partially Successful, or 2=Failed.
VendorJobId
STRING
Vendor job ID, enclosed in single straight quotes.
VendorPolicyName
STRING
Vendor policy name, enclosed in single straight quotes.
JobLevel
STRING
Job level, enclosed in single straight quotes. Example: Incremental, Full.
TargetName
STRING
File system backed up by the managed backup system (MBS), enclosed in single straight quotes.
ScheduleName
STRING
Name of the backup schedule, enclosed in single straight quotes.
EXAMPLE: genericBackupJobs.csv
'Mainframe Backup','mainframe_name','10.10.10.10','BACKUP','2008-03-24 10:25:00', '2008-03-24 11:50:00',3713,45221,'D',0,'413824','Retail_s01002030','Incremental','/I:/Shared/','Daily'
'UNIX tar backup','host_xyz.anyco.com','null','BACKUP','2008-03-24 10:22:00',
'2008-03-24 12:50:00',1713,45221,'T',1,'5201','HQ_Finance','Full','/D:/Backups/','Daily'
'ArcServe','host_123.anyco.com','null','RESTORE','2008-03-24 8:22:00',
'2008-03-24 9:12:00',0,0,'T',0,'2300','Retail_s03442012','Incremental','/I:/Shared/','EOM'