Tracking Of File Import/Export Process.

Hello Amit_Kumar​.

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.

Regards,

Sourabh Kumar

Hi Sourabh,

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.

Regards,

Amit

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!

Reagrds,

Sourabh Kumar

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.

Thanks Amit

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

Regards,

Sourabh

Hi Amit_Kumar

Thanks for Help!

Can you please help me how to capture Filename? 

Regards,

Sourabh kumar

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!

Amit