Cloud Import/Export Workaround

The Import and Export features have been currently suspended. Our team is working to restore functionality, and we apologize for any inconvenience this may cause you. In the meantime, you can follow these steps to Import and Export certain files into OP:

Note: This change only affects Cloud users.

Import Workaround

Import Only Requirements

Your workstation must have Remote Scan installed on any machine which has a scanner attached to it in order to scan directly into OP.

Import Workaround Step by step

Follow these steps to import documents into OP using Remote Scan:

  1. Print the document.
  2. Navigate to the Manage Documents window:
  • Clinical or Practice Management tab > Document Mgmt button
  • Clinical, Practice Management, or Billing tab > Patient Chart button > Documents
  1. Click the New Document button

Note: If a patient was previously selected, their Document information is displayed in the Document Details panel of the window. You'll receive a confirmation window asking if you want to retain that information. Click None, Details, or All. Any information you choose to retain can be edited, as appropriate, before saving. Clicking Cancel will close the confirmation and take you back to the previous record with no changes made to the current record.

  1. Place the document onto the document scanner.
  2. Click the Page Scanner button. The scanner activates and the Scan Options window is displayed

 Note: The Twain interface must be enabled by selecting the Use radio button in the Twain Use/Hide field below the device icon buttons. 

  1. Click the Scan button.
  2. Repeat these steps with the reverse side of the page, if needed. This is only necessary if your scanner doesn't have a duplex scan option. The image(s) are displayed as thumbnails in the Sketch Panel
  3. Select the Image(s) in the Sketch Panel.
  4. Drag and drop the Page(s) to the Document Panel.

Export Workarounds

837 Export Workaround

  1. In OP, navigate to Admin > Admin Documents.
  2. The Repository window will open.
    • Leave the Correspondent field blank:
    • In the Transaction Type field, choose 837.
    • In the Begin date and End date fields, set the date range for the 837 files you are looking for. Note: This is the date that the claim file batches were created, which is not necessarily the same as the date of service (DOS) or the dates the claims were created.
    • Check the Include reviewed records box.

  1. Click the Search button.
  2. The set of 837 files matching your search criteria will appear. Click the notepad icon on the left side of the file row you want to copy.

  1. A Windows notepad ("Notepad #1") containing the data will appear. Click anywhere in the body of the text of Notepad #1, then click Ctrl-A to copy everything. You'll see the entire file contents become selected:
  2. Now, with everything highlighted, click Ctrl-C to copy the contents.
  3. Open another Notepad instance (Notepad #2) on your computer, e.g by clicking the Windows button and typing NOTEPAD. A blank instance of Notepad will appear.
  4. Click into the Notepad #2 instance so the cursor is located in the body of the blank Notepad.
  5. Now, with your cursor in your new blank Notepad, click Ctrl-V (Paste.) The text you copied over now appears in the new Untitled instance.
  6. File > Save the file. Choose a location on your computer that's easy to find later.
  7. If you want to keep the same naming convention without manually entering the file name:
    • Highlight the file in the Repository window you just copied.
    • Click the Export button.
    • When the Save As dialog box opens, copy the file name.
    • Rename the file you saved earlier by right clicking the file and selecting Rename.
    • Ctrl-V (Paste) the new file name with its proper suffix.

  1. Now you can upload the file directly to your clearinghouse. For example, if you use Instamed, go to Claims > Upload file, set the File Format dropdown to ANSI X12 5010 PROFESSIONAL, then click the Browse button (highlighted) to navigate to the file you saved in step 13, above.

Immunizations Export Workaround

  1. In OP, navigate to Admin > Admin Documents.
  2. The Repository window will open:
    • Select the name of your IIS in Correspondent, or alternatively you may leave the field blank. 
    • In the Transaction type field, choose IMM.
    • In the Begin date and End date fields, set the date range for the immunization batch files you are looking for. Note: This is the date that the imms file batches were created, which may or may not be the same as the date the vaccines were administered.
    • Check the Include reviewed records box. 

  1. Click the Search button. The set of immunization files matching your search criteria will appear.
  2. Now, click the Notepad icon on the left side of the file row you want to copy. An HL7 file will pop up in a Notepad file.
  3. Open a second instance of Notepad on your computer (e.g. by clicking the Windows button and typing NOTEPAD.)
  4. Copy the contents of the first Notepad into the second Notepad. (You can use the Ctrl-A, Ctrl-C, Ctrl-V method described above in 837 Workaround.) You'll see the HL7 data appear in your second Notepad.
  5. Now, prepare to save your file. It's important to keep the same file name that OP assigned for immunization files, so you'll want to capture the file name that OP assigned rather than just naming your file "myimms.txt."
  6. Return to Admin Documents and click the Export button. A Save As popup will appear. Click in the File name field and copy the filename that is present:

  1. Return to your newly created Notepad copy and select File > Save As from the menu bar. 
  2. Navigate to the folder you typically export your batches into. 
  3. Paste (Ctrl-V) the name of the filename you copied and append .hl7
  4.  Set the file type as Any file (*.*) 
    • Ex: OH132424_VXU_20240522040706.hl7
    • File type Any file (*.*)
  5. Upload to the site.
  6. Mark the file in Admin Documents as Reviewed (Revd).

Database Viewer Export Workaround

  1. Open the Database Viewer: Tools > Database Viewer.
  2. Search for and Run the report you want to export.
  3. Click into the bottom box with the report. Click CTRL A to select all, then CTRL C to copy.
  4. Open an Excel file.
  5. Click into the spreadsheet and paste (CTRL V).
  6. Save wherever you would normally save your exported reports.

Other Administrative Documents Export Workarounds

While most clients need these workarounds for outgoing claim (837) and immunization files, you can use this method to extract any other Administrative Documents located in your OP. For example, you might want eligibility validation files ("271"), Instamed portal credit card payment receipts ("PAY"), or daysheet records ("DAYSHEET"). If this is the case, you can use steps similar to the ones outlined in the 837 and Immunization Export sections.. 

Contact OP Support if you have any questions about extracting lesser-used document types out of your Administrative Documents.

Reports Workarounds

DAR: How can I export a spreadsheet from the DAR?

  1. In OP, navigate to the DAR. 
  2. Click the Export XLS button.
  3. In the Save As window:
    • Click the drop-down in the Save as type field and select Delimited files (*.csv).
    • Click Save.

  1. Click the Export XLS button again.
  2. You'll see the CSV file you just saved in the center panel. Right click on the file name and choose Open with > Notepad. Your data will pop up in Notepad:

  1. On your own computer, open an instance of Notepad.  For Windows computers, you can press the Windows button and then type NOTEPAD.
  2. Copy the data to your new instance of Notepad:
    • In the old instance, click anywhere, then Ctrl-A to select all then Ctrl-C to copy it.  
    • Then click anywhere in your new Untitled instance of Notepad, and enter Ctrl-V to paste.

  1. Save your data:
    • From the file bar, select File > Save As.  
    • Set Save as type to All Files.  
    • Enter a file name ending with .CSV:

  1. Finally, navigate to the file you just saved:
    • If you already see a green Excel icon, you can simply double-click to launch the file in Excel (a).  
    • Otherwise, you can right-click on the file and choose Open with, then Excel.  If you don't see Excel listed readily, you can search for it with Choose another app (b).

(a)

(b)

Billing Transaction Reports: How can I export a spreadsheet from Transaction Analysis, Reimbursement Analysis, or Standard Billing Reports?

  1. Navigate to one of the above reports you would like to export.
  2. Click the Export XLS button.
  3. In the Save As window:
    • Click the drop-down in the Save as type field and select Delimited files (*.csv).
    • Click Save.

  1. Click the Export XLS button again.
  2. You'll see the CSV file you just saved in the center panel. Right click on the file name and choose Open with > Notepad.
  3. Follow steps 7-10 outlined in the DAR section above.

RCM Analysis Reports: How can I export the RCM Daily Summaries or Monthly Summaries?

  1. Navigate to one of the above report summaries you would like to export.
  2. Click the Save as CSV button as you normally would.
  3. Enter a filename and click Save.

  1. You'll be taken back to the RCM Report screen. Click the Save CSV button again.
  2. You'll see the CSV file you just saved in the center panel. Right click on the file name and choose Open with > Notepad.
  3. Follow steps 7-10 outlined in the DAR section above.