Skip to main content

Hi there, 

 

I have connected to a Sharepoint Excel file in my workbench. I am able to read the rows and values when inspecting the Excel. 

 

However, when I connect the Sharepoint Excel reader into any transformer, I get the error below:

 

Exception ignored in: <finalize object at 0x13bf76a0; dead>
Traceback (most recent call last):
  File "weakref.py", line 590, in __call__
  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections
    conn.close()
  File "http\client.py", line 1020, in close
  File "socket.py", line 505, in close
  File "ssl.py", line 1311, in _real_close
  File "socket.py", line 499, in _real_close
OSError: rWinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Exception ignored in: <finalize object at 0x13bf7cc0; dead>
Traceback (most recent call last):
  File "weakref.py", line 590, in __call__
  File "C:\Program Files\FME\python\urllib3\connectionpool.py", line 1135, in _close_pool_connections
    conn.close()
  File "http\client.py", line 1020, in close
  File "socket.py", line 505, in close
  File "ssl.py", line 1311, in _real_close
  File "socket.py", line 499, in _real_close
OSError: _WinError 10093] Either the application has not called WSAStartup, or WSAStartup failed
Error running translation.
 

 

When I try open the Python file linked the error log, it does not open (not sure if this is expected or not). 

 

I have tried getting around this by first creating a copy of the Sharepoint Excel with no luck. 

 

Any pointers on how to fix this? Thanks

Morning Hayley,

 

Do you use the SharePointOnlineConnector to connect to the sharepoint, and the excel?

When I want to read and use an excel file from sharepoint, I have the SharePointOnlineConnector download the file to a temp folder (using the Request action “download”) to be able to open, and work with it.

 

SharepointOnlineConnector → Download to temp folder

FeatureReader(Excel) → Read from downloaded folder.

 

Maybe this helps in your case?


@jobvdnoort that worked perfectly, thank you! 


Reply