Correspondence in Servoy

Classic Servoy
1

I need an advice how to write correspondence in Servoy.

Usually is a database not the best application to write letters. Formatting, placing images and page setup are a real pain.

In Filemaker we could call a Word template, fill it with data from FileMaker and save it externally with a link so we could open it, make changes all from our database.

I would like to do the same in Servoy, but then save it in a blob in stead. Is this possible? Or is there a better way?

2

yes, we do it with RTF and Servoy tags like this:

%%companyname%% which we replace.

with the Word plugin of IT2BE you can use native word-files also and merge them with your own data.

Hope this helps

3

It sounds like a job for a Google Docs mash-up. I do not think the complete interface for that is available yet, but the following will provide a deep link to Gmail or Gmail Compose:

//deep link to Gmail
var a = ‘https://www.google.com/accounts/ServiceLoginAuth?’;
var b = ‘Email=’;
var c = gmail_name;
var d = ‘&Passwd=’;
var e = gmail_password;
var f = ‘&continue=’;
var g = ‘http://mail.google.com/mail’;
var h = ‘https%3A%2F%2Fgmail%2Egoogle%2Ecom%2Fgmail%3Fview%3Dcm%26fs%3D1%26tf%3D1#compose’;
var i = ‘_self’;
application.showURL(a + b + c + d + e + f + g, i);
//to deep link to Gmail Compose (substitute h for g)

The above is not a complete solution, but it is a start.

To view an interesting youtube video entitled “What are mash-ups” see:
http://youtube.com/watch?v=U9sENSA_sjI

Google Docs link:
http://code.google.com/apis/documents/overview.html
Hopefully Docs will eventually become as easy as Google charts:
http://code.google.com/apis/chart/

Dean Westover
Choices Software, Inc.

4

Another option is the OLE Bean.

With the OLE Bean it is possible to place a Word instance on a Servoy form as if it is part of the Solution. More info: http://www.it2be.com/beans.htm#ole

5

Hi Marcel,

I had a look at the OLE Bean, to bad that it doesn’t work on a Mac. Do you have any plans for this in the future?

6

If/when possible the answer is three-fold yes (I am a mac user myself and we develop all Components on the Mac).

Unfortunately OLE is MS technology and not available for the Mac.

Based on the fact the now even VBA support is dropped for the latest Office 2008 I am not so sure that we will ever see OLE for Mac.

I think the Word Plug-in is going to be your second best.
We will work on support for OOXML this year as well…

7

IT2Be:
We will work on support for OOXML this year as well…

:loud applause:

kazar

8

If you don’t want to wait for that you could that yourself by using the XML-Plugin… :wink:

9

Nice are you people! First you show me heaven and then… :lol:

But seriously! I would like to store the documents in Servoy, not externally.
Every time the user makes changes to the document the new version should be stored in place of the old one.

Is al that possible with the Word Plugin?

10

The way to do this is open the document from Servoy, write a temp file, open that file, save the file and store the file in the database.

If I am correct this is the way the sample solution works.