Bug 144422 - Sheet, "Link To External Data", directly import csv FILEOPEN, FILEIMPORT
Summary: Sheet, "Link To External Data", directly import csv FILEOPEN, FILEIMPORT
Status: CLOSED DUPLICATE of bug 114995
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-10 02:22 UTC by Martin
Modified: 2021-09-10 10:17 UTC (History)
0 users

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 Martin 2021-09-10 02:22:14 UTC
Description:
URL of external data source.
Enter the URL or the file name that contains the data that you want to insert, and then press Enter. Alternatively, click Browse button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.

Note Icon 
A dialog for CSV data import appears when linking to external CSV file.


Available tables/ranges
Select the table or the data range that you want to insert. "If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and OK button will remain inactive" 

I am referring to the last part of the description above in quotes""

I have a HTML link to a downloadable .csv file.
This dialogue works up to and including defining special column data as one would on opening the file directly from my local disc.

The system process underlying the part quoted should be changed to permit an assumption that the whole document is to be loaded as per the settings in the csv column definition dialogue and the OK button activated so the process can proceed.

Sample public link
https://data.nsw.gov.au/data/dataset/aefcde60-3b0c-4bc0-9af1-6fe652944ec2/resource/21304414-1ff1-4243-a5d2-f52778048b29/download/covid-19-cases-by-notification-date-and-postcode-local-health-district-and-local-government-area.csv

Steps to Reproduce:
1. Menu
2. Sheet
3. Link to external data
4. insert URL press enter
5. Text import dialogue pops up
6. Select Comma, Format quoted field as text, Fields Column type YMD on first column.
7. click OK
8. Available Tables/Ranges is blank but it could say "Entire file"
9. select Update every 84600 seconds for a daily update
10 OK button is inactive but it could be active.

Actual Results:
got nowhere

Expected Results:
should have created permalink to the file


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: en-AU (en_AU.UTF-8); Calc: group
Comment 1 Eike Rathke 2021-09-10 10:15:39 UTC
Your version 6.0.7.3 is too old. CSV can be used as external linked data since 6.1 already see https://wiki.documentfoundation.org/ReleaseNotes/6.1#Link_to_External_Data_supports_CSV
Comment 2 Eike Rathke 2021-09-10 10:17:06 UTC

*** This bug has been marked as a duplicate of bug 114995 ***