link to Excel doc on local directory

[Ben John]

Hi folks - please would someone tell me how to put a link from an Excel file stored on my hard drive into a tiddler. Thanks

Ben

[Tobias Beer]

Works for me...

file:///c:/Windows/foo

http://tb5.tiddlyspot.com/#filesystem-links

http://tb5.tiddlyspot.com/#external-links-forced

Note: For that to work, your wiki does have to be on your local filesystem, not on the web.

Best wishes, Tobias. 

[Stephen Kimmel]

Tobias can correct me if I am wrong but though you can link to external files, only certain types will execute inside your browser. I have linked to Microsoft Excel files but they have always started Excel external to the program and run the files there.

[Ben John]

Hi Tobias - many thanks but I can't get that to work . If my file location is file:///C:/Users/Ben/Desktop/Tiddlywikkis/ONS%20Notebook.htm please can you show me how that is configured in a tiddler.

many thanks

--
You received this message because you are subscribed to the Google Groups "TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+...@googlegroups.com.
To post to this group, send email to tiddl...@googlegroups.com.
Visit this group at http://groups.google.com/group/tiddlywiki.
For more options, visit https://groups.google.com/d/optout.

[Tobias Beer]

Hi Stephen,

 

though you can link to external files, only certain types will execute inside your browser

Not sure exactly where (I would do that in Chrome) but I know that you can tell Firefox which filetypes to open in the browser and which in another program, i.e. pdf... that is, of course, in sofar as the browser natively supports it or via some addon. Otherwise it will always open the external application, unless the file asked to be openeed is an executable where a browser might just refuse to do so.

If my file location is file:///C:/Users/Ben/Desktop/Tiddlywikkis/ONS%20Notebook.htm

Afaik, the location of your file does not matter for filesystem links. Of course, you can only make use of relative paths using [ext[path/file]] when your file resides in a subfolder to your wiki folder.

Best wishes, Tobias.

[Ben John]

Hi Tobias - here's what I get

File not found

The address wasn't understood

Firefox doesn't know how to open this address, because one of the following protocols (c) isn't associated with any program or is not allowed in this context.

    You might need to install other software to open this address. 

and

Firefox can't find the file at /C:/Users/Ben/Desktop/Tiddlywikkis/Users/Ben/Desktop/RESPONSE WITH FORMULAE FINAL copy 2.

    Check the file name for capitalization or other typing errors.
    Check to see if the file was moved, renamed or deleted.

Any help would be appreciated

--

[Stephen Kimmel]

Ben,

This may seem a bit off topic but here is a copy of the line I use in my wiki to display a text file in my wiki.

<iframe src="file:///f:/reboot.txt" frameborder=0 width="100%" height="700"></iframe>

and here is another that displays a pdf file that is displayed:

<object width="100%" height="900" type="application/pdf" data="file:\\E:\binder.pdf #toolbar=0&amp;navpanes=0&amp;statusbar=0">
</object>

Both of those lines work for me. There are a couple things to be careful of here.

1) Be sure you are spelling the filename and the directory name correctly. Some systems are more sensitive to differences in capitalization than others. The  line you have there has Users/Ben/Desktop twice and I generally don't spell wikis with two 'k's.
2) The number of slashes or back-slashes is important. Since your error message says it can't find

Firefox can't find the file at /C:/Users/Ben/Desktop/Tiddlywikkis/Users/Ben/Desktop/RESPONSE WITH FORMULAE FINAL copy 2.

I would try it with one fewer slash than you used before.
3) I've had some difficulties using this sort of address line with Windows folders. You might try putting the file in a more fixed directory such as C:/Wikidata/

[Birthe C]

Hi Ben

I had to try more than 50 times before I had my first success getting my file. To me one of the obstacles was using danish translated Windows, but the link that worked ended up being a mixture. To find the link, I found the file in filemanager, right clicked for a shortcut, looked at that in properties and copied. Now I only had to rewrite with the forward slashes.
If you have all your files at the same folder, you will only have to do that once.

Looking at your link, I will add that I could not make my link work to files with spaces in the title or special danish letters.


Birthe

[Jeremy Ruston]

The easiest technique I've found for getting the correct link to a file is to locate the file in your file manager (Windows Explorer or Mac Finder) and drag it to the icon for your browser. On most browsers, the file will be opened in a new window and you'll be able to copy and paste the URL from the browser address bar.

Best wishes

Jeremy

--

Jeremy Ruston
mailto:jeremy...@gmail.com

[Ben John]

Hi Jeremy - thanks for that - I've copied and pasted from my file manager and  the address  shows as a link in the tiddler but when I click on it nothing happens.

: file:///C:/Wikidata/RESPONSE%20FORM%20WITH%20FORMULAE%20FINAL%20copy%202.xls

[Jeremy Ruston]

Hi Ben

Did the file open correctly in the browser when you dragged it from the file manager?

Best wishes

Jeremy.

[Stephen Kimmel]

I've been playing with this some and I find this combination works on my Windows 7 machine. Nothing I tried with the users directories worked... presumably because of something that Windows does.

<a href="file:///c:/backup/daily.xls">View xls</a>

This causes a small window to pop up which tells me that "You have chosen to open: daily.xls which is: Microsoft Office Excel 97-2003 from c:/backup." and asks if I want to open it with Microsoft Office Excel.

I believe that is what you want.

[Ben John]

Hi Jeremy

yes it did

Ben