Normal Topic Loading Word Merge file from server? (Read 1153 times)
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Loading Word Merge file from server?
Sep 2nd, 2006 at 5:19pm
Print Post Print Post  
Is it possible to load the word-file from the server rather than the client?
I have an application with clients acessing via WAN. To keep merge files updated it is currently necessary to send them out via mail to each user and ask them to copy them into the respective directory.
I would rather only have one source, say on the server, where these files are either used from or downloaded automatically onto the client.
Any chance?

-- Carsten
  

Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Loading Word Merge file from server?
Reply #1 - Sep 2nd, 2006 at 5:32pm
Print Post Print Post  
This is more of an operating system question than it is a purely Sesame question. The problem is the MSWord is not client / server, it runs entirely on one machine. It can get its files from a file server using shared hard drives or by using a netpath (or NFS), but the program itself has to run on the client machines's CPU. That means that the word file has to be transfered to that machine some way or another. So you could open up your server - share its hard drives with your client computers. Unfortunately, that is not really advisible for security reasons.

The only way to make it work that is reasonable secure is to run MSWord on the server, instead of on the client. This can be done if you can find a way to invoke it from the client computer, export its display to the client computer, and cause its printed output to be generated on the client computer's printer. MS does not really setup their OSs to work this way. It would probably take some fairly kludgy utilities to accomplish all of that, and probably wouldn't be very secure.

Unix (Linux) does allow applications to be invoked across the net. It allows the export of displays across the net, and it allows printing through the net. Unfortunately, MSWord doesn't run very well on Linux and you would probably need to have Linux on both the clients and the server.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Re: Loading Word Merge file from server?
Reply #2 - Sep 2nd, 2006 at 5:40pm
Print Post Print Post  
Hi Mark,

thanks for the reply. I agree that opening the server and sharing directories across the internet is not advisable, especially not with buggy MS-SW. Angry

Unfortunately I am bound to MS for several reasons (else it would have long ago vanished from my premesis!).

Is there any way that I could distribute the files with the help of Sesame? I am thinking about some sort of update button that would do the job.

-- Carsten
  

Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Loading Word Merge file from server?
Reply #3 - Sep 2nd, 2006 at 5:47pm
Print Post Print Post  
Not with Sesame 1.x.x alone. The only "file" transfer we do is for images in reports. But you can probably use the @Shell command (or @ASynchShell) to use the FTP command to transfer the file. You will need to setup a FTP server on the computer that is "hosting" the MSWord documents and move the documents to a secured directory that that FTP server can access. You can then script the FTP clients on your client machines to automatically log in and download the appropriate files.

You may also consider using one of the several NFS servers that are available for Windows. I'm not sure if they are any good. I use NFS on Linux and it has its advantages, but is not the most secure option.

Sesame 2.0 has file transfer commands built in, including one based on the FTP protocol. So you may want to keep doing as you are doing and upgrade when the time comes.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Loading Word Merge file from server?
Reply #4 - Sep 2nd, 2006 at 6:08pm
Print Post Print Post  
I haven't thought about this in depth yet, but I did have a quick thought ...

Couldn't you use @Shell with Copy command to copy from Server to local drives?

Click button to run merge:
1.  @Shell to Copy Word document from server to local machine
2.  Run normal Merge code

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Loading Word Merge file from server?
Reply #5 - Sep 2nd, 2006 at 6:28pm
Print Post Print Post  
Bob_Hansen wrote on Sep 2nd, 2006 at 6:08pm:
I haven't thought about this in depth yet, but I did have a quick thought ...

Couldn't you use @Shell with Copy command to copy from Server to local drives?

Click button to run merge:
1.  @Shell to Copy Word document from server to local machine
2.  Run normal Merge code



The problem with that is security. He would have to share the hard drive on the server through the network, and in his case that network is at least partially the internet. Windows is not much for security and there is no realistic way to secure a shared server using MS file sharing software through the internet. Additionally he would have to open that server's ports through his firewall, for some very "broad" access. The port sniffers would get him in a matter of days.

Using a secure ftp server, he would have to open two ports through his firewall (for FTP to get through, one command port, on data port), but because there is security on the FTP server and the FTP server can limit access to specific files and directories, and can curtail password guessing schemes, he would be more secure than with any of MS's built ins.

He will need to find a secure FTP server though. The one that comes with MS server software isn't very tight. But even it is much more secure  than MS file sharing.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Re: Loading Word Merge file from server?
Reply #6 - Sep 2nd, 2006 at 6:49pm
Print Post Print Post  
I will probably wait for Sesame 2.0 and live with the limitation until then. Any guess when it will be available?
  

Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Loading Word Merge file from server?
Reply #7 - Sep 2nd, 2006 at 6:49pm
Print Post Print Post  
Quote:
and in his case that network is at least partially the internet


Actually, I assumed that because he mentioned in a different thread that he is using 2M DSL. I suppose he might be using VPN or event a dedicated network, in which case - yes, just use a file copy.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Loading Word Merge file from server?
Reply #8 - Sep 2nd, 2006 at 6:52pm
Print Post Print Post  
carsten wrote on Sep 2nd, 2006 at 6:49pm:
I will probably wait for Sesame 2.0 and live with the limitation until then. Any guess when it will be available?


Yup. I have quite a few guesses. But its not really up to me.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged