WorkflowGen.com | Knowledge Base | Documentation | Downloads | Support | RSS

Entries in Process design (45)

Is it possible to have multiple processes each starting at request #1?

Posted on Sunday, May 11, 2008 at 14:56 by Registered CommenterWFG Team in | CommentsPost a Comment

Yes, it is possible.  In the first action of your process you can pass as an IN parameter the macro "Request.Relative Id" to the form.  The first relative ID for any process is 1.

Note that each request's unique Request number is still the Request Id that WorkflowGen generates automatically and that is predominantly visible on the user portal.  By making the Relative Id an additional DATA element of your process you can display this Relative Id as well in the portal in the same way other process data can be displayed.

How do I use XmlToDatabase to export web form data to a text file as comma separated values (CSV)?

Posted on Sunday, January 6, 2008 at 11:29 by Registered CommenterWFG Team in , | CommentsPost a Comment

Here is the example of the transactions.xml file used (located [DRIVE]:\Inetpub\wwwroot\wfgen\WfApps\WebServices\xmlToDatabase\App_Data):   

      <transaction name="EXPORT2TEXT">   
            <databases>   
                  <database name="EXPORT2TEXT" connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Export2Text\;Extended Properties='text;HDR=No;FMT=Delimited';" provider="System.Data.OleDb">   
                        <command type="INSERT" loop="NO" xpath="/NewDataSet/Table1/">   
                                INSERT INTO [CBRE_EXPORT2TEXT]
                                (
                                  [Field1]
                                 ,[Field2]
                                 ,[Field3]
                                 ,[Field4]
                                )
                                VALUES
                                (
                                 '{PARAM:MyParamAsText1}'
                                ,{PARAM:MyParamAsNumeric2}
                                 ,3
                                 ,'{PARAM:MyDateTimeAsMacro1}'
                                )
                        </command>   
                  </database>   
            </databases>   
      </transaction>   

You will require a schema.ini file within the “C:\Export2Text\” folder

[EXPORT2TEXT.txt]   
Format=Delimited(,)   
CharacterSet=ANSI   
ColNameHeader=False   
Col1=Field1 Char
Col2=Field2 Integer Width 40
Col3=Field3 Integer Width 40
Col4=Field4 Date Width 15
comment=my comment

If you do not need a header row (as in this example), set the parameter “HDR=No” in the connection string.  Also, be sure to set Read and Write/Modify permissions on the folder which contains the "EXPORT2TEXT.txt" file.

Reference:  http://www.connectionstrings.com/?carrier=textfile

 

What is the value contained in the macro <WF_ACTIVITY_INST_LIMIT_DATETIME>?

Posted on Sunday, December 16, 2007 at 16:42 by Registered CommenterWFG Team in | CommentsPost a Comment

Question
What is the value contained in the <WF_ACTIVITY_INST_LIMIT_DATETIME> macro? Is it the lead time value (ie: 90 days) of the action or is it the actual date that WFG calculates as the lead time (e.g. 90 days following the action is started/assigned)?

Answer
The latter: it is the calculated end-date (e.g. 90 days into the future), and is cast as a date/time value.

What is the difference between a process and a sub process?

Posted on Sunday, December 2, 2007 at 16:41 by Registered CommenterWFG Team in | CommentsPost a Comment
The only difference is that a sub process can be called from a another process or a third-party application.

How can I copy a process into another WorkflowGen process?

Posted on Sunday, November 25, 2007 at 16:30 by Registered CommenterWFG Team in | CommentsPost a Comment

You can do this by creating a sub process and calling the sub process from your main process.  Or you can set an existing process to be a Public sub process and call it from another main process.

Page | 1 | 2 | 3 | 4 | 5 | Next 5 Entries