Skip to Content
avatar image
Former Member

Multiple flat files reading from Network

Hi,

I am trying to load multiple files from Network. My path looks like ( \\tpdevqa\data\ ) . I used wait_for_file('\tpdevqa\data\*.txt', 0,0,1,$filename) and replace_substr($filename, '/', '\\'). My file path is recognized but I am not able to load. Here is the error - Cannot open file <\\tpdevqa\data\71420551618841>. Check its path and permissions.

I followed this procedure. Selective Reading and Postprocessing

http://wiki.scn.sap.com/wiki/display/EIM/Selective+Reading+and+Postprocessing?original_fqdn=wiki.sdn.sap.com

Please through light on this one - Thanks Chandra

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 05, 2014 at 05:37 PM

    Your file should be placed in the same location as the job server.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks Arun! JS is not installed on my system, so i am not able see BO under services. I will check on Monday and will be back with update. But I am able to load with normal FF loading with the same path //tpdevqa/data/*841 about 5 million records still lot files are missing because no concatenated. Still do you thinnk that SYSTEM/ADMIN issue?

  • Sep 05, 2014 at 07:18 PM

    Try to use the wildcard in the file loader.

    For example,*.csv or *.xml

    This will pull all the files in that folder.

    Add comment
    10|10000 characters needed characters exceeded