Forum Discussion

giovanni_favara's avatar
giovanni_favara
Contributor
7 years ago

import values with dots

Hello, I want to import a csv file. In this file there is a colum with dates. The date format have dots to separe the information in the date (e.g. "05.05.2018"). This date format will be used in Ge...
CSV import
data-driven loop
  • AlexKaras's avatar
    AlexKaras
    7 years ago

    Hi Giovanni,

     

    Can you post here the problematic code and its output?

    I tried a simplest keyword test with your sample cvs file and got expected result in the log:

     

     

  • giovanni_favara's avatar
    giovanni_favara
    7 years ago

    Hello Alex,

    thx for your support. I have found a solution.

     

    I had made a mistake with the schema ini file. I forget to unceck the option "Use these custom parameters instead of the system settings:".

     

    With schema file now the import works well.

     

    I think that with you the import behaves differently, because my Windows configuration is different regarding country settings.

     

    Regards

    Giovanni

AlexKaras's avatar
AlexKaras
Champion Level 3
7 years ago

Hi,

 

> For me is that a bug.

CSV file is processed not by TestComplete but by a driver that provides processed data to TestComplete. Behaviour of the driver can be influenced by the locale settings of the given machine. For the maximum reliability and portability of the import I would recommend to create a schema.ini file and specify required settings there.

https://docs.microsoft.com/en-us/sql/odbc/microsoft/schema-ini-file-text-file-driver?view=sql-server-2017

https://stackoverflow.com/questions/12259562/how-can-i-create-schema-ini-file-i-need-to-export-my-csv-file-to-datagridview

  • giovanni_favara's avatar
    giovanni_favara
    Contributor
    7 years ago

    Hi AlexKaras,

    if I don't use a text qualifier then you have right. But I use text qualifier and choice the correct text qualifier in the wizzard. In this case, I expect the date to be treated as a string.

     

    I have followed your advice and generated a schema file. The CSV file I have again exported without double quote and again performed the import. Result: The schema file will be is ignored.

     

    Regards

    Giovanni

    • AlexKaras's avatar
      AlexKaras
      Champion Level 3
      7 years ago

      Hi Giovanni,

       

      Can you post here the problematic code and its output?

      I tried a simplest keyword test with your sample cvs file and got expected result in the log:

       

       

      • giovanni_favara's avatar
        giovanni_favara
        Contributor
        7 years ago

        Hello Alex,

        thx for your support. I have found a solution.

         

        I had made a mistake with the schema ini file. I forget to unceck the option "Use these custom parameters instead of the system settings:".

         

        With schema file now the import works well.

         

        I think that with you the import behaves differently, because my Windows configuration is different regarding country settings.

         

        Regards

        Giovanni