EXPORT DOCUMENT - MERGE INTO ONE function

[Rennur]

You can DISPLAY DOCUMENT DocTemplate MERGE INTO ONE and it work fine.

Is anyone aware of how this can be achieved with using
EXPORT DOCUMENT DocTemplate TO FILE 'c:/myMergedDos.html' (MERGE INTO ONE).

Cheers

[kklosson]

I use PDF Toolkit to merge multiple pdf docs. It has a command line interface (in fact, that's all it has) so you just use the EXECUTE PROGRAM action to employ it.

[Rennur]

Thanks

What I have:
50 records of in a Dockets BO. I need to export a HTML report document (HTML Doc Template) of each record to a file.
This will mean I will have 50 separate Docket.html files.

What I need is, instead of 50 separate files, EXPORT HTML Document of each record into one html document i.e. MERGE INTO ONE.

This works: DISPLAY DOCUMENT 'Docket Template' FROM 'myQuery' MERGE INTO ONE IN WINDOW
This would be ideal: EXPORT DOCUMENT 'Docket Template' FROM 'myQuery' TO FILE 'myFile.html' MERGE INTO ONE

If PDF Toolkit deals with the already created PDFs and merges them into one, and I have them stored on file, can you please share the parameters to merge them into one?

Cheers

[kklosson]

In this example I have already exported all documents with specific names into a specified folder...

EXECUTE PROGRAM 'C:\Program Files (x86)\PDFTK\bin\pdftk.exe ' +
LoggedInInvestigator.MyPath + '\Cover.PDF ' +
LoggedInInvestigator.MyPath + '\Executive_Summary.PDF ' +
LoggedInInvestigator.MyPath + '\Narrative_Summary.PDF ' +
LoggedInInvestigator.MyPath + '\Contact_Checklist.PDF ' +
LoggedInInvestigator.MyPath + '\Contact_Report.PDF ' +
LoggedInInvestigator.MyPath + '\Concerns.PDF ' +
LoggedInInvestigator.MyPath + '\Personal_History_Statement.PDF ' +
LoggedInInvestigator.MyPath + '\Reference_Questionnaires.PDF ' +
LoggedInInvestigator.MyPath + '\Spouse_Questionnaires.PDF ' +
LoggedInInvestigator.MyPath + '\Employer_Questionnaires.PDF ' +
LoggedInInvestigator.MyPath + '\Landlord_Questionnaires.PDF ' +
LoggedInInvestigator.MyPath + '\Law_Enforcement_Agency_Questionnaires.PDF ' +
LoggedInInvestigator.MyPath + '\Interviews.PDF ' +
LoggedInInvestigator.MyPath + '\Exams.PDF ' +
LoggedInInvestigator.MyPath + '\Notes.PDF ' +
LoggedInInvestigator.MyPath + '\Supplemental_Forms.PDF ' +
LoggedInInvestigator.MyPath + '\Attached_Documents.PDF ' +
'CAT OUTPUT ' + LoggedInInvestigator.MyPath + '\' + REPLACE_PATTERN(PHS.Candidate.LastName,' ','_') + ',' + REPLACE_PATTERN(PHS.Candidate.FirstName,' ','_') + '_Final_Report.PDF'

[customaware]

I am using PDFCombineProx http://www.coolutils.com/PDFCombinePro
which allows you to combine basically anything you want into a single PDF. The X extension adds
the Command Line option which I call from Aware.

You can have any number of DOC, DOCX, RTF, TXT, XLS, XLSX, HTML, HTM, MHT, PS, EPS, PRN, PDF, TIFF, JPEG, PNG. files in a folder
and it will bundle up the whole lot into a single PDF.

I Create a Folder on the server named with a unique value of the LoggedInRegularUser, Export all the files to there and then run PDFCombineProX to
generate the PDF and then copy it back into Aware.

It has worked flawlessly.

Not free but worth every cent.

[kklosson]

I'm pretty sure that's the first tool I employed for this function and had to abandon it because the process kept hanging on the server. The process was called PDFCombineX or something. I thought this was a great tool but just kept having this issue. If it's the one I remember...

[JoshK131]

I've found LibreOffice to convert word docs to pdf.
It has command line function, all open source.

7pdf had issues with word doc formatting, table of contents and bullet points.