Code Samples - iNTERFACEWARE Help Center

Listings

Welcome to iNTERFACEWARE’s code repository – a place to find and share official and community-submitted code. Our goal is to provide useful and commonly used interfaces, modules, code snippets, and to encourage the members of our community to learn, share and help each other with their projects.

Add Code

Calclulate age from DOB (date of birth)

Added by iNTERFACEWARE

Code Samples

This function calculates age from DOB, it returns years, months and partial years (i.e., 17, 3, 17.296272).

Call a DB stored procedure

Added by iNTERFACEWARE

Code Samples

Demonstrates the use of conn:execute{} to call a stored procedure.

Create a custom ACK

Added by iNTERFACEWARE

Code Samples

Create a custom ACK by using a script in an LLP Listener component

Create a SQLite database and tables

Added by iNTERFACEWARE

Code Samples

This script automatically creates a SQLite database and then generates the tables specified in a VMD.

DB table Insert with auto-incrementing Id

Added by iNTERFACEWARE

Code Samples

Demonstrates how to use conn:merge{} with a table that has an auto-incrementing Id column.

Dehydrate (serialize) as JSON

Added by iNTERFACEWARE

Code Samples

How to dehydrate (serialize) raw JSON data, this can be useful for storing in a databases

Dehydrate (serialize) as XML

Added by iNTERFACEWARE

Code Samples

How to dehydrate (serialize) raw XML data, this can be useful for storing in a databases

Embed a binary file in an HL7 message

Added by iNTERFACEWARE

Code Samples

How to encode binary files as base 64 text, then embed them as OBX-5 segment repeats

Escape a SQL query string

Added by iNTERFACEWARE

Code Samples

How to correctly escape a SQL query string

Filtering messages

Added by iNTERFACEWARE

Code Samples

How to filter out unwanted HL7 messages (similar principles apply to other message types)

Format a phone number

Added by iNTERFACEWARE

Code Samples

This function formats phone numbers nicely with the area code in brackets.

Format data using repeating fields or segments

Added by iNTERFACEWARE

Code Samples

How to format a report as a single NTE or OBX segment with repeating field or using multiple NTE segments, one for each line of the report

Format HL7 message fields as tab delimited

Added by iNTERFACEWARE

Code Samples

Format specified HL7 message fields in a tab delimited string and push the string to the queue for further processing

Format HL7 without the "|" trailing character

Added by iNTERFACEWARE

Code Samples

How to format an HL7 message without the trailing "|" at the end of each line

How to retry a database connection

Added by iNTERFACEWARE

Code Samples

Retry an ODBC query to a MySQL DB when an error occurs, can be adapted for retrying LLP etc.

Insert data into a database

Added by iNTERFACEWARE

Code Samples

How to insert data from an HL7 message into a database (similar principles apply to other message types)

Mapping messages

Added by iNTERFACEWARE

Code Samples

How to map all or part of an HL7 message (similar principles apply to other message types)

Merge data into a database

Added by iNTERFACEWARE

Code Samples

Basic example of merging data into a SQLite database (code is "plug and play" as the DB will be created if it does not exist)

Normalize X12 delimiters

Added by iNTERFACEWARE

Code Samples

How to normalize X12 delimiters for processing in Iguana scripts, they can be reverted after processing if needed

Ordering Database Inserts

Added by iNTERFACEWARE

Code Samples

How to use transactions and conn:begin{}, conn:execute{} and conn:commit{} to insert data into a database in a specific order.

Code Repository