Forum Discussion

sdeng's avatar
sdeng
New Contributor II
7 years ago

Not able to read file content by using MFT as file server

We’re using MFT as file server, we’ve created an Basic Auth Account, it will got below error when reading the xlsx files. It’s not work for csv or txt as well. Is there any other account type we should use for this kind of file server? I’m using this format: AAA Sorry Page

I’ve tried to use below in the file reader as well, but all will get an error when reading the file. sftp://aaa.com:22/Foldername/a.xlsx
sftp://aaa.com:22/webclient/Foldername/a.xlsx
sftp://aaa.com/webclient/Foldername/a.xlsx
sftp://aaa.com/Foldername/a.xlsx
sftp://aaa.com:22/Foldername/a.xlsx

3 Replies

  • cstewart's avatar
    cstewart
    Former Employee
    7 years ago

    It looks as though the failure is happening on the parse Snap, not the Reader. Perhaps you can try to do the File read from your MFT and temporarily write it to the local disk, then read with file reader and parse. This would help identify if the issue is the read from MFT or downstream. If you land the file, you may also check to see if you can ready it using Excel.

    • sdeng's avatar
      sdeng
      New Contributor II
      7 years ago

      I created the file in excel format and loaded it to the file server.

  • nandudevi05's avatar
    nandudevi05
    New Contributor II
    2 years ago

    Hi sdeng.. can u please tell me r u got solution for this MFT account  in snaplogic?