Skip to main content
  • EN

I want to read a csv from a URL, but I am failing to connect.

I add a Reader

Format: CSV (Comma Separated Value)

Dataset: http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axf

under Parameters

Delimiter Character: ,

Field Names Line: 20

Data Start Line: 21

 

but I get the error

CSV reader: Failed to open file 'http://www.bom.gov.au/fwo/IDQ60801/IDQ60801.94418.axf' for reading. Please ensure that the file exists and you have sufficient privileges to read it

When I use chrome to visit the URL I succeed. The URL and resulting csv file definitely exist.

What I want is to read (and process) the csv file using FME

Hi @nicholas It works for me. Can you attach your workspace here or else send it to https://www.safe.com/support/report-a-problem/ ? Thanks!

Hi DanAtSafe

I cannot attach a workspace as I cannot even create a workspace.

When I attempt to insert a reader into the blank workspace, it fails to insert the reader.

The final error line is Workspace generation failed.

I work in a government department.

Do I have to configure my internet connection for a proxy server?

I assumed that as I can access the file via an internet browser, that my internet connection was fine. But maybe there is some more configuration I should be doing?

Solved it.

I had to set up the network proxy in Tools | FME Options | Network Proxy

I chose "Use system proxy settings"

I ticked "Proxy Server Requires Authentication"

and entered my internet logon and password

Authentication Method was basic.

This got me through my organisation's proxy server

Obviously may be different for other users

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.