Ticket #128 (accepted enhancement)

Opened 9 years ago

Last modified 8 years ago

Opening files with File Open common dialog

Reported by: cole.petersburg@gmail.com Owned by: alamaison
Priority: minor (e.g. uncommon, cosmetic, has workaround) Milestone: 2.0 Extra features
Component: frontend Version:
Keywords: Cc:


Your program is extremely cool, but there's something extra-cool I would like it to do. I'm downloading what I believe to be MS database files (in disguise) from a server and then loading parts of that database into Excel using an Excel macro. I can see the files in my Swish folder, and I can double-click them from Windows Explorer, but unfortunately that doesn't get the data into Excel. I can even see the Swish folder (including the subfolder I'm interested in, plus subfolders of that) through the Excel macro's dialog boxes. Unfortunately, the macro cannot see a single file in the subfolder. I tried to force the issue by copying and pasting the file name into the dialog box, but that got translated into ::{20D04...}::\{B816A... and it won't actually load the data.

Will the next update allow the level of access I'm looking for? I imagine the file would have to be cached before it's loaded since it's on a different machine, but it would be "nothing but net" from a user's perspective.


swish-almost-works.png Download (137.8 KB) - added by anonymous 9 years ago.
Screenshot of Excel macro

Change History

Changed 9 years ago by anonymous

Screenshot of Excel macro

comment:1 Changed 9 years ago by alamaison

This is an interesting scenario you've described.

I would like Swish to be able to do something like this but it doesn't look likely in the near future. Swish is an Explorer namespace extension which means its view of files and folders only exist in Explorer's 'mind'. Excel is expecting a real path to a filename which means it needs a true SFTP filesystem driver. Something like Dokan SSHFS might do what you are after.

As for Swish, I hope to have double-click opening of files working in the couple of releases time. This still isn't quite what you are after. It will just copy the remote file to a local temporary directory and then open that. I've heard that there might be a way to trick the File Open dialogues into using the local temporary path but that is a challenge for the future.

comment:2 Changed 8 years ago by alamaison

  • Milestone set to 2.0 Extra features

comment:3 Changed 8 years ago by alamaison

  • Status changed from new to accepted

comment:4 Changed 8 years ago by alamaison

  • Summary changed from Opening files with Excel macro to Opening files with File Open common dialog

comment:5 Changed 8 years ago by alamaison

* Ticket #211 marked duplicate of this one *

Note: See TracTickets for help on using tickets.