Differences

This shows you the differences between two versions of the page.

--- cookbook:networker [2018/09/19 02:59] – [Networker Sync Cookbook] Scott Cunliffe
+++ cookbook:networker [2025/01/23 03:50] (current) – [Example Synchronization Definition] Gerard Nicol
@@ Line 3: / Line 3: @@
 [[https://en.wikipedia.org/wiki/EMC_NetWorker|NetWorker]] is a Dell EMC backup solution and is available for Linux, Windows, macOS, NetWare, OpenVMS and Unix.
+===== Data Extraction From Networker =====
+The first step in Synchronizing your Networker Library with TapeTrack is to extract the Volume data from your Networker instance.
+Using the administrative tool mminfo, the Volume data needs to be extracted from the Networker save sets and exported into CSV file format.
+{{mminfo_extract.png}}
 ===== The mminfo command =====
@@ Line 9: / Line 16: @@
 To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:
-<sxh plain;>
+<code plain;>
 mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
-</sxh>
+</code>
 ==== Example mminfo output ====
-<sxh plain;>
+=== Output With Suffix ===
+<code plain;>
 volume,barcode,family,type,location,pool
 L6,000000L6,tape,LTO,Offsite,weekly_full
@@ Line 25: / Line 34: @@
 L6,000006L6,tape,LTO,Offsite,weekly_full
 L6,000007L6,tape,LTO,Offsite,weekly_full
-</sxh>
+</code>
+=== Output Without Suffix ===
+<code plain;>
+volume,barcode,family,type,location,pool
+,000000,tape,LTO,Offsite,weekly_full
+,000001,tape,LTO,Offsite,weekly_full
+,000002,tape,LTO,Offsite,weekly_full
+,000003,tape,LTO,Offsite,weekly_full
+,000004,tape,LTO,Offsite,weekly_full
+,000005,tape,LTO,Offsite,weekly_full
+,000006,tape,LTO,Offsite,weekly_full
+,000007,tape,LTO,Offsite,weekly_full
+</code>
 ==== Post-processing ====
 <note important>You will need to install the [[cli:sync_suite|TapeTrack Sync software]] to complete these instructions.</note>
-To interpret the output in the file we use a definition file (default.ttidef) which reads the data in the Networker file, line by line, and parses the information which TMSS10Sync then uses to update the volumes location (and other data as specified) in the TapeTrack Server.  It is best practice to write the definition file in a program like Notepad or Vi to ensure it is plain text and has no hidden control characters.
+==== Barcodes ====
+It possible for NetWorker barcodes to be missing the LTO L-Suffix.
-===== default.ttidef =====
+It is always recommended that where possible volumes are loaded into TapeTrack with their L-Suffix, and this suffix can be established by:
+  - The Media-ID value if it includes the suffix.
+  - Adding an appropriate suffix to the Media-ID based upon the value of the Media Type field.
+  - Adding an appropriate suffix based upon the range of the Media-ID.
+  - Using TapeTrack's Constructive Barcode feature.
-default.ttidef file sample with code to:
+===== Synchronization =====
-  * Set CSV file delimiter (2)
-  * Exclude any string that starts with barcode (5)
-  * Set customer ID to US01 (8)
-  * Set media ID to LTO (9)
-  * Set default repository to LIBR (12)
-  * extract volume ID from column 1, length 8 characters (15)
-  * extract volume description from column 6, length 50 characters (18)
-  * If description contains the string "Offsite" set repository to **OFFS** (21)
-<sxh plain;>
+Synchronization with TapeTrack is performed by calling the [[cli:TMSS10Sync|TMSS10Sync]] command-line program, along with:
-# Set CSV delimiter
-SetCSVDelimiter(",");
-# Skip any line that begins with barcode (header)
+  - The CSV file produced by pre-processing the mminfo output.
-AddString(EXCLUSION, 0, "barcode*");
+  - Command-line arguments that instruct the program how to process volumes.
+  - A synchronization definition file that instructs the program how to interpret the mminfo output.
-# Set customer ID and media ID to sync with
+{{networker_sync.png}}
-setLiteral(CUSTOMER, "US01");
-setLiteral(MEDIA, "LTO");
-# All volumes initially set to library
+==== Example Command Line Arguments ====
-setLiteral(REPOSITORY, "LIBR");
-# Extract Volume ID from column 1 (up to eight characters long)
+<code>
-Extract(VOLUME, 1, 8, 0);
+TMSS10Sync -d Volume.ttidef -a -S user:-password@server < report.csv
+</code>
-# Extract volume Description from column 6 (up to fifty characters long)
+Where:
-Extract(DESCRIPTION, 6, 50, 0);
+  * ''-d'' is the path to the Synchronization Definition File.
+  * ''-a'' tells the program to add new tape volumes if they are encountered.
+  * ''-S'' tells the program what [[cli:server_argument|Server]] to connect to.
+  * ''report.csv'' is the ''mminfo'' output file.
-# Send any volume from the pool **offsite** to OFFS repository
-AddTranslation2(REPOSITORY, DESCRIPTION, "Offsite*", "OFFS");
-</sxh>
+==== Example Synchronization Definition ====
-===== Sync Information =====
+<code plain;>
+#
-Create a batch file with code to run Networkers mminfo command and then TMSS10Sync with the required parameters to input the report.csv file and default.ttidef file.  Running with the -M command will place the Sync in dump mode, which allows you to check the output from the process without executing any alterations in the TapeTrack Server.
+# Set the Customer and Media as literal values as they never change
+#
-Sample batch file to run mminfo, pass the information to TMSS10Sync and output a dump of information.
+SetLiteral(CUSTOMER, "ACME");
-<sxh plain;>
+SetLiteral(MEDIA, "LTO");
-mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
+#
+# Set the delimiter to a CSV
-TMSS10Sync -M < report.csv > stdout.txt 2> stderr.txt
+#
-</sxh>
+SetCSVDelimiter(",");
+#
-When you are happy with the output, remove the -M attribute and insert -S attribute and access credentials for the TMSS10Sync command line.  Adding an attribute -a will add any new volumes in Networker not present in TapeTrack.
+# Skip any line that begins with string volume (header)
+AddString(EXCLUSION, 0, "volume*");
-<sxh plain;>
+#
-mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
+# Set the Description to the Pool Name
+#
+Extract(DESCRIPTION, 6, 20, 0);
+RemoveSpaces(DESCRIPTION);
+#
+# Get the Volume-ID from the report
+Extract(VOLUME, 1, 8, 0);
+#
+# Get the Repository from a translated location
+Extract(REPOSITORY, 5, 20, 0);
+RemoveSpaces(REPOSITORY);
+#
+# Send any volume from the pool **offsite** to OFFS repository, all others to LIBR
+AddTranslation(REPOSITORY, "Offsite*", "OFFS");
+AddTranslation(REPOSITORY, *, "LIBR");
-TMSS10Sync -S user:-password@server -a < report.csv > stdout.txt 2> stderr.txt
+</code>
-</sxh>
-===== Automating The Sync Process =====
-Once the Sync process is set up and running correctly, the batch file can be run automatically every hour (or at a time frame that suits) through windows scheduler to keep TapeTrack up to date.
+<- :cookbook:netbackup|NetBackup Sync Cookbook ^ :cookbook:introduction|Cookbook ^ :cookbook:tsm|Tivoli Storage Management Sync Cookbook->
+{{tag> cookbook}}