Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Export of Skills - Listed by Resource

SOLVED
Go to solution
Highlighted
Elux_Leslie
Occasional Contributor

Export of Skills - Listed by Resource

Anyone know how to export resources with their associated skills?  I honestly don't care if it's from a canned report (which I can't find if it's there) or SQL for the workbench, I just need a dump of the information into Excel.  Any help would be appreciated!

4 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Export of Skills - Listed by Resource

Hi Elux,

 

You can get the associated skills from

 

SELECT RSP.SKILL_ID, 

(SELECT KU1.FULL_NAME FROM KNTA_USERS KU1 WHERE KU1.USER_ID = RSP.PARENT_ID) USER_NAME,

(SELECT SKILL_NAME FROM RSC_SKILLS RS WHERE RS.SKILL_ID = RSP.SKILL_ID) SKILLS,

PROFICIENCY_LEVEL_CODE APTITUDE 

FROM RSC_SKILL_PROFICIENCY RSP

WHERE RSP.PARENT_ID IN (SELECT KU.USER_ID FROM KNTA_USERS KU WHERE KU.USERNAME IN ('username1','username2'))

 

You can also join with KRSC_RESOURCE_SKILLS_V or KNTA_USERS_V to get complete details....

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Elux_Leslie
Occasional Contributor

Re: Export of Skills - Listed by Resource

Hi and thank you for the response!  However, it's returning zero lines!  Please see below...  Any other ideas? 

 

Note:  I have ensured that there are no hidden characters from the copy/paste that might be affecting the run.

 

Celil
Esteemed Contributor
Solution

Re: Export of Skills - Listed by Resource

Hi Elux,

 

Utkarsh given an example at the end of SQL, username field. Because of you didn't change it, it get no records.
If you get all users skills use this:

 

SELECT RSP.SKILL_ID, 

(SELECT KU1.FULL_NAME FROM KNTA_USERS KU1 WHERE KU1.USER_ID = RSP.PARENT_ID) USER_NAME,

(SELECT SKILL_NAME FROM RSC_SKILLS RS WHERE RS.SKILL_ID = RSP.SKILL_ID) SKILLS,

PROFICIENCY_LEVEL_CODE APTITUDE 

FROM RSC_SKILL_PROFICIENCY RSP

WHERE RSP.PARENT_ID IN (SELECT KU.USER_ID FROM KNTA_USERS KU WHERE KU.ENABLED_FLAG = 'Y'))

 

If you want to get spesific users' skills use this:

 

SELECT RSP.SKILL_ID, 

(SELECT KU1.FULL_NAME FROM KNTA_USERS KU1 WHERE KU1.USER_ID = RSP.PARENT_ID) USER_NAME,

(SELECT SKILL_NAME FROM RSC_SKILLS RS WHERE RS.SKILL_ID = RSP.SKILL_ID) SKILLS,

PROFICIENCY_LEVEL_CODE APTITUDE 

FROM RSC_SKILL_PROFICIENCY RSP

WHERE RSP.PARENT_ID IN (SELECT KU.USER_ID FROM KNTA_USERS KU WHERE KU.USERNAME IN ('username1','username2'))

 

You must enter what you want username instead of red highlighted text

 

Celil

IT Governance Professional
& PPM Solution Architect
Elux_Leslie
Occasional Contributor

Re: Export of Skills - Listed by Resource

Hello Utkarsh and Celil,

 

Thank you so much for your input.  I was able to export the list of users both as single instance and group level.

 

I did have to exclude the line:

WHERE RSP.PARENT_ID IN (SELECT KU.USER_ID FROM KNTA_USERS KU WHERE KU.ENABLED_FLAG = 'Y'))

becuase KU.ENABLED_FLAG threw an error in the system, but it still generated the information I needed.

 

I appreciate your time and advice!  Thanks again!

//Add this to "OnDomLoad" event