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.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