Normal Topic RunExportSpec from remote connection (Read 1172 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
RunExportSpec from remote connection
Oct 22nd, 2010 at 6:39pm
Print Post Print Post  
A remote user needs to run an export and save the data to his computer, not the server. RunExportSpec() says a relative or absolute path can be used. Can I get an example of a 'path' to the remote users C:\temp folder?

Thank you,

Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: RunExportSpec from remote connection
Reply #1 - Oct 22nd, 2010 at 7:11pm
Print Post Print Post  
Given that it's very unlikely that you have (or want) a drive on the remote machine shared in such a way that the server can see it, you probably need to export to a directory on the server that is visible to the remote client and then transfer the file.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: RunExportSpec from remote connection
Reply #2 - Oct 23rd, 2010 at 11:04pm
Print Post Print Post  
Thanks Erika. I'll look into another method of getting the exported data to the remote user's computer.

Steve
  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: RunExportSpec from remote connection
Reply #3 - Oct 24th, 2010 at 3:29am
Print Post Print Post  
Tip: WordMerge prints its data file to the remote machine. And so does FileOverwrite().
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: RunExportSpec from remote connection
Reply #4 - Oct 25th, 2010 at 2:25pm
Print Post Print Post  
Good to know. Thank you!
  
Back to top
IP Logged
 
Robert
Member
*
Offline



Posts: 35
Joined: May 7th, 2013
Re: RunExportSpec from remote connection
Reply #5 - Sep 16th, 2014 at 10:01pm
Print Post Print Post  
I know this is an old thread however I'm having this issue right now.  Users are all remote and running export gives them the hard drive of the server it's installed on instead of their own. 

The only way around it is to give them a mapped drive to the server?  They want to put the exported file into excel so they want a simple Export >> Excel.
  
Back to top
 
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: RunExportSpec from remote connection
Reply #6 - Sep 16th, 2014 at 10:56pm
Print Post Print Post  
I am sure an expert will eventually chime in, however in the mean time if you just want to get data into excel you could just run a quick report and then either use right click import to excel or cut and paste.

If you are looking for an sbasic solution, I may be way off base but maybe consider looking at the LocalCWD() command


LocalCWD(path as string)

LocalCWD sets the current working directory on the client. After use, it is recommended that you set the current working directory back to the original value.


var vCWD as String

     vCWD = @LocalCWD()      // Get current CWD
     WriteLn(vCWD)
     LocalCWD("c:\Windows")      // Change CWD
     WriteLn(@LocalCWD())
     LocalCWD(vCWD)            // Reset CWD to original value
     WriteLn(@LocalCWD())

Keep us posted on your progress!
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: RunExportSpec from remote connection
Reply #7 - Sep 17th, 2014 at 6:58pm
Print Post Print Post  
The QuickReport method is a good option for this. When you run the QuickReport, choose the HTML Preview option. You can then copy the URL from the browser and open the file in Excel.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged