Import Dates with data loop and CSV

Question

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.&nbsp;I'm from Germany and I must use the following Date Format in the tested program.&nbsp; (DD.MM.YYYY)For example:CSV-File&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Imported01.01.2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101202012.01.2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12012020’01.01.2020’&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ’01.01.2020’I need:01.01.2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2020or &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01012020I already tried the Schema.ini file but it's not working for me.I hope you can help me.Greetings

rku_avo · Accepted Answer

I made a small Workaround now&nbsp; and my Problem is done with it.function Excel_Loop(){&nbsp; //Runs the "EXCEL" tested application.&nbsp; TestedApps.EXCEL.Run(1, true);&nbsp; Project.Variables.csv2207.Reset();&nbsp; for(; !Project.Variables.csv2207.IsEOF();)&nbsp; {&nbsp;&nbsp;&nbsp; csvimporttest = Project.Variables.csv2207.Value("F5");&nbsp;&nbsp;&nbsp; test123 = String(Project.Variables.csv2207.Value("F5"));&nbsp;&nbsp;&nbsp; laengecsv = test123.length;&nbsp;&nbsp;&nbsp; if (laengecsv &lt; 8&nbsp; {&nbsp;&nbsp;&nbsp; csvimporttest = "kleiner 8" + "&nbsp;&nbsp; 0" + Project.Variables.csv2207.Value("F5") + "&nbsp;&nbsp; " + laengecsv&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; csvimporttest = "größer 7" + "&nbsp; " + Project.Variables.csv2207.Value("F5") + "&nbsp;&nbsp; " + laengecsv&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp; //csvimporttest = Project.Variables.csv2207.Value("F5") + "&nbsp;&nbsp;&nbsp;&nbsp; " + laengecsv&nbsp;&nbsp;&nbsp; //csvimporttest = "Test123" +&nbsp; Project.Variables.csv2207.Value("F5")&nbsp;&nbsp;&nbsp;&nbsp; Aliases.EXCEL.wndXLMAIN.XLDESK.Mappe1.Keys(csvimporttest);&nbsp;&nbsp;&nbsp; Aliases.EXCEL.wndXLMAIN.XLDESK.EXCEL6.Keys("[Enter]");&nbsp;&nbsp;&nbsp; Project.Variables.csv2207.Next();&nbsp; }}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

marsha_r · Answer

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

marsha_r · Answer

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

sonya_m · Answer

Thank you for providing guidance Marsha!
&nbsp;
RKU_AVO&nbsp;was this article helpful?

rku_avo · Answer

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.202012.01.2020Thanks

Forum Discussion

Import Dates with data loop and CSV

5 Replies

Related Content

Cannot import project

Import Postman Collection

Parsing a date in groovy.

How to manipulate system date

Keying Future Date

Recent Discussions

How to import external node modules in TestComplete

convert absolute path to relative path

Multiple execution of a test plan with different values from an Excel table

Searching for mapped object took too much time msg

mht files are by default opening in Edge browser and its blank