There was an error displaying content. Please refer to event log.
×
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
New Ticket
Existing and Public Tickets
Ticket:
621
Created:
10/8/2020 8:15 PM
Public/Private:
Public
Private
Status:
New
Active
On Hold
Resolved
Cancelled
Feature request accepted
Assigned:
Unassigned
Lean Application / Version:
EDT 5.1.130
EDT 5.1.15
EDT 5.1.14
EDT 5.1.10
EDT 5.1.9
EDT 5.1.8
EDT 5.1.4
EDT 5.1.3
EDT 5.1.2
EDT 5.0.129
EDT 5.0.128
EDT 5.0.127
EDT 5.0.125
EDT 5.0.124
EDT 5.0.123
EDT 5.0.122
EDT 5.0.121
EDT 5.0.120
EDT 5.0.119
EDT 5.0.118
EDT 5.0.116
EDT 5.0.115
EDT 5.0.114
EDT 5.0.113
EDT 5.0.109
EDT 5.0.106
EDT 4.0.238
EDT 4.0.233
EDT 4.0.232
EDT 4.0.226
EDT 4.0.221
EDT 4.0.220
EDT 4.0.207
EDT 4.0.206
EDT 4.0.205
EDT 4.0.200
EDT 4.0.199
EDT 4.0.198
EDT 4.0.197
EDT 4.0.194
EDT 3.x
EDT 4.x
P4W Purchase 1.x
P4W Sale 1.x
P4W Remortgage 1.x
Perfect Portal 1.x
EDT 2.x
P4W Purchase 1.1
P4W Purchase 1.2
P4W Purchase 1.3
Lean Website x
Priority:
Normal
High
Low
Due Date:
Name:
CommerceHub
Email:
-
Phone:
Estimate Hours:
Description:
Start:
Complete:
Comment
User
Time
Select
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 will open a new one if the problem reoccurs in the future.
CommerceHub
10/9/2020 3:27:43 PM
Select
O.K. figured out that I need to click "Insert" rather than "Save"
CommerceHub
10/9/2020 3:26:33 PM
Select
I have tried multiple times to add comments to this ticket and they don't persist.
CommerceHub
10/9/2020 3:26:00 PM
Select
Error report : EDT Version 4.0.174 Please (if possible) can you provide a brief description of actions that lead to the error : Thank you System message: Error 9 [Subscript out of range] Line: 70 in procedure ParamComboChangeEvent of Module modSearchCombo Technical information: 10/8/2020 3:13:18 PMParamComboChangeEvent-> 54798 10/8/2020 3:13:16 PM<
<
ParametersValid-> 10683 10/8/2020 3:13:15 PMParameterValidationAndDefaults-> 54796 10/8/2020 3:13:15 PM<
<
ParametersValid-> 10683 10/8/2020 3:13:15 PMParameterValidationAndDefaults-> 54796 10/8/2020 3:13:14 PM<
<
ParametersValid-> 10681 10/8/2020 3:13:13 PMParameterValidationAndDefaults-> 54793 10/8/2020 3:13:11 PM<
<
ParametersValid-> 10679 10/8/2020 3:13:11 PMParameterValidationAndDefaults-> 54792 10/8/2020 3:13:11 PM<
<
ParametersValid-> 10679 10/8/2020 3:13:11 PMParameterValidationAndDefaults-> 54791 10/8/2020 3:13:11 PM<
<
ParametersValid-> 10679 10/8/2020 3:13:11 PMParameterValidationAndDefaults-> 54791 10/8/2020 3:13:08 PM<
54788 10/8/2020 3:13:07 PM<
54788 10/8/2020 3:13:07 PM<
<
GetConnectionSummary-> 10675 Operating system: Other version Workstation ID:NEXUS_LT-BPMI-DS2 Application : EDT Version 4.0.174 Excel version 16.0 build 12527 CommonProgramW6432=C:\Program Files\Common Files JAVA_HOME=C:\Program Files\Java\jdk1.8.0_131 LANG=en_US.CP1252 locale LOGONSERVER=\\NXDC-OPALB-001 NUMBER_OF_PROCESSORS=8 OneDrive=C:\Users\dsmith\OneDrive - Commerce Technologies, Inc OneDriveCommercial=C:\Users\dsmith\OneDrive - Commerce Technologies, Inc OS=Windows_NT Path=C:\ProgramData\Oracle\Java\javapath;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files\IDM Computer Solutions\UltraEdit;C:\Program Files\Mercurial\;C:\Program Files\Git\cmd;C:\Program Files\KDiff3;C:\Program Files\PuTTY\;C:\Program Files\Java\jdk1.8.0_131\bin;;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\TortoiseGit\bin;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\RSA SecurID Token Common\;%USERPROFILE%\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Microsoft Office\root\Client PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=AMD64 PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 94 Stepping 3, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=5e03
Requestor
10/8/2020 8:15:33 PM
Tags:
Skip Navigation Links.
Bug report
Consultancy
Database
Feature request
Feedback
Help request