I have built a DA for our Peoplesoft Actuals. I am doing a manual import in the DA to pull in this information. What I would like to accomplish is to have the option to not import duplicate records. It looks like the file coming from Peoplesoft will actually have the data accrued in it, for example I will get a file for January and it will only have January data. The next file I will receive will have January and February data. The next file I receive will have January, February and March data and so and so on. I have been looking at my DA and the import tool and I do not see where I can have the option to not import duplicate records. I did import my data and then imported the same data again, and it did the import twice so I ended up with duplicated records. Am I missing something or is this the functionality of the DA import tool? I have a few different work arounds that I can do for this, just want to make sure that I am not missing something and making more work for myself. Thank you.

The Import function is only additive - it does not check for or update existing records.  The best way to address this would be to delete the old records prior to importing the new, aggregated records from PS.  Alternately, if you are able to get incremental records from PS (not pre-aggregated), you could allow the DA to peform the aggregation through views, custom fields, and reports.

Another option might be to create a web services integration that would allow you to update existing records rather than deleting/inserting records each month.  This would take more work up front to develop the web services piece, but would eliminate the ongoing administration of the DA data through Daptiv.

Thank you Erik. I will look into the web services integration.