Hi,
The attachments in this case would be stored in for example:
C:\remedydump\CHG_Infrastructure_Change\CHG000000001234\
But it might be that the attachments are not stored in CHG:Infrastructure
Change but for example in the related worklog form.
The config I gave you was just a skeleton. You need to figure out exactly
which data you want to export.
It might look like you are storing the attachments in the main ticket, but if
I remember right it is stored in CHG:WorkLog, HPD:WorkLog etc.
Best Regards - Misi, RRR AB, http://rrr.se
> Hi Misi,
>
> Yes, I forgot that I had mentioned to D:\remedydump while I configured the
> export.cfg file in my system.
>
> I can see the arx files getting created CHG_Infrastructure_Change.arx and
> PBM_Problem_Investigation.arx & PBM_Problem_Investigation.idx so far.
> But I am still unable to find the sub directory/ ies with ticket numbers as
> names to get the exact attachments.
>
> I believe this should be last query from my end and really appreciate your
> help end to end.
>
> Big Thanks.
>
> Regards,
> Sagar
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
> Sent: Friday, 8 May 2015 5:42 PM
> To: [email protected]
> Subject: Re: Retrieving attachments from Remedy Tickets
>
> Hi,
>
> Please read the documentation on the various parameters.
>
> To create your own help file do like this:
> rrrchive.exe -help all >rrrchivehelp.txt
>
> You can also review the help online: https://rrr.se/cgi/index?pg=chive-doc
>
> You specify the target directory with parameter "target_dir" which in the test
> config I gave you was set to "C:\remedydump"
>
> You can also use the configurator to create/change your configs:
> New config: https://rrr.se/cgi/rrrchive/config
> Change config: https://rrr.se/cgi/rrrchive/config?req=submittext
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> Hi Misi,
>>
>> Thanks for providing that additional parameter to be added into the
>> export.cfg, seems its working as below -
>>
>> D:\Sensis Data Extraction Project>cd rrrchive_win_dll
>>
>> D:\Sensis Data Extraction Project\rrrchive_win_dll>RRRchive.ext
>> export.cfg 'RRRchive.ext' is not recognized as an internal or external
>> command, operable program or batch file.
>>
>> D:\Sensis Data Extraction Project\rrrchive_win_dll>RRRchive.exe
>> export.cfg Counting records in source form CHG:Infrastructure Change
>> Counting records in source form PBM:Problem Investigation Processing
>> form PBM:Problem Investigation (form count 1 of 2, approx 0.00% to
>> 33.37% of 2992852 records)
>> Analyzing source PBM:Problem Investig50% 75%
>> 100%
>> +------------------+------------------+------------------+------------------+
>> **********************************************************************
>> ******* Copying 291870 records to target form PBM:Problem
>> Investigation
>> Copying PBM:Problem Investigation 50% 75%
>> 100%
>> +------------------+------------------+------------------+------------------+
>> ***************************************************************6
>>
>> But not sure how long it would take to complete, already close to
>> 30-45 mins since it is running.
>> Also, could you please help me with the location where I would be able
>> to see the folders with tickets numbers as names and the corresponding
>> attachments within them.
>>
>> Regards,
>> Sagar
>>
>> Thanks & Regards,
>> Sagar G Anandpara
>> E : [email protected]
>> D : +61399113461
>> M: +61470380369
>> Infosys Limited, Docklands
>>
>> Infosys Technologies, IMST | iTAM L3 Support
>>
>> -----Original Message-----
>> From: Action Request System discussion list(ARSList)
>> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
>> Sent: Friday, 8 May 2015 6:14 AM
>> To: [email protected]
>> Subject: Re: Retrieving attachments from Remedy Tickets
>>
>> Hi,
>>
>> I suspect that you are not using a portmapper.
>>
>> Try adding source_tcp=1234 or whatever number you have set.
>>
>> Best Regards - Misi, RRR AB, http://rrr.se
>>
>>> Thanks for the ongoing help Misi. I did the steps you gave below and
>>> ran the command RRRchive.ext export.cfg, however, unfortunately its
>>> only ending up with below error -
>>>
>>> Error from export.log -
>>> ---------------------------------------------------------------------
>>> -
>>> ----------------------------------------------------------
>>> rrrchive: 2015-05-08 05:04:25, type=APP, level=NOTICE,
>>> file=rrrchive.cpp,
>>> line=5043
>>> Program Start: configfile=export.cfg
>>> rrrchive: 2015-05-08 05:05:43, type=ARS, level=ERROR,
>>> file=rrrchive.cpp,
>>> line=389
>>> ARGetServerInfo(server=au10qap4mdtels2, AR_SERVER_INFO_DELAY_RECACHE_TIME)
>>> API CALL SEVERITY: AR_RETURN_ERROR, failure, status contains details
>>> ARStatusList: contains 1 messages
>>> Number: ARERR 90
>>> Message: Cannot open catalog; Message number = 90
>>> Append: au10qap4mdtels2 : RPC: Rpcbind failure - RPC: Timed out
>>>
>>> rrrchive: 2015-05-08 05:05:43, type=APP, level=NOTICE,
>>> file=rrrchive.cpp,
>>> line=5057
>>> Program End: configfile=export.cfg, timetorun=0:01:18
>>> ---------------------------------------------------------------------
>>> -
>>> ----------------------------------------------------------
>>>
>>> The server au10qap4mdtels2 is one of the user facing server from the
>>> Server Group Environment we're having in our Production Env.
>>> I believe this might be because I am trying to run this from my local
>>> machine.
>>> Do you suggest to try for some other test environment server first to
>>> confirm (will also help to understand if any performance impact due
>>> to the activity, if any).
>>>
>>> Also would like to know Misi, how much time should I expect the
>>> activity to take, approximately.
>>> So that accordingly I can try one form at a time, if required.
>>>
>>> Thanks,
>>> Sagar
>>>
>>> -----Original Message-----
>>> From: Action Request System discussion list(ARSList)
>>> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
>>> Sent: Friday, 8 May 2015 4:18 AM
>>> To: [email protected]
>>> Subject: Re: Retrieving attachments from Remedy Tickets
>>>
>>> Hi,
>>>
>>> It extracts data fields to a single ARX text file for each form. Each
>>> attachment stored in an ARS/Remedy record, of any type, will be
>>> stored in a separate sub directory with the Request-ID as directory name.
>>>
>>> Just create the config with notepad and call it something like export.cfg.
>>>
>>> Then start a cmd-prompt and run RRR|Chive.
>>>
>>> C:\rrrchive\> rrrchive.exe export.cfg
>>>
>>> Best Regards - Misi, RRR AB, http://rrr.se
>>>
>>>> Thanks a lot Misi, that seems going to be helpful to my requirement
>>>> and I could sign up and download the software successfully, the rrrchive.
>>>>
>>>> Just had 2 doubts queries -
>>>> 1. Does this help only for the ARS-files or can that help extract
>>>> any kind of attachments. (as per my email below, the major candidate
>>>> would be Changes form as it may have the attachments of different
>>>> types including .doc, .xls, .msg, .xml, .zip, etc).
>>>> 2. The sample configuration you've provided below, could you please
>>>> also tell me which file I should configure it within. Or if need to
>>>> be created from a notepad explicitly, what extension I should save
>>>> it with.?
>>>>
>>>> I hope making the things as advised by you will work for me (my
>>>> requirement).
>>>> Thanks again.
>>>>
>>>> Regards,
>>>> Sagar
>>>>
>>>> -----Original Message-----
>>>> From: Action Request System discussion list(ARSList)
>>>> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
>>>> Sent: Thursday, 7 May 2015 9:54 PM
>>>> To: [email protected]
>>>> Subject: Re: Retrieving attachments from Remedy Tickets
>>>>
>>>> Hi,
>>>>
>>>> I would use our RRR|Chive tool to export everything to a directory
>>>> with ARX-files. For each ticket you will get a directory containing
>>>> the attachments.
>>>>
>>>> Here is the download: https://rrr.se/cgi/index?pg=chive
>>>>
>>>> Sample config for dumping everything for a few forms:
>>>> source_server = yourserver
>>>> source_user = Demo
>>>> source_password =
>>>> target_dir = C:\remedydump
>>>> multipleforms = \
>>>> HPD:Help Desk,\
>>>> PBM:Problem Investigation,\
>>>> CHG:Infrastructure Change
>>>> splitsearch = YES
>>>> transfertype = COPY
>>>> skipfields = DISPLAYONLY
>>>> logfile = AUTO
>>>> progressbar = YES
>>>>
>>>> You have to adapt it to the forms containing your attachments.
>>>>
>>>> We also have a tool to convert the ARX-data into HTML format:
>>>> https://rrr.se/cgi/tools/main?tool=rrrArxToHTML
>>>>
>>>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
>>>> 2011)
>>>>
>>>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
>>>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>>>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
>>>> Find these products, and many free tools and utilities, at http://rrr.se.
>>>>
>>>>> Thanks for quick response Misi. Yeah, if it would be one or two,
>>>>> can do the below solution.
>>>>> However, we have apporx. 88k INCIDENTS and 7500+ Changes (the
>>>>> biggest
>>>>> candidate) and PBI and PKEs approx. 1k each.
>>>>>
>>>>> Need to do this activity to transfer the same to the customer
>>>>> before they close off.
>>>>>
>>>>> They need to have all the data they have in the system, including
>>>>> the tickets and the attachments in them.
>>>>>
>>>>> Please let me know would you need anything more from my end.
>>>>>
>>>>> Thanks,
>>>>> Sagar
>>>>>
>>>>> Thanks & Regards,
>>>>> Sagar G Anandpara
>>>>> E : [email protected]
>>>>> D : +61399113461
>>>>> M: +61470380369
>>>>> Infosys Limited, Docklands
>>>>>
>>>>> Infosys Technologies, IMST | iTAM L3 Support
>>>>>
>>>>> -----Original Message-----
>>>>> From: Action Request System discussion list(ARSList)
>>>>> [mailto:[email protected]] On Behalf Of Misi Mladoniczky
>>>>> Sent: Thursday, 7 May 2015 8:01 PM
>>>>> To: [email protected]
>>>>> Subject: Re: Retrieving attachments from Remedy Tickets
>>>>>
>>>>> Hi,
>>>>>
>>>>> One way would be to open the Incident form in the Mid-Tier browser,
>>>>> and clicking on the right buttons to retrieve it.
>>>>>
>>>>> Or do you need to dump them all out to the file system?
>>>>>
>>>>> Can you please elaborate a little on the reasons behind this
>>>>> requirements?
>>>>>
>>>>> Best Regards - Misi, RRR AB, http://rrr.se
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Greetings.!
>>>>>> Need assistance in retrieving the attachments from Incidents,
>>>>>> Problems, Known Errors and Changes from Remedy ITSM v7.0.
>>>>>>
>>>>>> Kindly advise the best possible option to do this.
>>>>>>
>>>>>> Please let me know for anything needed for answering my requirement.
>>>>>>
>>>>>> Regards,
>>>>>> Sagar
>>>>>>
>>>>>>
>>>>>>
>>>>>> **************** CAUTION - Disclaimer ***************** This
>>>>>> e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
>>>>>> solely for the use of the addressee(s). If you are not the
>>>>>> intended recipient, please notify the sender by e-mail and delete
>>>>>> the original message.
>>>>>> Further, you are not to copy, disclose, or distribute this e-mail
>>>>>> or its contents to any other person and any such actions are unlawful.
>>>>>> This e-mail may contain viruses. Infosys has taken every
>>>>>> reasonable precaution to minimize this risk, but is not liable for
>>>>>> any damage you may sustain as a result of any virus in this
>>>>>> e-mail. You should carry out your own virus checks before opening the
>>>>>> e-mail or attachment.
>>>>>> Infosys reserves the right to monitor and review the content of
>>>>>> all messages sent to or from this e-mail address. Messages sent to
>>>>>> or from this e-mail address may be stored on the Infosys e-mail system.
>>>>>> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>>>>>>
>>>>>> __________________________________________________________________
>>>>>> _ _ _ _ _________ UNSUBSCRIBE or access ARSlist Archives at
>>>>>> www.arslist.org "Where the Answers Are, and have been for 20 years"
>>>>>>
>>>>>
>>>>> ___________________________________________________________________
>>>>> _ _ _ _________ UNSUBSCRIBE or access ARSlist Archives at
>>>>> www.arslist.org "Where the Answers Are, and have been for 20 years"
>>>>>
>>>>> ___________________________________________________________________
>>>>> _ _ _ _________ UNSUBSCRIBE or access ARSlist Archives at
>>>>> www.arslist.org "Where the Answers Are, and have been for 20 years"
>>>>>
>>>>
>>>> ____________________________________________________________________
>>>> _ _ _________ UNSUBSCRIBE or access ARSlist Archives at
>>>> www.arslist.org "Where the Answers Are, and have been for 20 years"
>>>>
>>>> ____________________________________________________________________
>>>> _ _ _________ UNSUBSCRIBE or access ARSlist Archives at
>>>> www.arslist.org "Where the Answers Are, and have been for 20 years"
>>>>
>>>
>>> _____________________________________________________________________
>>> _ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> "Where the Answers Are, and have been for 20 years"
>>>
>>> _____________________________________________________________________
>>> _ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> "Where the Answers Are, and have been for 20 years"
>>>
>>
>> ______________________________________________________________________
>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>> ______________________________________________________________________
>> _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
> Are, and have been for 20 years"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
