Apache OpenOffice (AOO) Bugzilla – Issue 121057
Webquery: Insert Link to External Data gives server Error in ver. 3.4.1, used to work perfectly
Last modified: 2017-05-20 11:42:03 UTC
Created attachment 79577 [details] file used to do WebQueery perfectly in earlier version, now NOTHING WebQuery: Loading table from Internet gets error: URL [see below] works fine in Firefox, OO file worked perfectly in previous version [3.3??] and File is attached, now I updated to your latest 3.4.1 and get "server Error" Right after "Insert Link to External Data", pasted this link to URL box, push Return and get an error. [I'm after “main_Table” in Available Tables window.] Document that used to work just fine in previous version has the data, now upon opening and clicking Update [this file contains link to external data?] it gives error AND erases everything ["The link could not be updated."]. Also Refresh every 60 seconds worked, now it stopped. Here is the link - below. Document enclosed - email me if you have questions - thanks!! [login email denver80218us@yahoo.com or alexander1us@msn.com] but I think I covered it all in detail. Worked, now in 3.4.1 does NOT. I tried a blank New Spreadsheet but no result either. You can test it in your older version. [How can I get older version to get it working till it's fixed and resolved??] File enclosed: webqueryError [A6 is the cell where i load data] saved as .XLS if that makes any difference? I tried blank sheet and it still gives same error. https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?SessionID=2F0293B4451B4D12B89D6C5364F67439&Symbol=AAPL&Range=0&lstMarket=3&ChainType=&AdjNonStdOptions=OFF&lstMonths=Nov12&FromVB6=True#
Want to add that "Insert Link to External Data" worked minutes before OO update to 3.4.1, file enclosed is from 2 days ago = everything is current, current data in spreadsheet. BTW, is there any way to delete my 2 email addresses from my initial submission? [don't want to get spammed] - thanks!!
Likewise Edit -> Links... Update nor Modify buttons don't work.
Even stripped down version of URL gives error [now little progress - it may work sometimes, but not ALL, mostly NOT: [And my Windows XP is updated to the latest - ran update last couple weeks or so when provided by MS] https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=0&lstMarket=3&lstMonths=Nov12 https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=0&lstMarket=3&lstMonths=Nov12&FromVB6=True
this one is the *simplest* of all - *never works*, yet in ANY browser [IE, Firefox] works fine [till Jan '13]: https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013
Tools>Options>Internet>Proxies: None
Created attachment 79729 [details] First error when Linking to external data in Calc In Calc, menu Insert - Link to external data... URL of external data source: http://twolf.hermitstore.com/wolf.gz/ver001/yield.html
Created attachment 79730 [details] Second error in Calc Despite of the first error, the application allows selecting import options (like locale).
Confirmed on Linux
Regression from OOo 3.4 Beta may be introduced while removing neon, see bug 118569
I downloaded the webqueryError.xls and load it. I got asked that the file contains links to other files and if I want update them. Clicking ok triggered an update and the document got updated. I can't reproduce the problem withe this document on MacOS and AOO 3.4.1
sorry your email addresses can't be deleted.
(In reply to comment #10) > I downloaded the webqueryError.xls and load it. I got asked that the file > contains links to other files and if I want update them. Clicking ok > triggered an update and the document got updated. I can't reproduce the > problem withe this document on MacOS and AOO 3.4.1 Attachment 79577 [details] works for me too, but please try with URLs in comment 4 and comment 6 Both work in OOo 3.4.0 BETA OOO340m0 9583, and don't work with AOO.
The second Url in comment 4 works for me as well, the first Url only once and the Url from comment 6 doesn't work for me. Seems to be not stable or a general problem. Further investigation necessary.
Thanks for testing it guys... [yes sometimes some URLs work] BUT overall most URL don't work ALL the time, or consistently... pointing to some BUG. Problem that needs to be resolved so it works 100% - as it used to work in previous versionS. Noticed a Mac may work "better"? :)
Similar problem has been seen with 3.4.1: http://www.oooforum.org/forum/viewtopic.phtml?t=182626
(In reply to comment #6) > Created attachment 79729 [details] > First error when Linking to external data in Calc > > In Calc, menu Insert - Link to external data... > URL of external data source: > http://twolf.hermitstore.com/wolf.gz/ver001/yield.html Works after updating serf to 1.2.0
(In reply to comment #0) > Created attachment 79577 [details] > file used to do WebQueery perfectly in earlier version, now NOTHING Works after updating serf to 1.2.0 > https://www.optionsxpress.com/OXNetTools/Chains/index. > aspx?SessionID=2F0293B4451B4D12B89D6C5364F67439&Symbol=AAPL&Range=0&lstMarket > =3&ChainType=&AdjNonStdOptions=OFF&lstMonths=Nov12&FromVB6=True# Works too
(In reply to comment #4) > this one is the *simplest* of all - *never works*, yet in ANY browser [IE, > Firefox] works fine [till Jan '13]: > https://www.optionsxpress.com/OXNetTools/Chains/index. > aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013 Works after updating serf to 1.2.0
(In reply to comment #15) > Similar problem has been seen with 3.4.1: > http://www.oooforum.org/forum/viewtopic.phtml?t=182626 The URL posted by the forum user works fine after updating to serf 1.2.0: http://shares.telegraph.co.uk/indices/?index=NMX
I'm just a regular user... how do I install this serf thing on my Windows XP Home, latest version??? You say "Works after updating serf to 1.2.0" I downloaded "serf" and it has a bunch of files, no installer, opened Readme and have no idea what it is and what to do with it??: -------- Welcome to serf, a high-performance asynchronous HTTP client library. The serf library is a C-based HTTP client library built upon the Apache Portable Runtime (APR) library. It multiplexes connections, running the read/write communication asynchronously. Memory copies and transformations are kept to a minimum to provide high performance operation. * Status: http://code.google.com/p/serf/wiki/ * Site: http://code.google.com/p/serf/ * Code: http://serf.googlecode.com/svn/ * Issues: http://code.google.com/p/serf/issues/list * Mail: serf-dev@googlegroups.com * People: Justin Erenkrantz, Greg Stein ---- Quick guide for the impatient (Unix) % ./configure % make % make install ---- Building serf from a Subversion checkout (non-packaged releases) We suggest that you try out 'serfmake'. % ./serfmake --prefix=/usr/local/serf --with-apr=/usr/local/apr install If you want to use the autoconf build system and are using a Subversion checkout, you need to run buildconf and have APR and APR-util sources handy. % ./buildconf --with-apr=/path/to/apr --with-apr-util=/path/to/apr-util (By default, buildconf will look in . and ../ for apr and apr-util.) Then, you can use ./configure, make, etc. ------------------------------- Thanks guys for fixing it. Just what to do with it??????
(In reply to comment #20) > I'm just a regular user... how do I install this serf thing on my Windows XP > Home, latest version??? You say "Works after updating serf to 1.2.0" This was to register that updating our version of serf solves the bug. I didn't mean you download and install serf (something impossible for a regular user, as you have to build it from source). > Thanks guys for fixing it. Just what to do with it?????? Unfortunately, OpenOffice does not provide partial updates for important fixes. So you have to wait until the next release. If this issue is a blocker for you, and you are adventurous, you could try a build from the nightly build bot (if you are interested, I pass you the link). If that build solves the bug, you could try copying the serf libraries from this build into the installation folder of OpenOffice 3.4 (if you are interested, I tell which libraries to copy, and where to copy them). Disclaimer: I'm not suggesting you to do so ;) (even if you are adventurous, the build from the build bot will replace previous versions of OO, so this should be tried in a virtual machine).
Fixed on trunk. @Alexander: the next release will be OpenOffice 4.0, there is no final release date yet; it might be in the middle of 2013 In these times of cloud storage and web connectivity, this bug might be a blocker for several users; it might make sense to think about a bug fix release. This kind of discussions happen on the development mailing list, anyone interested can post a mail bringing this topic.
tested with https://www.optionsxpress.com/OXNetTools/Chains/index.aspx?Symbol=AAPL&Range=10&lstMonths=1/19/2013 http://twolf.hermitstore.com/wolf.gz/ver001/yield.html on OS X 10.8.4 AOO400m3(Build:9702) - Rev. 1499347 2013-07-03 14:06:53 (Wed, 03 Jul 2013) and Windows 8 AOO400m3(Build:9702) - Rev. 1499347 2013-07-03 15:11:47 (Mi, 03 Jul 2013)