brm2015 Absent Member.
Absent Member.
378 views

Requests Export and Import

Hello All,

Is it possible to export PPM requests, staffing profiles and programs from one environment and import it in other environment?

 

Thanks,
BRM

0 Likes
2 Replies
Established Member.. Benny Kung
Established Member..

Re: Requests Export and Import

My company PPMetrics has created a tool called the Excel Inteface (XLI) that can assist with your requirement except for the exporting/importing Programs. It's essentially used to manage and report on PPM data in Excel. PM me if you'd like more info.

0 Likes
Derek Giedd Honored Contributor.
Honored Contributor.

Re: Requests Export and Import

I started developing database procedures to do this, but have not fully completed it yet due to other priorities. I did see some success but I needed to do some more testing and cleanup. It is not the simplest procedure but it does seem to work.  If you want it, I will try to find some time to clean it up a little and then I can send it to you. The process I used was:

1) Create custom database tables to mimic the request interface tables (kcrt_requests_int, kcrt_request_header_details_int, 

2) Run a custom procedure to retrieve the data from the appropriate tables and store this in the custom tables.

3) Copy the custom table data to the destination environment.

4) Run a custom procedure to move the data to the Interface tables.

5) Run the Import Requests report.

-- Remember to give Kudos to answers! (click the KUDOS star)
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.