Skip to main content

I would like to copy multiple records from one database table to another and change some of the data in the process.  The tables are on different servers but I have SmartObjects for both of them.  I can think of a way to do this on a form with a list control, but I would prefer doing this in a workflow without pulling the data into a form.  

 

It seems like it should be a simple task, but I am struggling to find a way to do this.

 

Thanks for any help.

That could be tricky. Off the top of my head I think you can do the following (in theory, not tested, mileage may vary, all sales final)

 

  1. Use a thick client designer such as K2 Studio or K2 for VIsual Studio.
  2. In your process that you want to crunch the data, use an advanced destination rule and set it as plan per slot. the list method the slots will require is a list of record IDs from your source DB. Hopefully you have these IDs ahead of time to avoid extra calls. (NOTE: to get the the advanced designation rule, access the destination rule options from the activity property, click the back button and select the "Advanced Mode" checkbox which will expose more options.)
  3. 14882iED9E189770791F84.png
  4. You will need two Smart Object Events in your activity. One for source data and one for destination. You will want to make the return of your source smart object event call to an activity level data field. Since you will be doing a loop you want each cycle of the loop to have it's own data which is why process data fields won't work here as you will step on yourself.
  5. the destination smart object event will use the activity data fields above as input properties.

13380iFE4DDD938D628F59.png

 

Hope this helps.

 

S.


One parting thought, on your activity data fields, ensure that they all have "Keep Audit" turned off (In the screen shot below it is turned on which is default behavior). Depending on the number of records you don't want to go filling up your ServerLog schema with a bunch of transient data.

 

12501iC491343A16BAB218.png

 

 


Thanks Scott!  That worked.


Reply