What operations are performed on the data sets update in FlexiCapture?

 When you run the data set update in FlexiCapture 12, operations performed with data set records are follows:

1. If the data set record was manually edited, the edited values are not changed. They are kept in the  FlexiCapture data set.

2. If the data set record was not changed, but some record values were changed in source database, the data set record values are replaced with database values.

3. If the data set record was not changed, and it is the same as source database record, the values are replaced with database values. We actually do not see the difference. However, sometimes it is necessary to take in account that the record is not skipped, but rewritten.

4. If the record is deleted from the data set, but exists in the source database, it will be added to the data set.

5. If the record is manually added to the data set, but never existed in source database, it will be deleted from the data set and will not be added to the source database.

6. If the record was added to the data set from database, was never edited, but now does not exist in the source database, it will be deleted from the data set. It will not be added to the source database.

7. To erase all the edited records from the data set, it is recommended to reconnect the source data base, e.g. to create a new connection string. To do it, use the Set Up... button:

mceclip1.png

Or, just erase the database and update it manually. To do it, use the Clean Up button to erase and the Update button to populate the data set: 

mceclip3.png

You can find a detailed description and additional information about the data sets update process in the Updating data sets article.

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.

Recently viewed