Setup: 02 - Socket to Database

The following instructions will help you set up the second Iguana demo channel (02 – Socket to Database) correctly.

Step One: Set up the files

Before you create the channel, you need to make sure that you have all the files needed.

1. Locate your Iguana install directory.
2. Within the iNTERFACEWARE/Iguana folder, create a new folder and name it ‘Demo‘.
3. Save this SQL database file to the iNTERFACEWARE/Iguana/Demo folder: PatientData.sqlite
4. Download these two project zip files:
   • 02_Socket_to_Database_Filter.zip
   • 02_Socket_to_Database_To_Translator.zip

Step Two: Create the channel

Now you are ready to create the channel itself:

1. From the Iguana Dashboard, click the Add Channel button. The Add Channel dialog appears.
2. Make the following component selections:
   • Source = LLP Listener
   • Destination = To Translator
3. Click the Configure Channel button. The Channel Configuration screen appears, providing you access to the new channel’s settings.
4. In the Channel tab, enter the following information:
   • Channel name = 02-Socket to Database
   • Description = Process only ADT messages and insert patient data into database
5. In the Source tab, enter the following information:
   • Port = 5145
6. In the Filter tab, enable the User Filter checkbox.
7. In the Destination tab, keep the default settings.
8. Click the Add Channel button.

   Warning! Upon creating the channel, you will receive an automatic ‘error’ because you have not yet saved a milestone. Don’t worry, we will fix this when we add the code (see below).

Step Three: Import the code

With the channel set up, now you can import the code:

1. If you are not already in the Channel Configuration screen, click the channel’s name in the Dashboard to open it.
2. In the Filter tab, click the Edit Script hyperlink. Iguana launches the Translator and the following dialog appears:
   
3. Enable the Import project from zip file option.
4. Click the Choose File button.
5. In the dialog that appears, browse and select the Filter project zip file that you downloaded earlier (02_Socket_to_Database_Filter.zip).
6. Click the Import button. Iguana loads the project into the Translator (including the code and module libraries).
7. Save this script’s first milestone.
8. Return to the Dashboard. In the Channel Name column, click 02-Socket to Database to reopen the Channel Configuration screen.
9. In the Destination tab, click the Edit Script hyperlink. Iguana launches the Translator and the following dialog appears:
   
10. Enable the Import project from zip file option.
11. Click the Choose File button.
12. In the dialog that appears, browse and select the Translator project zip file that you downloaded earlier (02_Socket_to_Database_Translator.zip).
13. Click the Import button. Iguana loads the project into the Translator (including the code and module libraries).
14. Save this script’s first milestone.