Hi, i would like to know if anybody have an explanation of the XML
structure.
I'm developping an APP which permit to create lots of Excel report thank to
the XML file.
Recently i have discover some strange figure for the attribute "rate" in
the description of a "Task".
Workbench displays the values of the "estimates" curve when you view Assignment Estimates in a Workbench view. To get the value that Workbench would display as a single number, as opposed to a series of time varying values, you would add up all the work, in hours, for each of the segments. To get the amount of work from each segment you take the number of seconds of work time between the segment start and segment finish and multiply it by the rate and multiply that by 3600 (the number of seconds/per hour). To determine the number of seconds of work time you use the calendar associated with the segment. If there is no calendar associated with the segment then you use the resource's calendar.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for your answer. I'm going to show you the real problem with a XML file com from a Clarity project and save on my localhost with OWB.
I have discover the method you explain me before but i have some strange thing :
1 - In OWB i have the good figures when i open the XML file from my localhost. But in this XML file, i have more data than in the result in OWB :
- In OWB the value of "actuals" for the task xxxxxxx is 0.0
- In the XML file you have that :
<Curve name="actuals" type="2" default="0.0">
<Segments>
<Segment start="2007-01-15T00:00:00" finish="2007-01-16T00:00:00" rate="0.25">
<Calendar>
....... (shift period between monday to friday => 08h-12h/13h-17h)
</Calendar>
</Segment>
<Segment start="2007-01-16T00:00:00" finish="2007-01-17T00:00:00" rate="0.5">
<Calendar>
....... (shift period between monday to friday => 08h-12h/13h-17h)
</Calendar>
</Segment>
There are lot of same case in my XML file, i really don't understand how OWB know when he have to consider this figures or not.....
2 - The second thing in th same XML file :
- For the task YYYYYYY in OWB, i have a value for the "estimates" equals to 3.75. This figure is on the 1st June 2007
- According to what you said and what i have understand, i have to add all segments in curve name="estimates" and take care with dates or whift perdio of the calendar. This is all segments for this case :
From the little information you provided I don't see why OWB is displaying the amounts differently than what is captured in the XML. It could be the way the view is configured, data that violates a business rule, a business rule limiting the range of the data, a bug or ...
If I were debugging the this issue I'd start by getting rid of as much data as I could but still have the issue manifest itself. Once I'd pared the project down as much as possible I'd start debugging in the C++ view code and look to see if the view is modifying the raw values or truncating the bounds of the curves being displayed. If I didn't find anything in the view layer then I'd follow the data trail from the Java side and keep watch of the data as its being requested from the C++ code to see if a business rule is getting invoked and to make sure the data structures actually contain the values we see in the XML.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Do you how i can find a contact with people who work on openworkbench and specialy in XML architecture?
I'm quite new in java developping and a noob in C++ , it could be much more easier for me.
thank you very much for your help!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is the best place to get technical information. Hopefully someone else can give you a hint as to what might be happening if debugging the code is a problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After several test, i have discover that xhen tyou open an XML file with OWB ( a XML file creat by OWB), the result you obtain is quite different that the RMP file. i have notice in a case 50 days more for estimates for a total of 35 days normaly !!!!!
I think, this problem is due to the extract from Clarity server. Our team work on lots of differents modules in Clarity.
I have see also that the deleted task is in the XML file, for the estimates it cause lots of trouble. Do you know there is a field which specify in the XML file that it is a deleted task ??
TASK field's : proxy/critical/status/outlineLevel/summary/milestone /fixed/locked/key/lastUpdatedBy/percComp/unplanned and others which refers to dates.
Thank you
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you're seeing different results, within OWB, between an RMP file and a XML file created from that same RMP then it sounds like it could be a bug. The XML file should not contain deleted tasks. If the task does not exist, when viewing the project from OWB, then it should not reside in either the RMP or the XML file.
Dan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a similar question, but about the structure of Dependencies within the XML file.
It appears External Dependencies (a dependency on a task in another project) are not extracted into the XML format; they simply disappear. For intra-project dependencies, the <Dependency> tag contains a predecessorUID and a successorUID element, but for external dependencies, only the predecessorUID or the successorUID tag (depending on whether the task within the project is a predecessor or a successor) is included.
Can someone please confirm I'm not mis-reading the data construct?
Whether I'm right or wrong, is there a way I can see external dependencies and their attributes in the XML?
Thanks!
Alistair Miller
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, i would like to know if anybody have an explanation of the XML
structure.
I'm developping an APP which permit to create lots of Excel report thank to
the XML file.
Recently i have discover some strange figure for the attribute "rate" in
the description of a "Task".
Thank you.
Sample : <Curve name="estimates" type="2" default="0.0">
<Segments>
<Segment start="2007-06-01T08:00:00" finish="2007-06-01T15:00:00" rate="4.725730142968241E-10">
I don't understant in this case how i can find the same result as OWB.
<b>May be it's possible to access OWB code which treat the XML data?</b>
Workbench displays the values of the "estimates" curve when you view Assignment Estimates in a Workbench view. To get the value that Workbench would display as a single number, as opposed to a series of time varying values, you would add up all the work, in hours, for each of the segments. To get the amount of work from each segment you take the number of seconds of work time between the segment start and segment finish and multiply it by the rate and multiply that by 3600 (the number of seconds/per hour). To determine the number of seconds of work time you use the calendar associated with the segment. If there is no calendar associated with the segment then you use the resource's calendar.
Thank you for your answer. I'm going to show you the real problem with a XML file com from a Clarity project and save on my localhost with OWB.
I have discover the method you explain me before but i have some strange thing :
1 - In OWB i have the good figures when i open the XML file from my localhost. But in this XML file, i have more data than in the result in OWB :
- In OWB the value of "actuals" for the task xxxxxxx is 0.0
- In the XML file you have that :
<Curve name="actuals" type="2" default="0.0">
<Segments>
<Segment start="2007-01-15T00:00:00" finish="2007-01-16T00:00:00" rate="0.25">
<Calendar>
....... (shift period between monday to friday => 08h-12h/13h-17h)
</Calendar>
</Segment>
<Segment start="2007-01-16T00:00:00" finish="2007-01-17T00:00:00" rate="0.5">
<Calendar>
....... (shift period between monday to friday => 08h-12h/13h-17h)
</Calendar>
</Segment>
There are lot of same case in my XML file, i really don't understand how OWB know when he have to consider this figures or not.....
2 - The second thing in th same XML file :
- For the task YYYYYYY in OWB, i have a value for the "estimates" equals to 3.75. This figure is on the 1st June 2007
- According to what you said and what i have understand, i have to add all segments in curve name="estimates" and take care with dates or whift perdio of the calendar. This is all segments for this case :
<Curve name="estimates" type="2" default="0.0">
<Segments>
<Segment start="2007-06-01T08:00:00" finish="2007-06-01T15:00:00" rate="4.725730142968241E-10">
<Calendar>
<Days>
<Day dayOfWeek="SUN" isWorkDay="false"/>
<Day dayOfWeek="MON" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Day>
<Day dayOfWeek="TUE" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Day>
<Day dayOfWeek="WED" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Day>
<Day dayOfWeek="THU" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Day>
<Day dayOfWeek="FRI" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Day>
<Day dayOfWeek="SAT" isWorkDay="false"/>
<Day start="2007-04-09" isWorkDay="false"/>
<Day start="2007-04-16" isWorkDay="false"/>
<Day start="2007-04-17" isWorkDay="false"/>
<Day start="2007-04-18" isWorkDay="false"/>
<Day start="2007-04-19" isWorkDay="false"/>
<Day start="2007-04-20" isWorkDay="false"/>
<Day start="2007-05-01" isWorkDay="false"/>
<Day start="2007-05-08" isWorkDay="false"/>
<Day start="2007-05-17" isWorkDay="false"/>
<Day start="2007-05-28" isWorkDay="true">
<Shifts>
<Shift start="08:00:00" finish="12:00:00"/>
<Shift start="13:00:00" finish="17:00:00"/>
</Shifts>
</Calendar>
</Segment>
<Segment start="2007-06-01T15:00:00" finish="2007-06-01T17:00:00" rate="3.7651901187985004E-5">
<Calendar>
....... (same)
</Calendar>
</segment>
<Segment start="2007-06-01T17:00:00" finish="2007-06-04T00:00:00" rate="1.0">
<Calendar>
....... (same)
</Calendar>
</segment>
<Segment start="2007-06-04T00:00:00" finish="2007-06-04T17:00:00" rate="0.9999905866702733">
<Calendar>
....... (same)
</Calendar>
</segment>
For me it's like a magic thing !!!!! i have work 3 days to find this problem but i did not find it .....
Thank you
From the little information you provided I don't see why OWB is displaying the amounts differently than what is captured in the XML. It could be the way the view is configured, data that violates a business rule, a business rule limiting the range of the data, a bug or ...
If I were debugging the this issue I'd start by getting rid of as much data as I could but still have the issue manifest itself. Once I'd pared the project down as much as possible I'd start debugging in the C++ view code and look to see if the view is modifying the raw values or truncating the bounds of the curves being displayed. If I didn't find anything in the view layer then I'd follow the data trail from the Java side and keep watch of the data as its being requested from the C++ code to see if a business rule is getting invoked and to make sure the data structures actually contain the values we see in the XML.
Thank for you reply.
Do you how i can find a contact with people who work on openworkbench and specialy in XML architecture?
I'm quite new in java developping and a noob in C++ , it could be much more easier for me.
thank you very much for your help!
This is the best place to get technical information. Hopefully someone else can give you a hint as to what might be happening if debugging the code is a problem.
Do you know if we can read the project file .rmp with a software? (i.e : with notepad you cannot)
I want to see its architecture.
thks
hi Dan,
After several test, i have discover that xhen tyou open an XML file with OWB ( a XML file creat by OWB), the result you obtain is quite different that the RMP file. i have notice in a case 50 days more for estimates for a total of 35 days normaly !!!!!
I think, this problem is due to the extract from Clarity server. Our team work on lots of differents modules in Clarity.
I have see also that the deleted task is in the XML file, for the estimates it cause lots of trouble. Do you know there is a field which specify in the XML file that it is a deleted task ??
TASK field's : proxy/critical/status/outlineLevel/summary/milestone /fixed/locked/key/lastUpdatedBy/percComp/unplanned and others which refers to dates.
Thank you
Hello,
If you're seeing different results, within OWB, between an RMP file and a XML file created from that same RMP then it sounds like it could be a bug. The XML file should not contain deleted tasks. If the task does not exist, when viewing the project from OWB, then it should not reside in either the RMP or the XML file.
Dan
I have a similar question, but about the structure of Dependencies within the XML file.
It appears External Dependencies (a dependency on a task in another project) are not extracted into the XML format; they simply disappear. For intra-project dependencies, the <Dependency> tag contains a predecessorUID and a successorUID element, but for external dependencies, only the predecessorUID or the successorUID tag (depending on whether the task within the project is a predecessor or a successor) is included.
Can someone please confirm I'm not mis-reading the data construct?
Whether I'm right or wrong, is there a way I can see external dependencies and their attributes in the XML?
Thanks!
Alistair Miller