Applied Users Forums

General Topics => Helpline => Topic started by: andrew_ashby on July 28, 2010, 08:00:05 AM

Title: User Defined Reports / Custom Reports
Post by: andrew_ashby on July 28, 2010, 08:00:05 AM
Hi

Can anyone tell me where the user defined reports are stored & what file format they are stored in ?

I need to restore a user defined report that I think has become corrupted.
Title: Re: User Defined Reports / Custom Reports
Post by: Andrew Carrick on July 28, 2010, 08:52:36 AM
I believe they're in the SAVE.... DBF files.
Title: Re: User Defined Reports / Custom Reports
Post by: andrew_ashby on July 28, 2010, 09:13:56 AM
Thanks . Can't find a SAVE directory - we have a SAFE directory & an SAV directory.
Title: Re: User Defined Reports / Custom Reports
Post by: Andrew Carrick on July 28, 2010, 09:16:19 AM
The ones we have are in applied\TAM folder, along with the other DBF files.
Title: Re: User Defined Reports / Custom Reports
Post by: andrew_ashby on July 28, 2010, 09:40:06 AM
I think that 10.2 might be different form 7.6. I thought that customer reports were not stored as .dbf
Title: Re: User Defined Reports / Custom Reports
Post by: Hans Manhave on July 28, 2010, 10:57:53 AM
TAM 9.3 also has them in the TAM folder.

A way to quickly find out: Open Wintam reports on your desktop, open the Open Files listing on your server and see where your user code has open files.  You'll most likely find the interesting data files at the TAM folder. 

I understand that this does not make restoring very easy.
Title: Re: User Defined Reports / Custom Reports
Post by: Ian Blundell on July 29, 2010, 12:23:36 PM
I think that you have to have saved the custom report to the infamous 6 files in order to be able to restore from a backup of those files.
I've attached a copy of the instructions but if your report is already corrupted and you haven't backed it up yet then I think that you may be up a creek without a paddle.
Title: Re: User Defined Reports / Custom Reports
Post by: andrew_ashby on July 30, 2010, 09:37:58 AM
Thanks Ian.

I've got a pre-upgrade back up on an external hard drive - but presumably I'd have to restore the data on the live server to 'back up' the two reports.

BUT, I've got a cold emergency server at home that I normally restore the live data to weekly but which I haven't restored to since the upgrade. I can presumably create back up files from the emergency server & try installing them onto the live server !