Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Same with previous posters, we were looking at migrating a lot of our functionality away from the older style deprecated plugs ins that the HEalthcheck has highlighted to use the Excel Tools functionality but the loss of the Export CDT to Excel smart service now prohibits that activity (if we wanted to use the up to date version of the plug in - bit of a catch 22 situation).
For the CSV to database V3 smart-service, we have also found that the insert scripts from the CSV file for databases that use Schemas are generating incorrectly.
The insert scripts are generated like the below,
insert into [schema.tableName] (column1,colum2) values (value1,value2) -- WRONG
But it should be generated as,
insert into [schema].[tableName] (column1,colum2) values (value1,value2) – CORRECT
Any chance this could be addressed in a future update?