Clarity

We are planning to create a code which we will get all the timesheet entry from excel or csv file and create a XML to be XOGed into Clarity.

Below queries we are having, if any suggestion please let know.

1. What are the minimum mandatory values we need to provide for the timesheet
to import into Clarity ?
2. Is it mandatory to have XOGing timesheet entry's task id and name matching
as per the Clarity ?
3. If it does not have matching task id and name, will Clarity complaint or
will it allow to enter as a new task for corresponding project ?
4. If it allow then, will it create any issue in Clarity later, if yes then what is expected to go wrong ?

5. To XOG timesheet into Clarity, below things we need to make sure it is
true as per our understanding, please let us know if we are missing out
anything :-
a. Project should be active
b. Time period of the corresponding project should be open.
c. Resource should be active and should be a team member of the project.

5b. Do we need to run any job to make it available to the user or as soon as we import, it available to users in open status

6. We are planning to import timesheet by giving resourceid, project id, start date, finish date, and hours, if required then task information. Rest
all other information we are keeping as null. Based on that can you suggest minimum XML which can be use to upload the data
in Clarity.
7. Is it possible to get the information of the write XML attributes, so that
we can at least decide what we can provide or keep as null ?
For example :-
assignmentEstimate
assignmentEstimateForTimePeriod
assignmentFinish - This might be time period end date for example :
"2014-10-29T17:00:00"
assignmentID
assignmentPendingEstimate
assignmentStart - This might be time period start date for example :
2014-10-18T08:00:00"
chargeCodeID
typeCodeID
internalTaskID

Sorry not trying to answer your questions specifically, but I think you need to do some basic investigation yourself first - many of the answers you seek you should be relatively quick to get.

Read out a timesheet from Clarity using XOG (timeperiod read) - that will give you many of your answers. Experiment with XOG writing it back into Clarity (removing attributes as you go) - that will give you many more answers and will also educate you in how the XML works.

Also there are many threads on the communities regarding timesheet XOG, you should seek those out for some of the problems (and solutions) that you will encounter.

Follow Dave's advice -

"

Read out a timesheet from Clarity using XOG (timeperiod read) - that will give you many of your answers. Experiment with XOG writing it back into Clarity (removing attributes as you go) - that will give you many more answers and will also educate you in how the XML works.

Also there are many threads on the communities regarding timesheet XOG, you should seek those out for some of the problems (and solutions) that you will encounter.

"

Check out this thread as well -

https://communities.ca.com/message/241711998#241711998

NJ

And this -

XOG New Timesheet

https://communities.ca.com/message/100890321#100890321

NJ