Wiki

Scale Your Enterprise

User Tools

Site Tools

Trace: • Introduction (Encryption) • Introduction (Import/Export) • Introduction to DataBuilder • File Reader Tool • Introduction (File Reader)
bw: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
bw:file_reader_tool [2019/10/14 15:19]
runger [FileReader Tool] 		bw:file_reader_tool [2020/09/15 14:28] (current)
Line 12: Line 12:
 The **File Reader** tool is used to read data from “flat” delimited files and “structured” formats such as XML, JSON, and Microsoft Excel. There is also a special input type called “text reader.” Data read from the file is then available in subsequent processing steps. The **File Reader** tool is used to read data from “flat” delimited files and “structured” formats such as XML, JSON, and Microsoft Excel. There is also a special input type called “text reader.” Data read from the file is then available in subsequent processing steps.
  
-The File Reader tool is also used to process data being received from a webservice call. More information on this process can be found in the [[bw:web_service_tool|Webservice Tool]] page.+The File Reader tool is also used to process data being received from a webservice call. More information on this process can be found in the **//[[bw:web_service_tool|Webservice Tool]]//** page.
  
 File delimiters include: File delimiters include:
Line 37: Line 37:
 ====== Delimited Files ====== ====== Delimited Files ======
  
-{{:bw:frimage1.png?384x459}}+{{ :bw:frimage1.png?384x459 }}
  
 Example showing static file name. Example showing static file name.
  
-{{:bw:frimage2.png?384x460}}+{{ :bw:frimage2.png?384x460 }}
  
 Example showing input from Get File operation Example showing input from Get File operation
  
-  - Select the delimiter type from the drop-down list. \\ {{:bw:frimage3.png?309x103}}+  - Select the delimiter type from the drop-down list. \\ {{ :bw:frimage3.png?309x103 }}
       - If the “Custom Separated” delimiter option is selected, an additional field is displayed below the Input/File field. Enter the delimiter character here.       - If the “Custom Separated” delimiter option is selected, an additional field is displayed below the Input/File field. Enter the delimiter character here.
   - The **File Reader** option requires either a specific source file path & name or a Bizweaver variable that identifies the source file.   - The **File Reader** option requires either a specific source file path & name or a Bizweaver variable that identifies the source file.
Line 68: Line 68:
 The sample used for explanation of handling these types of structures is JSON input returned from a web service call. The data being processed is freight carrier information. The sample used for explanation of handling these types of structures is JSON input returned from a web service call. The data being processed is freight carrier information.
  
-{{:bw:frimage4.png?325x384}}+{{ :bw:frimage4.png?325x384 }}
  
 The “Use Null Value” option is used in cases where some records in the input file do not have any data. In these cases, the columns can become “mismatched,” causing problems correctly reading the data. The ”null value” option accounts for these missing values based on the template. The “Use Null Value” option is used in cases where some records in the input file do not have any data. In these cases, the columns can become “mismatched,” causing problems correctly reading the data. The ”null value” option accounts for these missing values based on the template.
Line 74: Line 74:
 When the input is XML or JSON, a new link named “Select object for formatting the data” is displayed. Click on this link to open a new dialog. When the input is XML or JSON, a new link named “Select object for formatting the data” is displayed. Click on this link to open a new dialog.
  
-{{:bw:frimage5.png?276x288}}+{{ :bw:frimage5.png?276x288 }}
  
 This dialog presents the various data groupings (nodes) in the input structure. Select a combination of checkboxes to “flatten” the data to the selected level. This dialog presents the various data groupings (nodes) in the input structure. Select a combination of checkboxes to “flatten” the data to the selected level.
Line 80: Line 80:
 To get the desired results, you must select all the associated higher-level nodes as well. In the first example we want just “RateResults”, so the /root level must be selected as well as /root/RateResults. When this is done we get the following results: To get the desired results, you must select all the associated higher-level nodes as well. In the first example we want just “RateResults”, so the /root level must be selected as well as /root/RateResults. When this is done we get the following results:
  
-{{:bw:frimage6.png?288x144}}+{{ :bw:frimage6.png?288x144 }}
  
 If we now want to get the “Charges” data, we change the object select to look like this: If we now want to get the “Charges” data, we change the object select to look like this:
  
-{{:bw:frimage7.png?264x121}}+{{ :bw:frimage7.png?264x121 }}
  
 Note that we must include /root and /root/RateResults as well, since “Charges” is a sub-group of /root/RateResults. Note that we must include /root and /root/RateResults as well, since “Charges” is a sub-group of /root/RateResults.
Line 90: Line 90:
 With this change we now see: With this change we now see:
  
-{{:bw:frimage8.png?288x140}}+{{ :bw:frimage8.png?288x140 }}
  
 If the input structure is complex, you may need to use multiple FileReader steps (with a common input) to get all the data elements you need. If the input structure is complex, you may need to use multiple FileReader steps (with a common input) to get all the data elements you need.
Line 106: Line 106:
 The Text Reader option is used when the input file needs to be read as a single string of text. The uses for this option are very specialized and limited. The Text Reader option is used when the input file needs to be read as a single string of text. The uses for this option are very specialized and limited.
  
-{{:bw:frimage9.png?288x209}}+{{ :bw:frimage9.png?288x209 }}
  
 The only input for this function is a file name, or workflow variable that identifies the file. The only input for this function is a file name, or workflow variable that identifies the file.
Line 114: Line 114:
 There are several variables from the File Operations function that can be used in other workflow steps. In the following examples the file being addressed is named “FileName.txt” and it is found in the folder “C:\SourceFolder”. There are several variables from the File Operations function that can be used in other workflow steps. In the following examples the file being addressed is named “FileName.txt” and it is found in the folder “C:\SourceFolder”.
  
-^**Variable Name**     ^**Explanation**                                   ^**Example**                 ^ +^**Variable Name**     ^**Explanation**                                   ^**Example**                 ^  
-|File Name             |Full file name including path (folder)            |C:\SourceFolder\FileName.txt| +|File Name             |Full file name including path (folder)            |C:\SourceFolder\FileName.txt|  
-|File Title            |The file name including the extension             |FileName.txt                | +|File Title            |The file name including the extension             |FileName.txt                |  
-|File Title without Ext|The file name without the extension               |FileName                    | +|File Title without Ext|The file name without the extension               |FileName                    |  
-|File Extension        |The file extension **including** the “.” separator|**.**txt                    | +|File Extension        |The file extension **including** the “.” separator|**.**txt                    |  
-|File Type             |File type such as TAB, csv, etc.                  |                            | +|File Type             |File type such as TAB, csv, etc.                  |                            |  
-|Source Path           |Path of the source file                           |C:\SourceFolder             | +|Source Path           |Path of the source file                           |C:\SourceFolder             |  
-|Source File Name      |“File” name as defined in a Get Files action      |Example: “*FileName.txt”    | +|Source File Name      |“File” name as defined in a Get Files action      |Example: “*FileName.txt”    |  
-|Target Path           |Path name from a File Writer operation            |C:\TargetFolder             | +|Target Path           |Path name from a File Writer operation            |C:\TargetFolder             |  
-|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”    | 
-|                      |                                                  |                            |+
  
bw/file_reader_tool.1571080765.txt.gz · Last modified: 2019/10/14 15:19 by runger

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