How to add custom portlets ?

[TuTaMixx]

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.

[kwood55]

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]

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]

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]

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]

"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]

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]

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]

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

[ieroglif]

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