| |
| reports:reconciliation [2019/01/14 03:18] – [Reconciliation Statistics] Scott Cunliffe | reports:reconciliation [2025/01/21 22:07] (current) – external edit 127.0.0.1 |
|---|
| The program runs in 4 sequential phases: | The program runs in 4 sequential phases: |
| |
| * **Phase 1** Load of the TapeTrack Scan-Map from a Scan File. | * **Phase 1** Load of the TapeTrack Scan-Map from a Scan-File. |
| * **Phase 2** Reconciliation of the Scan-Map. | * **Phase 2** Reconciliation of the Scan-Map. |
| * **Phase 3** Listing of unreferenced Scan-Map items. | * **Phase 3** Listing of unreferenced Scan-Map items. |
| {{reports:reports_tmss10reconcile_tapemaster_customer_status.png}} | {{reports:reports_tmss10reconcile_tapemaster_customer_status.png}} |
| |
| ==== Scan File ==== | ==== Scan-File ==== |
| |
| {{reports:reports_tmss10reconcile_tapemaster_scanfile.png}} | {{reports:reports_tmss10reconcile_tapemaster_scanfile.png}} |
| ==== Load of Scan-Map ==== | ==== Load of Scan-Map ==== |
| |
| The purpose of this phase is load a [[concepts:scan-file|TapeTrack Scan-File]] and resolve each of the a Scan-File Entries into a [[concepts:fully_qualified_barcode|Fully Qualified TapeTrack Barcode]]. | The purpose of this phase is to load a [[concepts:scan-file|TapeTrack Scan-File]] and resolve each of the a Scan-File Entries into a [[concepts:qualified_barcode|Fully Qualified TapeTrack Barcode]]. |
| |
| As the [[concepts:scan-file|Scan-File]] is loaded, a [[concepts:scan-map|Scan-Map]] is created. | As the [[concepts:scan-file|Scan-File]] is loaded, a [[concepts:scan-map|Scan-Map]] is created. |
| |
| Alternatively, rather than loading the [[concepts:scan-map|Scan-Map]] from a Scan-File, the [[subsystem:importengine|TapeTrack Import Engine]] can be used to load the [[concepts:scan-map|Scan-Map]]. This facilitates loading from Fixed Length Reports, CSV Files and ODBC Data Sources. | Alternatively, rather than loading the [[concepts:scan-map|Scan-Map]] from a Scan-File, the TapeTrack Import Engine can be used to load the [[concepts:scan-map|Scan-Map]]. This facilitates loading from Fixed Length Reports, CSV Files and ODBC Data Sources. |
| |
| The Fully Qualified TapeTrack Barcode can be resolved from an [[concepts:unqualified_barcode|Unqualified Barcode]] or an [[concepts:extended_attribute|Extended Attribute]]. | The Fully Qualified TapeTrack Barcode can be resolved from an [[concepts:qualified_barcode|Unqualified Barcode]] or an [[concepts:extended_attribute|Extended Attribute]]. |
| <sxh plain;> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 1: Load Scan-Map from Scan-File | Report Description: Phase 1: Load Scan-Map from Scan-File |
| 7 7 US04.LTO.111111L6 US04.LTO.111111L6 OK | 7 7 US04.LTO.111111L6 US04.LTO.111111L6 OK |
| ------ ------ ---------------------------------------- -------------------- ------ -------------------------- | ------ ------ ---------------------------------------- -------------------- ------ -------------------------- |
| </sxh> | </code> |
| |
| ==== Reconcile of TapeTrack Volumes ==== | ==== Reconcile of TapeTrack Volumes ==== |
| |
| The purpose of this phase is to list all of the [[:object:volume|Volumes]] that are either in, moving to, or unexpected in the specified [[:object:repository|repository]]. | The purpose of this phase is to list all of the [[:object:volume|Volumes]] that are either in, moving to, or unexpected in the specified [[:object:repository|Repository]]. |
| |
| The following statuses may result: | The following statuses may result: |
| |
| * **Reconciled** if the [[:object:volume|Volume]] is in the target [[:object:repository|repository]], is in the [[concepts:scan-map|scan-map]] and not moving. | * **Reconciled** if the [[:object:volume|Volume]] is in the Target [[:object:repository|Repository]], is in the [[concepts:scan-map|Scan-Map]] and not moving. |
| * **Reconciled (Confirmed)** if the [[:object:volume|Volume]] is moving into the specified [[:object:repository|repository]] and is in the [[concepts:scan-map|scan-map]]. The Volume will be Confirmed in the TapeTrack database. | * **Reconciled (Confirmed)** if the [[:object:volume|Volume]] is moving into the specified [[:object:repository|Repository]] and is in the [[concepts:scan-map|Scan-Map]]. The [[:object:volume|Volume]] will be Confirmed into the [[:object:volume|Volume's]] Target Repository in the TapeTrack database. |
| * **Absent from Scan-Map** if the [[:object:volume|Volume]] is confirmed into the specified [[:object:repository|repository]] and is not present in the [[concepts:scan-map|scan-map]]. An Audit Flag will be assigned to the Volume. | * **Absent from Scan-Map** if the [[:object:volume|Volume]] is confirmed into the specified [[:object:repository|Repository]] and is not present in the [[concepts:scan-map|Scan-Map]]. An Audit Flag will be assigned to the [[:object:volume|Volume]]. |
| * **Pending Confirmation** if the [[:object:volume|Volume]] is in a move status out from the specified [[:object:repository|repository]] and is not overdue at the target [[:object:repository|repository]]. | * **Pending Confirmation** if the [[:object:volume|Volume]] is in a move status out from the specified [[:object:repository|Repository]] and is not overdue at the Target [[:object:repository|Repository]]. |
| * **Overdue at Target** if the [[:object:volume|Volume]] is in a move status to the specified [[:object:repository|repository]], is not in the Scan-Map and is now overdue at the target [[:object:repository|repository]]. | * **Overdue at Target** if the [[:object:volume|Volume]] is in a move status to the specified [[:object:repository|Repository]], is not in the Scan-Map and is now overdue at the Target [[:object:repository|Repository]]. |
| * **Unexpected in Scan-Map** Present in the [[concepts:scan-map|scan-map]] but not present at, or moving to, the target [[:object:repository|repository]]. | * **Unexpected in Scan-Map** Present in the [[concepts:scan-map|Scan-Map]] but not present at, or moving to, the Target [[:object:repository|Repository]]. |
| |
| <note tip>Report headings and spacing have been edited to fit information on web formatting</note> | <note>Report headings and spacing have been edited to fit information on web formatting</note> |
| |
| <sxh plain;> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 2: Reconcile TapeTrack Volumes against Scan-Map | Report Description: Phase 2: Reconcile TapeTrack Volumes against Scan-Map |
| 6 US04.LTO.000009L6 Offsite Vault No Yes OK Reconciled | 6 US04.LTO.000009L6 Offsite Vault No Yes OK Reconciled |
| 7 US04.LTO.000010L6 Library No Yes NOT-OK Unexpected in Scan-Map | 7 US04.LTO.000010L6 Library No Yes NOT-OK Unexpected in Scan-Map |
| -- ------------------ -------------- ----------- ----------- ------- ------- ------ -----------------------</sxh> | -- ------------------ -------------- ----------- ----------- ------- ------- ------ -----------------------</code> |
| |
| Following the example data at the top of page we have: | Following the example data at the top of page we have: |
| * [[:object:volume|Volumes]] 000002L5 and 000009L6 are referenced as **Reconciled** as they are in the [[concepts:scan-map|Scan-Map]], and confirmed in the current [[:object:repository|repository]] (Offsite Vault). | * [[:object:volume|Volumes]] ''000002L5'' and ''000009L6'' are referenced as **Reconciled** as they are in the [[concepts:scan-map|Scan-Map]], and confirmed in the current [[:object:repository|Repository]] (Offsite Vault). |
| * [[:object:volume|Volumes]] 000003L5, 000004L6 and 000005L6 are referenced as **Pending confirmation** as they are in the [[concepts:scan-map|Scan-Map]], and in a move from the current [[:object:repository|repository]] but not yet confirmed at the target [[:object:repository|repository]]. | * [[:object:volume|Volumes]] ''000003L5'', ''000004L6'' and ''000005L6'' are referenced as **Pending confirmation** as they are in the [[concepts:scan-map|Scan-Map]], and in a move from the current [[:object:repository|Repository]] but not yet confirmed at the target [[:object:repository|Repository]]. |
| * [[:object:volume|Volumes]] 000008L6 is referenced as **Absent from Scan-Map** as it appears in TapeTrack as at the current [[:object:repository|repository]] but is absent from the [[concepts:scan-map|Scan-Map]]. This shows the volume is either somewhere it shouldn't be or is missing and as such is given a status of **NOT-OK** and is given an audit flag for further investigation. | * [[:object:volume|Volumes]] ''000008L6'' is referenced as **Absent from Scan-Map** as it appears in TapeTrack as at the current [[:object:repository|Repository]] but is absent from the [[concepts:scan-map|Scan-Map]]. This shows the [[:object:volume|Volume]] is either somewhere it shouldn't be or is missing and as such is given a status of **NOT-OK** and is given an audit flag for further investigation. |
| * [[:object:volume|Volume]] 000010L6 is referenced as **Unexpected in Scan-Map** as it is present in the [[concepts:scan-map|Scan-Map]] as being at the current [[:object:repository|repository]] but shown in TapeTrack as being confirmed at another [[:object:repository|repository]]. As such is given a status of **NOT-OK** and is given an audit flag for further investigation. | * [[:object:volume|Volume]] ''000010L6'' is referenced as **Unexpected in Scan-Map** as it is present in the [[concepts:scan-map|Scan-Map]] as being at the current [[:object:repository|Repository]] but shown in TapeTrack as being confirmed at another [[:object:repository|Repository]]. As such is given a status of **NOT-OK** and is given an audit flag for further investigation. |
| |
| <note tip>Status strings (Reconciled, Reconciled (Confirmed) etc) may be customized using [[|TMSSRECONCILETEXT]] variables </note> | <note tip>Status strings may be customized using [[reports:reconciliation_tmssreconciletext|TMSSRECONCILETEXT]] variables.</note> |
| ==== Unreferenced Scan-Map Entries ==== | ==== Unreferenced Scan-Map Entries ==== |
| This report shows [[:object:volume|Volumes]] that are in the [[concepts:scan-map|Scan-Map]], but are not known to TapeTrack. | This report shows [[:object:volume|Volumes]] that are in the [[concepts:scan-map|Scan-Map]], but are not known to TapeTrack. |
| <sxh plain;> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 3: Unreferenced Scan-Map entries | Report Description: Phase 3: Unreferenced Scan-Map entries |
| 1 US04.LTO.111111L6 | 1 US04.LTO.111111L6 |
| ------ -------------------- | ------ -------------------- |
| </sxh> | </code> |
| |
| Reasons for this error could be: | Reasons for this error could be: |
| * [[:object:volume|Volume]] does not belong to you but has been included with your [[:object:volume|Volumes]] by operator error. | * [[:object:volume|Volume]] does not belong to you but has been included with your [[:object:volume|Volumes]] by operator error. |
| * Manually produced scan file with a typo on a [[:object:volume|Volume]] ID. | * Manually produced Scan-File with a typo on a [[:object:volume|Volume]] ID. |
| * [[:object:volume|Volume]] added to inventory but not entered into TapeTrack. | * [[:object:volume|Volume]] added to inventory but not entered into TapeTrack. |
| |
| This report shows the final statistics for the Reconciliation process. | This report shows the final statistics for the Reconciliation process. |
| |
| <sxh plain;> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 4: Reconciliation Statistics | Report Description: Phase 4: Reconciliation Statistics |
| Phase 4: Total Errors 3 | Phase 4: Total Errors 3 |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| </sxh> | </code> |
| |
| === Phase 1 === | === Phase 1 === |
| |
| Reads in [[:object:volume|Volume]] ID's from the scan file, parses them (depending on format) into Customer ID, Media ID and [[:object:volume|Volume]] ID. Metrics are then displayed as the number of Volumes successfully and unsuccessfully loaded ready for reconciliation in phase two. | Reads in [[:object:volume|Volume-ID's]] from the Scan-File, parses them (depending on format) into Customer-ID, Media-ID and [[:object:volume|Volume-ID]]. Metrics are then displayed as the number of [[:object:volume|Volumes]] successfully and unsuccessfully loaded ready for reconciliation in phase two. |
| |
| With the example data, all 7 entries were successfully loaded as fully qualified barcodes from the scan file into the scan-map ready for reconciliation. | With the example data, all 7 entries were successfully loaded as fully qualified barcodes from the Scan-File into the Scan-Map ready for reconciliation. |
| |
| === Phase 2 === | === Phase 2 === |
| |
| <note tip>Status strings (Reconciled, Reconciled (Confirmed) etc) may be customized using [[|TMSSRECONCILETEXT]] variables </note> | <note tip>Status strings (Reconciled, Reconciled (Confirmed) etc) may be customized using [[reports:reconciliation_tmssreconciletext|TMSSRECONCILETEXT]] variables </note> |
| |
| * **Reconciled** shows number of [[:object:volume|Volumes]] present in scan-map and confirmed at subject [[:object:repository|repository]]. \\ | * **Reconciled** shows number of [[:object:volume|Volumes]] present in Scan-Map and confirmed at subject [[:object:repository|Repository]]. \\ |
| * **Reconciled (Confirmed)** shows number of [[:object:volume|Volumes]] confirmed into subject [[:object:repository|repository]] that were in a move to there and present in scan-map. \\ | * **Reconciled (Confirmed)** shows number of [[:object:volume|Volumes]] confirmed into subject [[:object:repository|Repository]] that were in a move to there and present in Scan-Map. \\ |
| * **Confirmation Bypass** (set as an attribute in [[cli:tmss10reconcile|TMSS10Reconcile]]) shows the number of [[:object:volume|Volumes]] moving to subject [[:object:repository|repository]] and present in scan-map but not confirmed. \\ | * **Confirmation Bypass** (set as an Attribute in [[cli:tmss10reconcile|TMSS10Reconcile]]) shows the number of [[:object:volume|Volumes]] moving to subject [[:object:repository|Repository]] and present in Scan-Map but not confirmed. \\ |
| * **Pending confirmation** shows number of [[:object:volume|Volumes]] present in scan-map, in a move status out of subject [[:object:repository|repository]] and yet to be confirmed at target [[:object:repository|repository]]. \\ | * **Pending confirmation** shows number of [[:object:volume|Volumes]] present in Scan-Map, in a move status out of subject [[:object:repository|Repository]] and yet to be confirmed at target [[:object:repository|Repository]]. \\ |
| * **Out of scope** shows the number of [[:object:volume|Volumes]] in the customers inventory that are not referenced in the scan-map and are listed in TapeTrack as being not confirmed in, moving to or from the subject [[:object:repository|repository]]. \\ | * **Out of scope** shows the number of [[:object:volume|Volumes]] in the customers inventory that are not referenced in the Scan-Map and are listed in TapeTrack as being not confirmed in, moving to or from the subject [[:object:repository|Repository]]. \\ |
| * **Absent from Scan-Map** show the number of [[:object:volume|Volumes]] expected to be either in, moving to or moving from the subject [[:object:repository|repository]] that are not listed in the scan-map. \\ | * **Absent from Scan-Map** show the number of [[:object:volume|Volumes]] expected to be either in, moving to or moving from the subject [[:object:repository|Repository]] that are not listed in the Scan-Map. \\ |
| * **Unexpected in Scan-Map** shows the number of [[:object:volume|Volumes]] present in the scan-map that, in TapeTrack, are not present in, moving to or moving from the subject [[:object:repository|repository]]. \\ | * **Unexpected in Scan-Map** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that, in TapeTrack, are not present in, moving to or moving from the subject [[:object:repository|Repository]]. \\ |
| * **Overdue at subject repository** shows the number of [[:object:volume|Volumes]] present in the scan-map that are moving to the subject [[:object:repository|repository]] but have exceeded the time threshold to complete the move. \\ | * **Overdue at subject repository** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that are moving to the subject [[:object:repository|Repository]] but have exceeded the time threshold to complete the move. \\ |
| * **Overdue at target repository** hows the number of [[:object:volume|Volumes]] present in the scan-map that are moving from the subject [[:object:repository|repository]] but have exceeded the target [[:object:repository|repository]]'s time threshold to complete the move. | * **Overdue at target repository** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that are moving from the subject [[:object:repository|Repository]] but have exceeded the target [[:object:repository|Repository]]'s time threshold to complete the move. |
| |
| === Phase 3 === | === Phase 3 === |
| **Unreferenced Scan-Map Items** shows the number of [[:object:volume|Volumes]] that are present in the [[concepts:scan-map|Scan-Map]] but don't exist within the customers target media. | **Unreferenced Scan-Map Items** shows the number of [[:object:volume|Volumes]] that are present in the [[concepts:scan-map|Scan-Map]] but don't exist within the customers target media. |
| |
| === Phase 4=== | === Phase 4 === |
| |
| **Total Errors** shows the total accumulated errors from the reconciliation process. | **Total Errors** shows the total accumulated errors from the reconciliation process. |
| This report shows statistics on [[:object:volume|Volumes]] that remain in a move status after the reconciliation has completed. | This report shows statistics on [[:object:volume|Volumes]] that remain in a move status after the reconciliation has completed. |
| |
| <sxh plain;> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 4: Movement Aging Report | Report Description: Phase 4: Movement Aging Report |
| 9 or more days 0 0 | 9 or more days 0 0 |
| -------------------- -------- -------- | -------------------- -------- -------- |
| </sxh> | </code> |
| |
| In the example data, these are the [[:object:volume|Volumes]] 000003L5, 000004L6 and 000005L6 which are in a move status (one day) out of the subject [[:object:repository|Repository]] but not yet confirmed into their target [[:object:repository|Repository]]. | In the example data, these are the [[:object:volume|Volumes]] 000003L5, 000004L6 and 000005L6 which are in a move status (one day) out of the subject [[:object:repository|Repository]] but not yet confirmed into their target [[:object:repository|Repository]]. |
| | |
| | {{tag> update_doco}} |
