Forum Discussion

Sravani93's avatar
Sravani93
Occasional Contributor
2 years ago
Solved

How to read a dynamically generated file using regular expression

Hello,   I want to compare a ".csv" file that's generated during the test to a baseline. I added the baseline to the Files check point using 'byte to byte' comparison. The issue is the file generat...
  • Kitt's avatar
    Kitt
    2 years ago

    Try this:

     

     

     

    function findFiles() {  
  var foundFiles, aFile;
  foundFiles = aqFileSystem.FindFiles("C:\\Exported_Data", "Output*.csv");
  if (!strictEqual(foundFiles, null)) {
    while (foundFiles.HasNext()) {
      aFile = foundFiles.Next();
      Log.Message(aFile.Name);
    }
  }
  else {
    Log.Message("No files were found.");
  }
}

     

     

     

  • chriscc's avatar
    chriscc
    2 years ago

    Hi Sravani93 

     

    If the directory will only have one file then you could use aqFIleSystem.FindFiles function to get the path to that one file. Something like this:

    var pathToDirectory = "c:\\";
var searchPattern = "*.txt";
var files = aqFileSystem.FindFiles(pathToDirectory , searchPattern, false);
var file = file.Next();
var path = file.Path;

     

    If there will be more than one file in that directory then you could try a couple of different things. 

    1. Get the list of files before and after running your test. Then compare the lists to find the new file.  

    2. If each test creates a new file then you could just get the most recent file:  The code below comes from this post: Solved: Re: How to Validate recently downloaded output Exc... - SmartBear Community

        function getMostRecentCreatedFile(directoryPath, searchPattern)
    {
      var newestFilePath = "";
      var previousCreationTime = "1/1/1900";
      try
      {
        var files = aqFileSystem.FindFiles(directoryPath, searchPattern, false);
        if (files != null)
        {         
          while(files.HasNext())
          {
            var file = files.Next();
            var creationTime = aqFile.GetCreationTime(file.Path);
            if (aqDateTime.Compare(creationTime, previousCreationTime) == 1)
            {
              previousCreationTime = creationTime;
              newestFilePath = file.Path;
            }
          }
        }
      }
      catch(e)
      {
        Log.Error("Exception in getMostRecentCreatedFile", e.descrpition);
      }
      //
      return newestFilePath;
    }

    function testGetFile()
    {
      var filePath=getMostRecentCreatedFile("C:\\Users\\herrerae\\Downloads", "*.xlsx");
    }

     

Marsha_R's avatar
Marsha_R
Champion Level 3

Your example has too many periods in it.  I would try Output*.csv

 

 

Sravani93's avatar
Sravani93
Occasional Contributor
2 years ago

I am seeing this error: 

There is no item or file named "C:\Exported_Data\Output*.csv".
  • Kitt's avatar
    Kitt
    Regular Contributor
    2 years ago

    Try this:

     

     

     

    function findFiles() {  
  var foundFiles, aFile;
  foundFiles = aqFileSystem.FindFiles("C:\\Exported_Data", "Output*.csv");
  if (!strictEqual(foundFiles, null)) {
    while (foundFiles.HasNext()) {
      aFile = foundFiles.Next();
      Log.Message(aFile.Name);
    }
  }
  else {
    Log.Message("No files were found.");
  }
}

     

     

     

    • Kitt's avatar
      Kitt
      Regular Contributor
      2 years ago

      Here are some additional example functions I've used to mess about with files. For example, if you want to check that a file was create today:

       

       

        var fileDate, fileName, folderInfo, latestFileIndex, newestTime, num;
  var filePath = "C:\\Exported_Data";
  
  // Count number of files in specified folder
  folderInfo = aqFileSystem.GetFolderInfo(filePath);
  num = folderInfo.Files.Count;
  Log.Message("The folder contains " + num + " files.");
  
  newestTime = aqDateTime.SetDateTimeElements(1000, 1, 1, 0, 0, 0);
  latestFileIndex = 0;

  // Get the most recently modified file in the specified folder
  for (var i=0; i < num; i++) {
    fileDate = folderInfo.Files.Item(i).DateLastModified;
    
    if(aqDateTime.Compare(newestTime, fileDate) < 0) {
      newestTime = fileDate;
      latestFileIndex = i;
    } 
  }
  fileName = folderInfo.Files.Item(latestFileIndex).Name;
  Log.Message("The most recently modified file " + fileName + " was created on " + newestTime); 
  
  // Verify that file was created today
  if(aqDateTime.Compare(newestTime, aqDateTime.Today()) == 1) {
    Log.Message("SUCCESS. File was created today."); 
  }
  else {
    Log.Warning("FAILURE. The file found was not recently created, this may be a result of the folder view not being refreshed."
    +" Check '" + filePath + "' for more information.");
  }

       

       

       

      OR if you want to create an array from the files in a folder and select the most recent (assuming you have more than 1 file to compare):

       

       

        var folderObject = aqFileSystem.GetFolderInfo(filePath);
  var folderItems = folderObject.Files     
  var fileDateModified = new Array();  
  var fileNumber = new Array();     
  var latestFileNumber;                    

  //Builds arrays with filnames containing FileNameContains regular expression
  for (var i=0; i < folderItems.Count; i++) {    
    if(folderItems.Count > -1) {  
      fileNumber.push(i);
      fileDateModified.push(folderItems.Item(i).DateLastModified);       
    }
  }         

  //Finds the most resent modified file
  newestTime = fileDateModified[0];
  latestFileNumber = fileNumber[0];

  for (var i=0; i < fileNumber.length; i++) {       
    if(aqDateTime.Compare(newestTime, fileDateModified[i]) < 0) {
      newestTime = fileDateModified;
      latestFileNumber = fileNumber; 
    }    
  }
  return folderItems.Item(latestFileNumber).Path;