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"
