Skip to content
+1-888-319-3663

COMMUNITY FORUM

do not import when in Database

bhopkins@broadpoint.net asked 8 years ago
Can someone tell me how to create the script on a task to skip records in the source file if the record is already in the database.

For instance is the customer id is already in the database skip this in the source file and move to pull in the next record.


I think i would add this Task under Task to run before the document, but not sure?

thanks Brenda
Answers
Best Answer
lorren answered 8 years ago
Brenda,

If you have our latest release of Smart Connect 2013, you can use a Multi-data source to restrict out those records that already exist.

Here is a Tech Tuesday article with Video that explains how you can do that.  This will help you accomplish the same task without having to write .NET code.

http://eonesolutions.blogspot.com/2013/12/tech-tuesday-multi-data-source-example.html

Lorren

If you would like to submit an answer or comment, please sign in to the eOne portal.