Forum Discussion

RKU_AVO's avatar
RKU_AVO
New Contributor
4 years ago
Solved

Import Dates with data loop and CSV

Hey there, I'm trying to figure out how to Import Dates from a CSV file into Testcomplete. I got a huge Problem when the Date has a starting "0" because I think Testcomplete is importing the Date ...
  • RKU_AVO's avatar
    4 years ago

    I made a small Workaround now  and my Problem is done with it.

    function Excel_Loop()
    {
      //Runs the "EXCEL" tested application.
      TestedApps.EXCEL.Run(1, true);
      Project.Variables.csv2207.Reset();
      for(; !Project.Variables.csv2207.IsEOF();)
      {
        csvimporttest = Project.Variables.csv2207.Value("F5");
        test123 = String(Project.Variables.csv2207.Value("F5"));
        laengecsv = test123.length;
        if (laengecsv < 8  {
        csvimporttest = "kleiner 8" + "   0" + Project.Variables.csv2207.Value("F5") + "   " + laengecsv
        }
          else {
            csvimporttest = "größer 7" + "  " + Project.Variables.csv2207.Value("F5") + "   " + laengecsv
          }
       //csvimporttest = Project.Variables.csv2207.Value("F5") + "     " + laengecsv
        //csvimporttest = "Test123" +  Project.Variables.csv2207.Value("F5")
     
        Aliases.EXCEL.wndXLMAIN.XLDESK.Mappe1.Keys(csvimporttest);
        Aliases.EXCEL.wndXLMAIN.XLDESK.EXCEL6.Keys("[Enter]");
        Project.Variables.csv2207.Next();
      }
    }


    I imported the data as before but then i watched at the length of the importet value and added a leading 0 when the length is 7.

    Thanks for your Replys