MustModify Blog: Recent Posts

HL7 via SFTP

February 20, 2013
This page documents the process of creating an HL7 interface between my client's "micro-EMR" and a medical laboratory named "BioReference":bioreference.com BioReference presented me with two interface options: * install software on my windows machine. Their software would dump files into a directory of my choosing. * SFTP Since our...


HL7 Issues Facing Developers

January 24, 2013
h2. Inconsistent use of HL7 Value Types Trying to increase quality control, I set told my import agent not to flag any observations where the value type wasn't what my app would have selected as the value type. The results were surprising. |Field|Quest's Value Type|Quest's Value|LabCorp Value Type|LabCorp...


storing patient history via HL7 / LOINC

January 04, 2013
In addition to storing data about a patient's current visit, my clients want to store a patient history. Thus, I need to store fields like: - history of breast cancer? y/n - history of lung cancer? y/n - history of x cancer? y/n and then: - if yes, any evidence of cancer in the last 5 years? What medicines are you taking? Have you been...


Finding a faster query for USQL

December 17, 2012
"select sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' };" ~ instant select NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI WHERE NOI_ALLOC_DATE = { d '2012-12-05' } GROUP BY NOI.NOI_TRN_NUMBER; ~ instant select TRAN_TYPES.TRN_NAME, NOI_TRN_NUMBER, sum(NOI_AMOUNT) FROM NOI, TRAN_TYPES WHERE NOI_ALLOC_DATE = { d '2012-12-05' } AND...


koding.com advice on being a great consultant

November 29, 2012
http://blog.koding.com/2012/08/freelance-developers-you-are-the-future-dont-mess-it-up/ I thought this post was insightful, if repetitive. I recognized just about all of the issues discussed as things that have been problems for me at some point. * The need for professionalism ** If you're being paid, it isn't a hobby. Act professionally. **...


Misys Tiger via ODBC via C#

November 07, 2012
The code below constitutes my various attempts to connect to Misys Tiger via ODBC using C#. Feel free to skip to the word "WiN" to skip the failures. h3. Warning This code below is not inteded to be production-worthy. I just wanted to see data. Excuse the slop. h2. Questions and Answers Q. How do I create a connection to the various...


research on .NET interface to Creative Solutions

October 28, 2012
I am looking for a way to push payments and invoices to Creative Solutions Accounting version 2012.0.9, Client Bookkeeping Services. In researching this topic, I found that it's basically impossible to research. "net" is already sort of ambiguous. Add "creative solutions" and Google has no idea what I want. With that said, I'm not sure whether...


Finding false negatives / false positives in unit tests

October 08, 2012
I get a lot of confidence from seeing my tests fail, then pass. Recently I wondered whether I shouldn't be codifying that. Just because I saw it fail initially doesn't mean I'm not getting a false positive now. *Caution: this is purely theoretical. It's worth exploring on a blog, but the agile part of me realizes that I rarely have issues...