Hi Marty,

If you are installing the CDE component in this server instead Libreoffice is because your RHEL server is not a virtualised server (remember the 453 case). Is it MMR working well in this installation?, i mean, you can generate DOC documents correctly, can you?

Please review that the CDE directory has the correct permissions in order the Apache server can access to the cde files.

Regards,

Anabel

ARGGHHH apologies for that post, I thought our network guys had migrated to a non-virtual setup, wrong. My bad. So, to implement the PDF functionality we should install Libre Office to the virtual server and I should configure the LibreOffice working directory to point to the installation directory, yes?

Thanks for your time and patience, apols for the mixup

Hey Anabel, read your documentation, option 1 entered the following path in the LibreOffice exe/binary path /usr/lib64/libreoffice/program/soffice

Confirmed that the following generated the Generate PDF button, attempted to create, results were blank PDFs.. tested the Word document generation and it worked perfectly. Checked my server logs and found the following:

Jan 14 13:46:43 caster httpd: PHP Warning: filesize(): stat failed for /data/web-data/sugar-production/document_templates/GEN-2e5bbc83-9e1e-b96c-e15f-56971a5a0e52.pdf in /data/web-data/sugar-production/modules/DHA_PlantillasDocumentos/Generate_Document.php on line 586 Jan 14 13:46:43 caster httpd: PHP Warning: readfile(/data/web-data/sugar-production/document_templates/GEN-2e5bbc83-9e1e-b96c-e15f-56971a5a0e52.pdf): failed to open stream: No such file or directory in /data/web-data/sugar-production/modules/DHA_PlantillasDocumentos/G

I checked the data/web-data/document_templates folder, it exists and has 755 rights for the apache owner and group

Thanks for any help you can give me

Hey Anabel, did the headless installation and still getting blank PDF's. We have tested the installation from the command line and it DOES convert DOCX/ODT files etc to PDF, however, does NOT from the Generate PDF button

We get the following errors:

Jan 19 09:57:42 caster httpd: PHP Warning: filesize(): stat failed for /data/web-data/sugar-production/document_templates/GEN-5e6c6df9-bf3e-9692-94cd-569d7b145716.pdf in /data/web-data/sugar-production/modules/DHA_PlantillasDocumentos/Generate_Document.php on line 586 Jan 19 09:57:42 caster httpd: PHP Warning: readfile(/data/web-data/sugar-production/document_templates/GEN-5e6c6df9-bf3e-9692-94cd-569d7b145716.pdf): failed to open stream: No such file or directory in /data/web-data/sugar-production/modules/DHA_PlantillasDocumentos/G

The pdf document specified is definitely NOT in the documents template folder...

My working directory is /tmp CDE path is EMPTY binary/exe path is /usr/lib64/libreoffice/program/soffice

Cheers

Hi Rob,

We think that you have some permission problems in your system.... or you have the "exec" function inactive ¿?

Please, download the zip TestPDF.zip from the next link: http://we.tl/Vf2HAE6ROO (it is a "wetransfer.com" link). That zip has to files: testPDF.php and testPDF.docx

You must to copy that 2 files into the root directory of SugarCRM (where the config.php file is), then you must to run the testPDF.php file. To run the file, if your URL is, by example, http://url-instalation.com, you have to run http://url-instalation.com/testPDF.php

This script will create a file called testPDF.pdf in the root directory of your instalation, and you will see in the screen the LibreOffice output.

If the testPDF.pdf file is not created, please send us the LibreOffice output.

Regards,

Anabel

UPDATE: got rid of the permissions error, still have the Document is empty error

:1: parser error : Document is empty

Hi Rob,

We think that you have problems with the mkstemp function.... but our plugin does not use this function.

Your system admin must review it... It seems that mkstemp function is trying to create a temp file in a directory without permission...

Please, look for solutions in google... by example look for: "mkstemp "--convert-to" Permission denied"

The temp dir that MMR plugin uses is defined into $sugar_config['DHA_templates_dir']: please, don't change this directory. If you want you can review the GenerarInforme function into the modules/DHA_PlantillasDocumentos/Generate_Document.php file.....

Regards,

Anabel

Hey Anabel, what ever the problem was, it has gone away!!!! PDF's are generating and they look great, one more question? One of the areas we are using your component is for PDF Invoices/Quotes. We'd like to be able to generate a more meaningful file name from the default GEN-[SugarID].pdf that is currently the case, is there a helper file or some other facility that will allow us to create a dynamic generated name based on underlying fields in the record?

Thanks for your time and patience

Hi, I've just tried to use the Attach to Email function and have been presented with the 'There is no action by that name' The name of the action is ComposeGeneratedDocumentEmail, i'm assuming it should be in a login hook or entrypoint somewhere? Could you tell me where the file that contains the function is located and where/how I can replace it?

Thanks for your time and patience

RE the above, sorted. Found the ComposeGeneratedDocumentEmail file and replaced in the custom/modules/Emails folder, all good now