Parsing CSV Files
Verified
Added by iNTERFACEWARE
A project demonstrating how parse CSV files.
Description
A project demonstrating how parse CSV files.
Attachments
Usage Details
1. Create a channel with a To Translator destination
2. Import the attached project zip file to in the Destination Translator
More Information
Added by iNTERFACEWARE
A very simple way to run all your code in protected mode with pcall() and log errors instead of stopping
Added by iNTERFACEWARE
How to prevent escaping of special characters like "&" in an HL7 message
Added by iNTERFACEWARE
How to process a batch of HL7 messages by removing the batch header and splitting it into separate messages.
Added by iNTERFACEWARE
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.
Added by iNTERFACEWARE
Demonstrates the best way to read an empty XML TEXT element, by using the text(' ') function from the xml.lua module
Added by iNTERFACEWARE
Retries a a custom ACK using the retry.lua module
Added by iNTERFACEWARE
This code checks EDI (XML) data for some common errors, you can use this approach for pre-processing messages to clean them up
Added by iNTERFACEWARE
Use smtp.send() to send an email from your Lua code.
Added by iNTERFACEWARE
Demonstrates the best way to set a XML node to a space character, by using setText(' ') from the xml.lua module
Added by iNTERFACEWARE
Simple functions to strip or add leading zeros
Added by iNTERFACEWARE
How to transform part of an HL7 message (similar principles apply to other message types)
Added by iNTERFACEWARE
How to update a database using data from an HL7 message (similar principles apply to other message types)
Added by iNTERFACEWARE
How to handle inserts and updates for a table using an autoincrementing ID
Added by iNTERFACEWARE
How to generate an HL7 message with non-standard delimiters and/or escaping, using serialize.lua
Added by iNTERFACEWARE
Shows the correct way to add and update TEXT (and other) fields, as well as what not to do
Added by iNTERFACEWARE
How to use an external command program to zip up a folder containing multiple files