Register
Login
Button
Home
Contact us
Products & downloads
Excel Database Tasks (EDT)
Download EDT
P4W Conveyancing Workflows
P4W Generic Awaiting Items (GAIL)
Help
Excel Database Tasks
Worked examples
Loading data
How to import CSV data to SQL Server
How to Import Multiple Excel Worksheets
How to import Multiple Excel Workbooks
How to Import Excel spreadsheet to SQL Server data
How to Import Excel spreadsheet using Stored Procedure
How to connect Excel to Remote Web Server SQL Database
First Steps
Requirements
Task Files and Task Folders
Installation
EDT and AVG anti virus settings
Network Installation
Advanced techniques
Task parameters
Include task parameter in connection string
Did you know? - EDT Tips
Organising EDT task files
Where should I install EDT?
Reference
Connection strings
CSV / Text file connection strings
Excel Connection Strings
SQL
Create Insert Update Delete stored procedure
Upgrade Advice
Copyright
Command Line Interface and Task Scheduling
introduction
Importing CSV Bank Statements with SQL
Task configuration tabs
Data Destination / template tab
Excel data destination connection
Select Task Method Template
Data source / SQL tab
Define data to retrieve
Maintain data source connection
Partner for Windows (P4W)
Conveyancing Workflows
Training
Conveyance - Purchase
EDT integration
Generic Awaiting Item Logic (GAIL)
Introduction
P4W Case flow development services
Feedback
Help desk
View Public tickets
New ticket
Remote Assistance
Service Level Agreement (SLA)
Purchase
Purchase your EDT Licence
Purchase Analysis / Developer days
Purchase your FormSnips Intranet licence
Help desk
×
Before you go ...
Discover Lean Solutions
* required
Our team will respond and discuss a solution with you
Provide a proof of concept model or quotation
You will be surprised by the possibilities!
New Ticket
Existing and Public Tickets
Reset Search
Ticket # or Search Text:
*All*
New
Active
On Hold
Resolved
Cancelled
*All*
Normal
High
Low
*All*
Unassigned
TaskID
Status
Priority
Due
Created
Assigned
Description
Requestor
App Version
Public/Private
624
New
Normal
3/19/2021
Unassigned
Paid for license renewal but still being rejected
Latest Comment:
We did a transaction to pay for renewal of our licenses that expired on 3/17/2021 but we are still being told the licenses have expired. ...
CommerceHub
EDT 5.1.130
Public
623
New
Normal
3/19/2021
Unassigned
Paid for license renewal but still being rejected
Latest Comment:
We did a transaction to pay for renewal of our licenses that expired on 3/17/2021 but we are still being told the licenses have expired. ...
CommerceHub
EDT 5.1.130
Public
621
Resolved
Normal
10/8/2020
Unassigned
Error reported by Task
Latest Comment:
This problem did not reoccur after reloading the Task. I don't know what caused the problem in the first place, but we can close this ticket now. I ...
CommerceHub
EDT 5.1.130
Public
619
New
Normal
5/6/2020
Unassigned
Office 2019 Support
Latest Comment:
Hi Richard, Is there a newer version of EDT that 5.1.4 that supports Excel 2019? Currently I'm finding that EDT crashes on Office 2019 when loading ...
Alex Snow
EDT 5.1.4
Public
618
New
Normal
4/1/2020
Unassigned
using a parameter value in the mapping for upload
Latest Comment:
Hi, I am uploading data from Excel into SQL and I need the user to be prompted for a job ID to add to each row in the upload. So I have created the t ...
Beau Carroll
EDT 5.1.130
Public
617
Resolved
Normal
7/11/2019
Unassigned
Title Class
Latest Comment:
New title fields have been added for you. usr_conveyance.Title1Class usr_conveyance.Title2Class
Alex Snow
P4W Purchase 1.x
Public
604
Resolved
Normal
3/20/2019
Unassigned
Unable to modify task crashing
Latest Comment:
Error report : EDT Version 4.0.200 Please (if possible) can you provide a brief description of actions that lead to the error : Thank you System m ...
Ann Matti
EDT 4.0.200
Public
603
Resolved
Normal
1/23/2019
Unassigned
Excel crashes when loading data for a task
Latest Comment:
Yes, I am past the problem of Excel crashing. I still have more testing to do, but this ticket can be dedicated to just the issue of preventing the c ...
CommerceHub
EDT 5.0.125
Public
602
Resolved
Normal
1/23/2019
Unassigned
Excel crashes when loading data for a task
Latest Comment:
Just started testing the new (v 5) release. The first task that I am testing results in Excel crashing after I load the task, make my parameter selec ...
CommerceHub
EDT 5.0.125
Public
601
Resolved
Normal
1/23/2019
Unassigned
Excel crashes when loading data for a task
Latest Comment:
Just started testing the new (v 5) release. The first task that I am testing results in Excel crashing after I load the task, make my parameter selec ...
CommerceHub
EDT 5.0.125
Public
600
Resolved
Normal
12/6/2018
Unassigned
Error when validating rows
Latest Comment:
Thanks for reporting, issue resolved in 5.0.121
Nissan Motor Manufacturing 01
EDT 5.0.116
Public
599
Resolved
Normal
12/4/2018
Unassigned
Error while validating
Latest Comment:
Error report : EDT Version 5.0.120 Please (if possible) can you provide a brief description of actions that lead to the error : Relatively straightfo ...
Alex Snow
EDT 5.0.120
Public
598
Resolved
High
9/5/2018
Unassigned
Grayed out "Map Column" button and "Report Column"
Latest Comment:
Issue resolved for client - an unusual error but now sorted. New version of EDT released. Thanks Jim for helping us sort this for you. ...
Jim Kientzy
EDT 4.0.205
Public
597
Resolved
Normal
8/15/2018
Unassigned
High Risk Flag
Latest Comment:
Hi Jyoti the Risk you see relates to the Milestone not being achieved within a set period of time. The Milestone expected by dates can be modified / e ...
Jyoti Patel
P4W Purchase 1.x
Public
596
Resolved
Normal
8/15/2018
Unassigned
Closure of Aborted matters
Latest Comment:
Hi Jyoti to archive a matter, Insert the step 'PRO Abort Matter' Taking this step you will be asked for an abortive reason and to set the matter Statu ...
Jyoti Patel
P4W Purchase 1.x
Public
595
Resolved
Normal
8/15/2018
Unassigned
LTR sols with enquires
Latest Comment:
Hi Jyoti please can you send details of letter amendments to Louise Daniels who is handling letter contents. Ro be able to edit teh letter, ensure the ...
Jyoti Patel
P4W Purchase 1.x
Public
594
On Hold
Normal
8/15/2018
Unassigned
Company Screen/box
Latest Comment:
Hi Jyoti please can you tell me the exact data items you would like to store in a new 'Company' section. Thanks ...
Jyoti Patel
P4W Purchase 1.x
Public
593
Resolved
Normal
8/15/2018
Unassigned
Deposit Giftors- pulled into Engagement area
Latest Comment:
Hi Jyoti as an additional note to this ticket, the step 'Awaiting Processing of Engagement Items' (Pre-Exchange sub Agenda) asks the question 'Please ...
Jyoti Patel
P4W Purchase 1.x
Public
592
On Hold
Normal
8/15/2018
Unassigned
Letter asking sols to confirm instruction
Latest Comment:
Hi Jyoti Please can you pass me an Entity/Matter number and confirm the letter name, and I will investigate and resolve this for you. Thanks ...
Jyoti Patel
P4W Purchase 1.x
Public
591
On Hold
Normal
8/14/2018
Unassigned
letter to lender registration
Latest Comment:
Hi Louise please could you pass me am Entity/Matter number for this one so I can test and resolve. It is likely the way teh Lender Entity has been cr ...
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
590
On Hold
Normal
8/14/2018
Unassigned
letter client case closure
Latest Comment:
Hi Louise if the Client matter Contact details are modified I would expect the letter to be correct. However you may wish to have a question 'Write t ...
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
589
Resolved
Normal
8/14/2018
Unassigned
registration
Latest Comment:
Hi Louise I have now developed the step as I have described below. In addition we now have a new group box in the Conveyance tab, with two new fie ...
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
588
Resolved
Normal
8/14/2018
Unassigned
letter to land registry with application
Latest Comment:
Sorted, thankyou
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
587
Resolved
Normal
8/14/2018
Unassigned
completion _bill
Latest Comment:
PRO Completion now inserts new step 'DOC Financial Entry Client Bill'. So far the bill lists all financial entries in the financial entry category 'Ou ...
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
586
Resolved
Normal
8/14/2018
Unassigned
completion
Latest Comment:
Hi Lousie I have added 'LTR to Sols Requesting Purchase Monies', and added this to teh PRO Completion Step ...
Louise Daniels, EHL Group
P4W Purchase 1.x
Public
Page Size:
5
10
25
50
75
100
300
500
1000
1
2
3
4
5
6
7
8
9
10
11
12
>
>>
Search Tags:
Skip Navigation Links.
Bug report
Consultancy
Database
Feature request
Feedback
Help request