"Report Refresh" – always deletes rows in target table?

[rafcinParticipant]

am I doing something wrong or is it a bug?
my task has these directives:

<Operation>Report</Operation>
<Handle>E663C19B8002491E97AF224ED8FCFE5E</Handle>
<RepeatInterval>0</RepeatInterval>
<RepeatUnits>0</RepeatUnits>
<StartTime>12:00:00 AM</StartTime>
<Disabled>False</Disabled>
<ChunkByDate>False</ChunkByDate>
<DaysInChunk>0</DaysInChunk>
<ReportChunkDays>0</ReportChunkDays>
<ReportGenericCols>False</ReportGenericCols>
<ReportAppend>True</ReportAppend>
<ReportDeleteRows>False</ReportDeleteRows>

You’d expect that the rows retrieved would be written to the target table and if there are any existing records they won’t be deleted… yet – i see that this table ALWAYS get purged… is there a way to have the task preserve existing data?

[Yudel RosalesKeymaster]

when you create the task you have to pick the append option. That will preserve the data retrieved before.

[rafcinParticipant]

Thanks for the response, but please look at the part of the OSConfig XML file I included:

<ReportAppend>True</ReportAppend>
<ReportDeleteRows>False</ReportDeleteRows>

As you can see the “Append” option IS set up to “True”, however the records still get deleted…

[Yudel RosalesKeymaster]

are you using OpenSync or CoreObjx?

[rafcinParticipant]

OpenSync 3.0.28

[Yudel RosalesKeymaster]

Append doesn’t work for the Report task. Sorry for the inconvenience.

[rafcinParticipant]

thanks for confirming it.
Any chance you guys could put it on “future enhancements” list?
Don’t believe it can be a hard thing to do…

[Yudel RosalesKeymaster]

That is something to look forward to implementing. The thing with reports that you can always add or delete rows, this makes the append harder to implement. But It will worth the look into it.

[Author]

Posts