Hi
I have been asked to reset up a group of reports that have been created by various different people and sent to data center, but under my username and sent to a central email address, for disaster recovery purposes. Anyone know if there is a quicker way to do this than writing down all the details and manually rescheduling them in my own account? There are over 100 of them so I'd love to make this job easier!
Thanks
Siobhan
Hi,
You can run sql queries to get the report request parameters. This could give you the parameter values as well for the request. In thoery you could use this to create a new report request through sql code or as a type of reference of what they should be when recreating them.
I have not done the last part, creating a report request through code, but I did run a SQL trace before, and it just runs an insert into gooesoft_request, gooesoft_request _parameter, gooesoft_report_schedule and an update on gooesoft_request. It might be a good idea to run a trace and look at all the steps involed.
Jon
Thanks Jon, I'll give that a try.
I have some sql that I use to change ownership of the reports if that is what you need, let me know if it is and I can send it to you.
As Jon said you could probably write something to change the reports; although I have never done that.
Caryl
That would be wonderful Caryl, it's half the job at least! x
Caryl can you send it to me as well please?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Siobhan Bennetts Sent: 09 February 2010 14:32 To: Halliday, Gary Subject: Re: [Tessitura Technical Forum] Replicating reports
From: Caryl Jones <bounce-caryljones3976@tessituranetwork.com> Sent: 2/9/2010 8:20:35 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Please send to me as well. Thanks!
Shirley Rice x3036
Database Programmer
The Santa Fe Opera
Telephone (505) 995-3036
srice@santafeopera.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gary Halliday Sent: Tuesday, February 09, 2010 7:42 AM To: Shirley Rice Subject: RE: [Tessitura Technical Forum] Replicating reports
www.southbankcentre.co.uk Ticket Office: 0844 847 9910 Southbank Centre is a Registered Charity No. 298909 ______________________________________________________________________ This message (and files transmitted with it) may contain confidential or copyright information. If you receive it in error, please notify the sender and delete it from your computer. _______________________________________________________________________
Changing the ownership of the report is pretty simple, and I do it all the time. I will sometimes set up a report as Sys Admin, but then someone else will then need to maintain that report parameters and schedule going forward and can’t if I am still the owner, so this is what I do. It’s really simple as I am usually only changing one report at a time. As gooesoft_request has the email recipients field in there too, then it should be pretty easy to change the recipient as well – but I would test first!
select top 10 * from gooesoft_report_schedule
where name like ('%totals%')
update gooesoft_request
set user_id = 'lbowyer'
where user_id = 'cfflurjo'
and id in (276386,276387) ( this id is the request id from gooesoft_report_schedule)
or if it is lots of reports
set user_id = 'cfflurjo'
where user_id = 'lbowyer'
and id in (select request_id from gooesoft_report_schedule where name like ('%totals%') )
For anyone still using this, it's now important to update the ug_id column in gooesoft_request to an appropriate user group for the new user. This is so that it can successfully authenticate against the REST API i.e
set user_id = 'cfflurjo',
ug_id = 'admin'