CMS reports plug-in - report administration

[gk]

Does anyone else use the RedDot CMS Reporting Plug-in?

We've installed it as per the instructions and most of it is working
as expected - all except the Report Administration bit. This is where
I'm supposed to be able to add content class elements that will allow
me to track review dates for pages rather than doing it through
Workflow.

I can open the Add Templates/Elements page, select the appropriate
content class folder from the drop-down box, select the appropriate
content class from the next drop-down box. When I then click on the
'Add' button nothing happens - no error, no nothing, just sits there.
Looking at the picture in the manual, I'm supposed to then be able to
add elements from that content class. Then I should be able to run a
Page Element Extended Report to show me what is due for review and
when.

Has anyone else had this problem? We are using RedDot V9.

[RedDotExpert]

Hello, from what I heard, the reports web app is divided into 2
backend calls, via RQL and SQL.

Can you do user specific detail report? If no, then the SQL
connection is not working.

[Gavin Cope]

Also, last I looked, it wasn't compatible if you were using Oracle as your CMS backend.

--
You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group.
To post to this group, send email to reddot-c...@googlegroups.com.
To unsubscribe from this group, send email to reddot-cms-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.

[RedDotExpert]

That is correct, an Oracle connection module was never written.

The next version will be entirely AJAX using JQuery, database
agnostic, and a much less complicated installation process.

Now, I am just waiting for Jian from OpenText to have time to do it.

On Feb 16, 10:30 pm, Gavin Cope <gavin.c...@gmail.com> wrote:
> Also, last I looked, it wasn't compatible if you were using Oracle as your
> CMS backend.
>

> > reddot-cms-use...@googlegroups.com<reddot-cms-users%2Bunsu...@googlegroups.com>

[gk]

Thanks

We are not using Oracle and no it won't let me run any user-based
reports (I hadn't tried these reports before).

Any ideas on what might be causing the SQL connection to not work -
where I should point my IT guy to?

> > > reddot-cms-use...@googlegroups.com<reddot-cms-users%2Bunsubscrib­e...@googlegroups.com>

> > > .
> > > For more options, visit this group at

> > >http://groups.google.com/group/reddot-cms-users?hl=en.- Hide quoted text -
>
> - Show quoted text -

[PaulG]

I'd looked at this report module a while back and there seemed to be a
couple of different versions floating around - with the one currently
on the Open Text KB site seeminly the last and more reliable of them.

Anyway (from memory), there's a couple of approches as to how the
plugin actually fetches the data to collated the reports - some via
RQL and some via direct ADO/asp connections.

I think the asp/ado connection string variables are located in a file
called redDot.asp in the reporting plugin windows folder.
Check they are configured correctly ... I would use a SQL login (not
Windows) to connect to the databases.
If you know the username/password of the sql user which RedDot uses,
ensure it has dbo rights to the RDReports db (and the other reddot
project DBs) and you should be right to go.
If you don't know those details, then create a new sql user and as
above, assign it dbo access to the RDReports db and all the other
project DBs.

Paul.

> > > >http://groups.google.com/group/reddot-cms-users?hl=en.-Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -