New Feature – File In
We are pleased to announce a new feature in the Boomerang Notification Framework. The new featured is called File In and is available from version 1.5.0.
The File In feature will automatically upload any file saved in a folder on a network share. One or more folder locations may be defined in the Boomerang Administration Console.
Uploaded files will be stored in the IN_FILE table. As with all services in the Boomerang framework File In also provide a way to further processing or evaluation after that the file has been uploaded. This is done with the stored procedure sp_On_File_In.
Excel to SQL
If you have worked in an IT department it is more than likely that you have been asked, more than once, to update a database from an Excel spreadsheet.
Business user’s preference to use Excel as their primary tool for creating these files is perfectly understandable; after all it is great tool for quickly adjusting, copying and transforming data. However getting the Excel file into a SQL database and process the data requires many steps and is often a tedious and time consuming prospect.
In this new application scenario we illustrate how you can automate excel imports in a few easy steps using the Boomerang Notification Framework.