Re-import of TmpV2 data from Julie's Export 2014-09-08: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (u) |
Ttenbergen (talk | contribs) m (updt) |
||
| Line 10: | Line 10: | ||
#* deleted the 120274 records in that query | #* deleted the 120274 records in that query | ||
# converted Julie's .xlsx file to something Access 2003 can read: .csv | # converted Julie's .xlsx file to something Access 2003 can read: .csv | ||
#* confirmed 259802 lines one less record in both | #* confirmed 259802 lines (one less record in both) | ||
# imported into table | # imported into table | ||
#* | #* needed to accommodate very long comments with commas, this was a pain, next time would do in Access 2010... | ||
# checked for orphans where there is data in tmp and none in L_Log, found some and emailed Pagasa and Julie Ttenbergen 14:44, 2014 September 5 (CDT) | |||
[[Category:All Projects]] | [[Category:All Projects]] | ||
Revision as of 14:44, 2014 September 5
Original import of TmpV2 went wrong. Julie provided a new export 2014-09-04.
Files are in X:\CCMDB\TmpV2_final
steps
- copied backup of centralized_data.mdb to files as centralized_data_pre_tmpv2_import.mdb
- copied centralized_data.mdb to desktop
- ran
- SELECT L_TmpV2.D_ID FROM L_Log INNER JOIN L_TmpV2 ON L_Log.D_ID = L_TmpV2.D_ID WHERE (((L_Log.RecordStatus)<>"incomplete"));
- deleted the 120274 records in that query
- converted Julie's .xlsx file to something Access 2003 can read: .csv
- confirmed 259802 lines (one less record in both)
- imported into table
- needed to accommodate very long comments with commas, this was a pain, next time would do in Access 2010...
- checked for orphans where there is data in tmp and none in L_Log, found some and emailed Pagasa and Julie Ttenbergen 14:44, 2014 September 5 (CDT)