Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

Hello,

I have in plan to upgrade a UCCX 7 system to 8 and my concern is weather custom build reports are migrated also. I know you can build custom reports in version 8 as well. In fact, what I don't know is if during the upgrading process from SQl to Informix DB keeps the custom stored procedures build especially for the reports. And if so, will the reports still be functional? Same tables, same DB schema etc. And also could they use the same templates we created in Crystal reports or not.

Thank you,

Octavian

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

Hi

I've not verified this myself yet, but I would strongly suspect that it would not.

It's likely  that your MSSQL SPs will require some editing so that Informix can use them (there are dedicated tools out there for this job, but even they don't claim to do this automatically 100% of the time) and that's not something Cisco will be helping you with very much.

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
5 REPLIES
Super Bronze

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

Hi

I've not verified this myself yet, but I would strongly suspect that it would not.

It's likely  that your MSSQL SPs will require some editing so that Informix can use them (there are dedicated tools out there for this job, but even they don't claim to do this automatically 100% of the time) and that's not something Cisco will be helping you with very much.

Regards

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

Yes, I suspect the same. This definitely needs testing and proper backup to SP and templates before upgrade.

Thank you for your reply Aaron!

Super Bronze

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

No problem.

If you have access to either new server hardware, or VMWare for the upgrade, I would get your software ordered, and build a small lab with UCCX8.0. You can then get your SPs ported and tested fully, as well as all your UCCX scripts which might require some modification (due to use of Windows style file paths or various other things).

Regards


Aaron

Please rate helpful posts and mark answered questions that you've got a satisfactory response from to help identify useful content in the forums...
https://supportforums.cisco.com/docs/DOC-6212

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

For sure I will test this in the lab. Good tip about the scripts!

Thanks,

Octavian

Re: UCCX 7.0 upgrade to v 8.0. Custom reports are migrated also?

UPDATE:

No it doesn't migrate anything.

And it's a bit of a pain to convert MS SQL procedures to Informix procedures (routines as they are called) but you have to do it manually. Some fields changed in some tables. Check database schema document. I used AGS server studio for this but SQuireL can be used also.

Seriously analyze if it isn't easier to start developing the reports from scratch.

The .xml report files also need some modifications in syntax for calling the procedure on the server

GMT offset doesn't work as in UCCX pre 8.0. UCCX keeps all historical data in UTC time. I modified the GMT offset in crystal report template to display the correct time.

916
Views
5
Helpful
5
Replies