Instructions for importing a batch of DSM Data: Revision history

17 October 2024

• curprev 14:1514:15, 17 October 2024 Ttenbergen talk contribs m 9,422 bytes +300 →Instructions Using SAS

20 September 2024

• curprev 13:1613:16, 20 September 2024 JMojica talk contribs 9,122 bytes +6 →Step 1- done by Julie

27 August 2024

• curprev 14:3914:39, 27 August 2024 JMojica talk contribs 9,116 bytes 0 →Step 1- done by Julie
• curprev 14:3814:38, 27 August 2024 JMojica talk contribs 9,116 bytes 0 →Step 1- done by Julie
• curprev 14:3814:38, 27 August 2024 JMojica talk contribs 9,116 bytes +27 →Step 1- done by Julie

26 August 2024

• curprev 12:1612:16, 26 August 2024 JMojica talk contribs 9,089 bytes +46 →Step 1- done by Julie
• curprev 12:1212:12, 26 August 2024 JMojica talk contribs 9,043 bytes +9 →Instructions Using SAS
• curprev 12:1112:11, 26 August 2024 JMojica talk contribs 9,034 bytes +25 →Step 2 - done by Pagasa
• curprev 12:0912:09, 26 August 2024 JMojica talk contribs 9,009 bytes +339 →Instructions Using SAS
• curprev 11:1811:18, 26 August 2024 JMojica talk contribs 8,670 bytes +1,807 No edit summary

17 May 2023

• curprev 16:4216:42, 17 May 2023 Ttenbergen talk contribs m 6,863 bytes −44 →Instructions

4 November 2022

• curprev 08:3308:33, 4 November 2022 JMojica talk contribs 6,907 bytes +65 →Integrity checks after import
• curprev 08:3108:31, 4 November 2022 JMojica talk contribs 6,842 bytes +453 →Integrity checks after import

19 October 2022

• curprev 09:3909:39, 19 October 2022 Ttenbergen talk contribs m 6,389 bytes +100 →Check for new labs
• curprev 09:3809:38, 19 October 2022 Ttenbergen talk contribs m 6,289 bytes +15 →Check for new labs
• curprev 09:3609:36, 19 October 2022 Ttenbergen talk contribs m 6,274 bytes −59 →Check for new labs
• curprev 09:3609:36, 19 October 2022 Ttenbergen talk contribs m 6,333 bytes −973 →Check for new labs

24 August 2022

• curprev 09:0109:01, 24 August 2022 Ttenbergen talk contribs m 7,306 bytes +132 →Check for new labs

10 August 2022

• curprev 13:4113:41, 10 August 2022 Ttenbergen talk contribs m 7,174 bytes −82 →Check for new labs

9 June 2022

• curprev 08:5708:57, 9 June 2022 PTorres talk contribs 7,256 bytes −120 →Run consistency checks: no more pivots and integrated the filtering into the query

20 April 2022

• curprev 21:1121:11, 20 April 2022 Ttenbergen talk contribs m 7,376 bytes +375 →Check for new labs

9 June 2021

• curprev 12:4312:43, 9 June 2021 Ttenbergen talk contribs m 7,001 bytes +14 →Run consistency checks

26 May 2021

• curprev 15:1815:18, 26 May 2021 PTorres talk contribs 6,987 bytes −15 →Prep
• curprev 15:1715:17, 26 May 2021 PTorres talk contribs 7,002 bytes +23 →Prep
• curprev 15:1615:16, 26 May 2021 PTorres talk contribs 6,979 bytes +36 →Prep

27 January 2021

• curprev 16:4716:47, 27 January 2021 PTorres talk contribs 6,943 bytes +14 →Run consistency checks
• curprev 11:2311:23, 27 January 2021 PTorres talk contribs 6,929 bytes +84 →Check for new labs

10 November 2020

• curprev 10:0310:03, 10 November 2020 Ttenbergen talk contribs m 6,845 bytes −539 links

5 November 2020

• curprev 19:5119:51, 5 November 2020 Ttenbergen talk contribs m 7,384 bytes +559 No edit summary
• curprev 16:2016:20, 5 November 2020 JMojica talk contribs 6,825 bytes +2 →Integrity checks after import
• curprev 15:5215:52, 5 November 2020 JMojica talk contribs 6,823 bytes +200 →Integrity checks after import
• curprev 15:4815:48, 5 November 2020 JMojica talk contribs 6,623 bytes +1,149 →Re-do the DSM matching 29Oct2020
• curprev 15:0915:09, 5 November 2020 JMojica talk contribs 5,474 bytes +107 →Integrity checks after import
• curprev 14:5614:56, 5 November 2020 JMojica talk contribs 5,367 bytes +242 →Integrity checks after import
• curprev 14:4914:49, 5 November 2020 JMojica talk contribs 5,125 bytes +127 →Integrity checks after import
• curprev 14:3514:35, 5 November 2020 JMojica talk contribs 4,998 bytes +211 →queries for which we have no page yet
• curprev 13:4913:49, 5 November 2020 JMojica talk contribs 4,787 bytes +622 →Integrity checks after import

11 August 2020

• curprev 16:3416:34, 11 August 2020 Ttenbergen talk contribs 4,165 bytes +39 →Check for new labs: links to the tables that would need to be updated.

14 May 2020

• curprev 14:0714:07, 14 May 2020 Ttenbergen talk contribs 4,126 bytes +74 →Check for new labs: if a lab is added, update DSM_data#DSM_results_we_store

18 December 2019

• curprev 14:4914:49, 18 December 2019 Ttenbergen talk contribs m 4,052 bytes 0 →Run consistency checks
• curprev 14:4614:46, 18 December 2019 Ttenbergen talk contribs m 4,052 bytes +6 →Run consistency checks
• curprev 13:4713:47, 18 December 2019 Ttenbergen talk contribs m 4,046 bytes +61 →Check for new labs

9 December 2019

• curprev 17:4317:43, 9 December 2019 Ttenbergen talk contribs 3,985 bytes −150 →Prep: no more reconnecting, it's built in now.
• curprev 17:2617:26, 9 December 2019 Ttenbergen talk contribs m 4,135 bytes −116 →Check for new labs: cleaned out old queries
• curprev 16:1616:16, 9 December 2019 Ttenbergen talk contribs m 4,251 bytes −50 No edit summary

24 October 2019

• curprev 15:2415:24, 24 October 2019 PTorres talk contribs 4,301 bytes +22 →Run consistency checks

23 October 2019

• curprev 10:4710:47, 23 October 2019 PTorres talk contribs 4,279 bytes +28 →Run consistency checks

4 July 2019

• curprev 15:1715:17, 4 July 2019 Ttenbergen talk contribs m 4,251 bytes +9 →Check for new labs
• curprev 15:1315:13, 4 July 2019 Ttenbergen talk contribs 4,242 bytes −60 →Instructions: Connector stuff was fixed some time ago.

14 June 2019

• curprev 13:5413:54, 14 June 2019 PTorres talk contribs 4,302 bytes −37 No edit summary
• curprev 13:3713:37, 14 June 2019 PTorres talk contribs 4,339 bytes −47 →Run consistency checks

4 June 2019

• curprev 12:1412:14, 4 June 2019 Ttenbergen talk contribs m 4,386 bytes +98 →Run consistency checks

3 June 2019

• curprev 10:2310:23, 3 June 2019 PTorres talk contribs 4,288 bytes −7 →Run consistency checks
• curprev 10:1810:18, 3 June 2019 PTorres talk contribs 4,295 bytes +448 →Run consistency checks
• curprev 09:5709:57, 3 June 2019 PTorres talk contribs 3,847 bytes +118 →Run consistency checks

29 May 2019

• curprev 12:4112:41, 29 May 2019 PTorres talk contribs 3,729 bytes −79 →Cleanup
• curprev 12:3912:39, 29 May 2019 PTorres talk contribs 3,808 bytes +47 →Cleanup
• curprev 12:2712:27, 29 May 2019 PTorres talk contribs 3,761 bytes +23 →Prep
• curprev 09:4709:47, 29 May 2019 PTorres talk contribs 3,738 bytes 0 →Check for new labs
• curprev 09:4609:46, 29 May 2019 PTorres talk contribs 3,738 bytes +7 →Check for new labs

17 May 2019

• curprev 14:1414:14, 17 May 2019 Ttenbergen talk contribs 3,731 bytes +67 →Cleanup: no sense doing it twice, and I can see why you would want to have all the info in one place.
• curprev 14:1314:13, 17 May 2019 Ttenbergen talk contribs m 3,664 bytes −571 →Log

15 May 2019

• curprev 11:3511:35, 15 May 2019 PTorres talk contribs 4,235 bytes +67 →actual data import

17 April 2019

• curprev 14:3314:33, 17 April 2019 Ttenbergen talk contribs m 4,168 bytes −931 →Integrity checks after import

12 April 2019

• curprev 09:0509:05, 12 April 2019 PTorres talk contribs 5,099 bytes +16 →Log
• curprev 08:2708:27, 12 April 2019 PTorres talk contribs 5,083 bytes +182 →Log

10 April 2019

• curprev 15:2015:20, 10 April 2019 PTorres talk contribs 4,901 bytes +46 →Log
• curprev 15:1415:14, 10 April 2019 PTorres talk contribs 4,855 bytes −1 →Cleanup
• curprev 15:0815:08, 10 April 2019 PTorres talk contribs 4,856 bytes +14 →actual data import
• curprev 11:0611:06, 10 April 2019 PTorres talk contribs 4,842 bytes +38 →Check for new labs
• curprev 11:0511:05, 10 April 2019 PTorres talk contribs 4,804 bytes −386 →Check for new labs
• curprev 11:0411:04, 10 April 2019 PTorres talk contribs 5,190 bytes +331 →Check for new labs
• curprev 10:5610:56, 10 April 2019 Ttenbergen talk contribs m 4,859 bytes +107 →Check for new labs
• curprev 10:4110:41, 10 April 2019 PTorres talk contribs 4,752 bytes +27 →Check for new labs
• curprev 10:2410:24, 10 April 2019 Ttenbergen talk contribs m 4,725 bytes +49 →Instructions

27 March 2019

• curprev 10:3010:30, 27 March 2019 Ttenbergen talk contribs m 4,676 bytes +133 →Cleanup
• curprev 10:2910:29, 27 March 2019 Ttenbergen talk contribs m 4,543 bytes +432 →Cleanup
• curprev 09:4009:40, 27 March 2019 Ttenbergen talk contribs m 4,111 bytes +93 →Log

14 February 2019

• curprev 16:0916:09, 14 February 2019 Ttenbergen talk contribs m 4,018 bytes +197 →Check for new labs
• curprev 14:0714:07, 14 February 2019 Ttenbergen talk contribs m 3,821 bytes +112 →Cleanup
• curprev 14:0114:01, 14 February 2019 Ttenbergen talk contribs m 3,709 bytes +100 →Log
• curprev 13:5913:59, 14 February 2019 Ttenbergen talk contribs m 3,609 bytes +73 →Prep
• curprev 10:1410:14, 14 February 2019 Ttenbergen talk contribs m 3,536 bytes +166 →D_IDs in CFE for which no DSM labs exist
• curprev 10:1110:11, 14 February 2019 Ttenbergen talk contribs m 3,370 bytes −5 →Instructions

17 July 2018

• curprev 08:3808:38, 17 July 2018 Ttenbergen talk contribs m 3,375 bytes +44 No edit summary

18 May 2018

• curprev 10:3410:34, 18 May 2018 Ttenbergen talk contribs m 3,331 bytes +55 →Log
• curprev 10:3310:33, 18 May 2018 Ttenbergen talk contribs m 3,276 bytes +185 →Check for new labs

17 May 2018

• curprev 16:0416:04, 17 May 2018 Ttenbergen talk contribs m 3,091 bytes +138 →Instructions
• curprev 15:4815:48, 17 May 2018 Ttenbergen talk contribs m 2,953 bytes +10 →Prep

9 April 2018

• curprev 16:4816:48, 9 April 2018 Ttenbergen talk contribs m 2,943 bytes 0 →Log
• curprev 16:4716:47, 9 April 2018 Ttenbergen talk contribs m 2,943 bytes −63 No edit summary

12 September 2017

• curprev 16:3116:31, 12 September 2017 Ttenbergen talk contribs m 3,006 bytes +68 →Instructions: header

11 September 2017

• curprev 18:1318:13, 11 September 2017 Ttenbergen talk contribs m 2,938 bytes +851 moved here from task
• curprev 14:1714:17, 11 September 2017 Ttenbergen talk contribs m 2,087 bytes +50 →Instructions: phi not needed during import, and CCMDB not needed any more because it grabs it from c:\ccmdb_program

31 August 2017

• curprev 10:5610:56, 31 August 2017 PTorres talk contribs m 2,037 bytes +174 m

25 August 2017

• curprev 18:3918:39, 25 August 2017 Ttenbergen talk contribs m 1,863 bytes +117 →Instructions: set date range
• curprev 18:1918:19, 25 August 2017 Ttenbergen talk contribs m 1,746 bytes +65 link
• curprev 18:1918:19, 25 August 2017 Ttenbergen talk contribs m 1,681 bytes +16 →need to re-launch program for second import: m

28 April 2017

• curprev 12:2212:22, 28 April 2017 Ttenbergen talk contribs m 1,665 bytes +83 →Instructions: cleanup

3 December 2015

• curprev 10:3410:34, 3 December 2015 Ttenbergen talk contribs m 1,582 bytes −1 m
• curprev 10:3310:33, 3 December 2015 Ttenbergen talk contribs m 1,583 bytes +213 m

1 December 2015

• curprev 11:2311:23, 1 December 2015 Ttenbergen talk contribs m 1,370 bytes −28 m

15 October 2015

• curprev 16:5116:51, 15 October 2015 Ttenbergen talk contribs m 1,398 bytes +45 →Instructions
• curprev 16:5016:50, 15 October 2015 Ttenbergen talk contribs m 1,353 bytes +332 m
• curprev 16:4116:41, 15 October 2015 Ttenbergen talk contribs m 1,021 bytes +309 No edit summary
• curprev 16:3716:37, 15 October 2015 Ttenbergen talk contribs m 712 bytes +442 m
• curprev 16:3216:32, 15 October 2015 Ttenbergen talk contribs m 270 bytes 0 Ttenbergen moved page Importing DSM Data to Instructions for importing a batch of DSM Data without leaving a redirect
• curprev 16:3116:31, 15 October 2015 Ttenbergen talk contribs m 270 bytes +38 No edit summary
• curprev 16:2616:26, 15 October 2015 Ttenbergen talk contribs 232 bytes +232 Created page with "We receive data from DSM that needs to be imported into our main repository. == Instructions == # Open DSM_Labs_Consistency_check.accdb # Click the import DSM .csv butt..."