L TMPV2 table data fixes: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Several data points went wrong on import. This article lists them and their fixes. == Dates imported as 1899 == == Dates backward == TMP dates imported backwards {{Bug}}" |
Ttenbergen (talk | contribs) m u |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
will be addressed by [[Re-import of TmpV2 data from Julie's Export 2014-09-08]] | |||
{{fixed bug}} | |||
---- | |||
Several data points went wrong on import. This article lists them and their fixes. | Several data points went wrong on import. This article lists them and their fixes. | ||
== No Transfer Date without items == | |||
There are entries for No Transfer Date without items... need to look into... | |||
== Diffs == | |||
=== in cent not in mdb === | |||
query ''2_tmp_in_cent_not_mdb'' | |||
D_Tmp_ID | |||
HSC_H4H-3856-8707 | |||
STB_E5-11012-8038 | |||
Appear to exist in centralized but not in tmp.mdb | |||
=== in mdb not in cent === | |||
query ''2_tmp_in_mdb_not_cent'' | |||
yikes 9050 of them! | |||
== missing postal codes == | |||
[[Postal code collection]] | |||
54 admitted since start are missing pcs in .mdb, and 390 are missing them in cent. | |||
* email to Trish and Pagasa Ttenbergen 11:33, 2014 July 4 (CDT) | |||
== Dates imported as 1899 == | == Dates imported as 1899 == | ||
| Line 5: | Line 31: | ||
== Dates backward == | == Dates backward == | ||
[[TMP dates imported backwards]] | [[TMP dates imported backwards]] | ||
Latest revision as of 09:24, 8 September 2014
will be addressed by Re-import of TmpV2 data from Julie's Export 2014-09-08
Several data points went wrong on import. This article lists them and their fixes.
No Transfer Date without items
There are entries for No Transfer Date without items... need to look into...
Diffs
in cent not in mdb
query 2_tmp_in_cent_not_mdb D_Tmp_ID HSC_H4H-3856-8707 STB_E5-11012-8038
Appear to exist in centralized but not in tmp.mdb
in mdb not in cent
query 2_tmp_in_mdb_not_cent yikes 9050 of them!
missing postal codes
Postal code collection 54 admitted since start are missing pcs in .mdb, and 390 are missing them in cent.
- email to Trish and Pagasa Ttenbergen 11:33, 2014 July 4 (CDT)