IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  Get FTP File name when using WildCards

    Posted 11/24/08 04:30 AM

    Originally posted by: Kepa_Screen


    Hello:

    We are using a map that reads files using the FTP Adapter.
    One of our functional maps has this rule at a Field where we collect ftp'ed files data.

    code
    =GET("FTP", "-KS -URL FTP://"(USER_FTP Argument:Entrada1)":"+(PASSWORD_FTP Argument:Entrada1)
    +"@"+(MAQUINA Argument:Entrada1)
    +"/"+(DIRECTORIO_ORIGEN Argument:Entrada1)
    +(FICHERO_ORIGEN Argument:Entrada1))
    [/code]

    At this rule "FICHERO_ORIGEN Argument:Entrada1" we have the Wildcarded filenames, like "CS*.dat"

    We would like to know how to retrieve the filename of the file that is being processed at GET command, if it's possible.

    Thank you very much. I can Attach my MAP & type trees.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Get FTP File name when using WildCards

    Posted 11/24/08 09:40 AM

    Originally posted by: repanzer


    -URL FTP://xxxxx:xxxxxxxx@xxxx.home.com/"WORD(Blob:In1,",",1) ";type=D '

    The Type=D will get only the filenames that are available on the ftp site in the URL, then I pass each name to a functional map that RUN's a map that gets each file one by one. Wildcards should work.

    Looking at your code though, I am very curious why it has, what looks like to me, HTML in it.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: Get FTP File name when using WildCards

    Posted 11/24/08 09:43 AM

    Originally posted by: repanzer


    Ok, now that I see my response was altered by the forum, I'm guess that html was just for the post and it's not in your code.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: Get FTP File name when using WildCards

    Posted 11/24/08 11:38 AM

    Originally posted by: Kepa_Screen


    Hi Repanzer:

    Thank you very much for your reply. Yes i received the line well at my mail ( i'm subscribed to this forum ).

    Yes, this could be a good way to do what we want. We could get first all filename's at subdir and then pass them to a functional map which will do the transfer....

    Thanks again, your post was really very helpful.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange