Then develop API, you may try the Fast-Export utility that I published at: http://communities.bmc.com/communities/docs/DOC-11866
Fast-Export is a migration utility that copy a data of a schema or a list of schemas from server to server for an identical schemas (schema-to-schema) or as a normal export utility (schema-to-file) send output to (.arx/.csv) file that can be imported by Remedy Import. Fast-Export designed based on the concept to repeatedly read the schema rows in a sequential order. The logic initiated to read the schema in forward or backward sequence of order. Users for backward or forward sequence can initiate the START-Read, to identify the starting point of the browse, and terminated with the END-Read. Ease-of-use facilitated with .NET window client which was developed to help users to access through a GUI, it was developed using the feature of .NET/C# so that to be executed as Windows (future Web-Based) and valid to access BMC-Remedy releases AR3-7. To use it: 1) Unzip the zipped file, 2) It generate a folder call FastExport 3) Run: FastDotNet.exe I will try to add this option next weeks. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Viki_kulkarni Sent: Monday, January 31, 2011 9:58 AM To: [email protected] Subject: Re: Data Archiving to Vendor form!! will it work? yeah Ali, your are right but the DBA is not agreeing to it. It needs to be done via remedy so here we are.. I am almost done will update the solution soon. Thanks, Viki Ali Musa wrote: > > From the application level required a lot of activities (Filter, > Escalation, Form archive). However, this can be done from the database > level using the replication tools (i.e. Oracle Streams processes) or copy, > export and import (i.e. tables such as Txx ,Hxx and Bxx). > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Viki_kulkarni > Sent: Monday, January 31, 2011 7:02 AM > To: [email protected] > Subject: Re: Data Archiving to Vendor form!! will it work? > > Yes I have been thinking in the same way but the DBA team is stressing to > put > it on a different database due to space issues at least thats what they > reason. > > I was trying to do the same task using a view form but facing issues in > push > fields well lets see how things work out. > > > patchsk wrote: >> >> why do you want to create vendor forms. >> You can just save as original form with a different name and use that >> as archive data holder. >> You can write the escalation to do a push field create entry to the >> new form and a delete entry on the old form. >> >> On Jan 28, 6:54 am, Viki_kulkarni <[email protected]> wrote: >>> hi Listers, >>> >>> We are trying to enable archiving on ARS 5.01. Yes we are aware that we >>> dont >>> have archiving functionality on ARS 5.0.1 (correct me if wrong). So here >>> is >>> how I am planning to do it and would like you guys to have a look at and >>> with all the experience you have it will be great review. >>> >>> The purpose of archiving is to increase performance while searching and >>> to >>> reduce database size. >>> >>> Hence what I am suggesting is to create a new database with tables same >>> as >>> in AR database. (the T Tables). Then I will create vendor forms for all >>> the >>> forms that I need to archive and map them to the new database tables >>> that >>> I >>> have created similar to the AR T tables using ARDBC plugin. Now I will >>> run >>> an esclation that will move the records from AR server forms to the new >>> vendor forms by a special user AR_ARCHIVER just as it does with the >>> inbuilt >>> archiving.All other users will have only read only access to the archive >>> form as per the inbuilt functionality. >>> >>> Now this will reduce the number of records on the AR Server forms and >>> move >>> it to the archive vendor form. (At least that is the idea) >>> >>> Now I am aware that I will need to keep an eye on all the changes that >>> happens to the base form in terms of field addition and need to >>> replicate >>> on >>> the vendor archive form. But thats ok with us as there wont be any >>> change >>> we >>> guess. >>> >>> So let me know if you guys think this will work? I am currently trying >>> for a >>> small POC for the same will update for the same once I pass/fail and >>> what >>> would be the pros and cons for the same. >>> >>> Just trying to think OOTB :) >>> >>> Thanks, >>> Viki >>> -- >>> View this message in >>> context:http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-wor... >>> Sent from the ARS (Action Request System) mailing list archive at >>> Nabble.com. >>> >>> ___________________________________________________________________________ >>> ____ >>> UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org >>> attend wwrug11www.wwrug.comARSList: "Where the Answers Are" >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >> >> > > -- > View this message in context: > http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-work--tp30786586p30803749.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > -- View this message in context: http://old.nabble.com/Data-Archiving-to-Vendor-form%21%21-will-it-work--tp30786586p30804250.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
