We have noticed that it is not possible in a FileWait/Move/Copy to search for a file containing spaces via fileInclude parameter. Suppose, if we want to search for the files("File Toto1.txt","File Toto2.txt","File Toto3.txt") by using fileInclude = "File*.txt" we will get 3 files, on the other hand by using fileInclude = "File Toto*.txt" XDI will not find any file.
Therefore, space is not allowed in the fileInclude parameter. Can we replace space by something else?
Best Answer
G
Gaurav Srivastava
said
over 2 years ago
We have two solution:
==>Use "?" which will only match one character rather than "*".
==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:
1 Comment
G
Gaurav Srivastava
said
over 2 years ago
Answer
We have two solution:
==>Use "?" which will only match one character rather than "*".
==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:
Gaurav Srivastava
We have noticed that it is not possible in a FileWait/Move/Copy to search for a file containing spaces via fileInclude parameter. Suppose, if we want to search for the files("File Toto1.txt","File Toto2.txt","File Toto3.txt") by using fileInclude = "File*.txt" we will get 3 files, on the other hand by using fileInclude = "File Toto*.txt" XDI will not find any file.
Therefore, space is not allowed in the fileInclude parameter. Can we replace space by something else?
We have two solution:
==>Use "?" which will only match one character rather than "*".
==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:
Gaurav Srivastava
We have two solution:
==>Use "?" which will only match one character rather than "*".
==>Drag a schema on the Filewait action to store the name of the files in the "ind_session_file_op_lst" technical table with all the other details concerning the files found by the action. This table is created and used automatically in the schema dragged onto the action. We can therefore imagine a process with a FileWait action which will retrieve the list of files to be processed and then a SqlOperation action as the source of a DirectBind to exploit the information in this table by filtering on the file names. For instance:
-
File external resolver with encrypted value
-
Timeout on Mapping/Webservice call
-
UNIQUE TEMP TABLE NAMES
-
Previous step name from a sub-process of execute delivery
-
Dropping multiple tables at once in XDI
-
Freeze Designer and corrupted workspace
-
Loop excel files
-
Change SVN user in the Designer
-
How to Specify the JVM used by the Designer?
See all 64 topics