Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 9 Service app
Message
From
10/05/2021 10:03:46
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01680208
Message ID:
01680277
Views:
74
Dmitry

TSPlus works fantastically well and with zero changes to your VFP app except ... the only exception we found was this; our apps often integrate with MS Office using office automation to create XLS or DOC files on the user's computer. This cannot work over TSPlus because your app is running on the server and the MSOffice is installed on the user's computer. Problem!

The solution is to create the XLS file on the server (using VFP and/or tools that create XLS files) and then store the XLS file to a local folder inside the TSPlus web folder, then create a URL to that XLS file, then tell the TSPlus to open the URL on the client side. What happens is that the URL is sent by TSPlus to the client to open and then the client's browser opens the URL which then downloads the XLS file from the server/TSPlus webs folder. Problem solved.

The above requires two things (1) the above code changes, and (2) a clean-up routine to regularly clean-up these XLS/DOC files which your app might create once the user has downloaded them. We just delete any file which has not been accessed for 1 hour. This is an arbitrary timeout since the user will have accessed the file immediately when the URL got redirected to him. It is just a time delay to use in our clean-up routines.

Of course, this is only necessary if your app integrates with MS Office using automation.

Another thing to be aware of; printing in TSPlus. How is this done since the app running on the server has no direct access to the printer connected to the user's computer? This is done by TSPlus capturing the print request (which is done on the server remember) and creating a PDF file of the report on the server. The PDF file is then sent to the user's computer for processing / printing by the TSPlus program on the client end. it is very seamless and very slick but you need to be aware that the report is not printed by VFP to a printer directly but rather to a PDF file which is then printed.





>Good evening Denis,
>
>Thank you for your encouragement. And thank for offering to help. I appreciate it!
>
>>Hello Dmitry,
>>
>>It is very easy to use and 0 change needed to the VFP application,.
>>
>>Their videos are very clear. Jus try the demo. If you have a question I'll be happy to help as much as I can.
>>
>>Regards.
>>
>>>>
>>>>I already use TSPlus and now I see that I could probnably use that AlwaysUp for my personal needs but also suggest it to the I.T. director where I work. Who knows in what situation we would need that tool.
>>>>
>>>
>>>I am jealous. I lose a lot of business because prospective customers do not want to deal with hardware (building VM, etc). TSPlus would be perfect; I just keep putting of leaning it :(
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform