External data source with csv

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

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

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

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 :slight_smile:

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