Skip navigation
Currently Being Moderated

Sequence number generator for any number of PDF forms

Jun 10, 2011 7:10 AM

Hi,

 

With the help of this forum I have now a simple process in Workbench that acts as a Webservice to generate a sequential number.

 

When invoked by a PDF form it reads a value from a database, increments the value and then reads the db again to send the incremented value back to the form.

 

It's working great, but now I need something else: I have around 60 forms and each will have its own sequence.

 

The way I see it all I have to do is:

 

- include a new column in the db table to store the forms IDs  (I have done this already).

- change the SQL statements to include the form ref number as a parameter for a WHERE clause (I have done this already).

 

and...

 

- send the form ref number from the PDF when invoking the web service. => I still haven't figured out how to do it.

- receive this ref number in workbench to use as a parameter in the WHERE clause.

 

Please could someone help me here?   Or point to some online example I could use as a guide?

 

Will I receive the info from the PDF as an XML file and extract the info from its structure?

 

Thank you very much for any hints.

 

Marcos

 
Replies
  • Currently Being Moderated
    Jun 11, 2011 9:53 PM   in reply to Marcos J Pinto

    Create an input variable in your web service process.

     

    You can use this variable in your SQL activity to get the results.

     

    The WSDL will populate this variable as input paramter of the web service operation.

     

    From your form's dataconnection, you can pass the FormId to Web Service through this input parameter.

     

    Hope that helps,

    Nith

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 13, 2011 4:25 AM   in reply to Marcos J Pinto

    Hi,

     

    Any variable created within a process are accessible by all the acitivties.

     

    You do not need to associate the value through additional acitivity.

     

    e.g. you can directly use this variable value in the SQL activity to increment & get the next sequence number.

     

    Note that you do not even need two SQL activities to perform this. A single SQL activity can execute multiple SQL Queries.

     

    Hope that helps.

     

    Nith

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points