Differences

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

--- sync:execute [2021/06/03 05:00] – created Scott Cunliffe
+++ sync:execute [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Running Sync ======
+TapeTrack Sync can be executed from a command line prompt manually, but as running the Sync is done on a regular schedule, it is best practice to place the commands in a batch file and once correct execution has been verified the batch file can be initiated using Windows Scheduler or similar programs such as Cron.
+Ensure that the batch file executes from the correct Sync directory by either adding the code in the batch file to change directory or specifying in the schedule call to start in the correct directory.
 It is advisable to execute the Sync process first in dump mode, then test mode before running in live mode.
+The process of running in all three modes only differs by adding or removing an attribute in the executable call.
 Dump mode will run the Sync and output the raw data without parsing or translating any fields.  This allows you check that the importation of data is correct before making any alterations to your database.
@@ Line 9: / Line 15: @@
 Live mode will update the database with the data from the input source file.
+The following examples reference all files, source, definition and output files, as if they are all contained in or written to in the one directory.  This is to demonstrate to format of the executable call in a generic manner.
+It is recommended to follow the Sync directory structure to place the source, definition and output or report files in the recommended directories to make future maintenance easier.
+  * [[sync:file_structure|Windows directory structure]]
+  * [[sync:file_structure_linux|Linux Directory Structure]]
 ===== Dump Mode =====
+  TMSS10Sync -S user:-password@server_address -M -a -d default.ttidef < source_input.csv > sync_stdout.txt  2> sync_stderr.txt
+Attributes:
+  * -S user:-password@server_address: logon string
+  * -M: Dump mode
+  * -a: Add any new Volumes
+  * -d default.ttidef: Definition file
+Input Files
+  * source_input.csv: Source file.
+Output Files:
+  * sync_stdout.txt: Standard output stream.
+  * sync_stderr.txt: Standard error stream.
 ===== Test Mode =====
+  TMSS10Sync -S user:-password@server_address -t -a -d default.ttidef < source_input.csv > sync_stdout 2> sync_stderr.txt
+Attributes:
+  * -S user:-password@server_address: logon string
+  * -t: Test mode
+  * -a: Add any new Volumes
+  * -d default.ttidef: Definition file
+Input Files
+  * source_input.csv: Source file.
+Output Files:
+  * sync_stdout.txt: Standard output stream.
+  * sync_stderr.txt: Standard error stream.
 ===== Live Mode =====
+  TMSS10Sync -S user:-password@server_address -a -d default.ttidef < source_input.csv > sync_stdout 2> sync_stderr.txt
+Attributes:
+  * -S user:-password@server_address: logon string
+  * -a: Add any new Volumes
+  * -d default.ttidef: Definition file
+Input Files
+  * source_input.csv: Source file.
+Output Files:
+  * sync_stdout.txt: Standard output stream.
+  * sync_stderr.txt: Standard error stream.
+<- sync:definition|Sync Definition Filesn ^ sync:introduction|introduction ^   sync:output|Sync Output->