L TMPV2 table data fixes: Difference between revisions
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]] | ||