Wiki bw

Bizweaver Activity Logging

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Oct 2019 14:48:18 +0000

Bizweaver Activity Logging As noted earlier in this document, actions from the Test Run tool are logged in text files. However, when a schedule executes a workflow, or using the “Run now” option, step information is logged to the SQL database used by Bizweaver.

Adding and Updating Business Partner Addresses

anonymous@undisclosed.example.com (Anonymous) — Tue, 19 Feb 2019 15:22:59 +0000

Adding and Updating Business Partner Addresses Following is an example for adding a new Business Partner address. In this example, the information for the new address is held in a SQL table named “SBO_Address_Info,” which is in a database named “VersagoData.”

Adding and Updating Business Partner Contacts

anonymous@undisclosed.example.com (Anonymous) — Tue, 19 Feb 2019 15:27:03 +0000

Adding and Updating Business Partner Contacts Following is an example for adding a new Business Partner contact. In this example, the information for the new address is held in a SQL table named “SBO_Contact_Info,” which is in a database named “VersagoData.”

Introduction (Bizweaver)

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 18:14:20 +0000

Introduction (Bizweaver) This set of pages provides an overview of the Bizweaver data integration application. Audience This document is intended for developers of Bizweaver workflows. Knowledge of standard SQL (Microsoft T-SQL) statements is required.

B1 Messages

anonymous@undisclosed.example.com (Anonymous) — Mon, 04 May 2020 16:14:28 +0000

B1 Messages SAP Business One messages can be created using DI API. These messages are displayed in the Incoming Messages area in Business One. The basic query to prepare to send a message will be something like this. select t0.UserID, t0.User_Code, t0.U_Name, 'Test Message' as "Subject", 'Test message text' as "MessageText", 1 as "SendInternal", -1 as "RecipientTypee", 1 as "MsgPriority", E_Mail from OUSR t0 where t0.UserID = 1

BigCommerce WebService Access

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 18:21:38 +0000

BigCommerce WebService Access Before a BigCommerce store can be accessed using the APIs, the store must be configured to allow this access. The configuration process is described in the following section. Some of the BigCommerce APIs can be accessed using basic authentication, but this is not advisable. BigCommerce is indicates that not all APIs are available with this type of authentication. And basic authentication will not be allowed at some point in the future.

Introduction (Bizweaver)

anonymous@undisclosed.example.com (Anonymous) — Wed, 26 Jan 2022 11:49:39 +0000

Introduction (Bizweaver) The Bizweaver application is set of tools used to automate data acquisition, data manipulation, file management activities, as-well-as providing data integration into SAP Business One. The various tools provided by Bizweaver are linked together as a set of sequential steps called a workflow.

Bizweaver API

anonymous@undisclosed.example.com (Anonymous) — Thu, 23 Jul 2020 11:26:47 +0000

Bizweaver API Bizweaver has its own API that can be used in a variety of ways. This is a directly-called API and does not currently use REST as the communication mechanism. Instead, a specially formatted URL is used. The two most common uses are to invoke a Bizweaver workflow from a Versago form or report, and to have one workflow call another workflow. See the

Introduction (Bizweaver)

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Dec 2020 14:14:18 +0000

Bizweaver Environment Requirements

anonymous@undisclosed.example.com (Anonymous) — Thu, 27 Aug 2020 12:04:23 +0000

Bizweaver Environment Requirements Review the following requirements for your Bizweaver environment. Server Hardware Requirements The following information represents a general guideline for minimum hardware requirements. They should be adequate for most Bizweaver installations. However, it may be necessary to increase CPU and RAM in larger installations.

General Settings for Bizweaver

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 17:08:03 +0000

General Settings for Bizweaver [General Settings] Database Settings Server and Database: The SQL Server instance and database where Bizweaver configuration information is held. * These values are set during installation and cannot be changed here. Username and

Trigger Configuration for Versago Multi-Select Report Processing

anonymous@undisclosed.example.com (Anonymous) — Tue, 28 Apr 2020 15:23:22 +0000

Trigger Configuration for Versago Multi-Select Report Processing Create the trigger on the table where records are saved by your Versago multi-select report. Values in are specific to your installation and need to be changed accordingly. The < and > symbols are removed when the desired value is entered.

Bizweaver Tips

anonymous@undisclosed.example.com (Anonymous) — Mon, 08 Jun 2020 09:15:14 +0000

Bizweaver Tips This page is for tips and tricks that have been helpful to users. If you have any suggestions please submit them via the Third Wave portal. Dealing with invalid email addresses If the Bizweaver email tool is configured to send an email from a variable that contains email addresses and, if a invalid email address is passed, the workflow can stop with errors. The following SQL statement examples can help find bad emails in the data on the SAP Contact Persons Table (OCPR).

Bizweaver Version

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Dec 2025 10:07:09 +0000

Bizweaver Version * Bizweaver 2025 R2 Bizweaver Release Notes To review Bizweaver release notes please click here Bizweaver Licensing Support For assistance with issues relating to licensing click here

Building a Workflow

anonymous@undisclosed.example.com (Anonymous) — Tue, 22 Oct 2019 16:43:40 +0000

Building a Workflow A workflow is constructed by connecting the various Bizweaver tools in a sequential manner. This is done in the Workflow Design pane. For this discussion, this area will be called the “design pane.” Start the process with an empty design pane. Click the “New Item” icon

bw:business_partner_for_service_layer

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Apr 2019 16:23:39 +0000

JSON for Business Partner { "odata.metadata": "https://18.208.56.251:50000/b1s/v1/$metadata#BusinessPartners/@Element", "CardCode": "C20000", "CardName": "Maxi-Tech", "CardType": "cCustomer", "GroupCode": 107, "Address": "4417 Stonebridge Rd", "ZipCode": "18067", "MailAddress": "4417 Stonebridge Rd", "MailZipCode": "18067", "Phone1": "555-0110", "Phone2": null, "Fax": "555-0111", "ContactPerson": "Max Teq", "Notes": null, "PayTermsGrpCode": 1, "CreditLimit": 0, …

Calling Bizweaver from SAP Business One

anonymous@undisclosed.example.com (Anonymous) — Thu, 23 Jul 2020 11:14:47 +0000

Calling Bizweaver from SAP Business One Some special program code, provided by Third Wave Business Systems, is required for this functionality to work. Configuration of the special code is described here. This is a technical process and should not be attempted by anyone not familiar with T-SQL stored procedures. Contact TWBS support if you need assistance.

SQL Configuration to Call a Bizweaver Workflow

anonymous@undisclosed.example.com (Anonymous) — Fri, 18 Dec 2020 13:25:29 +0000

SQL Configuration to Call a Bizweaver Workflow The following actions should only be performed by persons familiar with SQL Server Management Studio and understand how to manipulate objects in a database. To Begin The Bizweaver Web Service needs to be installed either from a Versago or Bizweaver installation to have the below file path available. If

Introduction (Crystal Reports)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 16:50:00 +0000

Introduction (Crystal Reports) This document describes the use of the Bizweaver Crystal Reports tool. Related Documents The following pages contain additional information that may be helpful with the development of Bizweaver workflows using the Crystal Reports tool.

Introduction to DataBuilder

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 15:33:32 +0000

Introduction to DataBuilder This document described the use of the Bizweaver DataBuilder tool. This tool is used to create JSON and XML data structures for use with web service APIs. Related Documents The following documents contain additional information that may be helpful with the development of Bizweaver workflows.

Introduction (Decisions)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 15:17:55 +0000

Introduction (Decisions) This page describes the use of the Bizweaver Decision tool Decision Tool The Bizweaver Decision tool provides the ability to do “branching” within a workflow based on values found in previous workflow steps. The test condition can be very simple, based on a single value, or more complicated using AND/OR conditions for a single test.

Introduction (Email)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 17:06:29 +0000

Introduction (Email) This document describes the use of the Bizweaver Email tool. Audience This document is intended for developers of Bizweaver workflows. Related Documents The following documents contain additional information that may be helpful with the development of Bizweaver workflows.

Introduction (Encryption)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 17:02:56 +0000

Introduction (Encryption) This page describes the use of the Bizweaver Encrypt Decrypt Tool. Encrypt Decrypt Tool The encryption tool is best used to encrypt data from a source (AWS, Versago) to your database. The functionality is used to store sensitive data in a database, or a file. The tool accepts a string as input and encrypts it with a key you create. To view the string in clear text it must be decrypted with the same key. An encryption step can be added any where to a workflow. In the…

Introduction to Error Handling

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Feb 2021 16:51:35 +0000

Introduction to Error Handling Error handling is introduced in version 2.2 of Bizweaver. Error handling in Bizweaver allows the designer/administrator to easily handle error conditions in a workflow. There are two levels of error handling: workflow level and step level. The configuration of these levels is described in the following sections.

Introduction (ExchangeConnector)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 16:55:08 +0000

Introduction (ExchangeConnector) This page describes the configuration of the Bizweaver ExchangeConnectortool. This tool is used to read email from a designated user and create new appointments for any user defined in Exchange. Related Documents The following pages contain additional information that may be helpful with the development of Bizweaver workflows using the Exchange Connector tool.

Executing a Workflow

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Jun 2020 10:20:44 +0000

Executing a Workflow There are four methods to execute a Bizweaver workflow: test/debug mode, “run now“, scheduled, and from SQL. The results are the same for all methods. Test/Debug Mode The Bizweaver Test Run Tool allows a developer to execute a workflow in a step-by-step manner. Variable values can be examined at each step to confirm that they are what is expected. More information on this tool is found

Introduction (File Operations)

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Sep 2020 14:30:06 +0000

Introduction (File Operations) This page describes the use of the “File Operations” tool in Bizweaver. Information regarding the associated File Reader and File Writer tools is found in separate documents. File Operations Tool The File Operations

Introduction (File Reader)

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Sep 2020 14:28:19 +0000

Introduction (File Reader) This page describes the use of the “File Reader” tool in Bizweaver. Information regarding the associated File Operations and File Writer tools is found in separate documents. Special Note Beginning in Bizweaver v2.0.170, two File Reader tools are displayed: FileReader and FileReader2. The functions are the same in both tools except for changes for handling XML and JSON files found in FileReader2. While workflows created using FileReader will continue to function, an…

Introduction (File Writer)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 15:29:53 +0000

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 The File Writer tool is used to format data from any previous step in a Bizweaver workflow whose output can be processed to write the data in a delimited format, structured format (XML), Excel, or Base64 binary data. The resulting file can then be used as needed in subsequent w…

FTP and Bizweaver

anonymous@undisclosed.example.com (Anonymous) — Fri, 22 Apr 2022 10:30:23 +0000

FTP and Bizweaver By design, Bizweaver does not include its own FTP functionality. Instead it uses the WF_Exec tool to call any FTP application that supports a command-line interface. The most common application used by Third Wave is winSCP (). We have found that winSCP offers all the functionality that is typically required. This page describes how to use winSCP with Bizweaver.

Introduction (Global Connections)

anonymous@undisclosed.example.com (Anonymous) — Mon, 10 May 2021 14:21:25 +0000

Introduction (Global Connections) This document describes to the process to create Bizweaver global connections. Global connections define connection information to allow other Bizweaver tools to interact with SQL Server databases, SAP HANA databases, SAP Business One DI Server, SAP Business One DI

HANA SQL Tips

anonymous@undisclosed.example.com (Anonymous) — Mon, 10 Aug 2020 14:34:26 +0000

HANA SQL Tips This page offers some tips for users that have experience with T-SQL (Microsoft SQL Server) and are switching to SAP HANA SQL. * HANA database objects (tables, columns, etc.) are enclosed in double-quotes. Tables do not need to be but it is easier to do it for consistency.

Introduction (Import/Export)

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Dec 2020 12:09:28 +0000

Introduction (Import/Export) This document discusses the Bizweaver Export/Import functionality. Audience This document is intended for developers of Bizweaver workflows. Related Documents The following documents contain additional information that may be helpful with the development of Bizweaver workflows.

Bizweaver Installation/Upgrade

anonymous@undisclosed.example.com (Anonymous) — Tue, 10 Sep 2019 11:55:28 +0000

Bizweaver Installation/Upgrade The process to install and upgrade Bizweaver is described here. Environment and Security Bizweaver environment and security information is found here. Installing and Upgrading Bizweaver This page outlines the process for installing and updating Bizweaver. The basic installation or upgrade of Bizweaver will typically take 15 minutes or less.

Preparation

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 17:07:13 +0000

This page describes the process for installing and updating Bizweaver. The basic installation of Bizweaver will typically take 15 minutes or less. Installation and updates follow the same set of steps. The only difference is that in an update, the Server Configuration values defined in a previous installation will automatically be displayed. The values can be used by clicking [

SAP Business One Inventory Transfer with Bins

anonymous@undisclosed.example.com (Anonymous) — Tue, 19 Feb 2019 15:04:37 +0000

SAP Business One Inventory Transfer with Bins Using DI Server or DI API to post an inventory transfer transaction in SAP Business One requires some additional configuration as described in this page. Basic Approach * A record for each From/To combination is needed, including cases where the From and To warehouses are different.

Bizweaver Old Licensing Assistance

anonymous@undisclosed.example.com (Anonymous) — Thu, 08 May 2025 13:42:15 +0000

Bizweaver Old Licensing Assistance The following are explanations for various situations that may arise with regard to the access and use of Bizweaver, the status of the license/maintenance or subscription contract, and the steps you can take to resolve the issue.

Introduction (Looping Tool)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 10:57:08 +0000

Introduction (Looping Tool) This page describes the use of the “looping” tool in Bizweaver. The Looping Tool The Bizweaver “looping” tool is a mechanism used to process a series of objects in succession while, optionally, performing other actions on each object. Typical use cases include:

Moving from Test to Production

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 17:13:30 +0000

Moving from Test to Production The Import/Export process also provides a mechanism to migrate workflows from testing to production in the same environment. Using this process means that you will not need to go into each workflow and change the connections. It also leaves your test workflows in place for later use, if needed. The basic steps are noted below.

Introduction (Pause)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 17:01:10 +0000

Introduction (Pause) This page describes the use of the Bizweaver Pause tool. Related Documents The following pagescontain additional information that may be helpful with the development of Bizweaver workflows using the Pause tool. * WebService Tool Beginning with Bizweaver v2.3, it is not necessary to use the Pause tool to control the execution of Bizweaver WebService steps. The WebService tool has its own

bw:purchase_order_for_service_layer

anonymous@undisclosed.example.com (Anonymous) — Tue, 09 Apr 2019 10:07:11 +0000

JSON for Purchase Order { "odata.metadata" : "https://18.208.56.251:50000/b1s/v1/$metadata#PurchaseOrders/@Element", "DocEntry" : 1, "DocNum" : 1, "DocType" : "dDocument_Items", "HandWritten" : "tNO", "Printed" : "psNo", "DocDate" : "2006-01-01", "DocDueDate" : "2006-01-16", "CardCode" : "V10000", "CardName" : "Acme Associates", "Address" : "600 Eastern Blvd\r\rManchester PA 03101\rUSA", "NumAtCard" : null, "DocTotal" : 19485.0, "AttachmentEntry" : nu…

Bizweaver Release Notes

anonymous@undisclosed.example.com (Anonymous) — Fri, 06 Jun 2025 13:21:43 +0000

Bizweaver Release Notes This page is dedicated to listing all release notes of Bizweaver from version 2.4.4 forward. Version - 2.4, Build 2.4.4 * New Features * BW-339 - Added a new option in the top icon bar to search for a workflow either by ID number or by name. The workflow can then be opened when selected.

Renaming A Bizweaver Databases

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Jun 2020 16:54:02 +0000

Renaming A Bizweaver Databases This process is most commonly done when you are switching a “Test” Database and connections to a “Live” or production database. For changing a Bizweaver database name the process is as follows. Renaming A Bizweaver Database

bw:sales_delivery_for_service_layer

anonymous@undisclosed.example.com (Anonymous) — Tue, 09 Apr 2019 10:19:18 +0000

JSON for Sales Delivery Note { "odata.metadata" : "https://18.208.56.251:50000/b1s/v1/$metadata#DeliveryNotes/@Element", "DocEntry" : 1, "DocNum" : 1, "DocType" : "dDocument_Items", "HandWritten" : "tNO", "Printed" : "psNo", "DocDate" : "2006-01-20", "DocDueDate" : "2006-01-20", "CardCode" : "C20000", "CardName" : "Norm Thompson", "Address" : "300 Billings Drive\rSuite 500\rHavertown PA 19083\rUSA", "NumAtCard" : null, "DocTotal" : 14310.0, "Attachmen…

bw:sales_invoice_for_service_layer

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Apr 2019 16:08:53 +0000

JSON for Sales Invoice { "odata.metadata": "https://18.208.56.251:50000/b1s/v1/$metadata#Invoices/@Element", "DocEntry": 1, "DocNum": 1, "DocType": "dDocument_Items", "HandWritten": "tNO", "Printed": "psNo", "DocDate": "2006-01-22", "DocDueDate": "2006-02-21", "CardCode": "C20000", "CardName": "Norm Thompson", "Address": "300 Billings Drive\rSuite 500\rHavertown PA 19083\rUSA", "NumAtCard": null, "DocTotal": 14310, "AttachmentEntry": null, "DocCurrency": "$", "…

bw:sales_order_for_service_layer

anonymous@undisclosed.example.com (Anonymous) — Thu, 04 Apr 2019 16:13:32 +0000

JSON for Sales Order { "odata.metadata" : "https://18.208.56.251:50000/b1s/v1/$metadata#Orders/@Element", "DocEntry" : 1228, "DocNum" : 1191, "DocType" : "dDocument_Items", "HandWritten" : "tNO", "Printed" : "psNo", "DocDate" : "2019-02-21", "DocDueDate" : "2019-02-28", "CardCode" : "C20000", "CardName" : "Maxi-Tech", "Address" : "4417 Stonebridge Rd\rSuite 500\rNorthampton PA 18067\rUSA", "NumAtCard" : null, "DocTotal" : 412.080, "AttachmentEntry" : …

Salesforce.com API

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 18:18:30 +0000

Salesforce.com API All information presented here is based on the Salesforce.com Classic edition. Instructions for the Lightning edition may be slightly different. Setup Before Salesforce can be used by Bizweaver, some connection information must be configured on the Salesforce.com site.

SAP Business One Enumerators

anonymous@undisclosed.example.com (Anonymous) — Wed, 15 Apr 2020 14:36:28 +0000

SAP Business One Enumerators “Enumerators” are the values that are passed to SAP Business One to represent a certain value when using an application interface like Data Transfer Workbench (DTW) or DI Server. A different value may be passed to the interface depending on the tool being used.

bw:sap_business_one_integration_for_sql_server_databases

anonymous@undisclosed.example.com (Anonymous) — Mon, 04 May 2020 15:53:31 +0000

bw:sap_business_one_integration_using_di#mapping_tips

Introduction (SAP Business One Integration on SQL Server)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 16:46:18 +0000

Introduction (SAP Business One Integration on SQL Server) This page discusses the Bizweaver tools used for integration with SAP Business One (SBO) on SQL Server databases. Related Documents The following pages contain additional information that may be helpful with the development of Bizweaver workflows.

Introduction (SAP Business One Integration Using Service Layer)

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Dec 2020 12:53:22 +0000

Introduction (SAP Business One Integration Using Service Layer) This page discusses the Bizweaver tools used for integration with SAP Business One (SBO) using the SAP Business One Service Layer. Service Layer integration is available for HANA installations as of SAP Business One v9.3. It will also be available for SQL Server installations in v10.

bw:sap_objects

anonymous@undisclosed.example.com (Anonymous) — Wed, 13 Mar 2019 11:54:33 +0000

Object Type CodeDescription1ChartOfAccounts object2BusinessPartners object3Banks object4Items object5VatGroups object6PriceLists object7SpecialPrices object8ItemProperties object12Users object13Documents object that represents a sales invoice document

SAP Business One Service Layer using Bizweaver v2.4

anonymous@undisclosed.example.com (Anonymous) — Wed, 22 Apr 2020 16:21:41 +0000

SAP Business One Service Layer using Bizweaver v2.4 Accessing SAP Business One using the Service Layer is a two-step process. The first step (Login) responds with two cookies. These cookies are then used in any subsequent web service calls in the current processing cycle. In Bizweaver v2.4, the configuration of the web service steps is quite manual.

SAP Business One Service Layer using Bizweaver v2.5 and higher

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 18:24:19 +0000

SAP Business One Service Layer using Bizweaver v2.5 and higher Accessing SAP Business One using the Service Layer is a two-step process. The first step (Login) responds with two cookies. These cookies are then used in any subsequent web service calls in the current processing cycle.

Introduction (SBO Schemas)

anonymous@undisclosed.example.com (Anonymous) — Wed, 13 Feb 2019 14:16:15 +0000

Introduction (SBO Schemas) This document discusses the data schemas used by Bizweaver to interface with SAP Business One and how to update these schemas when changes are made in SAP Business One. Audience This document is intended for technical users that create and maintain Bizweaver workflows. It is not intended for general end users.

Schedules

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Jun 2020 10:20:37 +0000

Schedules Schedule Execution To see information dealing with Bizweaver Version 2.4 and prior proceed here To see information dealing with Bizweaver Version 2.5 and after proceed here

bw:sending_data_to_the_sap_business_one_database

anonymous@undisclosed.example.com (Anonymous) — Thu, 04 Apr 2019 16:07:01 +0000

Transactions sent to the Service Layer for SAP Business One use a web service call that uses a JSON data structure. The structures must be specifically as the Service Layer expects the (order of values) and certain values are expected depending on the transaction. In addition, some values must be sent as

Working with the Service Layer

anonymous@undisclosed.example.com (Anonymous) — Tue, 15 Dec 2020 12:46:04 +0000

Working with the Service Layer Transactions sent to the Service Layer for SAP Business One use a JSON data structure. The structures must be structured specifically as the Service Layer expects them to be. The DataBuilder tool is used to create these structures. Information on the DataBuilder tool is found here

Introduction (SQLCommand Tool)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 10:35:43 +0000

Introduction (SQLCommand Tool) This document describes the use of the Bizweaver SQL Command tool. Audience This document is intended for developers of Bizweaver workflows. Knowledge of T-SQL (Microsoft SQL Server) or SAP HANA coding is required to use this tool.

Stored Procedure for SAP Business One Special Pricing

anonymous@undisclosed.example.com (Anonymous) — Tue, 04 Jun 2019 15:18:51 +0000

Stored Procedure for SAP Business One Special Pricing This procedure can be used as the data source in a Versago look-up report to find the lowest price for a business partner (typically a customer) based on price list, special pricing, date sensitive pricing, and quantity break pricing. The procedure is placed in the target SAP Business One database.

SQL Tools for Bizweaver

anonymous@undisclosed.example.com (Anonymous) — Mon, 28 Oct 2019 14:36:46 +0000

SQL Tools for Bizweaver Samples of tools that can be used with SQL Server in Bizweaver. Function to Strip HTML Tags This is a user-defined function that strips out various HTML tags from data being inserted into a SQL table. This is very helpful when the input comes from a web-based

Configure SQL to call Bizweaver WebService

anonymous@undisclosed.example.com (Anonymous) — Tue, 07 Apr 2020 15:23:13 +0000

Configure SQL to call Bizweaver WebService New in Bizweaver version 2.4 Obtain the DLL executable file * The file is installed in C:\Program Files\Bizweaver\BWPortal\BWSQLSP when Bizweaver is installed. * The file can be downloaded from in the Software Download section.

Introduction (Test Run Tool)

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 17:16:50 +0000

Introduction (Test Run Tool) Important Note The Test Run tool does not use “dummy” transactions. This means that if you are doing data updates (e.g. via SQL or SAP Business One connector), the data is really updated. Do all testing against test data whenever possible to avoid issues with duplicated or incorrect data.

Designer Help

anonymous@undisclosed.example.com (Anonymous) — Thu, 19 Sep 2019 13:15:18 +0000

Designer Help Best practices for designing effective workflows. Best Practices To come.

Introduction (Using Variables)

anonymous@undisclosed.example.com (Anonymous) — Wed, 23 Oct 2019 14:46:01 +0000

Introduction (Using Variables) This page describes the use of variables in a Bizweaver workflow. What are Bizweaver Variables? “Variables” are data values that are held in memory during the execution of a workflow. There are two types of variables in Bizweaver:

Introduction (VBScript)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 16:42:19 +0000

Introduction (VBScript) The VBScript tool is used to create “programming” statements in a Bizweaver workflow using the VBScript language. The results from a VBScript step can be used as variables in subsequent workflow steps. VBScript can be used for a broad range of purposes. Several VBScript samples are included in

Introduction (WebService Tool)

anonymous@undisclosed.example.com (Anonymous) — Tue, 02 Aug 2022 16:25:40 +0000

Introduction (WebService Tool) The Web Services tool is used to allow Bizweaver to interact with APIs from other applications. Bizweaver also has its own API in the form of the Bizweaver web service. Unfortunately, almost all APIs are different. This document describes how the Web Service tool is configured and provides some basic examples of how it is used for some major applications.

WF_Exec Tool

anonymous@undisclosed.example.com (Anonymous) — Wed, 17 Aug 2022 14:12:49 +0000

WF_Exec Tool The WF_Exec tool allows an external batch file (most common) or program (.exe) to be executed via a workflow step. The most common use of the tool is to execute a batch file that, in turn, executes FTP functionality. The tool consists of two functionality tabs.

Save a Bizweaver Workflow

anonymous@undisclosed.example.com (Anonymous) — Tue, 22 Oct 2019 16:23:36 +0000

Save a Bizweaver Workflow To save a workflow, click the “Save” icon in the top icon bar. New in Bizweaver version 2.4 Successful Save When a workflow is saved (or duplicated), a new window is displayed. Details about the save process are displayed as various validations, of each step take place. An example of a successful save is shown below. Note that all rows show a green checkbox on a successful save.

Workflow Schedules Version 2.4 and prior

anonymous@undisclosed.example.com (Anonymous) — Mon, 14 Dec 2020 17:19:55 +0000

Workflow Schedules Version 2.4 and prior When Bizweaver workflows are in active use (in production), they are at times executed using a schedule. This means that they will execute automatically at a defined time. No user action is required. A schedule is created by selecting the desired combination of options as described below. If both the schedule and the workflow are enabled, the workflow will execute automatically at the appropriate time.

Workflow Schedules Version 2.5 and after

anonymous@undisclosed.example.com (Anonymous) — Fri, 26 Jun 2020 11:36:09 +0000

Workflow Schedules Version 2.5 and after When Bizweaver workflows are in active use (in production), they are at times executed using a schedule. This means that they will execute automatically at a defined time. No user action is required. A schedule is created by selecting the desired combination of options as described below. If both the schedule and the workflow are enabled, the workflow will execute automatically at the appropriate time.

Workflow Tools

anonymous@undisclosed.example.com (Anonymous) — Fri, 05 Feb 2021 16:59:40 +0000

Workflow Tools A Bizweaver workflow is comprised of a series of “functions” known as tools. A high-level list of these tools is provided below. Click on the associated link (where provided) for more detailed usage information. Common Tools Start / End