Workflow Soluiton

 View Only
  • 1.  Create Multiple calls from spreadsheet

    Posted May 23, 2014 10:44 AM

    I am having a problem getting a workflow set up that allows you to create multiple calls from a spreadsheet. i have a form that the user will upload there excel spreadsheet and then it goes to the next step of reading all the data from it correctly,  I then have it pass to a "For each element in collection" component which then sets up the process and exposes the workflow tracking id,  But it gives all the tickets the same number rather than each new line a new tracking id.  I have attached a screenshot of what i have set up just now to make it easier to see what i am doing and where i might be going wrong.

     

    Currently running Workflow 7.1.1401.59

    Capture.PNG



  • 2.  RE: Create Multiple calls from spreadsheet
    Best Answer

    Posted May 26, 2014 02:46 PM

    Just based on the description you gave, I would recommend you create another workflow process that accepts whatever input you need to have in your process.  

    The steps would be like this:

    (Create a New Workflow Project)
    Setup Process component
    Expose Workflow Tracking ID component
    InsertorUpdateNewUserDIT component
    DialogWorkflowComponent
    Give the project the input line items you need to have mapped over to the ticket process
    Publish this workflow

    (Create a new integration library)
    Create a web service caller generator component that looks at the web service of your workflow project (above)

    (In your existing project, should be more of a feeder-type project)
    File Upload component
    DynamicClassRead component
    For Each Element in Collection component
    Web Service Caller integration component - this is created dynamically by publishing a workflow-type project that accepts input values (described above) and then, using an integration generator, create a web service caller generator that points to that published workflow.  This component will call the workflow as many times as the For Each component hits it, and will create that many process tickets as well, because each time it hits the web service component, the first component in the target workflow is a Setup Process component.

    It's not easy to explain in text, so i hope you got at least some ideas from this post - if you need help setting it up send me a PM and I'll be glad to do a quick webex to help.

    Also - unless you absolutely need the task/timeout/etc capabilities of the Dialog Workflow component over the regular Web Form projects, the feeders are normally used as Web Forms and trigger the workflow-type projects with web service calls.  What you have above could perhaps be migrated to a web form to give it a lighter footprint.



  • 3.  RE: Create Multiple calls from spreadsheet

    Posted May 27, 2014 08:12 AM

    Thanks for you help with this done as you said above and now work great.