Simple find and replace in 4D Write Pro.

2020-04-14 Thread Luc Devar via 4D_Tech
I am still using 4Dwrite and need to eventually convert to 4DwritePro but did not find the time to start this yet. I have a process on the server ( 64 bits) that send email containing a 4Dwrite document. Since I am on 64 bits. I cannot use any of the old 4D write command. So I am converting my

4D interface with Sharepoint

2020-03-04 Thread Luc Devar via 4D_Tech
I need to create an interface with Sharepoint. Right now, I am managing all the documents within 4D but the client would like to move this portion to Sharepoint. I will need to push and retrieved documents basically. Nothing more than that. Anyone has done something similar or maybe someone can

Looking for a MSI installer for 4D v17.4

2020-02-26 Thread Luc Devar via 4D_Tech
A large client is asking me for a MSI installer for 4D v17.4. Is this something I need to build or this exists somewhere ? Luc Devar ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https:

Old DDE tools plugins replace by an Oracle-SE bridge.

2020-01-19 Thread Luc Devar via 4D_Tech
Anyone has some good example of 4D using PLSQL. I found a v2004 old example that will certainly be helpful. Any example would be appreciated. I am starting learning OCI. So allis totally new for me. How would I send the statement below. I am using a PLSQL bridge that was created to replace DDE

Old DDE tools plugins replace by a Oracle-SE bridge.

2020-01-17 Thread Luc Devar via 4D_Tech
I need to call an enterprise service formally call DDE. They have built an Oracle SE bridge to replace the old plugins called ( DDE Tools) and I need to use it in order to extract information from an Oracle DB. I am not familiar with Oracle at all but this seems to be pretty straight forward.

Locking (restrict Editing) PDF document with 4D

2020-01-13 Thread Luc Devar via 4D_Tech
Oops… disregard my last request, just found that QPDF does it nicely. Luc Devar ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto

Locking (restrict Editing) PDF document with 4D

2020-01-13 Thread Luc Devar via 4D_Tech
I am creating different PDF documents via Rob Laveaux’s QPDF Plugin. I would like to restrict editing the document afterward. Is there a way to do that with 4D or any other plugin? I can always ask my client to open the PDF in Acrobat and hit save as with this option on. But this extra step that

Where is the 4D Write Hard hyphen ?

2019-12-07 Thread Luc Devar via 4D_Tech
Is there such a thing as hard hyphen in 4D write ? work with a city that is named: Saint-Bruno-de-Montarville. While printing 4D write documents, the client wants to have the city name always on the same line and never be broken into 2 lines. I can see under special character, unbreakable

Removing progress window while printing to PDF a 4D write documents.

2019-11-21 Thread Luc Devar via 4D_Tech
I am printing to PDF a 4D-Write document and need to remove the progress window. This is what I am doing: SET PRINT OPTION(Destination option;2;$Filename) OPEN PRINTING JOB MESSAGES OFF WR PRINT ($area;wr print values;1) MESSAGES ON CLOSE PRINTING JOB The p

Re: creating csv files

2019-11-06 Thread Luc Devar via 4D_Tech
Hi Chuck A single apostrophe ' before a number will force Excel to treat a number as text (including a default left align) Luc Devar ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https

Re: 4d write to write pro conversion

2019-09-03 Thread Luc Devar via 4D_Tech
I am curious to know the answer to your questions. I do have a product that uses 4D write extensively. The app build contracts and offers to tenders from a bank of clauses. At this point I do not feel it worth investing the time to convert as too many features seems to be missing. Reading a Wor

PDF Creator error

2019-08-29 Thread Luc Devar via 4D_Tech
UNABLE TO START PRINT JOB error using PDF Creator Driver. Using 4D v14 client/server on a Citrix environment. Sometime I got this error when trying to create a PDF via the Set Print Option (9;3;$filename). When this happens the user cannot print with 4D anymore as this seem to have “Stuck” PDF C

Re: Formulas with XLS Plugin

2019-08-29 Thread Luc Devar via 4D_Tech
Hi Peter, I am using Rob Laveau plugins called XL Plugin with great success. Pretty simple to use. For example, your formula would translate to this. $formula:="=("+xlSheetRowColumnToAddress ($sheet;$row;$col;$RowRelative;$ColRelative)+"+"+xlSheetRowColumnToAddress ($sheet;$row;$col;$RowRelati

Re: DocuSign and 4D

2019-07-10 Thread Luc Devar via 4D_Tech
QPDF Plugin by Rob Laveaux of Pluggers Software would definitely help you on this. I am using it with great success. Very good tool to edit PDF documents, adding fields, signature fields, actions, etc. Luc Devar > On Jul 10, 2019, at 16:57, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote:

WP EXPORT VARIABLE does not work Windows Server.

2019-06-21 Thread Luc Devar via 4D_Tech
4D Server V15.5 I am sending email created in a 4D writes zone that contains images and text. wpArea:=WP New([EMAIL_TEMPLATE]TEMPLATE_) ST SET OPTIONS(wpArea;ST Expressions display mode;ST Values) WP EXPORT VARIABLE(wpArea;$str;wk mime html) This worked fine on my Mac ( OSX.13.6), but fail on s

Problems with images on email create with WP Export Variable.

2019-06-17 Thread Luc Devar via 4D_Tech
I am sending email created in a 4D writes zone that contains images and text. I am using WP export Variable: wpArea:=WP New([EMAIL_TEMPLATE]TEMPLATE_) ST SET OPTIONS(wpArea;ST Expressions display mode;ST Values) WP EXPORT VARIABLE(wpArea;$str;wk mime html) This worked fine on my Mac ( OSX.13.6)

Conversion from v2003

2019-06-11 Thread Luc Devar via 4D_Tech
I have a client that still uses an old v2003 DB. They finally decided to upgrade to a more current version. I am doing a quick analysis to assets the amount of work that needs to be done. I can see the v2003 use old plugins that does not exist anymore. Most of them I can deal with but the plu

Re: Using iCal

2019-06-11 Thread Luc Devar via 4D_Tech
Hi James, You might want to look into this https://www.hmplugins.com/en/hmCal/Features-130.html . I use this plugin. Very power-full and can import/export in Ical format. I do not use that functionality. Luc Devar **

Re: Printing a PDF document from 4D

2019-03-19 Thread Luc Devar via 4D_Tech
Julio, I use QPDF plugin from Pluggers Software to do this kind of action and many more. Best tools out there to manage PDF documents from 4D. l...@lucdevar.com *

Re: Tracking Field Data Changes

2019-01-15 Thread Luc Devar via 4D_Tech
I will send you directly a little 4D library that does via a trigger. Setup is done via a preference table where you but the table number and field number. Very generic so you should be able to adapt it quickly. Luc Devar > On Jan 15, 2019, at 4:29 AM, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.c

Re: Thoughts and Suggestions ?

2018-10-02 Thread Luc Devar via 4D_Tech
Offline Data collection system I have in place such a system that does that via PDF enterable form. A Work Order is generated out of 4D creating multiple enterable PDF document saved into Drop Box shared directory. I am using a plugin from Pluggers software called QPDF. This tool allows me to

Re: 4D Write Pro WP feature request - need your support

2018-08-30 Thread Luc Devar via 4D_Tech
I certainly hope we can open/save .docx document with 4D Write Pro in a near future as this is mandatory for me also. I have an application install on several sites that write contracts from clauses stored in a 4D DB and I need to use 4D write and compatibility with MSWord is a must. Right now

Re: Web Area display PDF

2018-08-20 Thread Luc Devar via 4D_Tech
Jeffrey, If you do not mind, I will certainly use this in conjuncture with QPDF Plugins for one of my projects. A neat component I must say and it will add a nice touch to the application. Luc Devar > On Aug 20, 2018, at 8:30 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I

Importing contact list from Mail/outlook on OSX

2018-08-08 Thread Luc Devar via 4D_Tech
I have an email interface in my 4D application that I used to send email and would like to have access to the list of contact from mail and/or outlook on OSX dynamically. I can certainly run a background process on every x minutes to update a table in 4D. But ideally I do not want to store the