| |
| reports:reconciliation [2019/07/17 01:19] – [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 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: |
| 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. |
| * **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]]. \\ |
| **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}} |
