Getting error "Calling method '_start_suite' of listener 'DataDriver' failed: FileNotFoundError: File attribute was empty""

Arvind · 6 October 2022 11:27

Getting error as " Calling method ‘_start_suite’ of listener ‘DataDriver’ failed: FileNotFoundError: File attribute was not a full path."

Code:-

*** Settings ***
Library SeleniumLibrary
Library Collections
Test Template Fill the login form
Library DataDriver file=xyz/Resource/data.csv

*** Variables ***
${url} https://demoqa.com/
${browser} chrome

*** Test Cases ***
Execute Login test with user ${username} and password as ${password}

*** Keywords ***

Fill the login form
[Arguments] ${username} ${password}

open browser        ${url}      ${browser}
maximize browser window
sleep    3s

Appreciate quick help. Thanks

rasjani · 6 October 2022 11:53

github.com

Snooz82/robotframework-datadriver/blob/main/src/DataDriver/DataDriver.py#L1738


      
                      f"Tried to find {suite_path_as_data_file} but file does not exist. "
                      f"If no file validation is required, set file_search_strategy=None."
                  )
          
          def _check_if_file_exists_as_path_or_in_suite(self):
              if not Path(self.reader_config.file).is_file():
                  file_in_suite_dir = Path(self.suite_source).parent / self.reader_config.file
                  if file_in_suite_dir.is_file():
                      self.reader_config.file = str(file_in_suite_dir)
                  else:
                      raise FileNotFoundError(
                          f"File attribute was not a full path. Tried to find {file_in_suite_dir} but file does not exist."
                      )
          
          def _check_valid_glob(self):
              if self.reader_config.reader_class != "glob_reader":
                  return None
              if not glob(self.reader_config.file):
                  raise FileNotFoundError(
                      f"Glob pattern did not find a file or folder. Glob pattern was: {self.reader_config.file}"
                  )

So, the relative path you pass to the reader as “file” is not being able to be located in the form you are passing it …

When in doupt: use absolute paths - even if you would dynamically construct it …

Arvind · 6 October 2022 12:18

Thanks for your quick reply. Unfortunately tried couple of the options per suggestion but still getting same error.

Tried Option 1:-
Tried by providing absolute path (detailed path of data.csv) as parameter,
Library DataDriver File=C:\Users\abc\PycharmProjects\pavan\xyz\Resource\data.csv

Tried Option 2:-
Tried by providing absolute path (detailed path of data.csv) as parameter,
Library DataDriver File=C:/Users/abc/PycharmProjects/pavan/xyz\Resource/data.csv

Tried Option 3:-
Tried by providing absolute path (detailed path of data.csv) as parameter,
Library DataDriver File=data.csv

Complete Error:

==============================================================================
ParamterizationTestViaCSVFIle

[ ERROR ] [ DataDriver ] Error in robot file:
File “C:\Users\abc\PycharmProjects\pavan\xyz\ParamterizationTestViaCSVFIle.robot”, line 0
[ ERROR ] Calling method ‘_start_suite’ of listener ‘DataDriver’ failed: FileNotFoundError: File attribute was empty. Tried to find C:\Users\abc\Pych
armProjects\pavan\xyz\ParamterizationTestViaCSVFIle.csv but file does not exist. If no file validation is required, set file_search_strategy=None.

Really appreciate your help!!!

HelioGuilherme66 · 6 October 2022 13:08

Double-check the paths.

Arvind · 6 October 2022 13:44

Thanks Hélio Guilherme for reply.

That’s the point. I am asking DataDriver to pick “data.csv” file from mentioned location.
ParamterizationTestViaCSVFIle.robot file which uses DataDriver Library to take data.csv inputs.

Si am surprised why it is looking for ParamterizationTestViaCSVFIle.CSV file instead for data.csv file?

damies13 · 7 October 2022 02:29

Hi @Arvind,

Ah the joys of windows paths

I’ve seen python (and therefore robot framework) sometimes give weird intermittent file not found errors when combining paths with slashes going in different directions, which might be what you are getting here.

You gave the relative path of xyz/Resource/data.csv, but since it’s a relative path robot’s going to prefix the first part C:\Users\abc\PycharmProjects\pavan\? and you’ll end up with a path that looks like C:\Users\abc\PycharmProjects\pavan\xyz/Resource/data.csv which causes weird errors when python passes it to the windows system api.

A simple fix would be to use “windows” slashes (remember you need to escape them though:

Library DataDriver file=xyz\\Resource\\data.csv

but if you are hoping to run this test on a mixed environment that might break the tests on MacOS, Linux, etc, in which case using the path seperator from Operating-system variables might be a good idea:

Library DataDriver file=xyz${/}Resource${/}data.csv

The other option is just to use an absolute path with all the slashes going the same way (again this might be an issue if you need to run the test on multiple platforms)

Library DataDriver file=C:/Users/abc/PycharmProjects/pavan/xyz/Resource/data.csv

Hope this helps,

Dave.

Arvind · 7 October 2022 08:17

Hi Dave,

Thanks a lot for detailed explanation and possible solution.
I tried with windows slashes (“\”) and now partially it works for me. Now robot framework/DataDriver looking for “data.csv” file at expected location.

However, now facing new issue as unable to fetch values from data.csv file and hence throwing error as “Variable ‘${username}’ not found.”.

In actual, there are 3 columns along with data in data.csv file as below,
Test Cases,${username},${password}
invalid username,abc,DGTO12
invalid password,xyz,ABRE334

Not sure why this error is thrown now

damies13 · 7 October 2022 09:28

I recreated your robot file and data.csv file and I get the same error “Variable ‘${username}’ not found.”, I don’t know enough about DataDriver (I only just installed it to try and help you) I tried to follow the documentation to figure out what was wrong but I’m not sure

robot Arvind.robot
==============================================================================
Arvind                                                                        
==============================================================================
invalid username,"abc","DGTO12"                                       | FAIL |
Variable '${username}' not found.
------------------------------------------------------------------------------
invalid password,"xyz","ABRE334"                                      | FAIL |
Variable '${username}' not found.
------------------------------------------------------------------------------
Arvind                                                                | FAIL |
2 tests, 0 passed, 2 failed
==============================================================================

Clearly it’s picking up the variables from the file, but it seems the variables are not being created.

To try things out I created another keyword to use as the Test Template:

Fill the login webform
	${vars}= 	Get Variables
	Log 	${vars}
	Log		${username} | ${password}

when I looked into ${vars}, there was no ${username} or ${password} variable. so maybe there is a bug in the newest version of DataDriver?

Dave.

Arvind · 7 October 2022 10:15

Thanks again Dave.
I am not sure if this could be issue from DataDriver library or not.

@Someone from RobotFramework Responsible Forum, Please advise/help.

rasjani · 7 October 2022 10:34

Since your data.csv is using , as a separator, you should pass dialect=excel to DataDriver in the Library line

Arvind · 8 October 2022 08:25

Hi Jani,

Many thanks for your perfect solution.

Its working fine now:)
Appreciate your help and prompt response.
Have a nice day…!!!

Russel82 · 28 December 2023 04:22

I’m getting Excel variable not found while reading data from Excel sheet. Can some one plz take a look at it pleaseeeee. It’s throwing the same error
[ ERROR ] Calling method ‘_start_suite’ of listener ‘DataDriver’ failed: FileNotFoundError: File attribute was not a full path. Tried to find C:\Use
rs\503363989\PycharmProjects\ViewIT\ViewIT..\TestData\Data.xlsx but file does not exist.

My Exact location of this Excel is : C:\Users\503363989\PycharmProjects\ViewIT\ViewIT\Testdata

*** Settings ***
Library SeleniumLibrary
Resource …/ViewIT/resources.robot
Resource variables/CommonVariables.robot
Resource …/ViewIT/test.robot
Library DataDriver …/Testdata/Data.xlsx

Suite Setup Application Loggin
Suite Teardown Close Browsers
Test Template Login

*** Test Cases ***

WhenLoginusing ${username} ${Pwd}

[Tags] ViewIT home Page Verification

*** Keywords ***

Login
[Arguments] ${username} ${Pwd}
Enter Username ${username}
Enter PWD ${Pwd}

divyab05 · 16 September 2024 05:55

can you help for accessing the data from excel: I am getting error
Calling method ‘_start_suite’ of listener ‘DataDriver’ failed: AttributeError: partially initialized module ‘pandas’ has no attribute ‘_pandas_datetime_CAPI’
Variable ‘${username_e2e}’ not found.

divyab05 · 16 September 2024 06:00

I am getting error Calling method ‘_start_suite’ of listener ‘DataDriver’ failed: AttributeError: partially initialized module ‘pandas’ has no attribute ‘_pandas_datetime_CAPI’
Variable ‘${username_e2e}’ not found. while using xlsx… but with same data i am able to access with csv file.

Any help would be appreciated
Library DataDriver file=${Excel_Path_e2e} sheet_name= test1

Topic		Replies	Views
DataDriver powered test returns "Test cannot be empty" error DataDriver	11	1180	18 March 2024
AttributeError: 'str' object has no attribute 'path' Robot Framework	4	5028	9 December 2023
Chrome error with Selenium SeleniumLibrary	2	1548	20 March 2023
Error Reading Variables from Excel file Libraries	2	791	10 February 2023
Choose file not working in firefox SeleniumLibrary	4	672	5 August 2023

Getting error "Calling method '_start_suite' of listener 'DataDriver' failed: FileNotFoundError: File attribute was empty""

============================================================================== ParamterizationTestViaCSVFIle

[Tags] ViewIT home Page Verification

Related topics

==============================================================================
ParamterizationTestViaCSVFIle