CoreBOSBB
Template to Mail Merge - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forum-17.html)
+--- Forum: User Support (https://discussions.corebos.org/forum-6.html)
+--- Thread: Template to Mail Merge (/thread-574.html)

Pages: 1 2


Template to Mail Merge - LorenzoGreco - 02-21-2017

I was unable to use Template to mail merge, in contact modules,
I tried with rtf, (made with wordpad) .doc (microsoft)
but i've always a fatal error
Fatal error: Call to a member function FetchRow() on boolean in /home/xxxxxxxx/public_html/vt_test/include/database/PearDatabase.php on line 618
I'm using php 5.6 but i've tried also with 7 and 5.5 without UUID, opcache enabled
any ideas?
Lorenzo


RE: Template to Mail Merge - joebordes - 02-21-2017

well, that was interesting. I hadn't visited that part of the code in a while, specially after the massive update we have made for PHP7 and MYSQL support. I have cleaned and tested the files. I eliminated a bunch of warning message and fixed a couple of errors, mostly related to MySQL strict mode. It seems to be working correctly now for all four supported modules. Update you code when you can and give it a try.

Note: I have tried OpenOffice document and I am almost sure RTF will work. I truely doubt Microsoft will work because they used an ActiveX component which is most probably totally obsolete, but give it a shot and let us know how it goes.

Thanks!


RE: Template to Mail Merge - LorenzoGreco - 02-22-2017

git pull
Tried now also with a native ODT document
so made
NOME:  $contacts-firstname$ COGNOME: $contacts-lastname$
CITTA’ NASCITA: DATA NASCITA: $contacts-birthday

Fatal error: Call to a member function FetchRow() on boolean in /home/XXXXXXXX/public_html/vt_test/include/database/PearDatabase.php on line 621
whith php 5.6

P.S. I've custom fields in contact module


RE: Template to Mail Merge - joebordes - 02-22-2017

have you applied the changeset?


RE: Template to Mail Merge - joebordes - 02-22-2017

activate the debug log and show me the offending SQL


RE: Template to Mail Merge - LorenzoGreco - 02-22-2017

Yes i did corebos updater apply
i've sended you a private message with link for log


RE: Template to Mail Merge - joebordes - 02-22-2017

That did the trick (I hope). There was a missing condition in Contacts, Leads and Tickets.

Update your code and try again.

Let me know how it goes

https://github.com/tsolucio/corebos/commit/b291afc735678aa3ca0a1fef5cae4bbef8cad0dd


RE: Template to Mail Merge - LorenzoGreco - 02-22-2017

quite...
so now i arrive to Download merged document ( openoffice format)
I downloaded the file, but was
NOME: $contacts-firstname$ COGNOME: $contacts-lastname$
CITTA’ NASCITA: DATA NASCITA: $contacts-birthday

doesn't merge the field.


RE: Template to Mail Merge - joebordes - 02-22-2017

I think the capitalization is important. See the example here:

https://github.com/tsolucio/corebos/tree/master/build/oo-merge


RE: Template to Mail Merge - LorenzoGreco - 02-22-2017

I tried directly uploading the sample file.
and it works!
thanks a lot
Lorenzo