In this newsletter..
New Online tutorials to check out
- Version V2.9 released - recommended upgrade
- Version V3+ roadmap
- Feedback received
New Online Tutorials
This month we are concentrating on building data transfer tutorials.
Initially we have tackled using 'direct to table' technique, next week we will focus on 'Send to Stored Procedure', followed by how-to examples for building data maintenance tasks, and indeed entire applications with EDT.
The examples assume little or no knowledge of using EDT, so are quite detailed. You can navigate the tutorials using the floating contents panel you will see bottom right of your browser...
How to Validate and Import CSV data to SQL Server table
How to Validate and Import Excel spreadsheet to SQL Server database
How to Validate and Import from MULTIPLE Excel WORKSHEETS to SQL Server
How to validate and Import MULTIPLE Excel WORKBOOKS with a 'Select file' prompt
New release EDT Version 2.9.92
One-click Install or Upgrade
2.9 Install or upgrade program "EDT_Setup.exe" is now available on the lean downloads page:
If upgrading, simply select your existing EDT installation folder using the install wizard.
Alternatively, you can download the EDT zip from the same page and extract files manually as with previous versions.
'Save As.. '
New 'Save As..' button has added to task configuration, and a new Task Location Manager - making it easier to build new tasks based on an existing task.
EDT can now be launched from an email or any other Hyperlink, and specifying the task to initially load.
The task ID can be passed as a URL parameter Task ID can be found on EDT the task configuration More tab)
Open EDT Task XYZ
System Command Line
Similarly you can specify an initial task when launching EDT from a command line:
Extended Parameters & Task Scheduling
We will be adding additional options to allow you to completely automate/schedule a task and be able to specify values for any Task parameters you may have defined.
For international users, with language pack other than UK/US a number of problems were reported. Now resolved.
- Modifications have been made to support ACE/JET driver for loading directly from Excel workbooks - see worked examples.
- When changing the Source connection, then refreshing the Destination object, the incorrect destination object was listed. Now resolved.
- When an EDT drop down lookup was used, and the source only contained one row, no rows were shown. Now resolved.
- When a Task parameter was defined as an SQL lookup, the task Load button required two clicks. Resolved.
The following is a guide to expected versions to spring 2014, order of release is subject to client Fast-Track (purchased) development requests.
- Conversion to Excel Ribbon
- All EDT buttons are moving to a new Ribbon (2007+)
- As a result you gain:
- More data workspace
- Faster operation - as buttons don't have to redisplay
- Irradiate any screen flicker
- Irradiate problems when running multiple copies of EDT on Windows XP as buttons do not display correctly
- Support for SQL Server Schemas (currently auto generated SQL does not cater for SQL Schemas, the SQL has to be modified to insert schema name)
- Support for Oracle
- For data load tasks - Additional command line parameters to support task scheduling / automated operation
We have many requests for this - the ability to create parameterised data query / report task
Further development suggestions :
- Tasks and sub-tasks - the ability to drill down from one from task into another task
- Display task parameter values on main task sheet
- Allow record view switch/toggle - change current row so column names are listed vertically.
If you have development / feature requests - please send them to us for review, requests can be Fast-Tracked on a fixed price basis.
You might like to check out the Feedback page - read comments - and add your comments too ..
We will send out further notification next week as more online tutorials are added...
Meanwhile please do contact us for help and support...
Lean Software Team