External data source with csv

[PatrickH]

Hi,
I’m trying to create a calc sheet from a webservice. The webservice provides the data as CSV content. Downloading the result and then importing via Insert-> Table from File works just fine. However neither using the URL nor the downloaded file via Insert->link to external data works. I tried the same with MS Excel on a different computer, where this works. Any hints what can be done to get it to work with Libreoffice?

The URL is: http://www.gw2spidy.com/api/v0.9/csv/all-items/all

I’m on Libreoffice 4.1.3.2 (german).

Thanks

Patrick

[mariosv]

Well I have done a try, and it works for me with Win7x64 Version 4.0.6.2, with Insert from file. Link to external data seems to need a html file.

I think the issue is that it seems doesn’t work and some steps take a while.

How I did it?

• Menu/Insert/Sheet from file
• In address bar enter the path [enter]
• Wait for Open button.
• Click Open and wait, in my case near a minute.
• Window for set up the import appears.
• Ok
• Wait until you can mark link option.
• Ok

[eagle275]

if insert sheet only allowed to enter something … no … it needs a “hard” file on disk … simply stupid … if even microsoft managed to do it

[Pedro1]

Apparently it wont work with CSV. It expects a named table and CSV doesn’t have named tables. If you open the CSV, and give a Name to the range (Insert > Names > Define) and save it as ODS (or XLS, etc) then you can use it as a source to Insert the Link in another file

But I think this defeats the utility of the External link…