SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Review of PDF-eXPLODE


A Review of PDF-eXPLODE

Author
Message
Kathi Kellenberger
Kathi Kellenberger
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2469 Visits: 347
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/2850.asp

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Richard Gardner-291039
Richard Gardner-291039
SSC Eights!
SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)SSC Eights! (877 reputation)

Group: General Forum Members
Points: 877 Visits: 421

Hmmm... Not entirely clear on the email address, are you saying, for example, that you can run a report with outstanding invoices for (i.e.) 200 customers and insert their email address from your database into the report - giving you 200 invoices on 200 pages with an individual email address on each page?

If this is the case then fair enough, could be a useful product, if you can't do that then the email interface looks a little clunky....

Of course until it's tested with 200 invoices I wouldn't trust it not to fall over - documents and memory managment have never been the best of friends.....


Andy Warren
Andy Warren
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: Moderators
Points: 25271 Visits: 2746
Bursting is pretty common to advanced reporting systems (Cognos, Crystal), this seems interesting to move that to a more loosely coupled design.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Mark Fonseca
Mark Fonseca
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 9

Hello

I am the developer of PDF-eXPLODE in Australia. I was very surprised to find out recently that Kathi (who I was supporting along with the US Distributor while she was evaluating the product) was indeed a reviewer for SQLServercentral.

To answer your question:

"are you saying, for example, that you can run a report with outstanding invoices for (i.e.) 200 customers and insert their email address from your database into the report - giving you 200 invoices on 200 pages with an individual email address on each page? "

YES YES. Here is an extract from a Client who processed 3500 MS Access report pages - Yes you need upto 2 GB memory for this type of extensive run and YES it took a few business hours on one day, but please read on...

----------------------------------------------------------------------

fxBRIDGE®

TECHNOLOGIES

Mark Fonseca

3000AD Systems Pty LTD

10 Paul Ave

St Ives NSW 2075

Australia

Dear Mark,

Please accept this letter of recommendation for your product PDF-eXPLODE. fxBridge Technologies creates a comprehensive dealing platform for Forex & CFD options and spot trading. In supporting our clients, we create thousands of statements for their customer accounts.

When we decided to archive each statement as an individual file, we were facing thousands of dollars in potential programming effort. By using your software, we were able to eliminate having to tie up valuable programmer resources. One person from our administrative staff was able to get the job done in one day. We consider the savings from using your software far exceeding the price.

Thank you again for your product.

Sincerely,

James N. Friedman

Director of Marketing

----------------------------------------------------------------------

Business Objects have done a Case Study of PDF-eXPLODE in use at one Client site and you can read that here: diamond.businessobjects.com/system/files/cr_case_study_pdf_explode.pdf

Please feel free to view more FAQs that add to the Help files by clicking here:

http://www.pdf-explode.net/question.html

Thank you

Mark Fonseca

3000AD SYSTEMS, AUSTRALIA


Liam Gavin-382521
Liam Gavin-382521
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 153
Hi Kathi\Mark,

I have numerous SSIS packages that loop through a distribution list populating Excel reports and sending each file directly to clients. Would it be possible to use this product to convert the Excel file into a PDF and then send this file to the client within the SSIS package? Or do you know if there is another way of doing this using SSIS?

Thanks in advance.
Liam
Kathi Kellenberger
Kathi Kellenberger
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2469 Visits: 347
Liam,

You should probably contact the company directly. I think the question would be can this product be run from a command line so that it can be automated. It has been a while since I reviewed it, so I am not sure.

Kathi

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Virgil Trasca
Virgil Trasca
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 36
Hi,

I found a program which is doing report bursting and it delivers the bursted documents through email and/or ftp. The tool is called DocumentBurster (www.pdfburst.com) and it is free for using. It can burst reports generated with any popular report generator like Bussiness Objets or JasperReports and it can be used on Windows and Unix systems.

Thank you,
Virgil
Rob Hershfield
Rob Hershfield
SSC Journeyman
SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)SSC Journeyman (92 reputation)

Group: General Forum Members
Points: 92 Visits: 86
Hi Liam,

I have a client (prestigious Venture Capital firm) using PDF-eXPLODE to send Excel-based portfolio valuation reports. Each worksheet (tab) contains a different portfolio destined for a different client. I inserted another worksheet to list the tab names and decode them to one or more e-mail addresses to send each report to. I also compute the pdf file names based on the month/year of the reports, and whether or not to send the report to e-mail or only to store the pdf archive. PDF-eXPLODE has lots of options so we were able to customize it to the client's needs.

Rob H.



Liam Gavin-382521
Liam Gavin-382521
SSC Rookie
SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)SSC Rookie (47 reputation)

Group: General Forum Members
Points: 47 Visits: 153
Hi all,

Thanks for the replies but I don't think that is quite what I am looking for. I want to convert the Excel file into a PDF within the SSIS package and then email the PDF using SSIS. Kathi's suggestion would work but looking at their FAQs this is not what this product does.

I'll carry on looking.
Cheers,
L
Virgil Trasca
Virgil Trasca
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 36
Hello,

It is very easy to call DocumentBurster from command line in order to automate the process from other scripts. This is how it was designed. Give it a try.

Thank you,
Virgil
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search