Send and Receive HL7
In this example we are demonstrating sending HL7 messages from one instance of HL7Spy to another. Look how fast it sends 100,000 messages!
HL7Spy supports sending and receiving HL7 using SSL.
Write Custom Code in C#
Power users can write custom code in C# to do almost anything the .NET framework will allow you to do. In this simple example we are appending the text “-test” to the existing value of MSH-3.
Included in HL7Spy are examples of how to de-identify patient information, generate messages, and other more complex message processing routines.
Select All Messages for a Patient
By right-clicking on an HL7 field you can easy to select all messages for a patient. HL7Spy will query all messages, find those that match, and present an ordered list of messages.
If you want to compare any 2 messages, simply select any 2 messages from the list, then right-click and select the “Compare Messages”.
Getting Statistics on an HL7 Field
One of the most powerful features of HL7Spy is calculating statistics on a particular field. In this example we are loading 100,000 messages and getting the statistics on PV1-2. You will notice that 50,178 with value “O”, and 14,733 with the value “E”.
You can navigate values of a particular type by using the forward and back buttons as shown in the short clip.
You can also right-click on a field type, say “O” and send all messages with PV1-2=”O” to a separate tab.
Load HL7 from zip, xz, 7z, gz
In the example above we are loading 300,000 files from xz, zip, and gzip files. HL7Spy takes care of detecting the file type, decompressing, and loading the files.
Load Messages with FTPS/SFTP
Message can be loaded directly from an FTP server using secure FTPS, or SFTP.
Load Messages From Database
Messages can be loaded from Sql Server, Oracle, Postgres, My Sql and many other databases. HL7Spy will automatically detect which column contains the message data and will load the messages into the message editor. Clicking on a row in the result set will display the associated message in the Message Editor.
Load Messages From Folder
Directories can be loaded recursively and filtering by file extension and file content are also supported.
Load 100K Messages From a File
In this example we are loading 100,000 messages using the “Open File” menu option, then we are opening another 100,000+ messages by dragging and dropping them using Windows File Explorer.