vtiger

nango · Joined: 27 Mar 2006 Posts: 6

Hello,

Based on the rtf merge and the dynamic creation of .odt files I wrote an extension for merging open office documents in vtiger.

Open Office documents are ziped xml files, so you only have to unzip it, merge the data an zip it again. For now, the merge is only working in the contact module. Besides the odt merge I have also included the rtf merge mentioned above.

It works fine on my linux system, which is build on 6765 svn. The php version is 5.1.4, apache is 2.0.55 and mysql 5.0.21.

Anyway, as I tested it on the pre-beta version on my windows xp system, I got only a hacking attempt message.

The fields in the template have the following form: CONTACT_FIRSTNAME

Attached is the Merge.php (copy to modules/Contacts), the class for zipping files (test/wordtemplatedownload) and two samplemerge files, for Open Office and rtf merge.

Nico

mmbrich · Joined: 24 Sep 2005 Posts: 428 Location: Colorado USA

Thanks nico, this was on my list of things to do for 5.1, I'll move this into trunk when I get some time.

Matt

nango · Joined: 27 Mar 2006 Posts: 6

Thanks for doing so. Did you test it yourself or and if, does it working on you system?

Nico

nango · Joined: 27 Mar 2006 Posts: 6

Hello again,

I've worked on the Accounting merge and did some minor changes to the Contacts Merge.

If anybody tested it, I would be glad to get some feedback.

Nico

mmbrich · Joined: 24 Sep 2005 Posts: 428 Location: Colorado USA

I haven't had any chance to test or merge this yet. I am planning to get into my 5.x work very shortly. In the mean time, feel free to post this to the list, someone with more time on their hands may want to help get this merged in as well.

Thanks again for your contribution, come join us on the mailing list!

Matt

Joe e-CAP · Joined: 02 Feb 2006 Posts: 68 Location: Minnesota

If this will work on 4.2.3 I will help test, but would this take away my already working rtf merge for office? Which i love exceppt for the file size's
of rtf's with images.

nango · Joined: 27 Mar 2006 Posts: 6

@ Matt

Thanks for the tip, I'll post it on the developer list, if I have some time.

@ Joe

I doubt that this will work on 4.2.3 because of the different database setups of both versions. This Merge includes both, the rtf merge - customized for version 5.0 - and the open office merge. Its not that hard to change the files, so that they can be used for version 4.2.3, but I'll look next for the leads and helpdesk modules.

Nico

nango · Joined: 27 Mar 2006 Posts: 6

latest update for the contact and the account module. Did only some minor changes - cleared out the code.

Nico

mmbrich · Joined: 24 Sep 2005 Posts: 428 Location: Colorado USA

Commited to branches/VTIGERCRM-5.0.2-MMBRICH in revision 7877.

This is my personal branch, I haven't had a chance to test the feature out yet but anyone is welcome to play around with this branch and report issues back to me.

Thanks again for this contribution!

Matt

M00ser · Joined: 07 May 2006 Posts: 11

Hello Nico,

I have read your thread of wide interests. I want to test your merge scripts but I have some problems to find documentation to the “pperkmann_43f083f578913.zip”. Can you please post where I found a manual for this files.
Another problem is I don’t know where to copy the files.

Thanks
M00ser