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.  Determine Filename when using FTP Source Adapter

    Posted 02/17/09 11:32 AM

    Originally posted by: jadamski


    Greetings~
    I'm using WTX 8.1 and I have a fairly simple map that uses the FTP adapter in the primary source input card with a wild card (below) to scoop up various control files at timed intervals and then I need to route them based upon there original file names.

    -ts -URL ftp://username:password@site.ftp.com//dir/subdir/*;type=A

    I'm having trouble using the GETFILENAME, GETDIRECTORY and GETSOURCENAME functions when using the FTP adapter, each just returns my FTP argument (above). Does anybody have a suggestion on how to determine the file name of an input file when using the FTP adapter?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Determine Filename when using FTP Source Adapter

    Posted 02/17/09 11:40 AM

    Originally posted by: Daniel_MK


    I think the best way to do this is to use the FTP adapter to get a list of remote files, and then iterate through each one, retrieving and processing it.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: Determine Filename when using FTP Source Adapter

    Posted 02/17/09 11:52 AM

    Originally posted by: jadamski


    Sounds like a great idea, I have never used the FTP adapter to generate a file list, would generally (or detailed) the adapter string to do so?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Determine Filename when using FTP Source Adapter

    Posted 02/17/09 11:57 AM

    Originally posted by: Daniel_MK


    something like GET("FTP","-URL FTP://username:password@server/subdir/*;type=d")
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 5.  Re: Determine Filename when using FTP Source Adapter

    Posted 02/17/09 12:56 PM
      |   view attached

    Originally posted by: paul.brett


    How about an example?

    How to use these files should be obvious - come back if you've got any questions.

    Paul
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender

    Attachment(s)



  • 6.  Re: Determine Filename when using FTP Source Adapter

    Posted 02/18/09 05:22 PM

    Originally posted by: jadamski


    Great input guys.

    Thanks for the example map Paul, excellent!
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender