Tracking Of File Import/Export Process. | Community
Skip to main content
S
sourabhk3112
Level 2
February 6, 2018
Solved

Tracking Of File Import/Export Process.

  • February 6, 2018
  • 8 replies
  • 5181 views

Hi Team / Vipul Raghav​Amit_Kumar​

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.

Regards,

Sourabh Kumar

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    you can use vars.filename for filename.

    8 replies

    Amit_Kumar
    Amit_Kumar
    Level 10
    February 6, 2018

    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

      S
      sourabhk3112Author
      Level 2
      February 6, 2018

      Hi Amit_Kumar

      Thanks for Help!

      Can you please help me how to capture Filename? 

      Regards,

      Sourabh kumar

      Amit_Kumar
      Amit_KumarAccepted solution
      Level 10
      February 6, 2018

      you can use vars.filename for filename.

      S
      sourabhk3112Author
      Level 2
      February 6, 2018

      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

      Amit_Kumar
      Amit_Kumar
      Level 10
      February 6, 2018

      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.

        S
        sourabhk3112Author
        Level 2
        February 6, 2018

        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

        Amit_Kumar
        Amit_Kumar
        Level 10
        February 6, 2018

        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

          S
          sourabhk3112Author
          Level 2
          February 7, 2018

          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

          Terms & ConditionsAccessibility statement

          Loading footer...