Instructions for importing a batch of DSM Data: Difference between revisions

JMojica (talk | contribs)
Line 89: Line 89:
# Import the New_Lab_DSM to the DSM database.
# Import the New_Lab_DSM to the DSM database.
Julie is still thinking to re-send those profiles found with no lab data to DSM. Julie will give Pagasa some more list of changed D_IDs to be added to the CFE [[L_Problems_D_ID table]].
Julie is still thinking to re-send those profiles found with no lab data to DSM. Julie will give Pagasa some more list of changed D_IDs to be added to the CFE [[L_Problems_D_ID table]].
=== Re-do the importing: Sept 8-14, 2022 ===
*Tina updated the import program because matches are not completely done.  It was agreed to re-do the importing from Allun's DSM dumped files using the new import program in ACCESS.
*Pagasa  did the following steps:
# First, remove from the L_DSM_Data all data imported after Oct 2020.
# Using the new import program, upload the DSM data one batch at a time starting batch Dec 3, 2020 to batch Aug 31, 2022.


== Known issues ==
== Known issues ==