I am working on creating a separate schema in which we are loading Import/Export workflow's data.
In that schema, Fields are Like Date&Time, Count(In file), Successful (Inserted/Updated), Unsuccessful()Reject.
Can you please help me with that JS which will capture Successful and Unsuccessful Counts after Updating or Rejecting data in Update activity of workflow . So, that I can use it for Updating Our Tracking schema with that.
you can use vars.filename for filename.
build your workflow like this:
use above instance variables to update final update for success and rejected.
You can add your remaining code success js and use in an update.
I am confused with this question, what do you mean by "Advanced of Update data activity". can you explain this and please use a screenshot from your workflow.
Hi Sourabh ,
It's a two-step process
Step 1: Enable success and reject from update data activity(this will work for CRM export activity as well)
Use the following screen for the reference.
Step2: Use vars.recCount or vars.insertCount & vars.updateCount to get the count of records, you can use this variable to do whatever you want to use it for.
Example logInfo("successfully inserterd or updated records: "+vars.recCount);
Hope this helps!
Thanks for your Kind help!
Now I had created everything
Its Loading all required data in table. But Again I am facing some problem and that is
I have to load single data like I had loaded a File data inserted to this export log table is 1 Record of that with file name and like record have 25 data Successful is 24 and rejected is 1. Only one data should be Inserted Like this. I think I am missing some thing.
Thanks for Help !
Let me explain you my requirement.
I had created a Schema that will hold all data we will generate from Workflow failure/Success/Filename/Updated count/Successful/Unsuccessful count.
So based on Update data in Data table I am updating that schema table with workflow log (newly created).
Now this is my Schema ss in which I am loading data
Thanks for your Help!
I have one more doubt If I had checked Generate outbound transition of success and Reject . Then whats the keyword in JS that we will Use in Advanced of Update data activity
Thanks A lot