Bug 35040 - Link to External Data functionality should be extended to CSV and RAW files
Summary: Link to External Data functionality should be extended to CSV and RAW files
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 35041 69320 (view as bug list)
Depends on:
Blocks: Calc-External-Datalink 35041
  Show dependency treegraph
 
Reported: 2011-03-05 11:07 UTC by Rainer Bielefeld Retired
Modified: 2018-04-05 14:54 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2011-03-05 11:07:50 UTC
I tried to read data from a Programmable Logic Controller via Internet

Steps to reproduce:
1. open new spreadsheet, click 'A1'
2. Menu 'Insert > Link to External Data'
3. Insert "http://81.6.54.125/" into URL pane
   Expected: connection will be created, Some selections should be shown in
             "Available tables / ranges
   actual: nothing happens

That will work with OOo1.1.4, Here I can Continue the test
11. Select "HTML_all" <OK>
    after a short moment, word "Start" will be inserted

This also should work with LibO
Comment 1 Rainer Bielefeld Retired 2011-03-05 11:18:12 UTC
This one blocks
Bug 35041 - Improve 'Link to External Data' concerning CGI
Comment 2 Florian Bircher 2011-03-07 12:12:01 UTC
Analyse:
"http://81.6.54.125/" does not deliver a table or data in a database simmilary format!
It is proably right that there is no "HTML_all" avaliable!
It delivers only a HTML with a link to a JavaApplet that handles the full content.
There is now way to extract data whitout knowhow about the programm running on the PLC.

BUT! If you try:
"http://www.unlogisch.ch/testscripts/test.csv"
"http://www.unlogisch.ch/testscripts/readVal.exe"

A similar problem shows wich is probably the same as in Bug 35041

Expectet behavior:
1. open new spreadsheet, click 'A1'
2. Menu 'Insert > Link to External Data'
3. Insert "http://www.unlogisch.ch/testscripts/test.csv" into URL pane
Wait till the CSV Import function is OPEN
4. Configure the CSV Import as it is right for the Table
5. Press OK
   Expected: Import the CSV table into the Table.
             Or Jump back to select a specific cell to Import.
   actual: Jump back to the bervious dialog.
           OK Field is grayed out!
           No possibility to finish the Import!

Summary:
-HTML Table Import works
-CSV, RAW Data Import is broken!
-XLS NOT testet
-ODF NOT testet
-... NOT testet
Comment 3 Rainer Bielefeld Retired 2011-05-28 01:09:34 UTC
Confirmed by Comment 2

@Kohei
Please feel free to reassign if it's not your area!
Comment 4 wope 2011-06-18 03:47:11 UTC
It happens also with Suse 11.3, x86 and LibO 3.3.3
Comment 5 thePanz 2012-03-16 05:41:19 UTC
I can confirm this bug with latest Libreoffice 3.5.0 under Windows7 32bit
Comment 6 Florian Reisinger 2013-05-12 13:21:08 UTC
*** Bug 35041 has been marked as a duplicate of this bug. ***
Comment 7 Owen Genat (retired) 2013-12-13 11:46:56 UTC
This bug should is an enhancement request as not only has this facility never existed, the related Help page:

https://help.libreoffice.org/Calc/Inserting_External_Data_in_Table_WebQuery

... explicitly states (and always has) that only "tables from HTML documents" are supported. 

Severity set to enhancement. Version set to Inherited From OOo as I have tested this under Ubuntu 10.04 x86_64 running v3.3.0.4 OOO330m19 Build: 6 and the facility does not cater for CSV files.
Comment 8 Owen Genat (retired) 2013-12-13 11:52:36 UTC
*** Bug 69320 has been marked as a duplicate of this bug. ***
Comment 9 Jean-Baptiste Faure 2013-12-13 15:43:47 UTC
Made summary more clear (I think).

Best regards. JBF
Comment 10 Owen Genat (retired) 2014-01-06 10:27:04 UTC
Setting version back from "Inherited From OOo" to what it was prior (for bugs marked enhancement), for QA tracking purposes. My mistake. Apologies.
Comment 11 Alex Thurgood 2015-01-03 17:38:42 UTC Comment hidden (no-value)
Comment 12 jun meguro 2015-06-07 09:58:31 UTC
Still reproduced in LibreOffice5.0 beta1.
Comment 13 G. Richard Bellamy 2015-11-16 02:49:19 UTC
I'm running 5.0.3.2 Release.

In order to support using LibreOffice Calc as a front-end to various web service data providers, the link to external data should accept raw XML, JSON and CSV without the requirement for those sources to have "named tables" or "named ranges".

I recognize that I _can_ download the data to file, and then import it. This is far from ideal.

As a user I want to be able to have two worksheets, one with data that is refreshed on-demand, without having to shell out or leave the application, and one that analyses that data via charts, formulae, conditional formatting or other spreadsheet tool.

What's the likelihood this ends up on the roadmap? I understand this software is FOSS, and there's sooooo many other things to work on. Just trying to understand if it's even on a dev's radar...
Comment 14 Alex 2017-12-02 14:56:48 UTC
It seems to be present in 6.0 beta1. I've tried to import CSV from FreeCAD to create project schedule but lack of csv-as-external-data limits usage here.
Comment 15 Dan Dascalescu 2018-01-14 07:38:39 UTC
I'm surprised CSV imports don't work, but HTML ones do. The CSV format is far simpler than HTML. How did these two get prioritized?
Comment 16 Jean-Baptiste Faure 2018-01-14 19:11:47 UTC
Please, do not change the version number, it is intended to show the first version in which the bug has been observed.

Best regards. JBF
Comment 17 Eike Rathke 2018-04-05 14:54:56 UTC
Linking to CSV was implemented for bug 114995.