I am trying to link to an external data source where the data is in CSV format. The URL is http://gsaweb.ast.cam.ac.uk/alerts/alerts.csv. When I enter this as the URL of the external Data source and then press enter the text import wizard opens as might be expected for a CSV file.
Having set the correct parameters in the Text Import form I then click OK. The text import window closes but nothing happens. The external Data form just sits there with OK greyed out. However the Cancel & Help buttons work so it has not hung.
The same thing happens if I try to import from a local copy of the file so it does not seem to relate to the URL.
I know the parameters in the text import wizard are correct as I can open the local copy of the file and import it using file open.
I am attempting to get the link method to work as I want the data to be automatically updated rather than going through the need to save the file and then open it and then copy and paste it into the master spreadsheet. It would be a lot easier if I can get it to upload automatically in a similar way to the Excel data import works.
Am I doing something wrong or is this not possible in Calc ?
Thanks for your response ‘Opaque’
*As requested LibreOffice Version
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3;
Locale: en-GB (en_GB.UTF-8); Calc: group
These import settings work Ok if I save the file and then open it in calc.
One thing I know that is slightly unusual about this file and has stopped another pro9gramme working is that the last line does not have a line ending - the CSV spec is not clear on the requirement for a line end on the last line from what I was told by those investigating the problem with another programme. This may be a re-herring as it works ok when saved and opened.*