Centralized import from Ed.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 20: | Line 20: | ||
* labs | * labs | ||
** split labs into legacy and regular labs; in legacy, name the fields something like CBC_L38 | ** split labs into legacy and regular labs; in legacy, name the fields something like CBC_L38 | ||
* acquired pathogen is not going into centralized properly... (says my note; I think this is about the sent ones, not the imported ones) | * acquired pathogen is not going into centralized properly... (says my note; I think this is about the sent ones, not the imported ones) | ||
| Line 29: | Line 27: | ||
* fixed lab importing | * fixed lab importing | ||
* moved L_aux into centralized db and including in import and linking. | * moved L_aux into centralized db and including in import and linking. | ||
* set the record_Status to complete for all imported | |||
[[Category:2013 data upgrades]] | [[Category:2013 data upgrades]] | ||
Revision as of 16:25, 2013 November 18
The Access file Creating Centralized import from Ed.mdb contains the code needed to import Ed's old data into centralized_data.mdb.
It is stored on x:\ccmdb\Centralized import from Ed
Use
Open Modules, make sure paths in public constants on top are correct, run Public Sub Import().
resolutions for differences between ed's and centralized
serials for early CC data
Early CC records don't have serial numbers. I assigned negative numbers arbitrarily to these to be able to generate D_IDs.
duplicates
turned out there were a few duplicates in ed's where a serial was used twice for the same hospital/location. These were resolved in Ed's data and should not be a problem for the final import.
extra data
Ed's program stores a bunch of extra data such as apache scores and legacy info.
Need to address...
Fixes still needed
- labs
- split labs into legacy and regular labs; in legacy, name the fields something like CBC_L38
- acquired pathogen is not going into centralized properly... (says my note; I think this is about the sent ones, not the imported ones)
ver 2013-11-18
This is not the date it was made, but the date documenting started. after I lost and had to find the file. :-)
- fixed lab importing
- moved L_aux into centralized db and including in import and linking.
- set the record_Status to complete for all imported