Project and Portfolio Management Practitioners Forum
cancel

Import Excel to PPM

Highlighted
SDeRosa1
New Member.

Import Excel to PPM

Hello,

 

I have multiple projects that I need to do the staffing for. People have entered the resources they need, as well as their allocations, for the upcoming months in an excel workbook.

 

I was wondering if there was a way to import the excel file into PPM in order to staff all of the projects? Or am I only able to input each resource manually?

 

Thank you.

2 REPLIES
d4y4n4
Honored Contributor.

Re: Import Excel to PPM

As far I know we do not have such functionality. however we do have submitted some related ERs

QCCR1L26899: Importing from Excel to modify the forecasted hours by resource
QCCR1L35964: XML Import Utility - Users include additional field in resource XML import utility

We only have a XML and XSLT templates for requests check the release note http://support.openview.hp.com/selfsolve/document/KM1355991 on page 280
Manvendra_Singh
New Member.

Re: Import Excel to PPM

Hello,

 

Have you tried using the SQL control files from the database end to load the data in the .csv or .xls files into ppm tables.

 

Thanks!!!

 

Regards,

Manvendra Singh