Specifying Text File Name For Text Connections
Text File As A Source or Text File As A Target Connections process data contained in text files. When you configure a Text Source or Text Target Connection, you specify the text files to be used. Depending on how you specify the file names, you can process one or more text files from a single directory. Text file names are entered on the Source Text Connection — Entities Tab and the Target Text Connection — Entities Tab. Review the sections below for information on Text Source and Text Target Connections.
Source Text Connection File Names
On the Entities tab of the Source Text Connection dialog enter one of the following in the File name text box:
- The exact name of the source text file you want to process.
- The file name including the path of the file you want to process.
- A partial name with the * wildcard to identify the set files you want to process.
Path Names
You can include a path name as part of the file name. The path you specify here is a relative path to the path in the remote directory configured on the Location tab. You cannot access files in directories above the remote directory path. For example, you can specify the file name as:
Sales/Monthly/Sales*.txt
When including a path:
- You cannot use wildcards in the path name.
- You cannot specify a relative path using ../ .
- The path name is appended to the file location specified in the Location tab. If you specify /Sales in the Directory path or Remote directory path of the Location tab, and you specify Sales/Monthly/Sales*.txt in the File name, then TIBCO Cloud ™ Integration - Connect expects the complete file and path name to be:
/Sales/Sales/Monthly/Sales*.txt
Note: For DropBox and OneDrive entities, you must specify the full path name relative to the remote directory path.
Wildcards
If the wildcard search finds more than one file that meets the criteria, TIBCO Scribe® Online processes the oldest matching file first based on its date/timestamp. For example, assume you have the following files in your text file directory:
If your wildcard search is for Sales*.txt, the first run for this Solution processes SalesLeads02.txt because it has the oldest timestamp.
If your Map includes two entities that refer to the same set of input files, the Solution processes SalesLeads02.txt and then SalesLeads01.txt on the next entity within the same run of the Solution.
Target Text Connection File Names
On the Entities tab of the Target Text Connection dialog in the File name text box, enter the exact name, including the file type, of the output file where your integration should put the data. You can specify the full path name. For example, for a file named Q1Sales.txt, you might specify the full path name as:
/Sales/Quarters/Q1Sales.txt
Note: The path you specify here is a relative path to the path in the remote directory. You cannot access files in directories above the remote directory path.
Related Topics
TIBCO Scribe® Online Text File as Source
Configuring Text File As Source Connection
Source Text Connection — Entities Tab
TIBCO Scribe® Online Text File As Target
