Word report

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
mekin
Veteran Member
Posts: 40
Joined: 2019-04-22 17:09

Word report

Post by mekin » 2019-07-17 11:04

Hello, does anyone know a great way to import MYSQL data into Word-templates.
If I use mailmerge, then I cannot choose the records, it will merge all records of the selected table.

Or are there users who use other apps to generate/fill Word-templates/reports in a user-friendly-way.

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Word report

Post by pbottcher » 2019-07-17 11:09

Hi,

you can have a look at https://github.com/PHPOffice/PHPWord
I use it in some projects and it works quite nicely.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

mekin
Veteran Member
Posts: 40
Joined: 2019-04-22 17:09

Re: Word report

Post by mekin » 2019-07-18 05:20

Thanks @pböttcher, I took a look at it and (finally) get it working on my webhosting.
It's not as easy as the Appgini-setup ;) and you must have PHP-knowledge to get it started and creating a document.

I was actually looking for something a bit more locally, like a Windows-GUI-application.
Where you can open a Word-template and like mail-merge, you can edit it.
Like I said, mail-merge would do the trick for me, but I didn't figured out how to dynamically add tables with records.

I found this, but also this is not easy to setup:
https://www.mrexcel.com/forum/general-e ... ables.html
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Are there other options?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Word report

Post by jsetzer » 2019-07-18 05:55

It's not free but easy to integrate with AppGini:

phpdocx
https://www.phpdocx.com

There is a free trial which is embedding some watermark into the generated documents.

Regards
Jan
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

mekin
Veteran Member
Posts: 40
Joined: 2019-04-22 17:09

Re: Word report

Post by mekin » 2019-07-18 09:26

Thanks @jsetzer, PHPDocX also needs some PHP-knowledge.
I found something else, are there here users that know this tool.
This is actually what I'm looking for, as I can see, it's user-friendly for my co-workers to create documents.

https://www.dox42.com/Solutions/Datasources/Database

Post Reply