I have an excel sheet with all the relative fields in the request (ITG Request type form information)....User will fill this data in the excel and as an ITG member we need to upload the data from backend (By usind Oracle PL/SQL script)....
is it possible to Automate this procedure....Integration between Excel and ITG Database tables...Possible?
The answer depends on what you mean by "automate"?
You can create new requests from Excel/XML data by using the Excel data import tool. You cannot modify existing request data that way, and it isn't "automated" as such but is more of a data entry shortcut for PPM administrators & consultants.
If you want a truly automated solution that can also modify current request data, then you could build something that uses PPM's web services to do that...
yes you can. Just enhance the existing report type "Import Requests" and add an additional command to run your PL/SQL script. Have a look for the request type details report to see the use of a PL/SQL script in report type.
Does anyone know if there is a utility to insert, export or update any records to HP PPM? I don't see any software offered that allows you to extract or update data without building your own SQL statements. Any ideas???
I was able to Import 'Requests' using the Import functionality but I am not able to Create a Project it gives an Error2: Project Name Required. Is there something wrong that I am doing in importing the Projects. Mine is version 8.0
1. download sql developer from oracle.(its free and its from oracle) 2. format ur xls with header as column name 3. right click on the table and import from xls 4. choose the colums u req 5. finish 6. commit