tir-script-samples
tir-script-samples copied to clipboard
Não está conseguindo abrir arquivo CSV
Bom dia a todos,
Estou tentando realizar a leitura de arquivo CSV para automatizar os testes com o TIR. Mas após realizar a abertura do arquivo está ocorrendo erro de leitura do arquivo CSV. Estou realizando testes com o arquivo compactado liberado no link:
https://tdn.totvs.com/display/FDI/Testes+automatizados+usando+o+TIR
Abaixo segue como está configurado o arquivo config.json:
{ "Url": "http://127.0.0.1:5321/", "Browser": "FireFox", "Environment": "R2410_REST", "Language": "pt-br", "User": "admin", "Password": "123", "CSVPath": "C://TEMP", "DebugLog": false, "TimeOut": 90, "Headless": false }
Segue abaixo o erro:
====================================================================== ERROR: teste_MATA030_001 (main.MATA030.teste_MATA030_001)
Traceback (most recent call last): File "c:\Temp\Facilitador TIR\Teste_MATA030.py", line 16, in teste_MATA030_001 csv_content_dictionary = self.oHelper.OpenCSV(delimiter=";", csv_file="SA1_1.csv", header=True) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Python312\Lib\site-packages\tir\main.py", line 1212, in OpenCSV return self.__webapp.open_csv(csv_file, delimiter, column, header, filter_column, filter_value) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Python312\Lib\site-packages\tir\technologies\webapp_internal.py", line 10431, in open_csv data = pd.read_csv(self.replace_slash(f"{self.config.csv_path}\{csv_file}"), sep=delimiter, encoding='latin-1', on_bad_lines=False, header=has_header, index_col=False, dtype=str) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Python312\Lib\site-packages\pandas\io\parsers\readers.py", line 1013, in read_csv kwds_defaults = _refine_defaults_read( ^^^^^^^^^^^^^^^^^^^^^^ File "C:\Python312\Lib\site-packages\pandas\io\parsers\readers.py", line 2258, in _refine_defaults_read raise ValueError(f"Argument {on_bad_lines} is invalid for on_bad_lines") ValueError: Argument False is invalid for on_bad_lines
Ran 1 test in 65.044s
FAILED (errors=1)
[Done] exited with code=1 in 69.601 seconds