Trouble working with Link to External data

Discuss the spreadsheet application

Trouble working with Link to External data

Postby jaysugar » Thu Jan 19, 2012 6:24 pm

Hi. I can't seem to able to import data via a link to external data (Top Menu -> insert -> Link to External Data).These are the steps I took:

1) Top Menu -> insert -> Link to External Data, External data dialogue box comes up.
2) The url is entered into the source box, the data from the url is in the form of text CSV
3) Pressed Enter and the text filter selection comes up, "Text CSV" selected
4) Text Import menu comes up, character set to ASCII, English, from row 2, comma separator. Now the fields box clearly shows a preview example of what it should look like, detecting all the data and separated nicely into columns. Pressed OK to exit the menu...
5) Now back to External data dialogue box, only to be met with an empty box in the "available table/ranges", thereby stopping any importing (OK button is grayed out).

Now since the field box from the text import menu (step 4) was able to detect and show the data from the url, clearly it's not in a perculiar format that requires any special treatment, it's just text csv. To doubly make sure, I went to Top Menu -> File -> Open and use the same url as the file name to open, and it opened just fine without any errors.

Is there a workaround for this problem?

Thanks
LibreOffice 3.4.5 (OOO340m1 build 502) on Windows 7 SP1
jaysugar
 
Posts: 3
Joined: Thu Jan 19, 2012 5:57 pm

Re: Trouble working with Link to External data

Postby Villeroy » Thu Jan 19, 2012 6:39 pm

Use menu:Insert>SheetFromFile with option "Link". The external data feature imports named table ranges from spreadsheets or html.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26873
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trouble working with Link to External data

Postby jaysugar » Thu Jan 19, 2012 7:20 pm

Hello, thanks for the quicky reply. I have tested out the Sheet from File with "Link" option, and afraid it doesn't seem to serve my purpose. From what I can see, the Sheet from File with "Link" links to a static file rather than a URL, and as such, when the url is updated with fresh data, the old static file is not updated (yes, I have tested out with Edit -> Link and pressed the "update" button). [As for why there was a static file in the first place, I believe it is due to windows' integration with internet explorer, which upon file open request from Libreoffice, does a transparent loading of the web page, and as such the file is coindentially saved in IE's internet temp directory, which does happen in this case.]

Perhaps I might have cause misunderstanding when I mentioned in step 2 that the data from url is in form of text csv, it is served out by a web server and is constantly refreshed, hence I tried to use Link to External data in the first place, because it can do refresh upon selected time intervals.

Edit: forgot to add that the data url doesn't have an extension, ie, not http://host.com/data.csv, but is http://host.com/data

Thanks.
LibreOffice 3.4.5 (OOO340m1 build 502) on Windows 7 SP1
jaysugar
 
Posts: 3
Joined: Thu Jan 19, 2012 5:57 pm

Re: Trouble working with Link to External data

Postby Villeroy » Thu Jan 19, 2012 9:18 pm

Under Linux you could update a local copy of the files using some cron job with a built-in downloader such as wget. For Windows you need to find the right tool for this or write your own.
Then you connect a Base document to the directory of downloaded csv file(s), link a preformatted spreadsheet to it and let the import range update every few minutes.
 Edit: Insert>SheetFromFile with link option works with http sources. I just tried http://www.openoffice.org/download/md5s ... d5sums.txt 
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26873
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trouble working with Link to External data

Postby jaysugar » Fri Jan 20, 2012 2:29 pm

Well, I have tried an alternative spreadsheet software and that imported well with regular interval. I believe it's unofficial courtesy to not mention any names, but thanks for the help.
LibreOffice 3.4.5 (OOO340m1 build 502) on Windows 7 SP1
jaysugar
 
Posts: 3
Joined: Thu Jan 19, 2012 5:57 pm

Re: Trouble working with Link to External data

Postby Villeroy » Fri Jan 20, 2012 3:12 pm

jaysugar wrote:Well, I have tried an alternative spreadsheet software and that imported well with regular interval. I believe it's unofficial courtesy to not mention any names, but thanks for the help.

:?: This is not a marketing list. You hardly find any partisanship nor fan boyism in this forum. So what is your alternative spreadsheet software able to pull plain text via http protocol?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26873
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Trouble working with Link to External data

Postby librer » Sat Feb 17, 2018 10:07 pm

Such a old problem and it still valid to me. Trying to import the table from this link https://api.coinmarketcap.com/v1/ticker/bitcoin/
After klicking OK in the Text import dialog where you can see the table and its content, there is no available table in the parent dialog to import...
LibreOffice 5.1.6.2 on Linux Mint 18.3
librer
 
Posts: 1
Joined: Sat Feb 17, 2018 9:57 pm

Re: Trouble working with Link to External data

Postby Villeroy » Mon Feb 19, 2018 11:43 am

That is a JSON structure. Completely unrelated to spreadsheets. It's made for programmers.

https://forum.openoffice.org/en/forum/v ... c.php?f=45
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26873
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 38 guests