Clarity

Hi guys!

I hope this time somebody could help me; the problem is: the project's note maintenance.
Each Project has a page of notes that the user can access going on "Action-> Go to Note Page".
My goal is to xog-in / xog-out the list of notes associated to the project.

Can you help me?
I see those notes on "prnote" table but I do not find any way to xog them!

HELP!

prj_timeperiods_write.xml can be used.

I've attached the default xml for your reference.

NJ

If you use

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

<Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>

<Query>


<Filter name="start" criteria="BETWEEN">2012-12-30, 2013-01-03</Filter>




<Filter name="resourceID" criteria="EQUALS">mkinnunen</Filter>


</Query>
</NikuDataBus>


In v12.1 you get

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
<Header action="write" externalSource="NIKU" objectType="timeperiod" version="12.1.1.1208"/>
<TimePeriods>
<TimePeriod finish="2013-01-07T00:00:00" openForTimeEntry="true" start="2012-12-31T00:00:00">
<TimeSheets>
<TimeSheet ID="5001020"
lastModified="2013-01-22T00:31:50"
resourceID="mkinnunen" status="0" version="2">
<TimeSheetEntries>
<TimeSheetEntry assignmentEstimate="0"
assignmentEstimateForTimePeriod="0"
assignmentFinish="2013-04-22T17:00:00"
assignmentID="5003022"
assignmentPendingEstimate="0"
assignmentStart="2012-12-01T08:00:00"
chargeCodeID="capital"
chargeCodeName="Capital"
internalTaskID="5003025"
projectID="PRJ00016" projectName="zUrmas"
taskID="T1" taskName="Task1"
totalActuals="0" typeCodeID="normal" typeCodeName="Normal">
<DailyActuals>
<Actual actualDate="2012-12-31" amount="0"/>
<Actual actualDate="2013-01-01" amount="0"/>
<Actual actualDate="2013-01-02" amount="0"/>
<Actual actualDate="2013-01-03" amount="0"/>
<Actual actualDate="2013-01-04" amount="0"/>
<Actual actualDate="2013-01-05" amount="0"/>
<Actual actualDate="2013-01-06" amount="0"/>
</DailyActuals>
</TimeSheetEntry>
</TimeSheetEntries>
<Notes>
<NoteData category="Timesheet note category"
createdBy="mkinnunen"
createdTime="2013-01-22T00:32:33" noteText="This is timesheet note"/>
</Notes>
</TimeSheet>
</TimeSheets>
</TimePeriod>
</TimePeriods>
<XOGOutput>
<Object type="timeperiod"/>
<Status state="SUCCESS"/>
<Statistics failureRecords="0" insertedRecords="0"
totalNumberOfRecords="1" updatedRecords="0"/>
<Records/>
</XOGOutput>
</NikuDataBus>


Note that it is the timesheet notes you get. You do not get timeentry notes nor task notes.

Martti K.

Were you able to get a solution for this ?

NJ

Any luck with the solution (as Martti had suggested) ? If you can share !!! :wacko:

NJ

Related question:  Is it possible to use XOG to read/write the notes associated with a time entry (PRNOTE.PRTABLENAME="PRTimeEntry").  I believe the answer is no.

The XOG docs and the example above suggest that using the TimePeriods object you can only get the notes associated with a timesheet (PRNOTE.PRTABLENAME="PRTimeSheet")

It sounds like we cannot use XOG but have to go directly to the database, is that correct?

Thanks, JQ

With XOG query apli you can XOG out anything you can query. The down side is tha you cannot XOG that in at all.

 

Martti K.