Third Party tool interface with Clarity which updates resource calendar

[Nidhin Varghese]

Hi All,

 

Please share the experience -If anyone has implemented interface between Clarity and Third Party holiday tool to  update the resource calendar in clarity. Requirement is to update resources calendar based on holidays entered in Third Party tool via an interface so that resources will not have to update their calendar manually for vacations, holidays.

 

Regards,

Ravi

[Anon Anon]

I have the same problematic. Link to my comment on the post Calendar Integration with Outlook , I was thinking to use the REST API but this one seems not to include the calendar access.

[Sridhar Bandaru]

Note sure about REST API but how about SOAP (using rsm_resources_write.xml).  Do you think that helps?

[Deactivated User]

Try Search

Calendar Integration - More Info?

Calendar integration for clarity

Calendar integration for Clarity

Calendar integration with CA Clarity

or talk to any of the integration partners

[Anon Anon]

When you talk about SOAP, it means XOG isn't it ? If yes, XOG can't work on calendar (http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec531261.aspx).

 

About the links, "Calendar Integration for CA PPM" seems to be too "big" for what I want to do. My wish is to synchronize workday and non-workday from outlook to CA PPM.

[Sridhar Bandaru]

I believe the above KB talks about calendars defined by admin. But my point was more about updating resource specific calendar through XOG and it works fine for me, that is, I am able to mark specific day for a resource as holiday and also unmark the same using rsm_resources_write.xml. Is this what you are looking for or something else?

[Anon Anon]

You are right, rsm_resources_write.xml  is what I want. A REST API implementation would be better for me. Thanks

[System]

Hi clarityppmadmin - Did any of the responses help answer your question? If so please mark as Correct Answer. Thanks!

[Owen_R]

We have a semi-manual interface:

I receive an Excel file once a week containing data from the holiday system

I upload the file into a custom table in the Clarity database via SQL Server

I have a GEL script within an on-demand process that reads the contents of the table and creates a rsm_resources_write file setting holidays to be non-working days for the resource  if he/she is present in Clarity and the holiday request is approved.

 

This is on 14.3.  In our previous 12.1.3 environment the file was saved by me to a temp folder on the Clarity application server and read from there using ODBC.  However in 14.3's GEL implementation there's no longer an option to use ODBC to read from Excel, hence the database upload solution.

 

We could fully automate it by getting the two databases to link to each other but for the sake of 5 minutes work each week for me, it's not been worth the development effort.

[mike2.2]

I like this approach. We will be looking at something like this in the next few months. Mind if I PM you then and pick your brains on lessons learned?

[Owen_R]

Not at all, happy to chat about it.

[Monica_Rampradeep_Raj]

Hi - we are using something similar. But it does not load full vacation on to the resource calendar. But only part of it is loaded and rest is ignored. Did you had this kind of issue?

[Sergiu.Gavrila]

Hi Ravi,

 

besides changing the ressource calendar over XOG, which is indeed supported, you could also consider using an other work investment for tracking holidays and reducing capacity. You could have a company wide one or one of for each department.

An interface can easily create team entries and allocations on the other work over XOG and maybe event the REST API (not sure how far the REST Interface right now is).

 

One more reason for :this adding an exception to a calendar  has an sometimes unwanted effect on hard allocation for the resource: the amount of hours/day for a hard booking changes (the availability has changed) outside the requisition process.

 

There are also some other advantages like beeing able to track the holiday time, rights management, ....  but also disadvantages (line investments have to be reduced in the holiday period).

 

I have done both solution for customers, but for our own inhouse implementation we preffered the other work solution.

 

Kind regards,

 

Sergiu Gavrila

[Andrew M]

Like the idea of using other work.

Personally the whole resource calendar is due a revamp to become a simpler, cleaner experience for all.

I do feel sorry for both admins and users

[mike2.2]

Revamp? Nah. A formal goodbye party where we go to CA World, burn the code and toast the developers who will replace it with something that is much more usable and integrates easily with other tools.

 

I'll supply the matches and the toast.