-->
    Register   |  Login
    Search

    ★ EDT 3.2 released - including new Print options and 3.1 problem fixes

    by Lean Software on Wednesday, September 03, 2014 9:44 PM

    Greetings from Lean Software.

    Newsletter highlights :

    • EDT Version 3.2 released - with new Task Print options
    • Developer days can now be purchased online - services you can use by the hour.

    In this Newsletter:

    • Welcome to new clients and interesting projects
    • EDT 3.2 new features
    • EDT 3.1 problem fixes
    • EDT 3.3 development plan
    • Upgrading your license - Upgrade Calculator
    • Dedicated Analysis/Developer days - services by the hour
    • EDT 3.2 Download and Upgrade advice

    Welcome to new clients and projects

    Welcome to new clients Invesco(US) and BCA(US).

    We will be helping BCA to deliver a distributed EDT project - involving remote internet data access.

    If you would like to know how to securely connect EDT to remote (web server) data - you might like to check out this online lean workshop:

    How to connect and work with Remote Web Server Data

    EDT 3.2 new features

    • New print options including any number/combination of headers and footers, plus image/logo positioning:



    • Task sub-folders can now be created within the application folder - EDT will automatically search sub-folders and display in the task explorer tree.
    • Additional prompts - confirm on task save, confirm on exit EDT
    • Check file Write permissions before task save
    • Print icon added to 'Excel Tools' ribbon Print icon added to File menu

    EDT 3.1 problem fixes

    • Long text within wrapped cells would not be vertically justified
    • The 'Update' SQL setting was resetting back to checked on task edit
    • Ribbon was not always expanded - ribbon is now always forced expanded on application load
    • Changing the destination schema would not re-load SQL for the selected object correctly
    • Sometimes Excel would crash on EDT exit
    • Total Row count was out by 1 for Report tasks
    • Licence problems where local date format was not dd/mm/yyyy or mm/dd/yyyy
    • Column details would refresh twice when changing destination table or procedure

    EDT 3.3 development plan 

    EDT 3.3 will include application command line parameters - allowing you to schedule a suitable EDT task - such as data import.

    The parameters will include an alert email address - creating an email on any failure, complete with hyperlink to load and correct any task problems.

    We will also publish a help page showing you how to create a hyperlink to an EDT task to allow integration with a number systems.   Task parameters can be passed within the hyperlink or command line.

     

    Upgrading your license - Upgrade Calculator

    The new V3 Report type tasks present a strong business case to obtain more value and efficiency savings by deploying EDT on a network share and providing access to many users.

    There is a Upgrade calculator - available for download : http://leansoftware.net/software/edt_upgrade_calculation.xls

    The calculator will be replaced by an online page in due course.

    Please contact Office@LeanSoftware.net to arrange your license upgrade.

     Dedicated Analysis / Developer days

     Lean software additionally provide dedicated services to your company:

    • System Analysis and EDT task design
    • EDT Task development
    • SQL Server development
    • C# .NET Development
    • Office VBA Development
    • Office(VBA) development
    • P4W - Partner for Windows Development (Legal Case Management software)
    • DNN (Dot Net Nuke CMS) Development

    We run a simple system whereby Lean Software team members log any time spent in the above categories against Private Help Desk project entries for your company.

    In this way you only pay per hour for our services, as and when they are needed.

    When any team member adds a time spent entry - a short description of the activity is added, and you will receive an email as soon as the activity is logged.

    Please see the online page :

    Purchase Analysis / Developer days

    EDT 3.2 Download & Upgrade advice

    Download now available from the downloads page:

    V3.2 Professional Edition - Production release

    Upgrade procedure:
    1.    Backup your EDT V2 task files and backup your EDT application folder.
    2.    Download V3 from the downloads page : you can use either the Setup program - choosing to install to your existing EDT application folder, or download the EDT zip and extract all files to your EDT application folder.
    3.    Run EDT_32.exe for Excel 32 bit, or EDT_64.exe if you have the 64 bit version of MS Office.
    4.    The upgrade is now complete 

     

    Help..?

    Please do contact us for help and advice - either via the HelpDesk or directly - Support@LeanSoftware.net

     

    Wishing you a superb day.

    Lean Software team

    http://LeanSoftware.net

     

     

    EDT V3 - Production Version - Upgrade Advice, Special Merge Codes, Remote Data

    by Lean Software on Wednesday, August 06, 2014 3:37 PM

    Greetings from Lean Software.

    In this Newsletter:

    • V3 Production Release
    • How to Upgrade to EDT V3
    • Getting Started with EDT V3
    • New Special Merge codes
    • Remote Web Server data Tasks?

    V3 now in Production

    Companies are now successfully upgrading to EDT V3 - the Production ready release EDT V3.1.50 is now available to download via this link:

    http://leansoftware.net/forum/en-us/productsdownloads/exceldatabasetasks(edt)/download.aspx

    How to Upgrade to EDT V3

    Please note :

    • Tasks you have created in EDT Version 2 tasks will operate as expected in Version 3, without any modification.
    • When you edit a version 2 task in version 3 however, the task will be upgraded, the upgraded task file can then not be run in EDT version 2.
    • The Excel 2003 version of EDT V3 is planned for release on Wednesday 13th August.  Currently V3 supports Excel 2007, 2010 and 2013.

    Upgrade procedure:

    1. Backup your EDT V2 task files and backup your EDT V2 application folder.
    2. Download V3 from the downloads page : you can use either the Setup program - choosing to install to your existing EDT application folder, or download the EDT zip and extract all files to your EDT application folder.
    3. Run EDT_32.exe for Excel 32 bit, or EDT_64.exe if you have the 64 bit version of MS Office.
    4. The upgrade is now complete

    Getting Started with EDT V3

    When running V3 you will see your tasks are now displayed in the new Task Explorer - far left of the Excel ribbon.

    Note that V3 will also show any tasks within sub-folders as a separate branch - just like Windows Explorer.  This allows you organise tasks into logical groups and sub-groups.  Creating a new group is as simple as creating a sub folder, then placing the relevant tasks into the sub folder. The EDT task explorer will build a tree view for you automatically.

    As a task designer click the ribbon Login option (default password is 'lean'), you will then see the Modify task and New task options.

    Within Task maintenance you will see the new blue help icons - hover over the icons for explanations and design tips.

    One the great new features of V3 is the new 'Report' task method, offering an easy way to build fast, network ready, parameterised reports. 

    You may notice when loading data that V3 is considerably faster than V2 - as a result of us developing new data validation technology.

    New Special Merge codes

    Additional Special merge codes have been added to EDT.

    Merge codes are inserted into SQL code wherever you see the Insert merge code button:

    Insert Merge Code Screenshot

     

     

    The following new codes have been added to the 'Special merge code' section:

    {XL-merge:EDT_Mode} Evaluates to 'VALIDATE' or 'SEND', depending on the EDT operation
    '{XL-merge:EDT_NTUserName}' The user's NT logon name
    '{XL-merge:EDT_NTDomain}' The current Domain name, or computer name if not within a domain
    '{XL-merge:EDT_ComputerName}' PC computer name
    '{XL-merge:EDT_WorkStationID}' A string containing hardware serial numbers
    '{XL-merge:EDT_LicenceKey}' Your companies EDT license Key
    '{XL-merge:EDT_LocalIPAddress}' The workstations Local IP address
    '{XL-merge:EDT_ExternalIPAddress}' The external IP address as assigned by the Internet Service Provider (ISP)


    The new merge codes are particular useful when working with remote data or when we need to identify the EDT user.

    Remote Web Server data Tasks

    Version 3 contains modifications to support Remote data tasks, that is tasks that load or edit data on a Remote Web server.

    We are building a detailed help tutorial page to show you how this can now be quite easily achieved with a web server running MS SQL Server.

    There are some important security aspects to get right - we will explain this in detail in the step by step tutorial, to be released this Friday 8th August.

     Help is at hand

    If you have any questions or need help  - please do not hesitate to contact us, either directly by email Support@LeanSoftware.net or via the lean Help Desk, or via phone for M10 and above license holders.

    We can offer remote screen sharing assistance via Skype or MS Team Viewer, or your chosen screen sharing software.

     

    Wishing you a superb day.

     

    Regards

    Lean Software Team

    http://LeanSoftware.net

     

    Celebration Time

    by Lean Software on Thursday, July 31, 2014 2:47 PM

    Lean News 

      Celebration time for everyone  ! 

       

    EDT V3.1 Professional Edition Production release candidate is now available on the downloads page:

    http://leansoftware.net/en-us/productsdownloads/exceldatabasetasks(edt)/download

     

    In this newsletter:

    • Production release candidate 3.1
    • To celebrate all Trials have been Extended
    • New Licence Keys
    • Domain licences - new Automatic Workstation Registration
    • Excel 2003 support
    • Beta test roundup details

    Production Release candidate 3.1

    We are delighted to inform you EDT V3 is now out of beta and available for download.

    Particular thanks to companies who have helped us with beta testing these past two weeks.

    To celebrate - Trials have been Extended

    If you have previously registered with Lean Software and not yet purchased an EDT licence then you will find your trial period has been extended to Wednesday 6th August.

    Simply download the V3 release - and you will be up and running and get the chance to check out an incredibly superior product - EDT V3.

    Licence Keys  

    Each EDT licence now has an associated key - you can view your licence key on the My Licences lean web page.

    Your licence key can be used to register new workstations - as an alternative to using your registration email address.

    Domain licences - Automatic Workstation Registration

    For companies holding an EDT Domain Licence (Unlimited EDT Usage within a corporate domain), a new Auto-Registration feature has been added to the MyLciences page:

    As you can see in the screen shot below, you can enable auto-registration and specify the related domain name.   Please contact us if you wish to use the software in multiple domains.

    When the EDT program is run from a network installation for the first time the user will no longer be promoted for an email address or licence key, the software will simply run.

    This considerably reduces the maintenance for domain licence holders.

    Excel 2003 Support

    V3 currently supports Excel 2007, Excel 2010 and Excel 2013.   Support for Excel 2003 will be added in the next 2 weeks.

    Beta Roundup

    For a list of beta issues resolved - please visit the downloads page:

    http://leansoftware.net/en-us/productsdownloads/exceldatabasetasks(edt)/download

    Enquirers
    We hope you join us to celebrate - EDT V3 delivers many business advantages, download today or contact us today today to start to bring user efficiency and very significant development cost savings to your company.

     

    Regards

    Lean Software team

    http://LeanSoftware.net

    EDT - V3 Reporting and Beta Roundup

    by Lean Software on Tuesday, July 15, 2014 10:24 AM

    Greetings from Lean Software, 

    Many thanks indeed for the beta problem reports so far - please if possible could the problems be logged via the HelpDesk.

    In this newletter:

    • V3 Secure and very fast Excel Network Reporting
    • V3 Reporting performance
    • Latest V3 Beta release notes

    Secure and very fast Excel Network Reporting


    EDT V3 brings some very exciting opportunities for companies for fast data processing - but how about reporting?

    The reporting capability of V3 is something of a World first - the first truly secure and fast Excel reporting solution.

    Typically Excel is not chosen as an enterprise reporting tool - for these reasons:

    • Excel files are not secure - they can be broken into and the SQL modified.
    • Excel files are version sensitive - different versions may be emailed around the organisation without control.

    How does EDT overcome these problems?

    • EDT does not create any Excel files at all, it just uses Excel an 'Engine' to generate the report.
    • As no Excel files are ever created, the security issue has been solved.
    • EDT manages Task files or Reports on a shared network resource, typically this would be read-only to a task user, thus preventing multi-version problems.

    Reporting Speed

    In our tests a 40,000 row report will load in EDT in 2 seconds.

    What more can we say!

    Compared to an Intranet reporting tool - EDT will always win on performance - there is no browser generating lots of HTML, there is no intranet server to cause a bottleneck.

    For your interest in our next email we will provide a demo video for you showing you how to easily create a parameterised report with pre-grouping and user-sort functionality.

     

    V2 Beta roundup

    The following problems have been resolved and the latest beta (V3.0.889b) is now available on the downloads page.

    V3.0.898b  15-07-2014  Not loading SQL Source details correctly after save then modify (affected 889b only).  When using the Spell check tool, the worksheet was left unlocked.

    V3.0.889b  14-07-2014  Split bar betwen Report columns and Report total was not functioning. Possible error message relating to 'ArangeSQLControls'.

    V3.0.832b  11-07-2014  Custom SQL was not reloading correctly.  Sort icons too large. Destination SQL not colored black when custom.

    V3.0.825b  11-07-2014  Added report tools (Sort/Group) to Excel Tools tab. Color scheme not set correctly with Excel 2007.  Tested with German language pack. 

    V3.0.805b  10-07-2014  When a number format was applied to a column, the number format button did not show a 'green light' to indicate format applied.

    V3.0.801b  10-07-2014  Excel validation was not being applied correctly.

    V3.0.796b  10-07-2014  Column validation would still occur if the 'Include in SQL' was unchecked.  Date validation would would not allow an empty date, even though the column was not marked as mandatory.

    V3.0.793b  10-07-2014  'Include in SQL' column option not saving. Small fonts in some dialogue boxes.

    V3.0.784b  10-07-2014  SQL Builder form did not show correctly.

    V3.0.783b  09-07-2014  Initial V3 Beta release 

    Reported & Outstanding :

    Cannot drag & drop report column order

     

    With the help of your feedback and bug reporting, we are aiming to release the first production version of EDT V3 by Friday 25th July.

     

    Thanks and best regards

    Lean Software team

    http://LeanSoftware.net

    EDT V3 Beta Release

    by Lean Software on Wednesday, July 09, 2014 12:23 AM

     


    Great News - 


    EDT V3 Professional Edition (beta) is now available for download.

    (download from this link http://leansoftware.net/software/EDT_BetaSetup.exe)
    Please check out the software on a test database until we release the production version.

    Introducing EDT Version 3.0

    What's new summary:

        Performance - V3 is up to 100 times faster than V2
        Ribbon Interface - natural and intuitive design in line with Microsoft Excel standards
        Task Explorer - organise tasks into sub levels to any depth, explore the tasks easily with hover over task descriptions
        Reporting Module - faster reporting with easy grouping and totalling functions
        Interface Control - design your companies default scheme at a global level, modify the scheme at task level or column level
        Power tools - optionally allow tools such as Spell check and search and replace at task level
        New compatibility - new database compatibility: IBM DB2, Progress OpenEdge.  New data sources :Lotus Notes.  Operating systems :Windows 8.

    Performance
    We have developed high tech methods to turbo charge the performance of EDT V3.  Typically we are seeing 3000 rows loaded and validated in 2 seconds, 40,000 rows in 10 seconds.  Performance of course is dependent on the performance of your database server / network and the complexity of task validation rules.  Reporting is faster still with 3000 rows in 2 seconds, 40,000 rows in 4 seconds.

    Ribbon Interface

    The new ribbon has two modes : User mode and Task Builder mode:

    User mode:



    Additional Task Builder options are available after clicking ribbon 'Login':

     


    Notice the new Global Settings Icon- where company wide settings are held - such as Task location shares, company theme and security settings.

     

    There is an additional Excel Tools Tab - the contents of which can be specified at task level:

     


    The Spelling and Search and Replace options have been specially adapted to function correctly with EDT.

     

    Task Explorer

    A number of companies using EDT have hundreds of EDT tasks - so a better way of displaying and organising tasks was required.

    Task Explorer multi level organisation of tasks:


     

    When you add a task Location (within Global Settings) EDT will automatically include all sub-folders and task files, and display in treeview like menu as shown above.

    Tasks have a new 'Description' property that can be seen when hovering over the task.


    Reporting Module

     

    A great deal of thought has gone into the Report  type tasks - and make best use of Excel's capability.

    Here you can see the report column options in a Group, Sum and Average type report:

     

    Total and sub-totals can be applied to any degree of nesting, totals can be applied to multiple columns.  All column format and conditional formatting options are available.   All Excel summary functions can be used (Sum, Avg, Number count, StdDev etc).  Integrate with Excel formula 'Default value' column to make best of use of database and Excel capability.


    Interface Control

    Elements of the EDT interface can be modified - or a scheme applied as appropriate.



    New compatibility

    Now compatible with IBM DB2 and Progress OpenEdge database systems.   OS Compatible with Windows 8.   Lotus Notes can be used as a data source.

    Participating in the Beta programme

    Please can any issues discovered be reported to the lean online Help Desk:

    When creating a help desk ticket, please mark as Public, so that other companies can see that the problem has already been reported.

     


    Lean Software Team

    http://LeanSoftware.net

    EDT Version 3.0 : Development Update and Beta Invitation

    by Lean Software on Tuesday, May 27, 2014 8:12 AM

    Development update regards Excel Database Tasks Version 3.0

     

    Greetings from Lean Software,

    This is a courtesy announcement from Lean Software Ltd - to inform you of development progress of EDT Version 3.0.

    New functionality / development progress:

    Conversion to Excel Fluid Ribbon : 100% complete

    Conversion of all forms to match Excel / Microsoft standards : 80% complete

    IBM DB2 compatibility 100% complete

    Progress Open-Edge compatibility 100% complete

    Report type task method / Stored Query functionality : 80% complete


    To provide some insight into EDT version 3.0, we provide some screenshots of the new development:

    Ribbon

    The new Ribbon provides a more intuitive and productive interface to the application :


    Configuration screens

    All configuration screens now follow Microsoft Excel setup presentation, with integrated information icon hover help:

    [Task method selection]

     

    [Task design - Target columns]

     

    Beta release

    We are now expecting the first Beta release of V3 to be available in the second week of June.

     

    If you would like to be included as a Beta testing site - please click here to email the support team  - we will email you a download link and Beta community reporting instructions as soon as V3 is available. Your contribution is very much appreciated.


    Regards

    Lean Software Team

    support@leansoftware.net

    http://LeanSoftware.net

     

    ☆Lean News - EDT Version 3.0

    by Lean Software on Monday, April 28, 2014 5:58 AM

    Lean News

    EDT Version 3.0 will be released in Mid May 2014

    We would greatly value your feedback regards the new Ribbon interface, as shown in the below screenshots.

     

    V3 Ribbon: Showing Active Legend options

     

    V3 Ribbon: Showing Freeze options

    V3 Ribbon: Showing Insert rows options (Insert rows and Delete rows options can be enabled/disabled at task level - as with version 2.9)

     

    A forum post has been created where you can add comment or make requests :

    http://www.leansoftware.net/tabid/123/g/posts/m/71/EDT-Version-3-0.aspx#post71 

    Or please contact the development team directly by email development@leansoftware.net

     

    EDT V3 will also include :

    • Full support for IBM DB2
    • Full support for Progress OpenEdge

    Reporting capability will now be released in version 4.0, expected toward the end of June 2014

     

    Look forward to listening to, and responding to your requirements.

     

    Best Regards

    Lean Software Team

    http://LeanSoftware.net

     

     

    ☆ EDT - ORACLE support + Demo Videos + Task build Services

    by Lean Software on Wednesday, April 09, 2014 12:11 PM

    Lean News

    In this newsletter:

    • ORACLE now fully supported
    • New Video Demonstrations
    • Task build Services - how the service works

    ORACLE & EDT

    EDT is now fully integrated with ORACLE - (EDT Version 2.9.325 and above) with testing completed for ORACLE 11g (using Microsoft Oracle OLE Provider).   

    We are expecting full compatibility with all other ORACLE versions as the generated SQL is non version specific.

    All tasks methods are supported:

    ·        Edit data table

    ·        Edit / Insert data table

    ·        Transfer to table from any data source (including windows clipboard)

    ·        Transfer to Stored Procedure from any data source  (including windows clipboard)

    Demonstration Videos

    We are building a demo video library on YouTube - and welcome your suggestions / requests for  particular 'how to' examples.

    Whilst the videos demonstrate a particular database, you will find the techniques are fairly generic to all currently supported databases (SQL Server, Access, MySQL, ORACLE, FoxPro), so you may pick up some tips..

    Note that videos have a music sound track with annotations - and so are designed to be viewed with muted sound in an office environment.

     

    Here are the currently available videos:

    How to edit ORACLE table using Microsoft Oracle OLE Driver

    How to EDIT MS Access table using 2007-2013 OLE Driver (accdb datafile)

    How to Edit MS Access table using Jet 4 or ODBC Driver (mdb datafile) 

    How to Add a Delete Row facility with ORACLE (technique can be used for any database type)

    New videos will be added soon, including data load / transfer examples and how to handle Relational Lookup data.

     

    Task build Services - how the service works

                We are undertaking a number of Task Design and Build projects for clients.

                How the service works 

                            Initial Email or Telephone discussion regards your requirements.

                            We ask clients to provide :

    ·        sample SQL scripts so we can emulate your SQL environment

    ·        sample source data, this might be CSV, Excel workbooks for example

    • for security any sample structures or files supplied are stored on an inaccessible Virtual Server - never on a laptop of desktop
    • all files provided will be destroyed on client satisfaction on delivery of the solution - or upon client request

    Please contact development services development@LeanSoftware.net or telephone regards your requirements  (UK) 0113 2948207. or Outside UK -  UK country code + 113 2948207 (8am - 5pm GMT)

     

    Regards

    Lean Software Team

    support@LeanSoftware.net

    http://leansoftware.net                      

     

     

    ☆ EDT Advanced Schema Edition, Task build services & Consultancy

    by Lean Software on Sunday, March 30, 2014 2:48 AM

    Lean News  - EDT Advanced Schema Edition

    Greetings from Lean Software.

    As we work towards EDT Version 3 - we have released the planned advanced schema integration in this interim release (V 2.9.300).

    This being in relation to a number of clients requiring multiple schema functionality as a matter of priority.

     

    In this newsletter:

    • EDT 2.9.300 Advanced Schema Edition
      • Modifications in this Release
      • Issues Resolved
      • Upgrade Advice
    • Task Development Services & Consultancy
    • Client Feedback
    • EDT Version 3.0 - coming soon!

    EDT 2.9.300 Advanced Schema Edition

    Modifications in this release

    Multiple Schema Support
    New Schema Selection drop down on the task configuration data destination tab:
     

    New Schema Selection drop down on the task configuration data source tab:

     

    Extended Schema Information Extended column properties are now imported into a task definition.

    • Title : obtained from the database column Description property
    • Default Value : excel default value formula is now automatically created from the the database column Default value property
    • Mandatory : Set depending on the database column Allow Nulls property
    These extended properties are automatically imported when creating a new task, saving you time, and are offered as an optional import when configuring an existing task. All or only selected properties can be imported, as shown below :

    .


    Additional useful features

  • Text length validation : cell entry is now automatically checked for max length compared to the database column data type:

  • Column order : when creating a new task, the initial column order is set to be the same as the underlying table or procedure

  • Data type detail: datatype text length or numeric decimal places is now displayed in the Destination configuration tab

  • System tables and procedures : are no longer displayed in either the destination or source drop down table/procedure list

  • Date handling : dates are converted to generic date format 'yyyy-mm-dd' when sending to the database
  •  

    Issues resolved 

    • 2.9.300 : Task Configuration : Corrected data type display format for Microsoft Access
    • 2.9.295 : Task Send Operation :  When an Excel formula evaluated to an empty string, the column's merge code would remain in the SQL.
    • 2.9.280 : Previous 2.9 release (2.9.137) would display an error message when pasting data into a task, this did not affect operation of the task

    Upgrade Advice

    To upgrade using the install Wizard:

    Download the wizard from the downloads page or directly from this link:

    http://leansoftware.net/software/EDT_Setup.exe

    When running the Wizard, set the installation folder to your existing EDT installation folder.

    To upgrade using the ZIP:

    Download the zip from the downloads page or directly from this link:

    http://leansoftware.net/software/EDT_LatestBuild.zip

    Extract the zip to your existing EDT installation folder.


    EDT Development Services and Consultancy

    We have additional resource available to be able to offer clients an EDT Task Build service /  SQL stored procedure development or general consultancy.

    We work on the basis of purchasing development days, and time spent is recorded with your account, with feedback and progress reported to you when any work is undertaken.

    If you would details of this service, please contact us to discuss your requirements Development@LeanSoftware.net

     

    Client feedback

    There are some recent client feedback entries you may find interest :

    http://leansoftware.net/forum/en-us/feedback.aspx

    Please add your own feedback and experience as this is very interesting for other companies.  The feedback entry form is at the bottom of the feedback page.

     

    EDT Version 3.0 - coming soon!

    EDT 3.0 is in development and will provide an interface revamp with all controls moving to an Excel Ribbon bar.  Additionally  the much requested Reporting module will be released.

     

    Thats it for now, wishing you a fabulous day.

     

    Lean Software Team

    http://LeanSoftware.net

    Support@LeanSoftware.net

    ☆ EDT 2.9.121 Upgrade advice; Release notes; Help and advice

    by Lean Software on Monday, February 10, 2014 8:43 AM

    EDT 2.9.121 Upgrade advice

    In order to upgrade to EDT 2.9.121 we recommend (on this occasion) using either the EDT_Setup.exe program or extracting the new version from the EDT download zip.

    Both upgrade options are available online on the downloads page:

    http://www.leansoftware.net/en-us/productsdownloads/exceldatabasetasks(edt)/download.aspx

    We do not recommend using the 'Automatic upgrade on program launch' for this version.

    [The reason for this is that this method does not set the program EXE files to read-only, this being required to preserve the applications digital signature]

    The automatic upgrade option can however be used once again from version 2.9.121 onwards.

    To upgrade using the install Wizard:

    Download the wizard from the downloads page or directly from this link:

    http://leansoftware.net/software/EDT_Setup.exe

    When running the Wizard, set the installation folder to your existing EDT installation folder.

    To upgrade using the ZIP:

    Download the zip from the downloads page or directly from this link:

    http://leansoftware.net/software/EDT_LatestBuild.zip

    Extract the zip to your existing EDT installation folder.

    Release notes :

    • 2.9.108
      • When pasting data into a task that has no datasource, error may occur
    • 2.9.113
      • Minor change to address 'trails' that may be seen when moving or enlarging the task configuration form
    • 2.9.116
      • When creating a new task, error message 'Error 0 [] Line: 0 in procedure Config of Module modEDT_GlobalMethods'' may occur
    • 2.9.121
      • On upgrade. the EDT exe files were not set to read only, as required to preserve digital signature

    Help and support

    We are here to help with task design and general advice - either log a call on the helpdesk - or contact us directly:

    Online Conversations - the lean website now includes a new chat feature - click on the "Need help?" icon - top left of every page to talk to us online. This service however is subject to support staff availability.

    Log a Help Desk call http://leansoftware.net/en-us/helpdesk.aspx

    Direct Email Support@LeanSoftware.net

     

    Best regards

    Lean Software team

    http://LeanSoftware.net