The CSV Watcher can watch both local filesystem paths and network file shares using NFS. When a new CSV file is created in the watched folder (or a subfolder) with a file extension that matches a configured pattern, the file is read by the module. The module then parses the content of the file, extracting a configured column number as the message destination (for example, the module may be configured to set the first column to contain the message destination); and extracting another configured column number as the message text (for example, the module may be configured to set the second column to contain the message text). The message destination is then checked to see if it exists as a valid extension number already configured within the BlueSky Messaging System. If it doesn’t, the CSV Watcher may then send a Relay Message through another module in order to handle the message. After a CSV file has been fully parsed and handled, the file can then either be deleted or renamed with a different file extension, depending upon configuration. When used in combination with the FTP Scanner module, the CSV Watcher can also pull CSV files from FTP, FTPS and SFTP servers.

Use cases

Some example uses cases for this module include:

• Receiving output from existing systems which generate CSV reports, and forwarding details from these CSV reports on to another destination. For example, patient reminders may be dispatched as SMS text messages.
• Collecting alarms from a SCADA system to dispatch as messages to handsets and other devices.