do not import when in Database
bhopkins@broadpoint.net asked 10 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
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 10 years ago
lorren answered 10 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 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