Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Email) • Workflow Schedules Version 2.4 and prior • Loop Tool • about • File Writer Tool • Calling Bizweaver from SQL • Introduction (Crystal Reports) • Building a Workflow • contact • downloads
bw2:file_writer_tool

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
bw2:file_writer_tool [2022/08/02 15:30]
akoehler 		bw2:file_writer_tool [2024/09/24 16:22] (current)
dlee [File Writer Variables]
Line 1: Line 1:
-====== Introduction (File Writer)====== 
- 
-This page describes the use of the “File Writer” tool in Bizweaver. Information regarding the associated File Operations and File Reader tools is found in separate documents. 
  
 ====== File Writer Tool ====== ====== File Writer Tool ======
Line 113: Line 110:
 The first step within the loop is to gather the detail for each specific record. The SQL statement to do this is: The first step within the loop is to gather the detail for each specific record. The SQL statement to do this is:
  
-<code sql> Select FileName, FileContent from TWBS_VGO_FormAttachments where [ID] = +<code sql>SELECT fileName 
- +     ,fileContent 
-WorkFlow(SQLCommand1).Get({FIELD_ID}) </code>+FROM twbs_vgo_formAttachments  
 +WHERE id = WorkFlow(SQLCommand1).Get({FIELD_ID}) </code>
  
 The two values are then used in the File Writer step. The two values are then used in the File Writer step.
Line 158: Line 156:
 /* Convert image data to base64 Binary and insert it into a holding table named SignatureCapture. /* Convert image data to base64 Binary and insert it into a holding table named SignatureCapture.
 Assumes a text field named “Name” is used to capture the signature name */ Assumes a text field named “Name” is used to capture the signature name */
-insert into SignatureConvert+INSERT INTO SignatureConvert
 (ObjectID, ControlID, RecordId, FileName, FileType, FileContent, CreateDateTime) (ObjectID, ControlID, RecordId, FileName, FileType, FileContent, CreateDateTime)
-select +SELECT 
-@Object,'SigCapture',@vgoRecNum, isnull(Name,'None'), 'image/png', +     @Object 
-cast('' as xml).value('xs:base64Binary(sql:variable("@convstring"))', 'varbinary(max)'), getdate() +     ,'SigCapture' 
-from F2_SigCapture where vgoRecNum = @vgoRecNum+     ,@vgoRecNum 
 +     ,ISNULL(Name,'None') 
 +     ,'image/png' 
 +     ,CAST('' AS xml).value('xs:base64Binary(sql:variable("@convstring"))' 
 +     ,'varbinary(max)') 
 +     ,GETDATE() 
 +FROM F2_SigCapture 
 +WHERE vgoRecNum = @vgoRecNum
 </code> </code>
  
Line 196: Line 201:
 | StepMessage|During a failure the reason for failure will be populated here | | StepMessage|During a failure the reason for failure will be populated here |
 | StepStatus        |True or False| | StepStatus        |True or False|
 +
 +----
 +**[[bizweaver:Home|Home]]**
bw2/file_writer_tool.1659468626.txt.gz · Last modified: 2022/08/02 15:30 by akoehler

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 4.0 International
CC Attribution-Noncommercial 4.0 International Valid HTML5 Valid CSS Driven by DokuWiki