Debenu Quick PDF Library - UDF

[maniootek]

1 hour ago, mLipok said:

@maniootek How do you deal with QPDF?

It's ok. I can read pdf and make add text on existing ones. Anyway, my project is not finished yet, too busy with other stuff. Will go back later

Thanks

[maniootek]

There's no function to merge files from specified directory for commercial license users?

Merge functions I found in QuickPdf.au3

_QPDF_MergeFiles (only for commercial version)

_QPDF_MergeFiles_Lite (only for lite version)

why lite version are restricted to be used only with lite version? shouldn't be option to use lite version on commercial users?

I would change this line (from _QPDF_MergeFiles_Lite):

If _QPDF_CreateObjectAndUnlock($oQP) = $QPDF_RET_VALID_LITE Then

to this:

Local $Result = _QPDF_CreateObjectAndUnlock($oQP)
    if $Result = $QPDF_RET_VALID_LITE or $Result = $QPDF_RET_VALID_COMMERCIAL then

 

Edited December 23, 2021 by maniootek

[mLipok]

50 minutes ago, maniootek said:

_QPDF_MergeFiles_Lite (only for lite version)

not only.
_Lite() suffix is to show that this can be used with lite version

Yes it should be changed.

Edited December 23, 2021 by mLipok

[maniootek]

Have you consider add PageScaling parameter to _QPDF_PrintPDFFile() function? For me this is key feautre.

I am also wondering why _QPDF_PrintPDFFile() function uses default printer name when you pass to the PrinterName parameter name of printer which does not exists. I think function should return error in that case.

Edited October 1, 2022 by maniootek

[Skysnake]

 2019/10/11
    v0.10

    QuickPDF.au3

@mLipok I am still using the free DLL 11.14.  I see 11.15, and 17 were released, but I cannot get to a download link on the Foxit website. https://developers.foxit.com/

I have tried to run v.10 (downloaded 10 minute ago).

The Examples file appears to be missing an Include file ? 

See line 46 $__sLicenseKey_QPDF

Line 377 _QPDF_LastErrorCode($oQP)

Line 659 _QPDF_SaveToFile_Lite($oQP, $sPDF_FileFullPath)

 

I am still running on v.09 and it works like magic

Skysnake

 

 

[mLipok]

6 hours ago, Skysnake said:

 I am still using the free DLL 11.14. 

this is the last free released version.

[Skysnake]

16 hours ago, mLipok said:

this is the last free released version.

Thanks

However, I need some advice. 

I routinely generate reports in PDF format. Steps are basically

1. Create oPDF

2. Add standard info (headings, labels etc)

3. Add custom info

4. Write PDF to disk

This is slow. Takes 10-15s for each PDF.

Making 400 PDFs this can take up to 60-90 minutes.

I am looking to make this process faster. I am not sure where to start, but I suspect if I could make a master PDF and then copy/clone that for future use, I can eliminate the process repeatedly of loading standard info. The result should be less disk read and faster PDF creation.

Easiest way to duplicate an oPDF? 

What options exist to loop throught this process faster?

Skysnake

 

Edited December 14, 2022 by Skysnake

[mLipok]

3 hours ago, Skysnake said:

I routinely generate reports in PDF format. Steps are basically

1. Create oPDF

2. Add standard info (headings, labels etc)

3. Add custom info

4. Write PDF to disk

This is slow. Takes 10-15s for each PDF.

Did you measure how many time script spents for each steps ?

[Skysnake]

Thank you.

Delay is NOT the PDF. Multiple SQL selects cause the delay. I need to find a smarter/faster way to get custom data.

😞

[mLipok]

21 minutes ago, Skysnake said:

Multiple SQL selects cause the delay

What kind of data you are getting ? Are they binary data aka blob ? What kind of DB you have ? Is the DB server distant or local ? What kind of network you have ? Did you measure your select statement time ? Did you do query execution plany ? Maybe there is lack of indexes ?
 

[Skysnake]

The custom data uses twelve separate SQL SELECTS. Each takes approximately 0.5 sconds to return. This causes a six second delay. Compound this with some bad script design and it causes a major delay.

I have reduced all SQL SELECTS into a single query, and split the array into variables. PDF creation time is now between 2-4 seconds each.

 

Edited December 15, 2022 by Skysnake

[Skysnake]

PDF SDK for Windows 9.0 Release Highlights

·         PDF Conversion SDK is now available as an add-on

·         Multi-platform App UI (MAUI) project now available

·         Support for mixed raster content (MRC), a technique for compressing image objects

PDF SDK 9.0 Release Page

[mLipok]

31 minutes ago, Skysnake said:

PDF SDK for Windows 9.0 Release Highlights

·         PDF Conversion SDK is now available as an add-on

·         Multi-platform App UI (MAUI) project now available

·         Support for mixed raster content (MRC), a technique for compressing image objects

PDF SDK 9.0 Release Page

You must to know that this is not the same product.

And the one you have linked is much more expensive.

[Skysnake]

Is Debenu discontinued? I rely heavily on that DLL

[mLipok]

2 hours ago, Skysnake said:

Is Debenu discontinued? I rely heavily on that DLL

Yep. Me too. Do not worry. It will work many years.

Edited March 18, 2023 by mLipok

[Skysnake]

Czesc Michal @mLipok

I need some advice.

$c2 = StringReplace($c2, "Znak", "Click to open http://www.server.com/online/sample.pdf Znak")

This works. And the link is active.

But this is ugly.

I am looking for a way to embed that hyperlink under some user friendly text. Like an HTML hyperlink.

More like this

<a href="https://www.w3schools.com/">Visit W3Schools.com!</a>

Problem is that this hyperlink and it's position is dynamic. So I cannot preset the location. Best idea so far is to count lines, then write the hyperlink to the text location.  ugly. bad. 

Like this. 

        ; Add a URL Link
        _QPDF_AddLinkToWeb_Lite($oQP, 15, 65, 100, 20, 'http://www.autoitscript.com/forum/') ; the actual hyperlink
        _QPDF_DrawText_Lite($oQP, 25, 75, 'http://www.autoitscript.com/forum/') ; text only (but hyperlink recognized)

So have a function that combines the user text with the actual HTTP hyperlink just like HTML

For clarity, when the text is written, the position is not predetermined, it goes into an array. The Array gets written to the PDF. There could be multiple links in the array. I need the actual hyperlink to correspond with its text.

Do I make sense?

Skysnake

 

Edited October 5 by Skysnake

[mLipok]

Uisng both functions:

_QPDF_AddLinkToWeb_Lite($oQP, 15, 65, 100, 20, 'http://www.autoitscript.com/forum/') ; the actual hyperlink
        _QPDF_DrawText_Lite($oQP, 25, 75, 'http://www.autoitscript.com/forum/') ; text only (but hyperlink recognized)

you know location .

Why you just not use the same Left, Top coordinates ?