Hi there,
im trying to parse a project XML file into a project database, but I can't seem to work out how to convert the time definition of PT0H0M0S into a Float value....
has anyone had to do this before?
any chance of dishing out the formula or atleast a hint on where to go?
Ta !
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
You can create a custom text field to take in the original data as is, i.e., PT40H48M0S, then you can create another custom field that could look at the first custom field, and select the separate pieces by using a function such as:
(CInt(Mid([Text2],InStr([T
Which will give you the 2448 that you are looking for. You can then update this into the Duration field by adding a module in the VBA Editor that can run through the tasks and update the Duration according to your imported and converted information. In the following case, I used the Text field (Text2) for the above formula, and the Number field (Number2) for the following:
Sub updateDur()
i = 1
Do Until i = Application.ActiveProject.
Application.ActiveCell.Tas
i = i + 1
Application.SelectCellDown
Loop
End Sub
After you import, simply run this routine to update the Duration(s).
One more note: you should probably have your default units for duration set to minutes, otherwise, even though it will import as minutes it will show in the default units -- i.e., as days (unless that's what you want).
You can change the default units for duration in the Tools Menu, Options, Schedule Tab, then set the "Duration is entered in: " Choice to your desired units.
Hope this resolves your situation.
Leslyn :)
In reading my comment above, I want to clarify once more to alleviate any confusion. I imported the into my custom Text field (in this case Text2).
I placed the custom formula in my custom Number field (In this case Number2).
I placed my custom subroutine into a module in the VBA Editor for Project.
Then you can run the routine when you want to update the Duration field.
Leslyn :)
the XML in question is coming straight out of project 2003, if you save a project in XML format all task durations are in the format PTxHxMxS... however, in the Project Database Schema, they need to be a Float value. So I need to convert the PTxHxMxS into a float value.
Leslynf, this would have been the easiest way, however, we do not have the liberty to modify the project server database, all column types need to stay as is.
Business Accounts
Answer for Membership
by: d2kagwPosted on 2005-04-04 at 23:34:51ID: 13704505
i've been able to dig a little deeper.
the XSD definition of PT0h0m0s is that of XSD:Duration,
we have a few examples.
The XML file has the following entry.
PT40H48M0S - which we know means 40 hours, 48 minutes and 0 seconds.
we also know that that [in project terms] converts to 2448 minutes.
however, in the database its stored as 24480
Again, but with different values
PT73H36M0S - which we know means 73 hours, 36 minutes and 0 seconds.
we also know that that [in project terms] converts to 4416 minutes.
however, in the database its stored as 4416000 ?!?!?!
has anyone come across this before?