OnDemand Users Group

Support Forums => Report Indexing => Topic started by: DDP021 on March 26, 2018, 02:10:57 PM

Title: Updating multiple Indexs
Post by: DDP021 on March 26, 2018, 02:10:57 PM
Hi....We have been given the task of updating over 12,000 Application indexes...They all contain a line referencing and exit that is no longer needed...Our only means we know of to do this is open the ADMINISTRATOR thick client and going into each Application and then the INDEXER INFORMATION tab and manually removing this one line.  Its the same for each one.  Does anyone know if a way to somehow do this systematically or is this the only way?...Again, our group only has access to do this  via the ADMIN client...Appreciate any info.  Take care...DAVE
Title: Re: Updating multiple Indexs
Post by: Nolan on March 26, 2018, 02:19:42 PM
Are you saying ARSXML is not an option for your team?  ARSXML is the way to go. 

1. ARSXML to unload
2. Use a script to delete the line in the reports
3. ARSXML to update
Title: Re: Updating multiple Indexs
Post by: jsquizz on March 26, 2018, 02:49:51 PM
What Nolan said. ARSXML and a little bit of basic scripting is your friend here.
Title: Re: Updating multiple Indexs
Post by: DDP021 on March 26, 2018, 03:05:21 PM
Unfortunately the XML option isn't available for us..I'll pass this info onto our engineering team to see what they can come up with...I appreciate the input!!!!!!!...take care
Title: Re: Updating multiple Indexs
Post by: Greg Ira on March 27, 2018, 12:55:07 PM
Thinking a little outside the box.  If the exit isn't going to be used by anything else possibly rewrite the exit to do nothing?
Title: Re: Updating multiple Indexs
Post by: Justin Derrick on March 27, 2018, 01:14:58 PM
Without the CMOD arsxml utility, your only option to do this in an automated fashion is to write a custom tool that writes the indexer field to a file, changes the file, then replaces the index parameters in the database. 

It would honestly be easier to upgrade to a newer version of CMOD that supports arsxml.

-JD.