Finished

Details

Executable	Finished.exe
Stage	240
Percent Complete	94% - 100%
Message Queue	finished

The Finished ETL is responsible for completing a Truxton load. It performs the following tasks:

• Updating [File] table records to populate [NumberOfChildren] and [FullPathID] columns
• Record final load data in the [Statistics] table
• Generate the Load Log
• Update the [MD5Hash] table with a unique list of hashes

Automatic Backup

You can have a backup made of the freshly loaded media by adding the following to your configuration.

  <autobackup>Yes</autobackup>
  <backupfolder>C:\Temp\s7</backupfolder>

Name	Data Type	Description
autobackup	boolean	When true, it generates a media export
backupfolder	string	The name of the folder to hold the backup

The output filename will have the format of a timestamp followed by the media id. For example:

2021-01-24-06-05-59-18229588-049F-9E2B-868B-F8841392A4AF.tpmf

Automatic Publishing

You can have the freshly loaded media pushed to another instance of Truxton by adding the following to your configuration.

  <autopublish>Yes</autopublish>
  <apname>EnterpriseTruxton</apname>
  <apserver>localhost</apserver>
  <apport>5432</apport>
  <apuser>postgres</apuser>
  <appassword>Truxton4n6</appassword>

Name	Data Type	Description
autopublish	boolean	When true, it will copy the freshly loaded media from the local server to a remote one
apname	string	The name of the database to receive the freshly loaded media
apserver	string	The name of the database server machine to receive the freshly loaded media
apport	integer	The port number the server is listening on
apuser	string	The name the account to use to log onto the database server
appassword	string	The password of the account used to log onto the database server