EpicorData Reports folders

Both the Temp Folder and the Reports folder should be cleared out on a
regular basis.

First, the Reports folder should not be the same as the Temp Folder.
Unfortunately with Epicor 9.05 they are by default the same location.

If you use your EpicorData folder as your Reports folder, then check your
.pf files in Epicor905\server\config and make sure the -T is not the same
folder, usually when I install for a customer I change it to something like
EpicWork or EpicorTemp. The Temp folder can also be set during the install
process, I always change it at that point when I do the install, otherwise I
made the edit manually in the .pf files.

You should clean these folders out for performance reasons because of how
the system works. For a report to be pulled up for a client, it polls the
reports\username folder for new files, when it polls it needs to check every
file, the more files the more it needs to scan the longer it will take.

There are some .bat files and some .vbs files that exist out there I used to
use when I was working for Epicor, and I know versions of them are still
being used by the installation consultants for Epicor. I have spent a great
deal of time trying to find a simpler alternative to these files, and I
eventually found a little known utility that is built into both Windows 2003
and Windows 2008/R2.

The program is called forfiles, and I would recommend using this to clear
out all temp files and report folders. The best part of it is that it can be
used to removed files that are older than a specific amount of time without
needing to really do any type of scripting and it can also be used to
recourse through subdirectories which reduces even more need for scripting.

I put this in a batch file, assuming Epicor is on the E: Drive with
EpicorTemp as the Temp folder, and EpicorData as the Reports share and to
delete all files more than 7 days old.

forfiles /p "E:\EpicorData\Reports" /s /m *.* /c "cmd /c Del @path" /d -7
forfiles /p "E:\EpicorTemp" /s /m *.* /c "cmd /c Del @path" /d -7

/p sets the @path variable
/s tells the program to recourse sub directories
/m sets the mask for the files, you can use *.rpt or *.xml if you wanted to
delete specific files
/c sets the command to be used, in this I use the del command
/d sets the time period relative to the current date, -7 is for anything 7
or more days old.

I don't do just the base EpicorData folder since that can hold other files
that you don't want to delete.

In relation to what Vic said, while most people do leave most user folders
in the reports folder completely open in terms of security, if you do have a
user who is going to be printing sensitive reports like payroll, commission,
etc then it is best if you use NTFS permissions to secure that users folder,
it's easier and less maintenance to just secure the unique cases.


Ned
Alternative Technology Solutions




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Nancy
Sent: Thursday, January 26, 2012 3:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] EpicorData Reports folders

Good Afternoon,

Can anyone tell me their standard procedure for dealing with the
EpicorData/Reports folders? Our server admin likes to clean these out to
"free up space" occasionally.

I like to keep the report data to help with troubleshooting report/Crystal
errors and determining who is running what reports, for emailing particular
populations. Finally, seeing if someone is running a huge report with no
filters, and they don't need to do it, has been important in the past as
well. Sometimes the users don't even realize that they are doing this, they
just think their report is failing.

Is it usual for server admins to clear these user folders out or does it
seem to be unnecessary?

Thanks ~
Nancy



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Good Afternoon,

Can anyone tell me their standard procedure for dealing with the EpicorData/Reports folders? Our server admin likes to clean these out to "free up space" occasionally.

I like to keep the report data to help with troubleshooting report/Crystal errors and determining who is running what reports, for emailing particular populations. Finally, seeing if someone is running a huge report with no filters, and they don't need to do it, has been important in the past as well. Sometimes the users don't even realize that they are doing this, they just think their report is failing.

Is it usual for server admins to clear these user folders out or does it seem to be unnecessary?

Thanks ~
Nancy
I empty mine nightly. I see no need to keep that mess on there. I also empty \mfgwrk803 nightly. (via BAT file)

It also poses a security risk. Most of us probably have those folders wide open, unrestricted. So, hypothetically, “Frank in Marketing” could browse to that folder and see “Jane in Finance’s” confidential payroll/financial reports.



From: Nancy
Sent: Thursday, January 26, 2012 3:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] EpicorData Reports folders


Good Afternoon,

Can anyone tell me their standard procedure for dealing with the EpicorData/Reports folders? Our server admin likes to clean these out to "free up space" occasionally.

I like to keep the report data to help with troubleshooting report/Crystal errors and determining who is running what reports, for emailing particular populations. Finally, seeing if someone is running a huge report with no filters, and they don't need to do it, has been important in the past as well. Sometimes the users don't even realize that they are doing this, they just think their report is failing.

Is it usual for server admins to clear these user folders out or does it seem to be unnecessary?

Thanks ~
Nancy




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4768 - Release Date: 01/26/12


[Non-text portions of this message have been removed]