Entries in WorkflowGen Applications (3)
RemoteLaunch Security options
There are 2 possible security cases that could be used in RemoteLaunch.
Case 1: The connected user is a known user in WorkflowGen
* Use the .NET DefaultCredentials
* The user is requester of the process.
Case 2: The connected user is not a known user in WorkflowGen
* Use the .NET NetworkCredentials or Impersonification option throught the web.config (E.g. WorkflowGenUsername)
* The WorkflowGenUsername is requester of the process.
Note: The connected user is the user who is executing the remote launch script.
How can I use a stored procedure with the XMLTODATABASE application?
WFG Team
in WorkflowGen Applications
|
Post a Comment
To use a stored procedure in XmlToDatabase, follow this example which uses the PROCEDURE command:
- This feature is only available with the .NET 2.0 version of the application Advantys.Worflow.Applications.XmlToDatabase.
- You simply have to declare in the transaction file the type of the command:
<command type="PROCEDURE">
Sample:
<command loop="yes" type="PROCEDURE" xpath="/NewDataSet/UserNames/">
{CALL ap_InsertUsers(
'{XPATH::/NewDataSet/Table1/REQUEST_NUMBER}',
'{XPATH:UserNames}')}
</command>
How do I use XmlToDatabase to export web form data to a text file as comma separated values (CSV)?
WFG Team
in Process design, WorkflowGen Applications
|
Post 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
RSS