Created attachment 131676 [details] google search dynamic query As per http://support.microsoft.com/kb/157482, Excel Web Query files are plain-text files with an URL and optional GET and POST parameters (static and dynamic). Application should process the file, ask user for substitutions for dynamic parameters, create appropriate URL, and open it (presumably as spreadsheet from XML). Some services (like SharePoint ticket system) offer their lists in form of such files to reach relevant XML documents on-line. So, being able to understand them may be useful in these scenarios. A test sample .iqy is attached, as per https://www.vertex42.com/News/excel-web-query.html.
A patch proposed to gerrit: https://gerrit.libreoffice.org/34928
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=099f9406b6657a03a37fbe5cedf7cb7da765d4aa tdf#106359: Open Web Query (.iqy) files It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0c547776340c3983a867890b34f4a931215f8f52 tdf#106359: register .iqy in MSI and treat them as templates It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=82fbc7147183dd27be81c20d7c362937bafc3546 tdf#106359: register text/x-ms-iqy MediaType default extension It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aebdeb6541e2feea180f9f632e6a626c6ee14957 tdf#106359: missing leading dot It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I guess - we could close this bug ? =)
Thanks Michael! I suppose that basic support is finished, co closing.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f19fbadd00370820d026d9c29a7bc231e6fa49f0 tdf#106359: use SvFileStream to read iqy; fixes *nix compatibility It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=71a5bda1f65fa1b87a290f15c24034d25a9f1f25&h=libreoffice-5-4 tdf#106359: use SvFileStream to read iqy; fixes *nix compatibility It will be available in 5.4.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-5-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7a676a8618aab6001a9eb1c43be6c0fdc3d4286b&h=libreoffice-5-4-0 tdf#106359: use SvFileStream to read iqy; fixes *nix compatibility It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Forgive me Mike, please how it suppposed it works, opening iqy file directly with LO opens in writer, from Menu/Sheet/Link to external data opens the import text dialog. Opening from windows explorer seems to want open LibreOffice but nothing happens. (ver 5.4 and 6.0 on Win10x64)
This isn't working from File Open dialog. Something like soffice file.iqy is expected.