Wednesday, April 02, 2008

Misys PM Refund List Parser

This Excel spreadsheet takes text from Refund List reports in Misys PM (AIX Version) and generates a nicely formatted check register. You can't see it, because it's hidden behind the "form". After the import of the data, it is revealed. This simply doesn't do one sheet, and "that's all you get". It will allow you to save your results, and come back to a report later and import it, adding to the bottom of this spreadsheet. It "knows" what cell was last used, and jumps to the next available row. One of my co-workers needed this to track Refunds and compare our numbers to the actual bank account balances....this helped keep him sane. I'd show you the source text, except it's full of PHI (Protected Health Information), protected by HIPPA. Well, I've modified a sample of the text that gets pulled in to this spreadsheet so PHI is not revealed. Suffice to say, it's messy, no common delimiters, and unusable unless you intend on simply printing it...really poor.
Read this doc on Scribd: Misys PM Refund List Parser
Import Misys Refund Data This spreadsheet will import Refund reports generated by Misys and populate a checkbook register worksheet. 1. Run your Misys report. 2. Use WsFTP to copy the file to your desktop. 3. Rename the file whatever you like, so long as it is a text file (.txt). 4. Click the button below and watch the MAGIC! Click the Add Data to add Misys generated refund information to the workbook. Add Data

This is sample data.

Read this doc on Scribd: Sample for CheckBookParser
R111 -LIST REFUND (1) DATE 1/11/11 EMERGENCY MEDICINE SPECIALISTS TIME 11:11 USER - rl111 PAGE 1 REFUND BATCH PAT CHECK DATE AGE IN REFUND STATUS SEND TO SEND TO SEND TO DOCTOR W # # # # ENTERED DAYS AMOUNT CODE CODE # NAME # W ================================================================================== ================================================== 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 F1111111 1111111 FTW1111 1111111 F1111111 1111111 FTW1111 1111111 F1111111 1111111 F1111111 1111111 FTW1111 1111111 1111111 1111111 F1111111 1111111 M1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 FTW1111 1111111 111 F1111111 1111 WASHBURNE DEAN 111 F1111111 1111 APPLE JUDITH 111 F1111111 1111 GAMP 111 F1111111 1111 MIKEY CAROL 111 FTW1111 1111 WTF111111 111 F1111111 1111 SWAVE GRACE 111 FTW1111 1111 ERMED1111 111 F1111111 1111 MIKEY JAMES 111 F1111111 1111 SMITH LUCILLE 111 FTW1111 1111 WTF1111 111 F1111111 1111 GAMP 111 F1111111 1111 JOHNSON ESTHER 111 M1111111 1111 JOHNSON AMPORN 111 F1111111 1111 BAPTISTA MARIPER 111 F1111111 1111 BARELOTTA URBAN 111 F1111111 1111 PABST INSURANCE 111 F1111111 1111 CITY OF MILWAUKEE 111 F1111111 1111 SISSORHANDS EDWARD 111 F1111111 1111 LANGENFELD CORRINE 111 F1111111 1111 MEDICAID INDEPENDENT C 111 FTW1111 1111 ARP11111 111 F1111111 1111 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 1 1/11/11 M M M M M M M M M M M M M M M M M M M M M 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 1.11 1.11 111.11 11.11 11.11 11.11 11.11 11.11 11.11 111.11 11.11 11.11 11.11 11.11 11.11 11.11 111.11 11.11 11.11 11.11 11.11 11.11 UPDATED PAT UPDATED PAT UPDATED INS UPDATED PAT UPDATED GUAR UPDATED PAT UPDATED GUAR UPDATED PAT UPDATED PAT UPDATED GUAR UPDATED INS VOID PAT UPDATED PAT UPDATED PAT UPDATED PAT UPDATED INS UPDATED INS UPDATED PAT UPDATED PAT UPDATED INS UPDATED GUAR UPDATED INS 1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 1111111 1111111 1111111 1111111 FTW1111 1111111 FTW1111 1111111 1111111 1111111 1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 1111111 1111111 1111111 1111111 F1111111 1111111 FIRST HEALTH BENEFITS 111 F1111111 1111 CORANADO MARLENE 111 F1111111 1111 DOOME MARILYN 111 F1111111 1111 MCFI-FISCAL AGENT 111 F1111111 1111 MEDICARE 111 F1111111 1111 FUSEME MARY 111 F1111111 1111 MCFI-FISCAL AGENT 111 F1111111 1111 FLATFOOT ELIZABE 111 F1111111 1111 HAFERHOGER RAVEN 111 F1111111 1111 HARLEY JACQUEL 111 F1111111 1111 DAVIDSON PERRY 111 F1111111 1111 HUMANA 111 F1111111 1111 MOORE MICHAEL 111 F1111111 1111 GODFREE GILBERT 111 F1111111 1111 THESAINT JOSEPH 111 F1111111 1111 HOOPER WENCESL 111 F1111111 1111 HUMANA 111 F1111111 1111 COMPCAREBLUE 111 F1111111 1111 COMPCAREBLUE 111 FTW1111 1111 INCHARGE 111 FTW1111 1111 INCHARGE 111 F1111111 1111 MEDICAID INDEPENDENT C 111 F1111111 1111 MEDICAID ABRI HEALTH P 111 F1111111 1111 THURMAN UZMA 111 F1111111 1111 GOOSGOT GRONA 111 F1111111 1111 THEBAPTIST JOHN 111 M1111111 1111 GAMP 111 M1111111 1111 GAMP 111 F1111111 1111 MOORE MICHAEL 111 F1111111 1111 1 1/11/11 11 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 1 1/11/11 11 1/11/11 1 1/11/11 11 1/11/11 1 1/11/11 11 1/11/11 11 1/11/11 11 1/11/11 11 1/11/11 M M M M M M M M M M M M M M M M M M M M M M M M M M M M M 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11.11 11.11 11.11 111.11 11.11 11.11 11.11 111.11 111.11 111.11 11.11 11.11 11.11 111.11 111.11 111.11 111.11 111.11 11.11 11.11 11.11 111.11 11.11 11.11 11.11 11.11 11.11 11.11 11.11 VOID PAT UPDATED PAT UPDATED PAT UPDATED INS UPDATED PAT UPDATED GUAR UPDATED PAT UPDATED PAT UPDATED PAT UPDATED PAT UPDATED INS VOID PAT UPDATED PAT UPDATED PAT UPDATED PAT UPDATED INS UPDATED INS UPDATED INS UPDATED GUAR UPDATED GUAR UPDATED INS UPDATED INS UPDATED GUAR UPDATED PAT UPDATED PAT UPDATED INS UPDATED INS VOID VOID PAT PAT F1111111 MYAUNT ESTHER R111 -LIST REFUND (1) DATE 1/11/11 EMERGENCY MEDICINE SPECIALISTS TIME 11:11 USER - rl111 PAGE 1 1 M REFUND BATCH PAT CHECK DATE AGE IN REFUND STATUS SEND TO SEND TO SEND TO DOCTOR W # # # # ENTERED DAYS AMOUNT CODE CODE # NAME # W ================================================================================== ================================================== 1111111 F1111111 1111111 F1111111 1111111 F1111111 1111111 F1111111 111 F1111111 DETRICH 111 F1111111 MOORE 111 F1111111 MYAUNT 111 F1111111 DETRICH 1111 MARLENE 1111 MICHAEL 1111 ESTHER 1111 MARLENE 1/11/11 11 1/11/11 11 1/11/11 1 1/11/11 11 M M M M 11 11 11 11 11.11 11.11 11.11 11.11 VOID PAT UPDATED PAT UPDATED PAT UPDATED PAT ================================================================================== ================================================== # OF REFUNDS 11 SUB TOTAL $ 1,111.11 ================================================================================== ================================================== ********************************************************************************** ************************************************** TOTAL REFUNDS 11 GRAND TOTAL $ 1,111.11 ********************************************************************************** ************************************************** 1111D *pts/11*FTW *LIST REFUND (1) * 111* 1/11/11*11.11 ******************************************************************************** Start Stop 1) Date entered 111111 111111 1) Send to type A ALL ALL 1) Refund # 111111111+ 111111111+ 1) Batch # 1111+ 1111+ 1) Dr# 1111+ 1111+ 1) Patient # ZZZZZZZZZZ 1) Status * 1) Report order 1 Refund 1) Print address/claim #? N ************************************ * Where Written Legend * * -------------------* * A - AGED ACCT RECEIVABLE REPORT * * C - CONV TO NEW REFUND MODULE * * M - MANUAL PRINT CHECK UTILITY * * S - SPLIT REFUND UTILITY * ************************************

No comments: