Fred, Unfortunately the 0-length display-only field would always come back blank for me when I tried this approach. This made me think to create a 0-length (optional) character field and I just imported the work log field into it in addition to the diary field. That worked like a charm. Hacks don't need to be beautiful. :-)
Thanks for the suggestions. Jill Anderson NDSU ITS [EMAIL PROTECTED] On 8/20/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote: > Do a set fields to pull the complete diary entry into the form before > pushing it over to your new record. > > I usually pull it into a 0 length Display Only character field and then > push that to the new record > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Jill E > Sent: Monday, August 20, 2007 2:57 PM > To: arslist@ARSLIST.ORG > Subject: Diary field copy > > Hello list, > > I have a question relating to diary fields (CLOB). > > As part of an "upgrade" to ITSM 7, I am trying to make it as easy as > possible to get work in progress out of our home-grown Remedy > application into Incident Management. To accomplish this, I have made a > complete copy of the form (with many modifications since it should be > read-only and many fields aren't relevant outside the context of the old > application) and data in the new Remedy. I have added a button for > "copy to Incident" to the old form that will open an incident window and > set as much of the ticket data as possible, allowing for a person to add > data, as necessary, to fit in the new application before saving the > incident. > > Where I am stuck is with a work log (diary) field. I haven't been able > to figure out how to retrieve the old entries of the diary, only the > current entry. I can see the complete diary entry in the form if I > click the diary editor button but setting a field to $Work Log$ results > in only the current entry to be set, not the entire diary. I don't want > to explode the entries, just copy all of the diary into one Work Info > record with a "copied from old system" summary. > > Is there a special trick to copy diary fields using open window/field > mapping or by preparing the old data when it is exported/imported? Or > by another method? > > AR 7.0.01 patch 3 > Red Hat Linux 64bit > ITSM 7.0.02 patch 5 > Oracle 10.2 64bit > > Old app is AR 5.01/Solaris/Oracle 9.2 > > Thanks. > > Jill Anderson > NDSU ITS > [EMAIL PROTECTED] > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"