Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Absent Member.. Keeko Absent Member..
Absent Member..
1697 views

Using PPM commands through PL/SQL

Hi,

 

Can we use PPM commands through PL/SQL?

 

The actual requirement is to create Financial Summary Snapshots of projects in the system. The 'Take Snapshot' commands takes request ID as a parameter. Can't think of a way to call this command repeatedly for all projects. 

 

 

Thanks

Tags (1)
0 Likes
5 Replies
Bharath_Kumar Absent Member.
Absent Member.

Re: Using PPM commands through PL/SQL

Hey Keeko,

 

Use the OOB command

 

ksc_take_snapshot

 

which takes the following four arguments as parameters:

1) Req ID, 2) Snapshot name 3) Snapshot Desc and 4) Plan of Record (T or F).

 

if the version was upgraded all the budgets would have automatically converted to FS, however please us the above command in PL SQL code to achieve your goal.

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

Re: Using PPM commands through PL/SQL

Hi Bharat,

 

I know about that command, but the question is how can I use it to create snapshots of all the active projects in the system at one go. Trying of doing it through a report, but I'm not sure how to do it. I mean, creating a FS snapshot for single project is one thing, and creating FS snapshopts for all active projects is another. Need some ideas on that

0 Likes
Highlighted
Established Member.. Utkarsh_Mishra
Established Member..

Re: Using PPM commands through PL/SQL

Create a command which loops through the requested Projects/Proposals (can hard code it), then pass the ID one by one in ksc_take_snapshot.

Call this command in Report.

It works, I had done the same to mass update the work plan status.
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Absent Member.. PMOpartners Absent Member..
Absent Member..

Re: Using PPM commands through PL/SQL

That would be really useful, but I would not know how to start to prepare the list of projects and then go through one by one to call the 'take snapshot' special command using commands.

 

Any  prepared examples?

0 Likes
Established Member.. Utkarsh_Mishra
Established Member..

Re: Using PPM commands through PL/SQL

Well, using web servies is the asiest way to do.

 

In case of using command; you can create a CSV file (Project ID, Snapshot description..etc)... and use the method described in this post (below).

 

http://www.unix.com/shell-programming-scripting/31608-read-csv-file-assign-values-variable.html

 

You can google to get more example.

Cheers..
Utkarsh Mishra

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