User Defined Reports / Custom Reports

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

Andrew Carrick · July 28, 2010, 08:52:36 AM

I believe they're in the SAVE.... DBF files.

andrew_ashby · July 28, 2010, 09:13:56 AM

Thanks . Can't find a SAVE directory - we have a SAFE directory & an SAV directory.

Andrew Carrick · July 28, 2010, 09:16:19 AM

The ones we have are in applied\TAM folder, along with the other DBF files.

andrew_ashby · 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

Hans Manhave · 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.

Ian Blundell · 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.

andrew_ashby · 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 !