This code is a template for X12 parsing

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

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

A very simple way to run all your code in protected mode with pcall() and log errors instead of stopping

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

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

Shows the correct way to add and update TEXT (and other) fields, as well as what not to do

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

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

How to correctly escape a SQL query string

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

This code checks EDI (XML) data for some common errors, you can use this approach for pre-processing messages to clean them up

How to handle inserts and updates for a table using an autoincrementing ID

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

How to use an external command program to zip up a folder containing multiple files

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

Retries a a custom ACK using the retry.lua module

How to generate an HL7 message with non-standard delimiters and/or escaping, using serialize.lua

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

Query a database to identify patient in incoming HL7 messages. If a patient is not found return an ACK with a "Patient does not exist" message.