Create one binary from x files

(0) Share

Report

Posted on by RadekM

174

Hi,

I would like to create one binary value for multiple PDF's.

Like below sample I get a docuref and send it binary into SQL.

How can I expand it so I get one binary with multiple PDF's inside?

pslip = conIns(pslip,packingSlipCounter   1,inventTrans.PackingSlipId);
            datephys = conIns(datephys,packingSlipCounter   1,inventTrans.DatePhysical);
            refid = conIns(refid,packingSlipCounter   1,inventTransOrigin.ReferenceId);

for(int i = 1; i <=conLen(pslip); i  )
            {
                custPackingSlipJour = CustPackingSlipJour::findFromCustPackingSlipTrans(conPeek(refid, i), conPeek(pslip, i), conPeek(datephys, i));
                select docuRef
                where docuRef.RefCompanyId == custPackingSlipJour.DataAreaId &&
                      docuRef.RefTableId == custPackingSlipJour.TableId &&
                      docuRef.RefRecId == custPackingSlipJour.RecId &&
                      docuRef.TypeId == begaParameters.DocuTypeId;

if (docuRef)
                {
                    System.IO.Stream stream = DocumentManagement::getAttachmentStream(docuRef);
                    cmrFile = filePath   docuRef.originalFileName();
                    System.IO.FileStream fileStream = new System.IO.FileStream(cmrFile, System.IO.FileMode::Create, System.IO.FileAccess::ReadWrite);
                    stream.CopyTo(fileStream);
                    fileStream.Close();
                }
                
                ////
                ////

strfmt(",(sele///ct * FROM Openro/wset( Bulk '%1', Single_Blob) as CmrImage)",cmrFile)

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi RadekM,

You can't just combine binaries to get one file. You need to use an external tool like PdfSharp to combine several pdf files to one.

www.pdfsharp.net/.../ConcatenateDocuments-sample.ashx

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

Okay so it's not possible to make this in X++ code.

I wasn't sure if I can hide under one binary 2 or more files.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi RadekM,

PdfSharp is .net library and it's included in F&O (probably from 10.0.12 or 10.0.13). You can use it in x++ as well.

There is an old post about merging, you can try to copy-paste x++ code to check if it's working in F&O dynamicsaxgyan.wordpress.com/.../

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

Cant find a library like this in AOT. Its propable different here and the code don't work it shows errors at first lines already.

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi RadekM,

Which F&O version are you using?

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi RadekM,

Just mentioned that PDFSharp was brought to my environment by another ISV solution. So if you don't have it in your environment you can download the package from www.nuget.org/.../ , extract dll from it and add it as a reference in your project.

Was this reply helpful? Yes No
RadekM 174 on at

Like (0)

Report
Copy link

Link copied!

Im using 10.0.12 u36

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi RadekM,

In this case, you need to add a reference to pdfSharp dll (check the previous comment).

Was this reply helpful? Yes No