Uploaded image for project: 'YADE - Yet Another Data Exchange Tool'
  1. YADE - Yet Another Data Exchange Tool
  2. YADE-301

YADE getlist operation should not create result file list_of_files.txt.csv

    XMLWordPrintable

Details

    Description

      Current behavior

      • The YADE for operation getlist creates two result files, where file's location and name is configure using parameter result_set_filename
        1. list_of_files.txt : this result file contains list of files found on source_dir matching with file_spec
        2. list_of_file.txt.csv : this result file is CSV file, contains various information e.g. file size, name, md5hash etc.
        • The contains of CSV result files are not complete and relevant for the operation getlist , since this information is also available in jade_transfer_history file.
        • The name of CSV file is not explicitly configured in the YADE profile but derived from the parameter result_set_filename.
      • The YADE starting from version 1.9.0 also print file_list information on stdout console.

      Desired behavior

      • The CSV result file should not be created.

      How to reproduce

      • Profile
        [getlist]
        file_spec              = ^SOS-.*\.(xls|csv)$
        operation              = getlist
        ;;
        result_set_filename    = C:\__Temp\jade_logs\list_of_files.txt
        create_result_set      = true
        ;;
        source_protocol        = sftp
        source_host            = homer.sos
        source_port            = 22
        source_user            = test
        source_ssh_auth_method = password
        source_password        = Wddse73Ksdf$;;23
        source_dir             = /home/test/data/from_homer
        
      • session Log
        
        C:\Program Files\sos-berlin.com\jade>jade_client.1.9.0\bin\jade.cmd -settings=jade_settings.ini -profile=getlist
        
        + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
        +                       START  : JADE.CMD                         +
        +                       -----------------                         +
        + DATE     : 22.05.2015 11:14:28,63
        + HOSTNAME : MP
        + USER     : MP
        + CALL     : C:\Program Files\sos-berlin.com\jade\jade_client.1.9.0\bin\jade.cmd -settings=jade_settings.ini -profile=getlist
        +                                                                 +
        + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
        
        main INFO  11:14:32,274   (SOSDataExchangeEngineMain.java:73) ::Execute SOSDataExchange - Main routine started ...
        main INFO  11:14:32,299   (SOSDataExchangeEngine.java:485) ::showBanner
        ************************************************************************
        *                                                                      *
        *                JADE - JobScheduler Advanced Data Exchange            *
        *                ---www.sos-berlin.com---------------------            *
        *                                                                      *
        ************************************************************************
          Version                 = 1.9.0 (2015-04-30 12:26, revision d3a501831acf8d2ce0354da0b821f3a54bac2b7b) Copyright 2003-2015 SOS GmbH Berlin
          Date                    = 2015-05-22 11:14:32
          SettingsFile            = jade_settings.ini
          Profile                 = getlist
          Operation               = getlist
          Transactional           = false
        
          +------------Source------------
          | Protocol              = sftp
          | Host                  = homer.sos
          | User                  = test
          | AuthMethod            = password
          | AuthFile              = ***
          | Directory             = /home/test/data/from_homer/
          | FileSpec              = ^SOS-.*\.(xls|csv)$
          | ErrorWhenNoFilesFound = true
          | Recursive             = false
          | Remove                = false
        
        
        main INFO  11:14:32,357   (SOSVfsSFtpJCraft.java:890) ::connect SOSVfs-D-0101: Try to connect to host 'homer.sos' at Port '22'.
        main INFO  11:14:33,172   (SOSVfsSFtpJCraft.java:856) ::doAuthenticate SOSVfs_D_133: user 'test' logged in.
        main INFO  11:14:33,263   (SOSDataExchangeEngine.java:931) ::setInfo 4 files found for regexp '^SOS-.*\.(xls|csv)$'.
        main INFO  11:14:33,264   (SOSDataExchangeEngine.java:1059) ::transfer SOSJADE_I_0115: Operation 'getList' is specified. no transfer will be done.
        main INFO  11:14:33,265   (SOSFileList.java:408) ::logFileList
        /home/test/data/from_homer/SOS-100_09.03.2015.xls
        /home/test/data/from_homer/SOS-200_22.01.2015.xls
        /home/test/data/from_homer/SOS-100_22.01.2015.csv
        /home/test/data/from_homer/SOS-100_22.01.2015.xls
        *** ResultSet End ***
        main INFO  11:14:33,304   (SOSFileList.java:446) ::CreateResultSetFile ResultSet to StdOut and to csv-File 'C:\__Temp\jade_logs\list_of_files.txt.csv' written
        *** ResultSet Start ***
        ed5913e6-7bc3-41f2-bf40-c66a56bd8154;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_09.03
        .2015.xls;n.a.;344;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00;75d3d79d-2c5b-49d6-9b54-fb0305e98b4a;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;
        Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_09.03.2015.xls;n.a.;344;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00
        acc6485d-104f-4d45-9c38-7dffc9bd90b9;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-200_22.01
        .2015.xls;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00;271f3e8c-f92b-4fc9-b3a2-39e7d715ae4b;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;
        Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-200_22.01.2015.xls;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00
        6d0fad81-eba6-4954-9a7d-1e2d32fad807;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_22.01
        .2015.csv;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00;a7c06380-82b4-4888-8d06-e26bc42e157c;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;
        Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_22.01.2015.csv;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00
        4ca4f4d3-346c-4676-91a4-044c97b6b089;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_22.01
        .2015.xls;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00;2cb00c18-c5fd-4b86-8d72-a726223bb648;SOS;2015-05-22 11:14:33;10040;0;getlist;homer.sos;192.11.0.95;test;MP;192.11.0.49;
        Mahendra;;0;/home/test/data/from_homer/;;/home/test/data/from_homer/SOS-100_22.01.2015.xls;n.a.;433;n.a.;waiting4transfer;;stdout; ;;22;sftp;;1970-01-01 01:00:00
        *** ResultSet End ***
        main INFO  11:14:33,320   (SOSDataExchangeEngine.java:795) ::printState SOSJADE_I_0101: 0 files transferred
        main INFO  11:14:33,337   (SOSDataExchangeEngine.java:351) ::showResult
        *************************************************************************
         execution status     = success. Without Errors.
         successful transfers = 0
         skipped transfers    = 0
         failed transfers     = 4
         last error           =
        *************************************************************************
        
        main INFO  11:14:33,339   (SOSDataExchangeEngineMain.java:77) ::Execute Execute - ended without errorsended without errors
        main INFO  11:14:33,340   (SOSVfsTransferBaseClass.java:1161) ::logINFO (SOSVfsSFtpJCraft::disconnect) disconnect OK
        main INFO  11:14:33,341   (SOSVfsTransferBaseClass.java:1161) ::logINFO (SOSVfsSFtpJCraft::disconnect) disconnect OK
        
        + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
        +                        END   : JADE.CMD                         +
        +                        ----------------                         +
        + DATE     : 22.05.2015 11:14:33,79
        + HOSTNAME : MP
        + USER     : MP
        + CALL     : C:\Program Files\sos-berlin.com\jade\jade_client.1.9.0\bin\jade.cmd -settings=jade_settings.ini -profile=getlist
        + EXIT     : 0
        +                                                                 +
        + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
        
        
        C:\Program Files\sos-berlin.com\jade>
        

      Attachments

        Activity

          People

            oh Oliver Haufe
            mp Mahendra Patidar
            Mahendra Patidar Mahendra Patidar
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 2 hours
                2h
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h