In TIBCO Scribe Online or TIBCO Cloud Integration - Connect, you can use the Text Connector to process information in text files. However, in cases where multiple text files exist in the same folder, the Map/flow processes a single file and then ends. The next file is not processed until the Map/flow is executed again either manually or on based on the Solution or app schedule. This can cause a delay when there are many inbound files to be processed. Using the Files Connector resolves this issue by allowing you to Query a folder with multiple files, and move and rename files as they are processed without exiting the Map or flow. The Sample Maps/flows attached to this article are very simple and do not get into details about mapping data to other systems. They only demonstrate what can be done with files and folders. Each Block in the Maps/flows has a brief description that explains the purpose of that Block.

The Files Connector Sample Maps Setup (Run once) Map/flow demonstrates the following:

• Creating three folders: Inbound, Processing, and Archive.
• Creating a file with a header row in the Inbound folder.
• Retrieving records from a source datastore
• Appending those records as text records or lines of text to the file.

The Pre/Post Processing Sample Map demonstrates the following:

• Querying a folder. In this case we query the Inbound folder.
• Moving a file to from the Inbound folder to the Processing folder.
• Processing the contents of the file.
• Moving the file from the Processing folder to an Archive folder and renaming it after processing is complete.

The Reading And Writing Entire Files Map/flow demonstrates the following:

• Mapping files stored locally to another Connection.
• Looking up Byte Array (binary file data) for a file.
• Mapping the file to a target datastore.
• Querying or Fetching files and attachments from a source datastore, such as Salesforce.com.
• Writing files or attachments to your local system.

Scribe Online Classic Users
For more information on prerequisites, importing the Maps, and using the Files Connector, see Connector Extensions and Files Connector.

TIBCO Cloud Integration - Connect Users
For more information on prerequisites, importing the flows, and using the Files Connector, see Connector Extensions and Files Connector.
 

DISCLAIMER

 

Copyright (c) 2020, TIBCO Software Inc. All rights reserved.

 

No Support. You acknowledge that TIBCO will not provide any maintenance or support for this software. You have no right to receive any upgrades, patches, enhancements, bug fixes, new versions or new releases of the software.

 

Internal Use Only License Grant. TIBCO hereby grants you a limited, non‐transferable, non‐exclusive license to use the software solely for your internal business purposes. The name of TIBCO Software Inc. may not be used to endorse or promote products derived from this software without specific prior written permission of TIBCO Software Inc.

 

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT OWNERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.  

Use the attached Sample Maps/Flows to familiarize yourself with using the Files Connector Extension.