INSTRUCTIONS:
Scroll down until you reach your current version (shown in bottom left of program window). Then work
your way back up implementing any database changes as you go.  Changes to the exe are cumulative, so
you just need to copy across this from the most recent zip file to your local machine.
=======================================================================================
4.0.0.123
=======================================================================================
1. Warning if you action a job which is currently being actioned.

Items affected:lbehdesk.exe

=======================================================================================
4.0.0.122
=======================================================================================
1. Fixed bug on helpdesk activity report with some international settings and Sql Server.

Items affected:lbehdesk.exe
=======================================================================================
4.0.0.121
=======================================================================================
1. Removed extraneous blank rows when export selected records to html.

Items affected:lbehdesk.exe

=======================================================================================
4.0.0.120
=======================================================================================
1. Fixed bug when creating a new job with Sql Server and some language settings.

Items affected:lbehdesk.exe

=======================================================================================
4.0.0.119
=======================================================================================
1. Email notification of escalation to operator  used template email_job_escalate_manager.txt
not email_job_escalate_operator.txt
2. Email escalation notification was specifying previous priority.

Items affected:lbehdesk.exe


=======================================================================================
4.0.0.118
=======================================================================================
1. When closing a Job, can choose to include or exclude from the Web helpdesk knowledgebase

Items affected:lbehdesk.exe

=======================================================================================
4.0.0.117
=======================================================================================
1. Fixed crash if repeatedly open the Filter window from the main toolbar and then press escape to close it.

=======================================================================================
4.0.0.116
=======================================================================================

1. Fixed bug that when an operator is restricted to a single customer, may not see any
jobs at all with certain filters.

Items affected:lbehdesk.exe

=======================================================================================
4.0.0.115
=======================================================================================
1. Email templates now give you complete control over email content.
Please see "Customize e-mails sent by the helpdesk" in the help.
2. New button on grid allows you to do a "Find Next" with the Quick Find.
3. Removed dropdown on Action Job window to select Action notes or History for the email as this is
now controlled by the templates.
4. Fixed bug which would overstate numbers on the  "Number of Jobs Completed by Operator Per Month/Week" reports
5. Fixed bug if used "and" or "or" in a filter
6. Fixed error in "Helpdesk Spending per Customer/Department/Contact" report
7. Fixed error that meant "Helpdesk Spending per Customer/Department/Contact" report was not shown if using Sql Server.
8. Fixed error in Helpdesk Activity report if using Oracle.

Items affected: lbehdesk.exe, lbehdesk.hlp
New files:
email_job_closed_contact.txt
email_job_closed_operator.txt
email_job_hold_contact.txt
email_job_hold_operator.txt
email_job_open_contact.txt
email_job_open_operator.txt
email_job_escalate_manager.txt
email_job_escalate_operator.txt
email_job_overdue_manager.txt
email_job_overdue_operator.txt

=======================================================================================
4.0.0.112
=======================================================================================
1. Warning if open a job where the history is near the maximum (64k)
2. Allow save if job history has exceeded the maximum, history is not updated.


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.111
=======================================================================================
1. Removed "This will also delete related records" message when "removing" a logged in operator as this does not apply
(NB. removing makes the specified operator log in again, it does not delete them).
2. When closing a job, does not disable "Email next operator"


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.110
=======================================================================================
1. Fixed inconsistency betweeen web/desktop helpdesk in case-sensitivity of "AT". "WHEN" and "PLUS" settings of Priorities

2. Fixed bug that when using Org Type C and click + button to add Contact, asks you to create a Dept and switches org type to D.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.109
=======================================================================================

1. Fixed problem with newline character being replaced with || when accept spell checker correction.
2. Added support for <!-- ##ASSETDESC --> and <!-- ##ASSETNUM --> to job sheet
Items affected: lbehdesk.exe


=======================================================================================
4.0.0.103
=======================================================================================

1. Fixed error when create child job if using Czech language settings.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.102
=======================================================================================

1. Added customer signature box to jobsheet
2. Fixed bug which meant some date filters did not work correctly.

Items affected: jobsheet.txt, lbehdesk.exe



=======================================================================================
4.0.0.101
=======================================================================================

1. Fixed bug with time on report date range incorrectly assuming it is PM.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.100
=======================================================================================

1. On Hold Jobs can now be included/excluded from Helpdesk Activity reports

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.99
=======================================================================================

1. Can now pass database connection string as part of the command line e.g. create a shortcut whose
target is:

"C:\Program Files\lbe\LBEHDesk.exe" PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=z:\SHARED\HELPDESK.MDB;PERSIST SECURITY INFO=FALSE

Please note, although the path to the exe should be enlosed in " marks, the database connection shouldn't.

This allows you to create multiple shortcuts which automatically connect to different databases.

2. On hold jobs are not included in the overdue jobs email notification.
3. On Hold jobs are excluded from the Helpdesk Activity report.
4. Can limit an operator to seeing data from a single customer
(N.B. This also affects those reports with "Customer" in their title, but not any others).
5. When a "Default Contact" is created, any e-mail address specified for the customer is copied to the new contact.

Items affected: lbehdesk.exe, database (see below)

ACCESS
======
Create a new text file called lbedbconvert.sql  in the same folder as
the desktop helpdesk installation, the contents of the text file should be as follows:

ALTER TABLE users add column custid long null
update users set custid = 0
Delete from opwindowsetting where winname = 'FRMOPERATORS'
delete from gridexsql where type = 'OPERATORS' or type = 'LINKEDFILES'
INSERT INTO gridexsql (type, sqlSelect) values ('OPERATORS',  'SELECT users.User_Id AS Id, users.User_Name AS Name, users.Email, users.Custom1, users.Custom2, Customers.Customer_Name as Restricted_to_Customer FROM users LEFT JOIN Customers ON users.custid = Customers.Customer_Id WHERE users.Deleted=0')
INSERT INTO gridexsql (type, sqlSelect) values ('LINKEDFILES','SELECT linkedfile.id, linkedfile.jobid AS Job_Id, linkedfile.description, linkedfile.filename FROM (((linkedfile INNER JOIN jobs ON linkedfile.jobid = jobs.Job_Id) INNER JOIN Person ON jobs.Customer_Id = Person.Id) INNER JOIN Dept ON Person.Dept_Id = Dept.Id) INNER JOIN Customers ON Dept.Cust_Id = Customers.Customer_Id where customers.deleted=0 and dept.deleted=0 and person.deleted=0')


(this file is provided for you in the zip)

Then run the desktop helpdesk.

ORACLE
======
ALTER TABLE users add  custid number (11,0) default 0 null;
update users set custid = 0;
Delete from opwindowsetting where winname = 'FRMOPERATORS';
delete from gridexsql where type = 'OPERATORS' or type = 'LINKEDFILES';
INSERT INTO gridexsql (type, sqlSelect)
values ('OPERATORS',
'SELECT users.User_Id AS Id, users.User_Name AS Name, users.Email, users.Custom1, users.Custom2, Customers.Customer_Name as Restricted_to_Customer FROM users,customers WHERE users.custid = customers.customer_id(+) and users.Deleted=0');

INSERT INTO gridexsql (type, sqlselect) values ('LINKEDFILES',
'Select linkedfile.Id, linkedfile.jobid as Job_Id, linkedfile.Description, linkedfile.Filename FROM jobs,linkedfile,dept,person,customers ' ||
'WHERE  (dept.cust_id = customers.customer_id) and (person.dept_id = dept.cust_id) ' ||
'and (jobs.customer_id = person.id) and (linkedfile.jobid = jobs.job_id) ' ||
'And (customers.deleted=0) and (dept.deleted=0) and (person.deleted=0)');
commit;


SQL Server
==========
USE lbehelpdesk
GO
ALTER TABLE users add  custid int null default 0
GO
update users set custid = 0
GO
delete from gridexsql where type = 'OPERATORS' or type = 'LINKEDFILES'
GO
INSERT INTO gridexsql (type, sqlSelect) values ('OPERATORS',  'SELECT users.User_Id AS Id, users.User_Name AS Name, users.Email, users.Custom1, users.Custom2, Customers.Customer_Name as Restricted_to_Customer FROM users LEFT JOIN Customers ON users.custid = Customers.Customer_Id WHERE users.Deleted=0')
GO
INSERT INTO gridexsql (type, sqlSelect) values ('LINKEDFILES','SELECT linkedfile.id, linkedfile.jobid AS Job_Id, linkedfile.description, linkedfile.filename FROM (((linkedfile INNER JOIN jobs ON linkedfile.jobid = jobs.Job_Id) INNER JOIN Person ON jobs.Customer_Id = Person.Id) INNER JOIN Dept ON Person.Dept_Id = Dept.Id) INNER JOIN Customers ON Dept.Cust_Id = Customers.Customer_Id where customers.deleted=0 and dept.deleted=0 and person.deleted=0')
GO

=======================================================================================
4.0.0.97
=======================================================================================

1. Fixed date error when creating child job or priority with certain Oracle language settings.
2. Customer Contact selected when create a new job against an asset
3. Customer Contact selected when create a new job against a customer which doesn't have a default
contact - chooses first contact by dept name and surname ordered alphabetically.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.96
=======================================================================================

1. Can now Expand All/Collapse All when using a public data view which is not your own.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.95
=======================================================================================

1. Fixed bugs relating to customers whose contract has expired: When creating a new job for them,
selecting "No", when asked if you wish to continue, opened a new, read-only job; When viewing a job,
were also asked if you wished to continue, despite this not being relevant.

Items affected: lbehdesk.exe


=======================================================================================
4.0.0.94
=======================================================================================

1. Fixed "FrmGrid - PopulateViewmenus()" errors which are sometimes seen when switching between open windows.

Items affected: lbehdesk.exe

=======================================================================================
4.0.0.93
=======================================================================================

1. New password encryption


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.92
=======================================================================================

1. " characters were replaced with "" in the Job Notes, % character was replaced with [%]


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.91
=======================================================================================

1. When you View a Job some of the fields were not properly disabled.


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.90
=======================================================================================

1. When you action a Job that has previously been placed On Hold, the target completion date is updated
to reflect the time already spent On Hold.  Similarly if you close a Parent Job, any Child jobs that
were on hold will have their target completion date updated for the period spent On Hold.


Items affected: lbehdesk.exe

=======================================================================================
4.0.0.89
=======================================================================================

1. "Actioned by" defaults to the logged in operator


Items affected: lbehdesk.exe


=======================================================================================
Version 4.0.0.88
=======================================================================================

1. Can specify a default problem value for new jobs (not children). To do so, create a file newjob.txt
with the required contents in the same folder as the lbehdesk.exe

2. Fixed Error 0 when opening/minimizing/maximizing Action Job window. Side effect is that this window should open slightly faster.

Items affected: lbehdesk.exe, new file:newjob.txt.

Copy both files into the folder you installed LBE Desktop Helpdesk into.


=======================================================================================
Version 4.0.0.86
=======================================================================================

1. Can now specify multiple email address (separated by semi-colon) for operators or contacts.
E.g. this allows you to specify more than one address to be notified of auto-escalation

Items affected: lbehdesk.exe

=======================================================================================
Version 4.0.0.84
=======================================================================================

1. Solution now printed in the job sheet report.
2. Fixed bug that causes crash if have 3 or more Action Job windows open at once.

Items affected: lbehdesk.exe, jobsheet.txt

=======================================================================================
Version 4.0.0.80
=======================================================================================

1. Fixed bug that meant you could double click the group headers/footers and could edit a record

Items affected: lbehdesk.exe

=======================================================================================
Version 4.0.0.79
=======================================================================================

1. Correctly remembers state of Mail check boxes on Action Job window from one session to the next.

Items affected: lbehdesk.exe

=======================================================================================
Version 4.0.0.78
=======================================================================================

1. Job History now notes any change in the "Pass To" Operator

Items affected: lbehdesk.exe

No database changes.

=======================================================================================
Version 4.0.0.77
=======================================================================================

1. Fixed bug caused by Operators created using web helpdesk having null values in certain Operator privileges.
2. Fixed reports:
Helpdesk Spending per Customer
Helpdesk Spending per Customer/Department
Helpdesk Spending per Customer/Department/Contact


Items affected: lbehdesk.exe

No database changes.

=======================================================================================
Version 4.0.0.76
=======================================================================================

Fixed bug that # button on Action Job window was not filtering Asset list correctly.

New feature sends notification email to assigned operator and/or specified email address when a job is automatically escalated.
This change involves:

1. New lbehdesk.exe - replace your existing one with this.
2. Modifications to the database.  If your are upgrading an earlier database, you will have to run the following queries:

ACCESS
======
The update zip file  should contain a file name lbedbconvert.sql.  Copy this to the same folder as you installed Lbe Desktop Helpdesk.  The next time you run the helpdesk, it will automatically convert the database, then delete the lbedbconvert.sql.  If you have more than one database, you will need to repeat this procedure for each one.

If you can't find the lbedbconvert.sql file, you can create a new file in notepad containing the following lines and save it as lbedbconvert.sql in the same folder as your helpdesk installation:

ALTER TABLE system add column  escntfyop bit, escntfyeml text(255) null
UPDATE  SYSTEM set  escntfyop = 1
DELETE FROM opwindowsetting where winname = 'FRMODUJOBSEMAIL'


ORACLE
======

Run the following scripts:

ALTER table system add  escntfyop number (1,0) DEFAULT (1);
ALTER table system add  escntfyeml varchar2(255);
UPDATE  SYSTEM set  escntfyop = 1;
DELETE FROM opwindowsetting where winname = 'FRMODUJOBSEMAIL';
COMMIT;

SQL SERVER
==========

Run the following script:

use lbehelpdesk
GO
ALTER table system add  escntfyop bit DEFAULT (1)
GO
ALTER table system add  escntfyeml varchar(255)
GO
UPDATE  SYSTEM set  escntfyop = 1
GO
DELETE FROM opwindowsetting where winname = 'FRMODUJOBSEMAIL';
GO


Version 4.0.74 21 Aug 2001
==========================

Implemented spell checking on most text fields.  To spell check, press the F7 key.  You must have MS Word installed for the spell checker to work.

Version 4.0.73 16 Aug 2001
===========================
Removed 255 char limit on length of replacement phrase in macros.  You can now specify up to 64k of text as the replacement phrase (2000 if the database is Oracle).   This requires the following changes to the datatype of the replaceword column in the opmacro table:

Access: MEMO
Oracle: varchar(2000)
Sql Server: text


Version 4.0.72 27 July 2001
===========================

Fixed:

1.  Change of contact not recorded in Job History
2.  Can't use arrow keys or PgUp, PgDwn, Home, End keys to scroll around Job History.

Version 4.0.71 21 July 2001
===========================

Fixed error when open System Options if any of custom field names set to null.

Version 4.0.66 28 June 2001
===========================

Added "Try this if all else fails!" option for email client on Tools, Personal Preferences.
Fixed various "Invalid use of null" errors when open view if Custom1/Custom2 set to null.

Version 4.0.0.57 June 2001
============================

1. Fixed jobsheet report so doesn't print blank page at beginning/end

Version 4.0.0.52 June 4 2001
============================
1. Fixed problems when running against Oracle database with different regional settings to local machine.
2. New gridex20.ocx (used by data views) which fixes number of minor bugs, in particular layout problems with certain regional settings.
3. Fixed errors which may occur when opening linked files from Action Job window.

Version 4.0.0.50 May 24 2001
============================

1. Fixed bug that meant date filters on views were not working.

Version 4.0.0.49 May 21 2001
============================

1. Fixed various bugs caused by corruption of the grid layout information in the datatabase.  Often these occurred when using dropdown lists as the select method, but also on the list of Linked Files when Actioning a Job.


Version 4.0.0.46 May 2001
==========================

1. Fixed bug with Custom Filters on Oracle.
2. Fixed bug when adding Contact to a database from early versions.

Version 4.0.0.37
================
Minor fixes:

1. Error on Job window for an existing job which meant you couldn't click on the dropdowns for contact or asset
2. Report: Number of Jobs completed by operator was incorrectly formatted.
3. Error when running some of the spending reports against a Sql Server database