L TMPV2 table data fixes: Difference between revisions

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}}"
 
mNo edit summary
Line 1: Line 1:
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 ==