Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (WebService Tool v2) • Introduction (Email) • Workflow Schedules Version 2.4 and prior • Loop Tool • about • Calling Bizweaver from SQL • Building a Workflow • contact • File Writer Tool • 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 [2024/01/08 14:17]
wgates [Uploaded Versago Data] 		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 159: 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 197: 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.1704741421.txt.gz · Last modified: 2024/01/08 14:17 by wgates

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