Hi! Two years ago I published a free utility to convert diary data into separate records in a form called RRR|DiaryX.
The utility can do pattern matching to extract some interesting data from your old diary. For example it can find Status-changes and Assignments and put this data into separate fields in the new form. You could use the fields StatusNew, StatusPrev, AssignedToNew and AssignedToPrev. RRR|DiaryX works against an arx-file, so all you need to do is to export your current data into an arx-file including Request-ID, your Diary-Field and any other field you would like to have in your new "diary-form". https://www.rrr.se/cgi/div/diaryx Best Regards - Misi, RRR AB, http://www.rrr. > On a related note, if you ever decide to convert your Diary fields into > individual records in a separate form (which may then be viewed in table > fields or 0-length display-only character fields), there is a free > utility that will populate your new Diary form with all the diary > entries in your ARS system. > > > > The name is ARS_CreateDiaryForm and can be downloaded from here > http://arswiki.org/projects/dotnetutil. Click on the Downloads > <http://arswiki.org/projects/dotnetutil/downloads> link. > > > > HTH someone. > > > > Stephen > > Remedy Skilled Professional > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza > Sent: Thursday, October 25, 2007 3:01 PM > To: [email protected] > Subject: Re: Diary Fields > > > > My guess is that its perhaps having that capability will only allow a > developer to check for TR and DB values against NULL as the diary field > will otherwise not be equal to any constant. Only a LIKE comparison > would be possible to check values contained in the DB. > > > > I have been in the past got stuck in a few corners too because of this > limitation/design. > > > > Another limitation I do not like about diary fields is how they appear > in a display only dialog box on window open. You cannot see the history > - just the transactional part. You need to create a separate display > only field to set and view the history part. > > > > I've often wondered why they have designed it that way. > > > > Joe D'Souza > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected] <mailto:[email protected]> ]On Behalf Of > Dwayne Martin > Sent: Thursday, October 25, 2007 2:21 PM > To: [email protected] > Subject: Re: Diary Fields > > > Many years ago I submitted a suggestion to have the db contents of a > diary field available to workflow. I've never heard back on it. > > Any reason why it wouldn't be a good idea? > > Dwayne Martin > James Madison University > > ---- Original message ---- >>Date: Thu, 25 Oct 2007 08:40:50 -0700 >>From: Rick Cook <[EMAIL PROTECTED]> >>Subject: Re: Diary Fields >>To: [email protected] >> >> ** >> Andy, workflow can only evaluate the current entry >> into a diary field - all existing ones are >> considered to be invisible to the transaction. >> >> Rick >> >> On 10/25/07, LJ LongWing (Head) >> <[EMAIL PROTECTED]> wrote: >> >> ** >> Not a dumb question actually....that qualification >> in an AL will give you only the 'change' to the >> diary. To determine if a diary has previous >> values you should do a setfield of the entry into >> a 0 length display only field and then check to >> see if it is null... >> >> ------------------------------------------------ >> >> From: Action Request System discussion >> __20060125_______________________This posting was submitted with > HTML in it___ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
