Query TISS Errors duplicate Items: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{LegacyContent
|explanation=Done in [[CCMDB.accdb]] now
|successor=[[query check_CCI_Picklist_duplicates]]
|content= 
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=A [[TISS28]] item exists twice
|DIC_summary=A [[TISS28]] item exists twice
Line 4: Line 9:
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_coding=query ''TISS_Errors_duplicate_Items''
|DIC_coding=query ''TISS_Errors_duplicate_Items''
|DIC_status=implemented
|DIC_status=retired
|DIC_app=TISS28.mdb
|DIC_app=TISS28.accdb
}}
}}
In CCMDB.accdb these will be taken care of by [[Query check CCI Picklist duplicates]].


== Causes and solutions ==
== Causes and solutions ==
If any records are listed, delete the form (see [[#How to resolve and delete a duplicate Tiss form during import]]) and then re-scan.
If any records are listed
{{Discuss | who=Pagasa | question =
* delete items from [[L TISS Item table]]
That link didn't resolve... what is it that is actually done here? }}
** open [[L TISS Item table]]
 
** filter by [[D_ID]]
** sort by Item_Date
** delete all those records that have dates of the duplicated form
* delete record from [[L TISS Form table]]
** same as above...  
* re-scan the duplicated form


Could fix these one by one, but usually it's quickest to just re-scan.
Could fix these one by one, but usually it's quickest to just re-scan.
{{Discuss | who=Pagasa | question =
* is it really true that a re-scan is quicker than [[Deleting a duplicate record from the TISS pre-import file]]? }}


== Log ==
== Log ==
2021-10-07 - deleted as part of [[Change to collect TISS data in CCI Picklist]]
2019-02-11 - updated to check the last 90 days of TISS items rather than all since 2016


== Related articles ==
== Related articles ==
{{Related Articles}}
{{Related Articles}}


[[Category: TISS28 checks]]
}}
[[Category: Data Processing]]
[[Category:Legacy TISS28 check]]
[[Category:TISS28 Scanning Process]]

Latest revision as of 15:14, 2021 October 7

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

Data Integrity Checks
Summary: A TISS28 item exists twice
Related: TISS28
Firmness: hard check
Timing: always
App: TISS28.accdb
Coding: query TISS_Errors_duplicate_Items
Uses L Problem table: not relevant for this app
Status: retired
Implementation Date: not entered
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

In CCMDB.accdb these will be taken care of by Query check CCI Picklist duplicates.

Causes and solutions

If any records are listed

Could fix these one by one, but usually it's quickest to just re-scan.

Log

2021-10-07 - deleted as part of Change to collect TISS data in CCI Picklist 2019-02-11 - updated to check the last 90 days of TISS items rather than all since 2016

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_TISS_Errors_duplicate_Items&oldid=152312"