link to local server files in a DT in RMarkdown

Asked May 04 '17 at 17:28

Active May 22 '17 at 07:17

Viewed 202 times

Trying to link to local server files inside a DataTable View.

Files are located on my server home folder, so links are actually linking to a local folder from Rmarkdown but remote folder from the user's browser.

Desired result is user opening Rmarkdown in a browser with datatable view and clicking a link then file is opened or downloaded.

   # df is a dataframe of filenames

    location <- "/home/user/files/"

    dt$link<- paste0("[",dt$Filename,"](", location,df$Filename ")")

    require(DT)

    datatable(df, rownames = F, filter = "top")

Filename column is rendered as simple text, no blue color, no hover , no link to file...

Regards

edited May 22 '17 at 07:17

zx8754

52,746
12
114
209

asked May 04 '17 at 17:28

Forge

1,587
1
15
36

`require(datatable)` -- do you mean `require(DT)`? – nrussell May 04 '17 at 17:31
You're right nrussell – Forge May 04 '17 at 19:08
Not duplicated as the other is for Shiny. Mine is for Rmarkdown – Forge May 04 '17 at 19:09
`datatable` renders HTML AFAIK; did you try making a proper HTML link (i.e. with an anchor element) and prefixing the file path with `file:///`? – nrussell May 04 '17 at 19:14
so, code will be?: paste0("", dt$Filename , "") – Forge May 04 '17 at 19:21
`sprintf('%s', dt$Filename, dt$Filename)` should work (note that the link given to `href` needs to be surrounded by quotes *in* the HTML code). Also, you need to specify `escape = FALSE` in the `datatable` expression. – nrussell May 04 '17 at 19:38
Did'nt know that "pythonesque" trick. Worked rendering a proper link (even the document is not downloaded or opened, I imagine permission issues)! Thanks nrussell – Forge May 05 '17 at 07:10

link to local server files in a DT in RMarkdown

0 Answers0