1. Sivaprakash BKR
  2. PowerBuilder
  3. Monday, 6 December 2021 04:58 AM UTC

Hello,

PB 23019 R3, PostgreSQL 11

Need to add mail merge facility in our application.  What will be the best approach given the environment.

1.  End-Users create/edit documents for future mail-merge. [Rich Text is preferred]
2.  Store the documents created above in a database table.
3.  Created documents contains columns that will be replaced at runtime (Name, address etc.)
4.  After mail merge, final document (also modifiable by end user) to be saved in a database column.
5.  Images could be added in the document at any point.

Would like to know whether to go with
1.  Built-in TX Text Control ActiveX 28
2.  Built-in TX Text Control ActiveX 15
3.  New Web Browser control    [ Not sure whether it suits for this nor not ]
4.  Others, if any and better

Should work with future version(s) of PB also.

Happiness Always
BKR Sivaprakash

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 6 December 2021 15:28 PM UTC
  2. PowerBuilder
  3. # 1

Hi BKR;

   FWIW: The mail merge feature is great long time feature of the RTF DataWindow. Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 6 December 2021 11:34 AM UTC
  2. PowerBuilder
  3. # 2

The txt v15 stopped working correctly for us somewhere along pb2017 -> pb2019 R3. So we're forced to use v28.0. (we got misformed contents when inserting a document which we previously had saved as html. (which is what you need to be able to send as email).

V 28.0 has difficulties with certain images when you paste them. Depending on from where you paste them (snipping tool, sketch, paint.exe, etc.) it might work or not. You will also get a link in the saved html to a temporary image that doesn't exist. Reported as bug https://www.appeon.com/standardsupport/search/view?id=5954

My strong advice is to stay away from the RTE control. Use an html editor like TinyMCE. See https://community.appeon.com/index.php/qna/q-a/pb-2019-r3-web-browser-control-event-handling#reply-27432 with an example app here: https://community.appeon.com/index.php/qna/q-a?controller=attachment&task=download&tmpl=component&id=1317

If you do a search on TinyMCE on this Q&A, you'll find multiple posts about RTE and TinyMCE

As a matter of fact, this week, I'm once again going to try and replace the RTE with the html editor. The only problem I'm afraid I might have, is that the new webbrowser control is still a bit buggy and there are several tickets open. (especially when OLE objects are on the same window as the webbrowser control, things might go south).

regards and good luck!

MiguelL

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 6 December 2021 06:13 AM UTC
  2. PowerBuilder
  3. # 3

If you do decide to use TX TextControl, definitely use version 28 instead of 15 if you want to future-proof your project... well as much as anything in tech can be future proof.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.