OpenSync

Home Forums OpenSync "Report Refresh" – always deletes rows in target table?

This topic contains 7 replies, has 2 voices, and was last updated by  Yudel Rosales 1 year, 3 months ago.

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #65963

    rafcin
    Participant

    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?

    #65969

    Yudel Rosales
    Keymaster

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

    #66006

    rafcin
    Participant

    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…

    #66020

    Yudel Rosales
    Keymaster

    are you using OpenSync or CoreObjx?

    #66028

    rafcin
    Participant

    OpenSync 3.0.28

    #66091

    Yudel Rosales
    Keymaster

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

    #66107

    rafcin
    Participant

    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…

    #66108

    Yudel Rosales
    Keymaster

    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.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic.