Performing Ingestion Using Single Ingestion Activity

To perform ingestion using single Ingestion Activity

1. Declare the following Variables in the Start Activity:

   1. VarPanelFormCount – number

   2. VarFileNameArray – array

   3. VarSourceArray – array

   4. VarFileName – string

   5. VarSource – string

   6. VarCompleteTransaction – boolean

   7. intLoopVariable – number

   8. intTotalLoopCount – number

   9. ^MultipleFilesIngestionTransactionId – string

   10. ^MultipleFilesIngestionServiceResponse – string

       

2. Update the VarPanelFormCount Variable value through Initialize Variable(s) property in the Start Activity based on the number of panel forms in the designed form. In this example, the Form is designed with three PanelForms.

   

3. Drag a Script Activity after the Start Activity and name it as GetFileNameandSource.

   11. Set the Language as CSharp.Net.

   12. Enter the code text as below in the Code property.

       using System;
       using System.Collections;
       using System.Xml;
       using Workflow.NET;
       using Workflow.NET.Engine;
       
       public class WorkflowScript61092250167a4eb297eb3890bc7e3b6b
       {
       public string Run(int ExecutionId, int ExecutionDetailsId, Workflow.NET.Engine.Context ctx, Workflow.NET.Action action, string inlink)
       {
       XmlVariable xmlVar = ctx.XmlVariables["SFFormData"];
       var xmlDoc = new XmlDocument();
       xmlDoc.LoadXml(xmlVar.RawXml);
       var totalCnt = Convert.ToInt32(ctx.Variables["VarPanelFormCount"].Value);
       ArrayList arrFileNames = new ArrayList();
       ArrayList arrSourceNames = new ArrayList();
       for (int i = 1; i <= totalCnt; i++)
       {
           var xPath = "Panelform" + i;
       
           foreach (XmlNode nodes in xmlDoc.DocumentElement.SelectNodes("//SKRootDefinition/" + xPath))
           {
               var fileNameXmlNode = nodes.SelectSingleNode("ExportedFileName" + i);
               var sourceXmlNode = nodes.SelectSingleNode("Source" + i);
               if (!string.IsNullOrWhiteSpace(fileNameXmlNode.InnerText))
               {
                   if (ctx.Variables["VarFileNameArray"].Value != null)
                   {
                       arrFileNames = (ArrayList)ctx.Variables["VarFileNameArray"].Value;
                   }
       
                   arrFileNames.Add(fileNameXmlNode.InnerText);
                   ctx.Variables["VarFileNameArray"].Value = arrFileNames;
       
                   if (ctx.Variables["VarSourceArray"].Value != null)
                   {
                       arrSourceNames = (ArrayList)ctx.Variables["VarSourceArray"].Value;
                   }
       
                   arrSourceNames.Add(sourceXmlNode.InnerText);
                   ctx.Variables["VarSourceArray"].Value = arrSourceNames;
                   ctx.SaveVariables();
       
               }
       
           }
       }
       
       ctx.Variables["intTotalLoopCount"].Value = arrFileNames.Count;
       ctx.SaveVariables();
       
       return "Success";
       } 
       }

4. Drag the For Loop Activity from the Engine Activity and connect it from Script Activity named GetFileNameandSource.

   13. Set the Loop Variable as intLoopVariable.

   14. Set the Loop Count as intTotalLoopCount.

   

5. Drag a Script Activity and name it as AssignFileNameandSource.

   15. Link the Script Activity from For Loop with the Output Step.

   16. Set the Language for the Script Activity as CSharp.Net.

   17. Set the Code as below in the Code property.

       using System;
       using System.Collections;
       using Workflow.NET;
       using Workflow.NET.Engine;
       
       public class WorkflowScript226c5adbe4724df2bd7e719c6731c3ad
       {
       public string Run(int ExecutionId, int ExecutionDetailsId, Workflow.NET.Engine.Context ctx, Workflow.NET.Action action, string inlink)
       {
       var index = Convert.ToInt32(ctx.Variables["intLoopVariable"].Value) - 1;
       var loopCount = Convert.ToInt32(ctx.Variables["intTotalLoopCount"].Value);
       ArrayList arrFileNames = (ArrayList)ctx.Variables["VarFileNameArray"].Value;
       ArrayList arrSourceNames = (ArrayList)ctx.Variables["VarSourceArray"].Value;
       
       ctx.Variables["VarFileName"].Value = arrFileNames[index];
       ctx.Variables["VarSource"].Value = arrSourceNames[index];
       
       if ((index + 1) == loopCount)
       {
           ctx.Variables["VarCompleteTransaction"].Value = true;
       }
       else
       {
           ctx.Variables["VarCompleteTransaction"].Value = false;
       }
       
       ctx.SaveVariables();
       return "Success";
       } 
       }

   18. Set the return value as Success.

6. Drag a Ingestion Activity and name it as MultipleFilesIngestion.

   19. Link the AssignFileNameandSource script activity to the Ingestion Activity with the output link as Success.

       1. Set the FileName property value as <%#Variable.VarFileName%>

       2. Set the Source property value as <%#Variable.VarSource%>

       3. Set the Complete Transaction value through Expression Editor pointing to the variable VarCompleteTransaction.

7. Drag the Next Loop Activity from the Engine Activity category.

   20. Link from the MultipleFilesIngestion Activity to the Next Loop Activity with the link output as Successful.

8. Link from the Next Loop Activity to the For Loop Activity with the link output as Next Step.

Design the Workflow as below: