We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

RKU_AVO's avatar
RKU_AVO
New Contributor
6 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 as a Number. 

I'm from Germany and I must use the following Date Format in the tested program.  (DD.MM.YYYY)

For example:
CSV-File                                                             Imported
01.01.2020                                                       1012020
12.01.2020                                                       12012020
’01.01.2020’                                                     ’01.01.2020’
I need:
01.01.2020                                                       01.01.2020
or                                                                       01012020

I already tried the Schema.ini file but it's not working for me.


I hope you can help me.
Greetings

  • RKU_AVO's avatar
    RKU_AVO
    6 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

5 Replies

  • Marsha_R's avatar
    Marsha_R
    Icon for Champion Level 3 rankChampion Level 3
    6 years ago

    This should help:

    https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqconvert/strtodate.html

    • sonya_m's avatar
      sonya_m
      Icon for Alumni rankAlumni
      6 years ago

      Thank you for providing guidance Marsha!

       

      RKU_AVO was this article helpful?

    • RKU_AVO's avatar
      RKU_AVO
      New Contributor
      6 years ago

      Hey,
      thanks for the respond but this is not working for me because the data is converted while Import.



      As you can see in the Field F5 the Dates are converted to numbers.
      The normal data is:
      01.01.2020
      12.01.2020

      Thanks

      • Marsha_R's avatar
        Marsha_R
        Icon for Champion Level 3 rankChampion Level 3
        6 years ago

        If you already have a string, then you can use aqString methods to pick the string apart and rebuild it in the format you want.

        https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/methods.html

  • RKU_AVO's avatar
    RKU_AVO
    New Contributor
    6 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