The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to add custom portlets ?

Highlighted
TuTaMixx
Occasional Contributor

How to add custom portlets ?

Hi everyone,

 

How to add custom portlets ? We are gonna adding UserNote system in PPM. But how doing don't know. Would you help us ? Where we should start ? Thanks.

9 REPLIES
kwood55
Frequent Visitor

Re: How to add custom portlets ?

So far I see three ways to create a custom portlet

1) Use existing tools that come with your PPM installation

2) Create and import a java portlet

3) Create and import a WSRP portlet.

 

I use 1, and it works fine for me.

 

1) Requires:

- A Data Source created in the PPM Workbench

- A portlet/module created in the PPM frontend.

See HP PPM Creating Portlets and Modules pdf documentation.

TuTaMixx
Occasional Contributor

Re: How to add custom portlets ?

Thanks. But I could not . How to adding UserNote system in PPM. Which programming language can I write ? PHP doesn't work. I don't know how to do it. Thanks.

kwood55
Frequent Visitor

Re: How to add custom portlets ?

For using PPM existing tools:
- You query the data base for the data you want displayed in your portlet (SQL - structured query language)
This becomes your Data Source created in the PPM Workbench.

Try this:
- Logon on to your PPM App Server and start the PPM Workbench
- In the left pane select Sys Admin > Server Tools
- Click on the window that says SQL Runner and maximize it.
- In the SQL Statement space, cut and paste the following SQL commands

SELECT
usr.user_id,
usr.full_name,
usr.username,
usr.email_address,
ou.org_unit_name,
ou.department_code

FROM
knta_users usr,
krsc_org_unit_members oum,
krsc_org_units ou

WHERE 1=1
AND oum.org_unit_id = ou.org_unit_id
AND usr.user_id = oum.user_id
AND usr.username in (select username from knta_users_v where enabled_flag='Y')

order by full_name

- This is the start of a custom portlet for displaying all of the enabled PPM users.
- Once it is running in the SQL runner, you can kind of save it as a permanent Data Source.
- Data Sources are created in the Dashboard > Data Sources section of the PPM Workbench.

TuTaMixx
Occasional Contributor

Re: How to add custom portlets ?

Thanks. Again I couldn't. Because I want to using textarea and values save to the database and read. Where do I put textarea?
kwood55
Frequent Visitor

Re: How to add custom portlets ?

"yes, we have no bananas".

You lost me, you were originally asking about custom portlets.

You sound way behind the power curve, and I was trying to spoon feed you a little.

 

Now you are talking about textarea.

 

Can you logon to the PPM workbench ?

 

With a little experience it is easy to display notes for Requests, but you have a long way to go...

TuTaMixx
Occasional Contributor

Re: How to add custom portlets ?

I want to using textarea in portlets. And note system for users. Users to enter notes in textarea. And button for save to the notes. And save to the database.
kwood55
Frequent Visitor

Re: How to add custom portlets ?

OK,

 

I have never seen user input with the standard Data Sources and Portlets that come with PPM.

 

I am not sure what is available with external portlets (imports).

TuTaMixx
Occasional Contributor

Re: How to add custom portlets ?

Hm. Thanks. So , How to using PHP files in PPM ? Php doesn't work.
ieroglif
Super Collector

Re: How to add custom portlets ?

I seriously doubt that such a thing would work..You should use .jsp

Best Regards,
Ieroglif.
//Add this to "OnDomLoad" event