Agile Central: Excel Add-in 2.4.4 - How to reuse my queries in another Excel instance?
book
Article ID: 94867
calendar_today
Updated On:
Products
Rally On-PremiseRally SaaS
Issue/Introduction
CA Agile Central provides an Add-in to Microsoft's Excel. This Add-in will help you organize your data. Using this Add-in you will create filter queries that you can later execute to export Rally data into your Excel spreadsheets. This doc explains how to be able to reuse queries in another Excel installation instance.
Is there a way to backup my queries in Excel so that they can be loaded into another Excel instance on another machine and reused without the need to manually create them again?
Environment
Release: Component: ACSAAS
Resolution
The CA Agile Central Add-in for Excel keeps its configuration in this file:
C:\Users\<WindowsUser>\AppData\Roaming\Rally\ExcelAddIn\rallyExcel.xml (where <WindowsUser> is the profile name of that user that's currently using this Add-in under Excel).
You can use any text editor to view this file. Among other details, this file contains the connection information, the selected workspace and project. Moreover, this file contains the list of queries you created in the CA Agile Central tab including their names, artifacts, fetched columns, order of columns and more.
You shall be able to backup this file occasionally so that you don't lose your info and queries. By that same practice, you can place this file in this location in another Excel instance on another machine, then upon opening that Excel you shall find your queries in the other Excel instance.