ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
2013 views

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.

0 Likes
9 Replies
Absent Member.. Absent Member..
Absent Member..

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.

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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.

0 Likes
Absent Member.. Absent Member..
Absent Member..

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.

Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Thanks. Again I couldn't. Because I want to using textarea and values save to the database and read. Where do I put textarea?
0 Likes
Absent Member.. Absent Member..
Absent Member..

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

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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.
0 Likes
Absent Member.. Absent Member..
Absent Member..

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).

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hm. Thanks. So , How to using PHP files in PPM ? Php doesn't work.
0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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

Best Regards,
Ieroglif.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.