Issue 122987 - Insert new sheet from .csv file located on remote server does not work when authentication data is passed in URL
Summary: Insert new sheet from .csv file located on remote server does not work when a...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.1
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp
Depends on:
Blocks:
 
Reported: 2013-08-08 22:20 UTC by Dimitri Pochet
Modified: 2014-01-14 13:24 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Dimitri Pochet 2013-08-08 22:20:29 UTC
From a Calc document, inserting a new sheet (with "link" checkbox checked) from a remote .csv file stored on a WEB server, does not work when authentication data gets passed in URL (in the form http://user:pwd@domain/path/file.csv).

I tried it with test WS at http://user1:user1@test.webdav.org/auth-basic/ and checked network traffic using Wireshark -> OO Calc does not even issue a TCP request towards the remote server.

Same attempt from Basic Macros :
 dim document as object
 dim feuille_donnees as object
 dim filtre as string
 dim details_filtre as string
 dim Url as string
 dim mode as integer
 document=ThisComponent
 feuille_donnees = document.Sheets.getByName("Données")
 Url = "http://samplecsvs.s3.amazonaws.com/Sacramentorealestatetransactions.csv"
 filtre = "Text - txt - csv (StarCalc)"
 details_filtre = "44,34,ANSI,1," ' comma (chr(44)) delimiter, double quote  (chr(34)) text delimiter, ANSI coding
 mode = com.sun.star.sheet.SheetLinkMode.NORMAL
 feuille_donnees.link(Url, "", filtre, details_filtre, mode) 
..and same no-effect.

I thought OO was compliant with RFC1738 §3.1 ?