none
FTP Adapter and FileMask RRS feed

  • Question

  • Hi,

    Can anyone tell me what is allowed in the FileMask property of the FTP Adapter?

    Ideally, I'd like to use regular expressions.

    I have this filename: R060620N

    I've confirmed that R*N and R??????N does work

    But what if I want to make it more generic with regular experssions, e.g.

    R??????(M|N)

    If FTP Adapter doesn't support this, are there others that do?

    My boss would prefer not to use 3rd parties... so what are my options?

    1) create another Receive Port - one for each R??????M and R??????N

    2) Use a pipeline to grab it all, and filter out what I don't need?

    (But, but, but... my FTP Adapter needs to delete the file after download, so how I can I 'delete' the file AFTER the pipeline as opposed to BEFORE?)

    3) Any other options? Am I stuck with using a 3rd party adapteR?

    4) NOTE: not likely I will be able to get the source system to change its workflow... and it would seem silly that I would have to write a program/script outside of BizTalk to prepare it for BizTalk (i.e. move the files to a dedicated directory first).

    Thanks.


    • Edited by Raymond6666 Thursday, January 9, 2014 11:33 PM
    Thursday, January 9, 2014 10:52 PM

Answers

  • You definitly cannot use regular expressions.  I believe, like the File Adapter, you get one wildcard before and one after the '.'.  With FTP, it would also depend on what the server can support.

    If the number of masks is managable, 2-10 let's say, I would go with option 1.

    • Marked as answer by Pengzhen Song Thursday, January 16, 2014 12:21 PM
    Friday, January 10, 2014 12:07 AM

All replies

  • You definitly cannot use regular expressions.  I believe, like the File Adapter, you get one wildcard before and one after the '.'.  With FTP, it would also depend on what the server can support.

    If the number of masks is managable, 2-10 let's say, I would go with option 1.

    • Marked as answer by Pengzhen Song Thursday, January 16, 2014 12:21 PM
    Friday, January 10, 2014 12:07 AM
  • Its a restriction that only one file mask or file name can be specified per receive location.

    No need to create different port , create 2 receive location with same port.

    Friday, January 10, 2014 12:29 AM