+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: User Support (https://discussions.corebos.org/forumdisplay.php?fid=6)
+--- Thread: Template to Mail Merge (/showthread.php?tid=574)
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