INSTRUCTIONS: Scroll down until you reach your current version (right click lbeweb40.dll, select Properties, Version). Then work your way back up implementing any database changes as you go. Changes to the dll and the .asp pages are cumulative, so you just need to copy across these from the most recent zip file to your web site. You will need to re-register lbeweb40.dll with regsvr32: From a command prompt: c:\winnt\system32\regsvr32 "c:\program files\lbe web helpdesk\lbeweb40.dll" (change the paths appropriately). You may have to stop/restart IIS and/or the server before you are allowed to do this. If you have had custom pages developed you need to contact LBE before proceeding. ======================================================================================= Release: 4.0.0.131 Date: 24/11/2008 ======================================================================================= 1. Fixed bug in MS Sql scripts for creating a new database Items affected : history.txt, lbeweb40.dll, create.sql, data.sql ======================================================================================= Release: 4.0.0.130 Date: 17/10/2008 ======================================================================================= 1. Fixed error if add operator using + button on Action Job page Items affected : jobupdate.asp ======================================================================================= Release: 4.0.0.129 Date: 21/03/2008 ======================================================================================= 1. Support for Arabic version Items affected : lbeweb40.dll ======================================================================================= Release: 4.0.0.128 Date: 06/03/2008 ======================================================================================= 1. Fixed bug if entered non-numeric in number of records to retrieve in *sel.asp pages Items affected : selhead.asp ======================================================================================= Release: 4.0.0.127 Date: 04/03/2008 ======================================================================================= 1. Fixed bug that prevented text after a " being passed to the "add job to knowledgebase" button Items affected : jobupdate.asp ======================================================================================= Release: 4.0.0.126 Date: 30/11/2007 ======================================================================================= 1. Added option to copy a job 2. Moved Options on Job Search to display horizontally 3. Fixed bug that allowed guest contact to edit another guests job if they know the id. Items affected : jobedit.asp, jobsel.asp ======================================================================================= Release: 4.0.0.125 Date: 08/11/2007 ======================================================================================= 1. Fixed javascript error "bsubmitted is not defined" Items affected : jobedit.asp ======================================================================================= Release: 4.0.0.124 Date: 15/10/2007 ======================================================================================= 1. Fixed order of Priorities in dropdown list on Action job page Items affected : jobedit.asp ======================================================================================= Release: 4.0.0.123 Date: 09/07/2007 ======================================================================================= 1. Added CUSTOMER_CUSTOM1 and CUSTOMER_CUSTOM2 to list of tags allowed in email templates Items affected : lbeweb40.dll ======================================================================================= Release: 4.0.0.122 Date: 03/07/2007 ======================================================================================= 1. Fixed "Type mismatch: 'Searc0hfor'" if leave one asset custom field blank Items affected : jobsrch.asp, lbeweb40.dll ======================================================================================= 4.0.0.121 ======================================================================================= 1. Fixed poor formatting of custom field values in job history if you have created custom fields as dropdown lists Items affected : lbeweb40.dll ======================================================================================= 4.0.0.120 ======================================================================================= 1. Fixed "Multiple-step operation generated errors. Check each status value" when saving customer Items affected : lbeweb40.dll ======================================================================================= 4.0.0.119 ======================================================================================= 1. Fixed problem with formatting of Custom3 field on job edit page Items affected : jobedit.asp ======================================================================================= 4.0.0.118 ======================================================================================= 1. Fixed "3021 Either BOF or EOF is True" error when add new KB item with Sql Server Items affected : lbeweb40.dll ======================================================================================= 4.0.0.117 ======================================================================================= 1. Added (optional) username to customer contact details. If present, this can be used to login or you can continue using the email address. If you decide not to modify the database to add this new field, the system will work as currently and require login with an email address. HOWEVER - you will still need to include the supplied username.asp and the other updated .asp pages, even if you do not wish to use this feature. 2. Fixed: List of "Sent to" email addresses not shown as ; separated in the history Items affected : username.asp, gstreg.asp, gstlogin.asp, contactsel.asp, contactedit.asp, contactupdate.asp, lbeweb40.dll, database (see below) DATABASE CHANGES: You will need to run the appropriate scripts below. If are not sure how to do so, please contact LBE. ACCESS ====== alter table person add column username text(50); update person set username=EMail where username is null; alter table person add constraint idx_username UNIQUE (username); MS SQL ====== use lbehelpdesk go alter table person add username varchar(50) Go update person set username=EMail where username is null; go ORACLE ====== connect lbe_owner/lbe; alter table person add username varchar2(50); update person set username=EMail where username is null; alter table person add constraint idx_username UNIQUE (username); commit; ======================================================================================= 4.0.0.116 ======================================================================================= 1. Removed "excluded from KB" column on jobs search (Summary) view as no longer relevant 2. Inserted newline before "add to knowledgebase" button on jobupdate.asp Items affected : jobsel.asp, jobupdate.asp ======================================================================================= 4.0.0.115 ======================================================================================= 1. Implemented new knowledgebase functionality - this info is now stored in tables separate from the jobs and can be viewed, edited, deleted separately. Can now populate job problem & solution from the kb. 3. Added new tag to email templates (#BCC) which allows you to specify a ; separated list of email addresses which will receive a bcc copy of the email. This can be handy for e.g. notifying a manager when a job is closed (or put on hold etc.) 4. If you select "preview email" option on Action Job page, will automatically popup the email preview page once you update, so you will never forget to send the email. 5. Fixed error message on asset type edit page. 6. Only smtp servers are supported for sending email as other options are superfluous 7. Two additional custom fields on the Jobs window. 8. Added #JOB_CUSTOM3 and #JOB_CUSTOM4 to list of tags that can be used in the email templates 9. Removed Reset button from search options Items affected : lbeweb40.dll, opedit.asp, opupdate.asp, kbsel.asp, kbedit.asp,kbupdate.asp, jobedit.asp,jobupdate.asp, jobsel.asp, jobsrch.asp,selhead.asp, pagehead.asp, browser.asp,asted.asp database,help.htm, jobsheet.txt, custom.asp, cstmupdate.asp, selhead.asp DATABASE CHANGES: You will need to run the appropriate scripts below. If are not sure how to do so, please contact LBE. ACCESS ====== CREATE TABLE kb (id counter, problem memo, solution memo) ; INSERT INTO kb ( problem, solution ) SELECT Jobs.Problem, Jobs.Solution FROM Jobs WHERE Jobs.jobstatus='C' AND Jobs.exkb='N'; INSERT INTO gridexsql (type, sqlSelect) values ('KBASE', 'SELECT id, Problem, Solution from kb'); ALTER TABLE users add column editkb bit,addkb bit, deletekb bit; update users set editkb=-1, addkb=-1,deletekb=-1; delete from opgridexview where gridexsqltype like '%DROP%'; delete from sqlwhere where Description ='Knowledge base search (closed Jobs containing...)'; INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('Problem contains',',KBASE',999,'(problem like ''%%'')','Search for text',null,null,'TEXT','TEXT','TEXT'); INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('Solution contains',',KBASE',999,'(solution like ''%%'')','Search for text',null,null,'TEXT','TEXT','TEXT'); alter table system add column job3 text(255); alter table system add column job4 text(255); update system set job3='custom3', job4='custom4'; alter table jobs add column custom3 text(255); alter table jobs add column custom4 text(255); delete from gridexsql where type = 'JOBSDETAILED'; INSERT INTO gridexsql (type, sqlselect) values ('JOBSDETAILED', 'SELECT Jobs.Job_Id as Id,Jobs.ParentId as Parent_Id, Jobs.Category_Id,Jobs.Priority_Id,Jobs.Next_User_Id,Jobs.Asset_id,Jobs.Logged_At as Created,Jobs.Last_Actioned ,Jobs.To_Complete_By,Jobs.Completed_On,IIf([jobs].[completed_on] Is Null And [jobs].[to_complete_by]>Now(),''In target'',IIf([jobs].[completed_on] Is Null And [jobs].[to_complete_by]<=Now(),''Overdue'',IIf([jobs].[completed_on] Is Not Null And [jobs].[completed_on]>[jobs].[to_complete_by],''Overdue'',''In target''))) AS Completion_Status, IIF(jobs.jobstatus = ''O'', ''Open'', IIF(jobs.jobstatus=''C'', ''Closed'', IIF (jobs.jobstatus=''H'', ''On Hold''))) as Job_Status,IIf([jobs].[completed_on] Is Null ,DateDiff(''h'',[jobs].[to_complete_by],Now()),IIf([jobs].[completed_on] Is Not Null, DateDiff(''h'',[jobs].[to_complete_by],[jobs].[completed_on]),'''')) AS Hours_Overdue,IIf([jobs].[completed_on] Is Null ,DateDiff(''d'',[jobs].[to_complete_by],Now()),IIf([jobs].[completed_on] Is Not Null, DateDiff(''d'',[jobs].[to_complete_by],[jobs].[completed_on]),'''')) AS Days_Overdue,IIf([jobs].[completed_on] Is Null, DateDiff(''h'',[logged_at],Now()),DateDiff(''h'',[logged_at],[jobs].[completed_on])) AS Elapsed_Hours, IIf([jobs].[completed_on] Is Null, DateDiff(''d'',[logged_at],Now()),DateDiff(''d'',[logged_at],[jobs].[completed_on])) AS Elapsed_Days, Jobs.Hours_Spent,Jobs.Cost,Jobs.Problem,Jobs.To_do,Jobs.Solution,jobs.Notes as History,Users.User_Name as Next_Operator,Jobs.[Open] as Currently_Opened_By,Jobs.Custom1 as Job1,Jobs.Custom2 as Job2, Jobs.Custom3 as Job3,Jobs.Custom4 as Job4,Priority.Name as Priority,Priority.Custom1 as Pri1,Priority.Custom2 as Pri2,Categories.Category_Name as Category,Categories.Custom1 as Cat1,Categories.Custom2 as Cat2,Asset.Asset_no as Asset_Number,Asset.Description as Asset_Description,Asset.Manufacturer as Asset_Manufacturer,Asset.Model_No as Asset_Model_Number,Asset.Serial_No as Asset_Serial_Number,Asset.Purchase_Date as Asset_Purchase_Date,Asset.Comment as Asset_Comment,Asset.Disposed_date as Asset_Disposal_Date,Asset.Custom1 as Asset1,Asset.Custom2 as Asset2,Asset.Purch_Ord as Asset_Purchase_Order,Asset.Invoice_Num as Asset_Invoice_Number,Asset.Purch_Price as Asset_Purchase_Price,Asset.Vendor as Asset_Vendor,Ass_type.Description as Asset_type_Description,Ass_type.Custom1 as Asstype1,Ass_type.Custom2 as Asstype2,Person.Title as Contact_Title,Person.Forename as Contact_Forename,Person.Surname as Contact_Surname,Person.Job_title as Contact_Job_Title,Person.Custom1 as Person1,Person.Custom2 as Person2, Dept.Name as Department_Name,Dept.[Location] as Department_Location,Dept.Custom1 as Dept1,Dept.Custom2 as Dept2, Customers.Customer_Name,Customers.Contact_details as Customer_Reference,Customers.Custom1 as Cust1, Customers.Custom2 as Cust2, customers.Contract_Expiry, customers.Job_Allowance FROM (Priority INNER JOIN (Users INNER JOIN (Categories INNER JOIN (((Jobs 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) ON Categories.Category_Id = Jobs.Category_Id) ON Users.User_Id = Jobs.Next_User_Id) ON Priority.Id = Jobs.Priority_Id) LEFT JOIN (Asset LEFT JOIN Ass_type ON Asset.type = Ass_type.Id) ON Jobs.Asset_id = Asset.Id '); MS SQL ====== use lbehelpdesk go CREATE TABLE [dbo].[kb] ( [id] int IDENTITY (1, 1) , [problem] [text] , [solution] [text] ) ON [PRIMARY] GRANT SELECT , INSERT , DELETE , UPDATE ON [dbo].[kb] TO [lbe_user] GO INSERT INTO kb ( problem, solution ) SELECT Jobs.Problem, Jobs.Solution FROM Jobs WHERE Jobs.jobstatus='C' AND Jobs.exkb='N'; go INSERT INTO gridexsql (type, sqlSelect) values ('KBASE', 'SELECT id, Problem, Solution from kb'); go ALTER TABLE users add editkb bit,addkb bit, deletekb bit; go update users set editkb=-1, addkb=-1,deletekb=-1; go delete from opgridexview where gridexsqltype like '%DROP%'; go delete from sqlwhere where Description ='Knowledge base search (closed Jobs containing...)'; go INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('Problem contains',',KBASE',999,'(problem like ''%%'')','Search for text',null,null,'TEXT','TEXT','TEXT'); go INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('Solution contains',',KBASE',999,'(solution like ''%%'')','Search for text',null,null,'TEXT','TEXT','TEXT'); Go alter table system add job3 varchar(255) Go alter table system add job4 varchar(255) Go update system set job3='custom3', job4='custom4' Go alter table jobs add custom3 varchar(255) Go alter table jobs add custom4 varchar(255) Go delete from gridexsql where type = 'JOBSDETAILED' Go INSERT INTO gridexsql (type, sqlselect) values ('JOBSDETAILED', 'SELECT Jobs.Job_Id as Id,Jobs.ParentId as Parent_Id, Jobs.Category_Id,Jobs.Priority_Id,Jobs.Next_User_Id,Jobs.Asset_id,Jobs.Logged_At as Created,Jobs.Last_Actioned ,Jobs.To_Complete_By,Jobs.Completed_On,CASE WHEN completed_on IS NULL AND to_complete_by < GetDate() THEN ''Overdue'' WHEN completed_on IS NULL AND to_complete_by >= GetDate() THEN ''In target'' WHEN completed_on IS NOT NULL AND completed_on > to_complete_by THEN ''Overdue'' WHEN completed_on IS NOT NULL AND completed_on <= to_complete_by THEN ''In target'' ELSE ''Unknown'' END AS Completion_Status,CASE WHEN jobs.jobstatus=''O'' THEN ''Open'' WHEN jobs.jobstatus=''H'' THEN ''On Hold'' WHEN jobs.jobstatus=''C'' THEN ''Closed'' END as Job_Status, CASE WHEN [jobs].[completed_on] Is Null THEN DateDiff(hh,[jobs].[to_complete_by],Getdate()) WHEN [jobs].[completed_on] Is Not Null THEN DateDiff(hh,[jobs].[to_complete_by],[jobs].[completed_on]) END AS Hours_Overdue, CASE WHEN [jobs].[completed_on] Is Null THEN DateDiff(dd,[jobs].[to_complete_by],Getdate()) WHEN [jobs].[completed_on] Is Not Null THEN DateDiff(dd,[jobs].[to_complete_by],[jobs].[completed_on]) END AS Days_Overdue, CASE WHEN completed_on IS NOT NULL THEN DateDiff(hh,[logged_at],[jobs].[completed_on]) ELSE DateDiff(hh,[logged_at],GetDate()) END AS Elapsed_Hours,CASE WHEN completed_on IS NOT NULL THEN DateDiff(dd,[logged_at],[jobs].[completed_on]) ELSE DateDiff(dd,[logged_at],GetDate()) END AS Elapsed_Days, Jobs.Hours_Spent,Jobs.Cost,Jobs.Problem,Jobs.To_do,Jobs.Solution,jobs.Notes as History,Users.User_Name as Next_Operator,Jobs.[Open] as Currently_Opened_By,Jobs.Custom1 as Job1,Jobs.Custom2 as Job2,Jobs.Custom3 as Job3,Jobs.Custom4 as Job4,Priority.Name as Priority,Priority.Custom1 as Pri1,Priority.Custom2 as Pri2,Categories.Category_Name as Category,Categories.Custom1 as Cat1,Categories.Custom2 as Cat2,Asset.Asset_no as Asset_Number,Asset.Description as Asset_Description,Asset.Manufacturer as Asset_Manufacturer,Asset.Model_No as Asset_Model_Number,Asset.Serial_No as Asset_Serial_Number,Asset.Purchase_Date as Asset_Purchase_Date,Asset.Comment as Asset_Comment,Asset.Disposed_date as Asset_Disposal_Date,Asset.Custom1 as Asset1,Asset.Custom2 as Asset2,Asset.Purch_Ord as Asset_Purchase_Order,Asset.Invoice_Num as Asset_Invoice_Number,Asset.Purch_Price as Asset_Purchase_Price,Asset.Vendor as Asset_Vendor,Ass_type.Description as Asset_type_Description,Ass_type.Custom1 as Asstype1,Ass_type.Custom2 as Asstype2,Person.Title as Contact_Title,Person.Forename as Contact_Forename,Person.Surname as Contact_Surname,Person.Job_title as Contact_Job_Title,Person.Custom1 as Person1,Person.Custom2 as Person2, Dept.Name as Department_Name,Dept.[Location] as Department_Location,Dept.Custom1 as Dept1,Dept.Custom2 as Dept2, Customers.Customer_Name,Customers.Contact_details as Customer_Reference,Customers.Custom1 as Cust1, Customers.Custom2 as Cust2, customers.Contract_Expiry, customers.Job_Allowance FROM (Priority INNER JOIN (Users INNER JOIN (Categories INNER JOIN (((Jobs 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) ON Categories.Category_Id = Jobs.Category_Id) ON Users.User_Id = Jobs.Next_User_Id) ON Priority.Id = Jobs.Priority_Id) LEFT JOIN (Asset LEFT JOIN Ass_type ON Asset.type = Ass_type.Id) ON Jobs.Asset_id = Asset.Id') ORACLE ====== connect lbe_owner/lbe; CREATE TABLE kb ( id number (11,0) CONSTRAINT pk_KB PRIMARY KEY, problem varchar2 (2000) NULL, solution varchar2 (2000) NULL ) ; GRANT SELECT , INSERT , DELETE , UPDATE ON kb TO lbe_user; INSERT INTO kb ( problem, solution ) SELECT Jobs.Problem, Jobs.Solution FROM Jobs WHERE Jobs.jobstatus='C' AND Jobs.exkb='N'; INSERT INTO gridexsql (type, sqlSelect) values ('KBASE', 'SELECT id, Problem, Solution from kb'); ALTER TABLE users add editkb number (1,0); ALTER TABLE users add addkb number (1,0); ALTER TABLE users add deletekb number (1,0); update users set editkb=-1, addkb=-1,deletekb=-1; delete from opgridexview where gridexsqltype like '%DROP%'; delete from sqlwhere where Description ='Knowledge base search (closed Jobs containing...)'; INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('Problem contains:', ',KBASE',999,'(Upper(problem) like Upper(''%%''))', 'Search for text',null,null,'TEXT','TEXT','TEXT'); INSERT INTO sqlwhere (Description, GridexSqlType, Sequence, SqlWhere, param1name, param2name, param3name, param1type, param2type, param3type) values ('solution contains:', ',KBASE',999,'(Upper(Solution) like Upper(''%%''))', 'Search for text',null,null,'TEXT','TEXT','TEXT'); alter table system add job3 varchar2(255); alter table system add job4 varchar2(255); update system set job3='custom3', job4='custom4'; alter table jobs add custom3 varchar2(255); alter table jobs add custom4 varchar2(255); delete from gridexsql where type = 'JOBSDETAILED'; INSERT INTO gridexsql (type, sqlselect) values ('JOBSDETAILED', 'SELECT Jobs.Job_Id as Id,Jobs.ParentId as Parent_Id, Jobs.Category_Id,Jobs.Priority_Id, Jobs.Next_User_Id,Jobs.Asset_id,Jobs.Logged_At as Created,Jobs.Last_Actioned , Jobs.To_Complete_By,Jobs.Completed_On, pkg_lbe.jobstatusdesc(jobs.completed_on, jobs.to_complete_by) AS Completion_Status, decode (jobs.jobstatus, ''O'', ''Open'', ''C'', ''Closed'', ''H'', ''On Hold'', ''Unknown'') as Job_Status, pkg_lbe.jobtimeoverdue(jobs.completed_on,jobs.to_complete_by,''HOURS'') AS Hours_Overdue, pkg_lbe.jobtimeoverdue(jobs.completed_on,jobs.to_complete_by,''DAYS'') AS Days_Overdue, pkg_lbe.jobtimeelapsed(jobs.completed_on, jobs.logged_at, ''HOURS'') AS Elapsed_Hours, pkg_lbe.jobtimeelapsed(jobs.completed_on, jobs.logged_at, ''DAYS'') AS Elapsed_Days, Jobs.Hours_Spent,Jobs.Cost,Jobs.Problem,Jobs.To_do,Jobs.Solution,jobs.Notes as History, Users.User_Name as Next_Operator,Jobs.Open as Currently_Opened_By, Jobs.Custom1 as Job1,Jobs.Custom2 as Job2,Jobs.Custom3 as Job3,Jobs.Custom4 as Job4,Priority.Name as Priority,Priority.Custom1 as Pri1,Priority.Custom2 as Pri2,Categories.Category_Name as Category,Categories.Custom1 as Cat1, Categories.Custom2 as Cat2,Asset.Asset_no as Asset_Number,Asset.Description as Asset_Description, Asset.Manufacturer as Asset_Manufacturer,Asset.Model_No as Asset_Model_Number, Asset.Serial_No as Asset_Serial_Number,Asset.Purchase_Date as Asset_Purchase_Date, Asset.comment as Asset_Comment,Asset.Disposed_date as Asset_Disposal_Date,Asset.Custom1 as Asset1,Asset.Custom2 as Asset2,Asset.Purch_Ord as Asset_Purchase_Order,Asset.Invoice_Num as Asset_Invoice_Number,Asset.Purch_Price as Asset_Purchase_Price,Asset.Vendor as Asset_Vendor, Ass_type.Description as Asset_type_Description,Ass_type.Custom1 as Asstype1,Ass_type.Custom2 as Asstype2,Person.Title as Contact_Title,Person.Forename as Contact_Forename,Person.Surname as Contact_Surname, Person.Job_title as Contact_Job_Title,Person.Custom1 as Person1,Person.Custom2 as Person2, Dept.Name as Department_Name, Dept.Location as Department_Location,Dept.Custom1 as Dept1,Dept.Custom2 as Dept2, Customers.Customer_Name,Customers.Contact_details as Customer_Reference, Customers.Custom1 as Cust1,Customers.Custom2 as Cust2, customers.Contract_Expiry, customers.Job_Allowance FROM Ass_type, Jobs, Person,Dept,Customers,Priority, Categories,Asset, Users WHERE jobs.customer_id = person.id AND Person.dept_id = dept.id AND Dept.cust_id = customers.customer_id AND Jobs.priority_id = priority.id AND Jobs.category_id = categories.category_id AND Jobs.next_user_id = users.user_id AND Jobs.asset_id = Asset.id (+) AND asset.type = ass_type.id (+)'); create sequence seq_kb INCREMENT BY 1 START WITH 1 ORDER; grant select on seq_kb to lbe_user; CREATE OR REPLACE TRIGGER kb_trigger BEFORE INSERT ON kb FOR EACH ROW WHEN (new.id is null) DECLARE newid NUMBER; BEGIN select seq_kb.nextval INTO newid from dual; :NEW.id := newid; END; / connect lbe_user/lbe; create synonym seq_kb for lbe_owner.seq_kb; create synonym kb for lbe_owner.kb; commit; ======================================================================================= 4.0.0.114 ======================================================================================= 1. Fixed bug when editing existing customer if you use the Sql Server Express SP1 or later Items affected: lbeweb40.dll ======================================================================================= 4.0.0.113 ======================================================================================= 1. Added "Job Sheet" link for each Job on Jobs Search page. This differs from selecting "Job Sheet" in the "Show" dropdown list in that it only shows the Job Sheet for the selected job and none of the page header info is displayed. Items affected: jobsel.asp, pagehead.asp ======================================================================================= 4.0.0.112 ======================================================================================= 1. Added #CONTACT_TELEPHONE, #CONTACT_FAX, #CONTACT_MOBILE, #CONTACT_EMAIL to list of tags that can be used in the email templates Items affected: lbeweb40.dll ======================================================================================= 4.0.0.111 ======================================================================================= 1. Linked file options not shown if no linked file location specified 2. Login page shows correct errors for incorrect username/passwords. Items affected: linked.asp, pagehead.asp, jobupdate.asp,jobsel.asp, lbeweb40.dll ======================================================================================= 4.0.0.110 ======================================================================================= Fixed Type mismatch jobedit.asp, line 270 if using Oracle Items affected: jobedit.asp, lbeweb40.dll ======================================================================================= 4.0.0.109 ======================================================================================= 1. Fixed: Operator who was only allowed to see own jobs, could see others if enter operator name in search box. 2. Fixed error if using MS Sql on non-English regional settings and choose Priority target due date/time using "ON" Items affected: jobsel.asp, lbeweb40.dll ======================================================================================= 4.0.0.108 ======================================================================================= 1. Fixed "invalid use of null" problem on spending report Items affected: repop1.asp ======================================================================================= 4.0.0.107 ======================================================================================= 1. Added reminder about trial username/password Items affected: oplogin.asp ======================================================================================= 4.0.0.106 ======================================================================================= 1. Fixed problem with target datetime if have custom priorities for a category. Items affected: jobedit.asp ======================================================================================= 4.0.0.105 ======================================================================================= 1. More validation on Priority target values Items affected: priupdate.asp ======================================================================================= 4.0.0.104 ======================================================================================= 1. Fixed: Completion date/time updated everytime action a job. Items affected: jobedit.asp ======================================================================================= 4.0.0.103 ======================================================================================= 1. Improved loading speed of jobedit.asp page if have a lot of categories. Items affected: jobedit.asp, lbeweb40.dll ======================================================================================= 4.0.0.102 ======================================================================================= 1. If sending via SMTP the recipient must have an internet style email address (x@y.com) 2. Changed "message not sent" text on jobupdate.asp Items affected: lbeweb40.dll, jobupdate.asp ======================================================================================= 4.0.0.101 ======================================================================================= 1. Fixed - change Category prompted for reset target date time even if no custom workhours or priorities. 2. Fixed - javascript error on changing category in jobedit.asp 3. Sending an email is recorded in the job history. 4. Fixed bug if using search box, clicking SELECT show window with all contacts Items affected:jobedit.asp, mailsend.asp, lbeweb40.dll ======================================================================================= 4.0.0.100 ======================================================================================= 1. Fixed bug if add a category using the + button on the Jobedit page. 2. Fixed bug if add asset using the + button on the Jobedit page. 3. Replaced "forename" with "firstname", "surname" with "Lastname" Items affected:jobupdate.asp, lbeweb40.dll, contactedit.asp, contactsel.asp,gstreg.asp ======================================================================================= 4.0.0.99 ======================================================================================= 1. Added #ASSET_CUSTOM1 and #ASSET_CUSTOM2 to list of allowed email template tags 2. Re-wording of "Edit and send the mail message" on jobupdate.asp to highlight that in preview mode, the message is not sent yet. Items affected: lbweb40.dll, jobupdate.asp ======================================================================================= 4.0.0.98 ======================================================================================= 1. Fixed "70 Permission denied" bug Items affected: lbweb40.dll ======================================================================================= 4.0.0.97 ======================================================================================= 1. Fixed problem: if use Firefox browser, operators restricted to one customer could still see all customers. 2. Priority not changing on jobedit.asp Items affected: lbweb40.dll, jobedit.asp ======================================================================================= 4.0.0.96 ======================================================================================= 1. Can now specify allowable Priorities for each Category. If no limits specified for a category, all priorities are allowed 2. Can now specify different work hours for a category. 3. Operator A cannot assign a job for customer B to Operator C if Operator C is not allowed to see Customer B 4. Different email addresses may be used for auto-esalation notification based on category 5. Job's created by end-users will be sent to operator dependent on the category. If no specific notification contacts have been specified for a category, the operator named "Not Assigned" will be notified as per current functionality. 6. Fixed bug - custom labels not displayed on Edit Category page. Items affected: lbeweb40.dll, catsel.asp, dbfunc.asp, jobsel.asp, jobedit.asp, selhead.asp, assetedit.asp,contactedit.asp, deptedit.asp, catedit.asp, catupdate.asp, jobupdate.asp, maintmain.asp, workhrs.asp, whrsupd.asp,escntfy.asp, help.htm New files: catpriupdate.asp, cat_pri_assoc.asp Database Changes ================ If you are not sure how to implement these changes, please contact LBE ACCESS: ====== CREATE TABLE cat_pri_assoc (pri_id long not null, cat_id long not null, CONSTRAINT pk_cat_pri PRIMARY KEY (pri_id,cat_id)) ; ALTER TABLE workhrs add column cat_id long not null; update workhrs set cat_id=0; alter table workhrs drop constraint wrkhrs_idx; alter table workhrs add CONSTRAINT pk_workhrs PRIMARY KEY (dayno,cat_id); alter table categories add column op_id long not null; alter table categories add column escal_email text (255) null; alter table categories add column escntfyop text (1) null; update categories set op_id=0 where op_id is null; INSERT INTO Workhrs ( cat_id, DayNo, DayName, StartHrs, StartMins, EndHrs, EndMins, globid ) SELECT Categories.Category_Id, Workhrs.DayNo, Workhrs.DayName, Workhrs.StartHrs, Workhrs.StartMins, Workhrs.EndHrs, Workhrs.EndMins, Workhrs.globid FROM Categories, Workhrs WHERE Workhrs.cat_id=0; MS SQL SERVER: ============== USE lbehelpdesk GO CREATE TABLE [dbo].[cat_pri_assoc] ( [pri_id] [int] NOT NULL , [cat_id] [int] NOT NULL ) ON [PRIMARY] GO ALTER TABLE workhrs add cat_id int not null default 0 GO alter table workhrs drop constraint PK_workhrs GO alter table workhrs add CONSTRAINT pk_workhrs PRIMARY KEY (dayno,cat_id); GO alter table categories add op_id int not null default 0; GO alter table categories add escal_email varchar (255) null; GO alter table categories add escntfyop varchar (1) null; GO update categories set op_id=0 where op_id is null; GO INSERT INTO Workhrs ( cat_id, DayNo, DayName, StartHrs, StartMins, EndHrs, EndMins, globid ) SELECT Categories.Category_Id, Workhrs.DayNo, Workhrs.DayName, Workhrs.StartHrs, Workhrs.StartMins, Workhrs.EndHrs, Workhrs.EndMins, Workhrs.globid FROM Categories, Workhrs WHERE Workhrs.cat_id=0; GO GRANT SELECT , INSERT , DELETE , UPDATE ON [dbo].[cat_pri_assoc] TO [lbe_user] GO ORACLE: ====== CREATE TABLE cat_pri_assoc ( pri_id number (11,0) not null, cat_id number (11,0) not null, CONSTRAINT pk_cat_pri PRIMARY KEY (pri_id,cat_id)) ; ALTER TABLE workhrs add cat_id number (11,0) default (0) not null; alter table workhrs drop constraint PK_workhrs; alter table workhrs add CONSTRAINT pk_workhrs PRIMARY KEY (dayno,cat_id); alter table categories add op_id number (11,0) default (0) not null ; alter table categories add escal_email varchar2 (255) null; alter table categories add escntfyop varchar2 (1) null; update categories set op_id=0 where op_id is null; INSERT INTO Workhrs (cat_id, DayNo, DayName, StartHrs, StartMins, EndHrs, EndMins, globid ) SELECT Categories.Category_Id, Workhrs.DayNo, Workhrs.DayName, Workhrs.StartHrs, Workhrs.StartMins, Workhrs.EndHrs, Workhrs.EndMins, Workhrs.globid FROM Categories, Workhrs WHERE Workhrs.cat_id=0; GRANT SELECT , INSERT , DELETE , UPDATE ON cat_pri_assoc TO lbe_user; connect lbe_user/lbe; create synonym cat_pri_assoc for lbe_owner.cat_pri_assoc; commit; ======================================================================================= 4.0.0.95 ======================================================================================= 1. Fixed bug in searching on asset custom fields 2. Added #CONTACT_CUSTOM1 and #CONTACT_CUSTOM2 to list of tags that can be used in email templates Items affected: assetsel.asp, lbeweb40.dll ======================================================================================= 4.0.0.94 ======================================================================================= 1. Changed wording on evaluation page Items affected: eval.asp ======================================================================================= 4.0.0.93 ======================================================================================= 1. Fixed bug in uploaded filename generated when linked file location is specified by IP address. 2. Added Uncheck All/Check All buttons for operator privileges Items affected: upload.asp, opedit.asp, lbeweb40.dll ======================================================================================= 4.0.0.92 ======================================================================================= 1. Modify summary_rpt database table - increase username field size to 50 char. To implement this change, you will to modify the database, if you are not sure how to do so, please contact LBE. Items affected:database ======================================================================================= 4.0.0.91 ======================================================================================= 1. Fixed incorrect setting of asset purchase/disposal dates Items affected: assetsel.asp, assetupdate.asp, assetedit.asp, lbeweb40.dll ======================================================================================= 4.0.0.90 ======================================================================================= 1. Fixed linked file error if using Oracle. Run the following query: Delete from gridexsql where type = 'LINKEDFILES'; INSERT INTO gridex3 (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.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)'); 2. Fixed incorrect searching on customers page. Items affected:database, custsel.asp ======================================================================================= Version 4.0.0.90 ======================================================================================= 1. Included note that you can specify multiple email adresses separated by semi-colon. 2. Added option to sort customers and assets by contract expiry and job allowance Items affected:opedit.asp, contactedit.asp, custsel.asp,assetsel ======================================================================================= Version 4.0.0.88 ======================================================================================= 1. Fixed bug that meant "see all operator jobs" operator privilege was not updated correctly. Items affected: lbeweb40.dll ======================================================================================= Version 4.0.0.87 ======================================================================================= 1. Fixed bug that caused error if operator created in the web helpdesk is used in the desktop helpdesk. Items affected: lbeweb40.dll ======================================================================================= Version 4.0.0.86 ======================================================================================= 1. Modification to jobsheet to include customer name Items affected:jobsel.asp ======================================================================================= Version 4.0.0.85 ======================================================================================= 1. Can now restrict most reports to jobs with specific Job Status values. Items affected: lbeweb40.dll, daterange.asp,repact.asp, repcommon.asp,repspent.asp,repspent1.asp,repspent2.asp,repspent3.asp,repspent4.asp, repspencus.asp,repspencon.asp,repspendep.asp,repop1.asp ======================================================================================= Version 4.0.0.84 ======================================================================================= 1. Support for Portugese version 2. New installation helpfile (webinstall.htm) Items affected: lbeweb40.dll, lbewebconfig.exe, webinstall.htm ======================================================================================= Version 4.0.0.83 ======================================================================================= 1. Job edit page now doesn't show Cateogories marked as deleted in the database. 2. Date format is now independent of the web server's regional setting and solely controlled by the date order chosen in the configuration tool. 3. Auto-escalation is recorded in the job history 4. Modified testfile.asp 5. Added two jpg files showing correct setup in Internet Services Manager (used by testfile.asp) 6. Added testsession.asp used for trouble-shooting some installations. Items affected: datefunc.asp,jobsel.asp,assetsel.asp,custsel.asp,repact.asp, repcomp1.asp,repjpm.asp, repjpw.asp,repop1.asp,repspent.asp,repspent3.asp, testfile.asp,testession.asp,websetup1.jpg,websetup2.jpg, lbeweb40.dll ======================================================================================= Version 4.0.0.82 ======================================================================================= 1. Job search page now remembers how many records you want to see per page (requires browser to accept cookie) 2. Links to subsequent pages appear above and below search results Items affected: jobsel.asp ======================================================================================= Version 4.0.0.81 ======================================================================================= 1. Fixed potential minor SQL server security vulnerability 2. Added a default index.htm page Items affected: index.htm, jobedit.asp,assetedit.asp,astedit.asp,catedit.asp,contactedit.asp,custedit.asp deptedit.asp,linkedit.asp, opedit.asp, priedit.asp ======================================================================================= Version 4.0.0.80 ======================================================================================= 1. Fixed incorrect display of
in Problem and To Do Items affected: Items affected: jobsel.asp, ======================================================================================= Version 4.0.0.79 ======================================================================================= 1. Custom fields can now be displayed as drop-down selection lists. Items affected: custom.asp, selhead.asp, assetedit.asp,astedit.asp, catedit.asp, contactedit.asp, custedit.asp, deptedit.asp, opedit.asp, jobedit.asp,jobsel.asp,jobsrch.asp,priedit.asp ======================================================================================= Version 4.0.0.78 ======================================================================================= 1. Added tag in change password screen 2. Removed superfluous tag in oplogin.asp Items affected: oplogin.asp, chgpwd.asp ======================================================================================= Version 4.0.0.77 ======================================================================================= 1. Fixed potential formatting problem of Job History on Job Detail view. 2. Email escalation notification was specifying previous priority. Items affected: jobsel.asp, lbeweb40.dll ======================================================================================= Version 4.0.0.76 ======================================================================================= 1. Bug fix for french version 2. Correct formatting of #OPLOGIN tag in email template when operator names contains spaces Items affected: lbeweb40.dll ======================================================================================= Version 4.0.0.75 ======================================================================================= 1. Support for French version. 2. Guests can see their linked files. Items affected: lbeweb40.dll, lbewebconfig.exe, jobsel.asp, linksel.asp ======================================================================================= Version 4.0.0.74 ======================================================================================= 1. Fixed potential formatting problem on job search page. 2. Fixed date problem with Sql Server if day of month < 10 Items affected: jobsel.asp, lbeweb40.dll ======================================================================================= Version 4.0.0.73 ======================================================================================= 1. Fixed error when search Operators on email address 2. Job detail view showing Job Status and Completion status swapped around Items affected: Opsel.asp, jobsel.asp, lbeweb40.dll ======================================================================================= Version 4.0.0.72 ======================================================================================= 1. Inserted extra explanation of common login error on the operator login page. 2. Additional metatag to prevent caching. 3. Fixed bug, which if already logged in, allowed one to log in with an invalid username/password, 4. Fixed bug, which if operator restricted to one customer, could still see all Assets on the Action Job page. 5. Fixed javascript bug with reports when restricted to one customer only. 6. Fixed date related syntax errors when using Sql Server with some regional settings. 7. New configuration utility instead of manually editing global.asa 8. Fixed "input past end of file" bug if newjob.txt file is empty. Items affected: oplogin.asp, pagehead.asp, jobedit.asp, daterange.asp, repcommon.asp, repcomp1.asp, repop1.asp, repspencus.asp, repspencon.asp, repspendep.asp, repspent2.asp, repspent3.asp, repspent1.asp, repspent4.asp, datefunc.asp, help.htm, lbeweb40.dll, lbewebconfig.exe No database changes ======================================================================================= Version 4.0.0.71 ======================================================================================= 1. Email templates now give you complete control over email content. Please see "Customize e-mails sent by the helpdesk" in the help. 2. Can now select which Customer (or "All Customers") that are included in reports 3. Several operator-related reports now allow you to select which operator (or all) is included in the report. 4. Support for Spanish version (see Allcybersites Corporation - allcybersites@cantv.net for more information) 5. If an operator is only allowed to see 1 customer, this affects **ALL** reports. 6. Fixed bug when adding operator from the Jobs page using + buttons 7. Fixed bug when adding customer from dept page using the + button 8. Removed dropdown on Action Job page to select Action notes or History for the email as this is now controlled by the templates. 9. Email check boxes on Action Job page now remember their values correctly. 10. Version number displayed on web page reflects the lbeweb40.dll version number. 11. Fixed bug which would overstate numbers on the "Number of Jobs Completed by Operator Per Month/Week" reports 12. Removed repsel.asp, repedit.asp, repupdate.asp as these were never implemented. 13. Fixed incorrect results from "Number of Jobs Completed by Operator Per Month/Week" reports. 14. Fixed incorrect results from "Average spending by Operator" reports. 15. Prevented double-clicking of submit on the login page, this will help to stop phantom logins. 16. "Spending by Operator and Category" report now excludes any with zero money and time spent. 17. Mailtag value removed from global.asa as no longer necessary due to email templates feature. Items affected: lbeweb40.dll, Jobupdate.asp, deptupdate.asp, help.htm, johedit.asp, daterange.asp, repact.asp, repcommon.asp, repcomp1.asp, repjpm.asp, repjpw.asp, repop1.asp, repperast.asp, reppercat.asp, reppercon.asp, reppercus.asp, repperdep.asp, repperop.asp, repperpri.asp, repspencon.asp, repspencus.asp, repspendep.asp, repspent.asp, repspent1.asp, repspent2.asp, repspent3.asp, repspent4.asp, respsel.asp, repedit.asp, repupdate.asp 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 ======================================================================================= Version 4.0.0.70 ======================================================================================= 1. Guest login must use the complete email address (not just a portion) of the email address registered. 2. If operator was limited to a single customers, it was still possible to see all jobs in some cases. 3. Re-formatted knowledge base results table. 4. Can now click on End-user in Asset search page to go direct to the Customer Contacts Page for that person. 5. When creating a new job and using search boxes, can now enter a Customer Name and click Select to search on. 6. Fixed bug if used + button to add new contact on job page when using organization type C Items affected: lbeweb40.dll, jobsel.asp, kb.asp, assetsel.asp, selhead.asp ======================================================================================= Version 4.0.0.69 ======================================================================================= 1. Added customer signature box to jobsheet 2. 'Hidden' customer contacts (edit the database, set the deleted column to 1), are no longer shown in the dropdown lists when creating a new job. Items affected: jobsel.asp, jobedit.asp, lbeweb40.dll ======================================================================================= Version 4.0.0.68 ======================================================================================= 1. Recompiled dll with options to overcome a memory leak issue with the VB runtime. 2. Fixed syntax error bug in securent.asp lbeweb40.dll, securent.asp ======================================================================================= Version 4.0.0.67 ======================================================================================= 1. On Hold Jobs can now be included/excluded from Helpdesk Activity reports 2. Minor bug fixes lbeweb40.dll, jobedit.asp, jobsel.asp, repact.asp, daterange.asp ======================================================================================= Version 4.0.0.66 ======================================================================================= 1. Fixed bug which could affect sending of email if your mailservertype in global.asa is SMTP or MAPI 2. Securent.asp now checks the Contact record's Custom1 and Custom2 field for the NT username. 3. Fixed non-sending of email if your mailservertype in global.asa is ASPEMAIL or CDONTS and are not previewing message first. 4. Fixed "not a valid month" error with certain Oracle language settings. 5. Added link to help on pageheader for guests 6. Included Category in Jobs search summary view 7. Incorporated separate MailSenderName (required by some mail installations). 8. On Hold jobs are excluded from the Helpdesk Activity report. 9. 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). 10. When a "Default Contact" is created, any e-mail address specified for the customer is copied to the new contact. 11. Job edit window remembers the e-mail checkbox settings you used last time. Items affected: lbeweb40.dll, global.asa, browser.asp, selhead.asp, selfoot.asp, securent.asp, mailsend.asp, gstlogin.asp, jobupdate.asp, pagehead.asp, jobsel.asp, custedit.asp, custsel.asp, custupdate.asp contactedit.asp, contactsel.asp deptedit.asp, deptsel.asp assetedit.asp, assetsel.asp, linkedit.asp, linksel.asp, jobedit.asp, jobsel.asp, opedit.asp, opsel.asp, repact.asp, edittip.asp, reppercon.asp, reppercus.asp, repperdep.asp repspencon.asp, repspencus.asp, repspendep.asp, database (see below) ACCESS ====== 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') You will need MS Access 2000 to run this query. If you don't have it or are not sure how to run queries in Access, please contact support@lbehelpdesk.com 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 ======================================================================================= Version 4.0.65 ======================================================================================= 1. Email notification now has correct order: Problem/To Do/Solution, not Problem/Solution/To do 2. Increased width of fields in guest registration page Items affected: lbeweb40.dll, gstreg.asp ======================================================================================= Version 4.0.64 ======================================================================================= 1. Knowledge base search now searches Solution as well as Problem. 2. Email notification to Customer Contact/Operator now include the Contact's email/Operator name. 3. Jobsheet display now include solution if there is one. Items affected: lbeweb40.dll, oplogin.asp, gstlogin.asp, secure.asp, kb.asp, jobsel.asp ======================================================================================= Version 4.0.0.63 ======================================================================================= 1. New password encryption Items affected: lbeweb40.dll, oplogin.asp ======================================================================================= Version 4.0.0.62 ======================================================================================= 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: lbeweb40.dll, jobedit.asp ======================================================================================= Version 4.0.0.61 ======================================================================================= 1. If preview Job message before sending, and if only the operator is receiving the message, url for the direct link to the job now goes via the oplogin page. If the guest is receiving the message (regardless of whether the operator is also included in the recipients), the url goes via gstlogin.asp 2. "Actioned by" defaults to the logged in operator Items affected: lbeweb40.dll, jobedit.asp ======================================================================================= No Version change - modification to jobedit.asp only ======================================================================================= 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 web helpdesk Items affected: jobedit.asp, new file:newjob.txt. Copy both files into the folder you installed LBE Web Helpdesk into. ======================================================================================= Version 4.0.0.60 ======================================================================================= 1. Fixed error when deleting Operator if using Sql Server as the database Items affected: Sql Server database change only SQL SERVER ========== Run the following from SQL Server Query Analyzer: use lbehelpdesk GO ALTER TABLE [dbo].[opactivity] drop CONSTRAINT [FK_opactivity_jobs] GO ALTER TABLE [dbo].[opactivity] drop CONSTRAINT [FK_opactivity_users] GO ======================================================================================= Version 4.0.0.59 ======================================================================================= 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. 2. Now sends different messages to operator and contact, the job link now takes them to the appropriate login page. Items affected: lbweb40.dll, escntfy.asp, linked.asp ======================================================================================= Version 4.0.0.54 ======================================================================================= 1. Email link in confirmation email sent to customer contact now takes them to the guest login, not operator login. 2. Linked files can now appear as http: links. See new section in global.asa Items affected: lbweb40.dll, secure.asp, global.asa linksel.asp, linkupdate.asp, help.htm N.B. Back up your existing global.asa and copy your settings from the old to the new global.asa No database changes. ======================================================================================= No Version change, modified asp pages only ======================================================================================= 1. Can now create a new job direct from the Asset search page 2. When create a new job, a contact is not pre-selected (unless you have clicked the link from Customers, Dept, Contact or Assets) Items affected: assetsel.asp, jobedit.asp No database changes. No dll changes. ======================================================================================= Version 4.0.0.53 ======================================================================================= 1. Fixed reports: Helpdesk Spending per Customer Helpdesk Spending per Customer/Department Helpdesk Spending per Customer/Department/Contact 2. Fixed "Invalid use of Null" when saving a new job if using Oracle database. 3. Fixed error when add a new operator using the + button whilst Actioning a Job Items affected: lbeweb40.dll, repspencus.asp, repspendep.asp, repspencon.asp, jobupdate.asp No database changes. ======================================================================================= Version 4.0.0.52 ======================================================================================= 1. Fixed minor SQL Server related bugs. ======================================================================================= Version 4.0.0.50 ======================================================================================= 1. Job History does not repeat "ASSIGNED TO:" information unless this changes. 2. Addition of a new feature sends notification email to assigned operator and/or specified email address when a job is automatically escalated. 3. When a Guest has a Job open, the "Currently Open By" shows the guest's email address rather than "Guest" 4. Minor correction to uploaded filename to use "/" rather than "\" The following have been changed/added: 1. New page (escntfy.asp) to manage notification options. 2. Modifications to the following pages: maintmain.asp, opedit.asp, opupdate.asp, jobsel.asp, jobedit.asp, jobupdate.asp, secure.asp, pagehead.asp, pagehead_autorefresh.asp, upload.asp, testfile.asp 3. A replacement dll - Unless you have installed the complete new setup for this version, you will need to re-register lbeweb40.dll with regsvr32 4. Modifications to the database. If you are upgrading an earlier database, you will have to run the following queries: ACCESS ===== Open the database in Access 2000 and run the following queries 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.0.43 28 Sep 2001 ======================================================================================= Fixed bug when editing job and add new contact using the + button - only applied if using organization type B. ======================================================================================= Version 4.0.0.41 27 Aug 2001 ======================================================================================= (changes to .asp pages only) 1. Fixed duplication of Address line 4 in Job History (jobsel.asp). 2. Fixed incorrect formatting if Job history contain a url tag(jobsel.asp). 3. Modified format of date on Asset edit page (assetedit.asp) 4. Page header reformatted to fill page width (pagehead.asp) 5. Edit job page reformatted to fill page width (jobedit.asp) ======================================================================================= Version 4.0.0.40 21 July 2001 ======================================================================================= 1. E-mail generated when action a Job does not contain a "TO DO" section if the "To Do" is empty ======================================================================================= Version 4.0.0.38 June 10 2001 ======================================================================================= 1. Fixed problem which might give "Unterminated string constant" when click on link to action a Job which is already opened by another operator. 2. Fixed missing "Organization structure" link on Maintenance and relevant checkbox on Edit operator. ======================================================================================= Version 4.0.0.35 June 4 2001 ======================================================================================= 1. Jobedit.asp - addition of client-side javascript to prevent double-clicking of the submit button 2. Assetsel.asp - fix to bug which gave incorrect results when searching for a particular asset type 3. Securent.asp - fix to retrieve username correctly when accessed from a DMZ ======================================================================================= Version 4.0.0.33 May 2001 ======================================================================================= No version change, just update to jobsel.asp which implements a warning message if an operator tries to Action a Job that is already being Actioned by another user. Also prevents a Guest users from Actioning that Job in the same circumstances. ======================================================================================= Version 4.0.0.33 May 2001 ======================================================================================= 1. Error "You tried to commit or rollback a transaction without first beginning a transaction" when close parent job with one child Job which has been completed 2. Fixed problems with NT authenication (securent.asp) 3. Change to Detailed Operator Activity sorted by Operator/Date to allow you to select a particular operator (or all), and to display the first 255 characters of the Problem. This makes these reports more suitable as the basis for timesheets. 4. The ability to specify which closed jobs are in the Knowledge base. 5. Fixed minor bug in Assets selection when Customer name contains an apostrophe. ======================================================================================= Version 4.0.0 Mar 2001 ======================================================================================= Automatic escalation. Link files to Jobs - useful for e.g. screen dumps of error messages. New Job Status - 'On Hold'. Cascading deleted - e.g. deleting a Customer will delete all related records. Can hide records (e.g. Customers) without deleting them. Manage support contracts by expiry date and/or number of new Jobs. Job Target date changes when select a new Priority. Complete control over what Customer/Dept/Contact address information is included in the History. Close any child Jobs when closing a Parent Job. Individual Action Notes now stored in Operator Activity as well as in the Job History Optionally allow operator to only see those Jobs assigned to them. Specify Organization Structure that you are supporting and the system adapts. E.g. if you are dealing with internal customers only, select "Single Customer, Multiple Departments" and the system will hide references and input fields related to Customer in most windows Use of drop-downs/search boxes is now a personal preference which can be chosen by each operator. Link Assets to Contacts. ======================================================================================= Version 1.4 Aug 2000 ======================================================================================= Support for Oracle. Option to use search boxes (not dropdowns) for Customer/Dept/Contact/Asset selection. New child jobs now inherit the parent's contact and asset. Only changed items are put into Job History when a Job is actioned. Option to select Ascending or Descending sort order on search pages. Search pages automatically retrieve when first select them. Color coding in Jobs Search page dependent on Status (see lbe.css style sheet if you wish to change the colors). Hide custom fields if you make the name of the custom field empty. Fixed several minor bugs. ======================================================================================= Version 1.3 July 2000 ======================================================================================= Complete re-design of web pages. Merged previous Professional and Enterprise editions into one version that can use either MS Access or MS Sql Server as a database. Greater control over customer information that appears in Job History. Empty fields don't appear on the Search pages. ======================================================================================= Version 1.2 July 1999 ======================================================================================= Initial release