Catalog Moved

[DrSimon]

We have moved our Impromptu reports and catalog from one server to another. So every time we open a new report it cannot find the catalog in the original location and asks the user to update it. Is there any way to update them all from the old to the new catalog using a macro or does it have to be done manually one at a time?
Simon Rouse

 

[griffindm]

Probably not the solution you want, but I'm fairly sure that if you put the catalogs in the same directory as the reports, they will open without complaint.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[griffindm]

The other better alternative, is to change the default catalog location (under Tools | Options | File Locations) to the new location. Then the reports will open without complaint also.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[DrSimon]

I didn't really think it would work, but as it was you Dave, I tried it out.
No go to either I'm afraid. It wouldn't be reasonable to move the catalog to the same folder as the reports, but I still tried it just in the cause of gaining further knowledge. The default catalog location had already been set to the new server directory.

The core of the problem is the way that the security is set up for users. And also that Impromptu saves every report's catalog in Report Properties/General/Catalog. With full admin rights I can open those reports and then change the catalog in report properties. So I'm after a method that will allow me to open a report, declare a new catalog and save it. What about using SendKeys, could that work?
Simon

 

[drlex]

Simon,
I had a similar problem. My solution was to write a macro that opened each report in a designated directory against the new catalogue prior to saving it. Worked like a charm.
lex

soi la, soi carré

 

[griffindm]

Simon,

I'm surprised that it did not work for you. I tried it at the client site I'm at today (version 6, I'm afraid), and both ways worked like a charm. I'm told this was a consequence of the modifications to let IWR work with a packaged report set. Were the catalogs in the exact directory the the options point to, or just a subdirectory of it?

I'll give it a try in version 7.1 just so see if it's version dependent.

drlex,

The problem I've had with macro solutions to this is if you have multiple catalogs with multiple reports to change, the macro doesn't know which catalog to open for each report. You could populate an array of reports and catalogs, but it's an ugly solution.

Dave G.



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[drlex]

Dave
point taken, but Simon referred to catalog(ue) in the singular, so I took that as indicating all reports were running from a sole catalog(ue).
lex

soi la, soi carré

 

[griffindm]

Simon,

I just did this test in Impromptu Admin 7.1.724:

1. Moved the Great Outdoors catalog to c:\temp

2. Set the default Catalog directory to c:\temp

3. Opened the sample report SalesRep Sales Totals.

4. Added the Catalog file path to the report footer (had to check it in page layout first).

It confirmed that the report was opened with the moved copy of the catalog without errror or comment by Impromtpu when I opened the report.

How did you try it on your end?

Dave G.



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[griffindm]

Lex,

Didn't mean to ignore you. Yes. If all the reports were running from a single catalog you could do a very elegant macro solution using the dir function.

Dave G.


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[drlex]

...very elegant macro solution...

No need to overcompensate, dave!

soi la, soi carré

 

[DrSimon]

Thanks for all this discussion in my absence guys - I'm in the UK so I've only just seen it.
Background: there are numerous reports in various directories and subdirectories, most but not all pointing to the same catalog. So Dave at this stage, I don't really want to do too much research that I'm not going to use. We're using Impromptu 7.1.
Lex's idea sounds a good one though. I'll give it a go and let you know what happens.
Simon