MustModify Blog: Recent Posts

Things I miss about Ruby when working in C#

April 09, 2013
h2. Preface: nil for those of you who don't know, nil is like NULL, but way cooler. But if you don't know, just pretend it means NULL, but if you ask whether NULL is true or false, it will say, "Oh, yeah, I'm false." Yes, I know, if you haven't heard of nil this makes you think I'm on crack. Roll with me. h2. Returning a value or "Sorry,...


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...