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"
