?
Solved

How do I implement itext in a Domino environment

Posted on 2010-09-14
7
Medium Priority
?
1,133 Views
Last Modified: 2013-11-16
Hello.
I am a Domino developer who codes using LotusScript and have for some time. Recently there has been a need in the organisation to produce reports preferably as PDFs. I have read about iText and it appears to be the solution I require for this type of project. Can anyone please assist me with an explanation of what I require to set my Domino environment so I can use iText. I have recently downloaded some dbs from OpenNTF which I will look at - hopefully they will have simple examples of agents that read through a view of documents and from each document gather data and output that data to a PDF that can be saved and accessed later.
Any information that would assist me in getting started would be appreciated greatly.

Kind regards
CM
0
Comment
Question by:ChrisMinas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 22

Expert Comment

by:mbonaci
ID: 33671091
Since Jasper reports works best with relational data, I used LEI (Lotus Enterprise Integrator) to configure the data transfer  (nightly) from Lotus to DB2.
LEI is scheduled to transfer all relevant data to DB2 (using LEI Direct Transfer Activities documents), by mapping LN Form fields with DB2 table attributes (using LEI Connection documents).

From then on it was trivial (iReport queries read db2 data)...
0
 

Author Comment

by:ChrisMinas
ID: 33671123
Thanks mbonaci for your reply. However I have been requested by management that iText is the only reporting solution that will be accepted due to the fact that if, "in the future", we were to move away from Notes itext would be portable. Our current system, written by a third party, has data exportyed from Notes to Access. Management want this transfer "cut" and data extracted directly out of Notes

Kind regards
CM
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 33671234
iText is used just for generating PDF documents. I assumed you need some kind of open source report designer.

But it doesn't matter which reporting tool you use (BTW: Jasper iReport is also open source), the whole thing will work the same way. For fast dynamic reporting capability you need relational database (or LS maintenance nightmare).

If you simply want to generate PDF (if collecting, aggregating and organizing data is not your concern) you can simply write a java agent that will use iText jars.

If you have further questions...

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 33672042
IMHO, iText is old school... If you want to standardize, you'd better look into XML/XSL/XSLT/XSL:FO.

About a year ago, I started a simple project to generate PDFs directly from a Notes database, where the database would provide the data only (in DXL), an agent would convert the DXL to XML (using XSLT) and the output could be used by XSL:FO and a format description to produce PDF. Due to lack of time, I fridged my project. I know there are some people who succeeded in producing PDF directly from Domino...

Useful links:
- http://www.w3schools.com/xslfo/default.asp
- http://xmlgraphics.apache.org/fop/
- http://www.slideshare.net/dominion/dxl-as-a-lotus-domino-integration-tool
- http://www.hort-net.de/EntwicklerCamp/Vortrag_XSL-FO.pdf (in German)
0
 
LVL 22

Accepted Solution

by:
mbonaci earned 1500 total points
ID: 33672234
Here's my answer to similar question:

http://www.experts-exchange.com/Q_24694367.html
0
 

Author Comment

by:ChrisMinas
ID: 33688111
Just evaluating the various options you have provided me with.... will be accepting solution soon.

Cheers!
CM
0
 

Author Closing Comment

by:ChrisMinas
ID: 33763647
The solution got me started with iText as it provided code for me to use.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question