Clarity

Bonjour,

Nous souhaitons exporter les planning GANTT et/ou Openworkbench de nos projets dans Clarity. Est-il possible de l'effectuer ? Si oui quelle est la méthode à utiliser ?

Est-il possible de les exporter en masse ?

Si cela n'est pas possible est-il possible d'exporter dans un fichier xls ou csv les tâhces jalons et dépendances des projets ?

Merci par avance pou votre retour

Cordialement,

Malheuresement seulement en Anglais

Maybe not answering your question, but touching the subject.

Openworkbench currently stores projects in separate files in rpm or xml format.

Neither can be imported into Clarity.

The standard way is to open each project in OWB and then save the project into Clarity.

In order to be able to do that the resources in the plan must either already exist in Clarity or be created before saving the project.

That is one project at a time. En masse is not possible.

The standard import method into Clarity is XOG and with that you can import projects en masse. Though the same restriction applies as with OWB though it is a little bit relaxed. If the resources does not exist then that data (team membership and assignment is not created, but the project is created).

XOG requires the input to be an xml file. There is a client for XOG which comes with Clarity and you can download it from the UI if you have the permission for that. The Client package has sample xml files for projects to see the structure and data that can be imported.

There are several ways of creating the xml files eg. from data in Excel spreadsheets, but no direct method from OWB views. Copy pasting the data from OWB to Excel and then using, formulas, mailmerge or Excel xml functionality demonstrated by Fedrico Pena of ITRoi to get the xml file(s).

Read the XML Open Gateway (XOG) Development part in documentation.

Hello,

Thanks for your answer. But my question is about export not into import.

We wish to export GANTT or Openworkbench plan of projects in Clarity tool. Is it possible to export ? If yes, which way ?

Is it possible to export all plan of projects one shot ? 

If it is not possible, it is possible to export in file xls or csv withe task, dependencies and milestones ? 

Thanks a lot for your future answer

Best Regards 

We can export project plans from Clarity using the XOG tool (XML Open Gateway). This produces XML data output.

Here is the latest documentation for XOG ; https://docops.ca.com/ca-ppm/15-2/en/reference/xml-open-gateway-xog-development  

The prj_projects_read.xml input for XOG contains various parameters which can define which aspects of a project you want to export.

However this is potentially a lot of information to be exported and there are technical limitations on the size of extract that we can do with XOG so extracting data in a controlled manner will probably be more successful than trying to export "everything".

We can also extract specific data from the database in an XML manner using the "Query API" - this is potentially a large subject area though.

What the XOG query api does is it allows you to read out the  data a NSQL retrieves.

Alternatively you can use the NSQL query as a data source for a portlet  and export to Excel the data.

Basically the query could retrieve  the data for all the projects. If  you read all project data with XOG query api you are  likely to run into performance or memory issues even though the data  is is less than the output of standard  XOG.

When exporting to Excel there  are  limits for the  amount of  data in order to avoid  these performance and memory issues.

Copy paste from OWB one project at a time is the most feasible way to export data from OWB to be used elsewhere.

OWB xml files and standard xml files from XOG require a fair  amount of xml tag removal before they can be used as csv files.