1 00:00:00,000 --> 00:00:05,333 Using RxMix to Retrieve NDCs for an Ingredient. 2 00:00:05,333 --> 00:00:07,899 Batch Mode. 3 00:00:07,900 --> 00:00:09,900 The RxMix application allows combining 4 00:00:09,900 --> 00:00:15,266 functional calls and the appropriate parameters of the RxNorm API and related drug 5 00:00:15,266 --> 00:00:19,499 information APIs to retrieve complex information through a simple interface. 6 00:00:19,500 --> 00:00:22,566 In our tutorial describing RxMix’s interactive mode, 7 00:00:22,566 --> 00:00:25,966 we have shown you how to build a workflow that retrieves 8 00:00:25,966 --> 00:00:29,499 National Drug Code IDs (NDCs) for an ingredient. 9 00:00:29,500 --> 00:00:34,433 In this tutorial we will see how to run the same workflow in the batch mode. 10 00:00:34,433 --> 00:00:37,033 Our workflow consists of 3 functions. 11 00:00:37,033 --> 00:00:41,599 First, the function ‘findRxcuiByString’ takes the search term as an input, 12 00:00:41,600 --> 00:00:47,000 and returns RxNorm concept identifiers, or RxCUIs, matching the input. 13 00:00:47,000 --> 00:00:49,266 The second function, “getRelatedByType”, 14 00:00:49,266 --> 00:00:51,899 accepts RxCUIs from the above step and 15 00:00:51,900 --> 00:00:56,366 retrieves term types, or TTYs, for each of the given RxCUIs. 16 00:00:56,366 --> 00:01:04,266 And finally, the function “getNDCs” retrieves all NDCs for the TTYs returned by the “getRelatedByType” function. 17 00:01:04,266 --> 00:01:07,632 First, prepare a simple text file with the input. 18 00:01:07,633 --> 00:01:10,533 In our example, that will be a text file containing terms, 19 00:01:10,533 --> 00:01:13,766 such as “fluoxetine”, “clozapine” and a few others. 20 00:01:13,766 --> 00:01:16,832 I have prepared such an input file in advance. 21 00:01:16,833 --> 00:01:21,866 Switch to the batch interface by clicking on the Batch tab in the INPUT section. 22 00:01:21,866 --> 00:01:27,132 Click on the “My File” tab and then on the button that says “Click to load an Input File”. 23 00:01:27,133 --> 00:01:29,399 Point to the input file and open it. 24 00:01:29,400 --> 00:01:34,000 Confirm that the input file name is displayed under the file load button to assure 25 00:01:34,000 --> 00:01:36,400 the file loaded successfully. 26 00:01:36,400 --> 00:01:40,033 Now type in the e-mail address where you would like to receive the message about 27 00:01:40,033 --> 00:01:45,433 completion of your batch run, select the desired output format (for example “TEXT”)and 28 00:01:45,433 --> 00:01:48,399 click the “Submit Batch” button to run the workflow. 29 00:01:48,400 --> 00:01:52,600 A confirmation about successful submission of the batch will display on the screen. 30 00:01:52,600 --> 00:01:55,800 The confirmation message will also contain the Job ID. 31 00:01:55,800 --> 00:01:58,666 Click OK and wait for an e-mail message. 32 00:01:58,666 --> 00:02:00,299 Once the batch job is complete, 33 00:02:00,300 --> 00:02:03,633 you will receive a message that contains a link to your results. 34 00:02:03,633 --> 00:02:05,466 Click on that link. 35 00:02:05,466 --> 00:02:08,799 This will download a compressed TAR file with the results. 36 00:02:08,800 --> 00:02:14,133 Extract the files contained in the compressed file and save them to your local drive. 37 00:02:14,133 --> 00:02:15,533 There will be four files: 38 00:02:15,533 --> 00:02:18,866 file with extension .info with the job ID, 39 00:02:18,866 --> 00:02:21,899 file with extension .input with your input, 40 00:02:21,900 --> 00:02:24,866 file .config with the encoded workflow, 41 00:02:24,866 --> 00:02:29,599 and the output file in the format you have chosen before submitting the batch job. 42 00:02:29,600 --> 00:02:33,500 In our case that would be the file with extension .text. 43 00:02:33,500 --> 00:02:39,233 By the way, the .config file can be used later if you wanted to run the same workflow again. 44 00:02:39,233 --> 00:02:41,199 You would just need to open that file using the 45 00:02:41,200 --> 00:02:46,900 “From my workflows” button in the LOAD section of the interface like I mentioned earlier. 46 00:02:46,900 --> 00:02:51,700 The text output file contains the final result, in our case the list of NDCs, 47 00:02:51,700 --> 00:02:53,700 and detailed information about the specific 48 00:02:53,700 --> 00:02:57,733 functions used to arrive at the particular final result. 49 00:02:57,733 --> 00:03:00,799 In our example, the results are presented in the following way. 50 00:03:00,800 --> 00:03:08,500 First, the function “findRxcuiByString” matched the input term “fluoxetine” to RxCUI 4493. 51 00:03:08,500 --> 00:03:13,166 The subsequent function “getRelatedByType” used RxCUI 4493 52 00:03:13,166 --> 00:03:19,766 as an input to retrieve RxCUI 104849 for the related drug product. 53 00:03:19,766 --> 00:03:24,466 Finally, “getNDCs” function with the input string “104849” 54 00:03:24,466 --> 00:03:29,966 produced NDC 54868051102. 55 00:03:29,966 --> 00:03:32,432 This completes our tutorial. 56 00:03:32,433 --> 00:03:38,066 New users can review the RxMix Tutorial by following the link at the lower right corner of the page. 57 00:03:38,066 --> 00:03:44,266 Use the Contact Us link at the bottom of the RxMix page to submit your questions or comments. 58 00:03:44,266 --> 00:03:52,166 Thank you for watching!