Applied Users Forums

General Topics => Helpline => Topic started by: Andrew Carrick on June 07, 2011, 09:44:09 AM

Title: Rename query
Post by: Andrew Carrick on June 07, 2011, 09:44:09 AM
Could somebody remind me please which log file holds previous rename lists? I'm sure there is one somewhere...
Title: Re: Rename query
Post by: GeorgeW on June 07, 2011, 10:09:15 AM
Not sure if there is an easier way to get this info, but I go into Utility manager (outside of TAM), into the Rename Program and then click on "options" and "History". You click on a date and it will show you what was renamed.
Title: Re: Rename query
Post by: Andrew Carrick on June 07, 2011, 10:15:37 AM
Nice one, thanks George.

Must be in some file somewhere though I guess.
Title: Re: Rename query
Post by: Alice on June 07, 2011, 11:19:55 AM
Andrew - there is a log in the Log folder if you catch it before anyone starts queuing more renames. Once that starts it gets over written. I took a look at the WRENLOG.DBF and it looks weird in that the old code and new code columns are in date (old) and time (new) format. I can mess with it some more to see if I can get it to make sense.
Title: Re: Rename query
Post by: Andrew Carrick on June 07, 2011, 11:23:48 AM
Looks like that is what the Utility is reading, cheers for that Alice. The queued items go into NIGHTREN.QUE in TAM/SAV.

It is satisfying knowing what is where and how they connect (sadness/geek rating 5).
Title: Re: Rename query
Post by: Alice on June 07, 2011, 12:09:59 PM
There's rename info in the  wiki  ;)
Title: Re: Rename query
Post by: GeorgeW on June 07, 2011, 01:05:16 PM
But those logs you all mention only show "queued" items correct?  I thought the original question was about previous renames?
Title: Re: Rename query
Post by: Alice on June 07, 2011, 01:11:17 PM
After rename processes, the items are listed in the log until someone queues another rename. Then it's overwritten. Trying to find something in the KB.
Title: Re: Rename query
Post by: Lance Bateman on June 07, 2011, 02:03:11 PM
I tried to find same thing, and ended up maintaining an Excel log of what it was, what it was changed to - and since we use etfile, that I'd made the change there also for attachments.
Title: Re: Rename query
Post by: GeorgeW on June 07, 2011, 02:14:19 PM
A helpdesk ticket gets created here (we use Track-It! ) for all renames, so it's very easy for me to search a code and find the changes. Using the view "history" option above can be a pain unless you know the date a code was changed.
Title: Re: Rename query
Post by: Alice on June 07, 2011, 02:29:50 PM
We use Track-It also, but only IT has access and I don't process the renames.  Look at KB39290 and let me know how that's supposed to work. There is no list of Utilities to select from and selecting all does not pull anything regarding renames.
This is getting a bit frustrating since rename data should be stored somewhere for future reference.
Title: Re: Rename query
Post by: GeorgeW on June 07, 2011, 02:48:41 PM
I think the only way is the way I first mentioned above, here is a knowledgebase article I just found:

Is it possible to view a Rename History to find out if a client code was renamed?
Product:  10.8, 10.7, 10.6, 10.5, 10.4, 10.3, 10.2, 10.1, 10.0, 9.4, 9.3, 9.2, 9.1, 9.0, 8.5, 8.4, 8.3, 8.2.0, 8.1, 8.0, 7.6.0, 7.5.0, 7.4.0, 7.3.0, 7.2.0, 7.1.1, 7.1.0, 7.0, 6.30

Solution:

Click Start, Programs, Applied Systems, Rename Customers or go to Start, Run, type X:\WINTAM\WRENCST.EXE and Enter.  

To view a rename history on version 7 and up go to Start, Programs, Applied Systems, Utility Manager, General, Rename Codes, if it shows users are in hit Cancel, then Yes to queue for Night, Options, History, and then click an entry to see what entity was renamed, old code and new code.  



An enhancement request has been submitted to have the Rename History screen updated with a better layout for viewing rename history. If this is important to you, help us prioritize this by submitting an enhancement request at http://www.appliedsystems.com/apps/enhancementrequest/eRequest.aspx (one request per agency). Please reference: PMR#145317.



This has been reported and is in the log.

Found in:

TAM > Using TAM > Utilities / Utility Manager > General > Renames > Questions
Last Revised: May 5, 2009 12:52 PM

KB32626

Title: Re: Rename query
Post by: Alice on June 07, 2011, 03:25:57 PM
Excellent George!  Thank you  :)
Title: Re: Rename query
Post by: Andrew Carrick on June 07, 2011, 03:50:12 PM
Quote from: Alice on June 07, 2011, 12:09:59 PM
There's rename info in the  wiki  ;)
Yeah I think I did most of it....  :o
Title: Re: Rename query
Post by: Ian Blundell on June 08, 2011, 12:49:23 PM
Andrew
Have you looked at the \TAM\WRENLOG.DBF file?  That appears to be where the History is pulling the records from.
Title: Re: Rename query
Post by: Andrew Carrick on June 09, 2011, 03:15:04 AM
Yes! see my post on June 7th - but thanks anyway!