Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • File Reader Tool • Introduction (Pause)
bw2:file_reader_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_reader_tool [2023/12/18 13:28]
wgates [XML & JSON Files] 		bw2:file_reader_tool [2024/09/24 15:51] (current)
dlee [FileReader Tool]
Line 1: Line 1:
-====== Introduction (File Reader v2) ====== 
  
-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 ===== +====== File Reader Tool ======
- +
-<WRAP center round important> +
-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 handling XML and JSON files found in FileReader2. While workflows created using FileReader will continue to function, any new workflows should use FileReader2. All references to “FileReader” in this section refer to FileReader2. +
-</WRAP> +
- +
-====== FileReader Tool ======+
 The **File Reader** tool is used to read data from “flat” delimited files and “structured” formats such as XML, JSON, Microsoft Excel. Plain text can also be read with “text reader” as a single string. The **File Reader** tool is used to read data from “flat” delimited files and “structured” formats such as XML, JSON, Microsoft Excel. Plain text can also be read with “text reader” as a single string.
  
Line 88: Line 80:
  
 {{ :bw2:bizweaverfilereader8.png |}} {{ :bw2:bizweaverfilereader8.png |}}
- 
-If the input structure is complex, you may need to use multiple FileReader steps to get all the data elements you need.  Also note that you might see multiple parent objects for each child object selected, you'll need to filter these out.  If you introduce a new fileReader2 in a loop to parse another child object, you'll need to make sure you're only taking the correct objects because all are returned regardless of outer-loop iteration. 
- 
-{{ :bw2:json_ordres.png |}} 
- 
-Loop through the JSON orders. 
- 
-{{ :bw2:json_orders_loop.png |}} 
- 
-Read the line_items 
- 
-{{ :bw2:json_orders_loop_line_items.png |}} 
- 
-You're now looping through every orders line items and must decide which line items to process. 
- 
-{{ :bw2:json_orders_loop_line_items_decision.png |}} 
  
 =====Specify Joining Character===== =====Specify Joining Character=====
Line 169: Line 145:
 |Target File Name      |“File” name as defined in a File Writer action    |Example: “*FileName.txt”    |  |Target File Name      |“File” name as defined in a File Writer action    |Example: “*FileName.txt”    | 
  
 +----
 +**[[bizweaver:Home|Home]]**
bw2/file_reader_tool.1702924133.txt.gz · Last modified: 2023/12/18 13:28 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