WB01337_.gif (904 bytes)RXPert Contents

4Q96 Pages 3 & 4

title_95.gif (5787 bytes)

SPECIAL FALL EDITION 15th Edition Written and Edited by Bruce Clutcher, R.Ph., Senior Consultant, SSG

STEP 1: LOADING THE CONVERSION SOFTWARE TO P.C. HARD DRIVE

  1. Load conversion software onto the hard drive.

    1. Place Install Disk into floppy drive
    2. From Program Manager Select File
    3. From ‘File’ Select RUN
    4. In the Command Line Type a:\setup.exe (if floppy drive is a different letter, then replace ‘a’ with appropriate letter)
    5. ‘ENTER’
    6. The system will prompt you when to place Disk 2 and Disk 3 into the floppy drive.

  2. Copy the file WIZARD.INI to the C:\WINDOWS directory on your hard drive. If the file does not exist copy from ‘A’ Drive to ‘C’ Drive following the steps out lined below. If this file exists, do not overwrite it; instead, edit the file and add the following line at the bottom: methodology=C:\SMS\IM

    1. Program Manager Select Main Icon
    2. From Main Icon File Manager
    3. Double Click the ‘A’ Drive
    4. Select ‘Window’ from the menu bar at the top of File Manager
    5. Select TILE HORIZONTALLY
    6. You should now see 2 Windows open, one for the ‘C’ Drive and one for the ‘A’ Drive
    7. From the ‘A’ Drive click and hold the directory ‘WIZARD.INI’. Drag the directory and drop it on top of ‘WINDOWS’ in C:\Windows. The system should inform you that a copy from ‘A’ Drive to the ‘C’ Drive is in progress.
    8. The ‘WINDOWS.INI’ directory should now be on the ‘C’ Drive in the ‘WINDOWS’ Directory
    9. Close the ‘A’ drive
    10. Close File Manager

STEP 2: CALLING THE DRUG MASTER REPORT

  1. Access RX Manager (RXM)

  2. Select RX Report Initiator (PRI)

    1. REPORT NAME Either PHMPDMU or PHMPDMD, both will need to be done separately
    2. FILE PASSWORD Either N/A
    3. PRINTER OR TERMINAL Either PRINTER
    4. REPORT DESTINATION Either Send to a Non-Active Queue
    5. PURGE AFTER PRINTING Either YES
    6. COPIES Either 1
    7. LATER Either N/A
    8. PRINT PASSWORD Either N/A
    9. RUN-TIME PARAMETERS Either N/A
    10. [OKAY] [EDIT] [CANCEL] Either OKAY
    11. Repeat for other file

  3. Verify that Reports are out on the Queues you have selected.

    * See Screen Print 1

STEP 3: MOVING REPORT FROM THE QUEUE TO C:\SMS\IM

  1. Access RX Manager (RXM)

  2. Select UNITY Report Download (RPT)

    1. QUEUE Queue to which you sent the reports
    2. ENTRY Select either report PHMPDMD or PHMPDMU, both will need to be done separately.
    3. OPTION 2 [DOWNLOAD OF REPORT TO PC (KERMIT)]
    4. NOTE: You have two other options:

      • (Move Report to Mailbox)
      • (Download of Report to ASCII File [Pathworks])

        These options allow you to move the file to a mailbox or to a floppy disk. To move the reports to a floppy disk, you will need Pathworks or use option 1 (move it to the hard drive), then use File Manager to move to a disk (see 1.2.1 of Step 1).

    5. FILE NAME QUALIFIER You can leave the report names as PHMPDMU and PHMPDMD or you can rename them what ever you like (just remember the name).

      * See Screen Print 2

    6. [OKAY] [EDIT] [CANCEL] OKAY
    7. You will see a message "FILENAME.DAT" (FILENAME is the report name you gave in 3.2.5 and .DAT is just the suffix) has been created and is ready to be downloaded", with the word QUIT backlighted.
    8. ‘ENTER’
    9. A menu with direction will display with all the files you could download underneath. The menu is incorrect so ignore the directions.
    10. C-KERMIT Type ‘SEND FILENAME.DAT’
      (FILENAME is the report name you gave in 3.2.5 and .DAT is just the suffix) just as you see it on the screen.

      * See Example 3

    11. Do NOT Repeat for other file yet
    12. To get out of C-KERMIT QUIT

  3. Select ‘Transfer’ from the RUMBA Menu Bar

    1. Select Receive
    2. The menu box ‘Copy File From Host To P.C.’ will pop up
    3. In the box, type one of the report names from 3.2.5; or you can rename the report, giving it any name you wish. If you do rename the report, make it logical; for example, PDMU and PDMD (name should reflex the report you are downloading).
    4. Directory should be C:\RUMBA\RVAX
    5. Select OK
    6. The ‘Kermit File Transfer Status’ box will appear showing the status of the transfer to the P.C. hard drive
    7. The System will not allow you to change directory, so you will have to download to C:\RUMBA\RVAX and then move the files to C:\SMS\IM using File Manager. Do this after you repeat the download for the other file.
    8. From Program Manager Select the Main Icon

      1. From the Main Icon select File Manager
      2. Double Click the ‘C’ Drive
      3. Select ‘Window’ from the menu bar at the top of File Manager
      4. Select ‘TILE HORIZONTALLY’
      5. You should now see 2 Windows open, both for the ‘C’ Drive
      6. From one of the ‘C’ Drives, click and hold one of the Report Files from C:\RUMBA\VAX. Drag the file and drop it on top of the ‘IM’ in C:\SMS\IM. The system should inform you that a copy from ‘C’ Drive to ‘C’ Drive is in progress.
      7. The Report File should now be in the C:\SMS\IM Directory
      8. Do the same for other file
      9. Close one of the ‘C’ Drives
      10. Close File Manager

STEP 4: UPLOADING PDM INFORMATION IN EXCEL SPREAD SHEET

 

 

 

 

  1. Log onto the hospital’s CICS using Rumba. You must be on the GEMFUN01 screen.

  2. From the RUMBA menu bar:
    1. Select Session
    2. Select EHLLAPI Configuration
    3. Place a X in  EHLLAPI SDK
    4. Type a ‘A’ in the SHORT NAME box
    5. Select OK
  1. Start up Excel and open the file RXINV.XLS in directory C:\SMS\IM\

  2. On the DATA ENTRY sheet, click on the button labeled Import RX File. You will see a dialog box where you can specify certain options.
    1. Pt Ed Monograph Field - Used to specify which INVISION user field (if any) you would like to store the Patient Education Monograph field from the Drug Master.
    2. Service Effective Date - You can chose either the default system date (the day after the upload takes place) or specify another future date.
  1. You will then be prompted to enter the name of the input file. Type in one of the Report File names from 3.3.3. You have to run the upload to the SM separately for the DPU Drug Report and the DPD Drug Report. At this point, a macro is executed to import the text input file into the Excel spreadsheet. This may take a few minutes, depending on the size of the file.

  2. Once the file is imported, browse the spreadsheet to make sure the data appears to be in the correct columns. Columns whose headings are shaded dark gray are mandatory fields, so make sure these have values in them. You can get help on a specific field by clicking on a cell in that column and then clicking on the Field Help button. The General Help button provides general information about the upload process. You can also make additions/changes directly to the fields on the spreadsheet before the conversions. You may need to do this to correct inaccurate data or to value a mandatory field.

  3. Do Not run the other Report File yet

STEP 5: UPLOADING PDM INFORMATION TO THE SERVICE MASTER

  1. When the data appears to be OK, click on the button labeled Send to INVISION and the upload will begin. You will see a status box indicating the progress of the upload and the estimated time remaining. At this point, you can swap back over to Rumba and watch the data being entered. If you wish to cancel the upload, click on the Interrupt button at any time. This will stop the upload and keep track of where it left off, so that when you restart later, it knows where to resume loading. To restart the conversion program, click the Send to INVISION button on the spreadsheet.

  2. Upon completion, the status box will indicate the number of errors that were encountered. When an error is encountered, the current record (drug) is not uploaded, and the next record (drug) is processed. If you have encountered errors, switch to the Upload Errors sheet (bottom of excel spreadsheet). The Upload Errors sheet is similar to the DATA ENTRY sheet, which list only those records (drugs) that contained errors. In addition, a column on the left lists the actual line 24 error message that INVISION generates.

  3. You should make any corrections to the data on the Upload Errors sheet. When all errors have been fixed, click on the Send to INVISION button on that sheet. The utility will again try to upload the remaining records (drugs). If the record (drug) is successfully uploaded this time, it will be removed from the error sheet. If there is a new error, the new error message will replace the old one. Since the system only uncovers one error per record (drug) at a time, you may need to repeat these last two steps several times before all of the errors are corrected.

  4. Return to Step 4 and repeat for other Report File.

STEP 6: Service Master Verification

Once the SM is converted, browse the SM for any obvious errors. A NDDF update tape should be run on INVISION, backing up the Interval Begin Date by five years, to ‘QA’ the SM. Just use the "Change" section of the NDDF Update Report to look for any discrepancies and discard the "Add" and "Obsolete" sections.

Pages 1-2

Pages 3-4 Pages 5-6

WB01337_.gif (904 bytes)RXPert Contents