Let us help. Let us help. Eitex is a leading IT Support company offering Cloud Computing, Microsoft Office 365, Microsoft CRM, Sage, IT Support, Computer and Network Support throughout Yorkshire and the UK. If your IT isn’t up to scratch, we can help!

Find out more about Eitex
Get a quote now

Thursday, 3 September 2009

Sage running slow when using Sophos

For Sage to run at optimal performance Sage recommend excluding certain file extensions from with Sophos or your anti-virus software.

The following file types may be excluded from the file scan:

Data Files:

*.DTA
*.DTH
*.COA

Report and Layout Files:

*.SRT
*.SLY
*.SLT
*.SLB
*.RPT

Sage 50 Accounts:

*.report
*.layout
*.letter
*.label

Memo Files:

*.SLM
*.PLM
*.NLM
*.ILM
*.BLM
*.CLM
*.DLM

Criteria Files:

Note: In the case of criteria files, the * represents the Sage Accounts user name that created the file. For example, Manager.slc

*.SLC
*.SLI
*.PRC
*.PRI
*.NMC
*.NMI
*.BKC
*.BKI
*.SKC
*.SKI
*.IVC
*.IVI
*.SPC
*.SPI
*.PCC
*.PPI
*.PCI
*.REC
*.REI
*.SAC
*.SAI
*.IPC
*.IPI
*.PDC
*.PDI

Sage Reports:

Edit Logon.bat > \\servername\NETLOGON\logon.bat

Add these lines:

cd C:\Program Files\Sage\Accounts\
mkdir Reports_Temp

1. Open the Windows registry and locate the following key:

HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\SageLine50v15

2. Within this key, create a new String Value called TempPathname.

Note: TempPathname is case sensitive. Using the wrong case causes an error message when running reports in Sage Accounts.

3. Modify the String Value and in the Value data box, type in the path to the folder where you want the temporary files to be created (This is the location of the folder that is being created in the logon script)

4. You can now configure your anti-virus software to exclude the following file types specifically in this folder:

*.TMP
*.000
*.001
*.002

All reports will be placed in here and not scanned by Sophos.

Hope this works for you. If you have any issues please feel free to contact us.

Dean Spencer
Eitex IT Support

No comments:

Post a Comment

Subscribe to Eitex IT Support by Email

Eitex on LinkedIn

Copyright © Eitex 2008 | Site Map | Blog Created by Eitex IT Support

Eitex is a registered trading name of Expert Systems Ltd, The Meeting Rooms, Boothroyd Lane, Dewsbury. WF13 2LP