Can an inbound file service pick up a file based on all wildcards? (FileSpec field)

Question

Question

Carl Campbell · Dec 16, 2019

the file being created on the FTP server will have a format that includes the current date I would like to pull this file off the FTP while ignoring other files on the same location.

Inbound Service Class

I would like to find the file on the FTP that is being created using Todays date. But it appears that the wildcard are not recognizing the file format:

Example below. This will not pull the file "ErrorFile_20191216.txt" off the FTP but it should. Should I be using custom code or can utilize something built in to do this. Am I missing something? Thanks in advance.

Discussion (5)0

Log in or sign up to continue

Jeffrey Drumm · Dec 16, 2019

printf formatting tokens (%Y, %m, %d, etc.) are not wildcard characters. You'll be limited to legal file naming characters and OS/Shell specific wildcard characters such as * and ? for fetching files.

0 0

score 0 · Answer 1 · 2019-12-17T03:25:24-05:00

Michel Bruyère Dec 17, 2019 to Jeffrey Drumm

OS/Shell specific wildcard characters such as * and ? for fetching files.

Is not possible!!!

0 0

score 1 · Answer 2 · 2019-12-17T05:41:04-05:00

Carl Campbell Dec 17, 2019 to Michel Bruyère

Thank you

1 0

score 0 · Answer 3 · 2019-12-17T06:29:47-05:00

If you could provide a little more detail on your use case, there may be a solution that doesn't involve developing a custom service.

For example, you could configure the service with a filename pattern that would retrieve all matching files in the target path, but discard, via a routing rule, any that do not meet the date criteria. The name of the file should be available in the Source property of the message object.

score 0 · Answer 4 · 2019-12-17T11:57:15-05:00

Thanks for more info. Yes at this point it probably would take a BPL or routing rule to to make this happen. Wanted it to come easier ..oh well! Thanks Jeff !