| |
|
|
Let's face it, to get that valuable information out into your favourite Office tool is a nightmare! Correction, was a nightmare, until you found this website with the solution to your Office Integration problems:
- For 80% of your requirements, no programming required (the remaining 20% is available to make the most stunning reports!)
- Works with all Office versions (97 upwards), all Notes databases (V5 upwards) and all browsers
- Integrate it into your application or don't touch the design of your source at all..
- Distribute their generated reporting and analysis as an e-mail or by storing them in Lotus Domino documents or saving of the reports on the file system
- Generate mail merge reports and print labels - it's simple
- Import data from Excel files or text files automatically generating Lotus Notes documents from the imported data
- Import Word documents into Lotus Notes documents as attachments, embedded objects or actually into a rich-text field
- Have exports, with graphs and pivot tables, and field exchanges to the Lotus Notes documents
- Generate reporting exports and imports on a scheduled basis with automatic execution and distribution
- Provide reporting facilities to both Lotus Notes client users and web browser users
- Manipulate their data through reports that use of Lotus Notes formula language and/or LotusScript
- Maintain Lotus Notes security on the databases on which they want reporting on, by ensuring authorisation on all levels will remain in place.
Lotus Notes Office Integration using MS-Word Integration
At its simplest level Integra for Notes allows for the creation of a one-to-one relationship between data contained in a Lotus Notes document and a Word document. This would for instance allow client names and addresses from a Lotus Notes database to be merged with a Word document to create a personalized mail shot.
In addition, Integra for Notes provides facilities for data contained in various Lotus Notes documents to be collated and pushed into a single Word document (or Excel spreadsheet). An example could be a collection of Notes documents each related to a client’s sales orders being collated into an MS-Word document for generation of an invoice which is to be printed and emailed to the client. It could than update certain fields in a history document and save a PDF of the sent document into a RTF field.
All this, is default functionality (the 80%) available within Integra for Notes, and you can see such examples at work in the evaluation version.
An example of a more complex Lotus Notes Office Integration could be a scenario, where one combines information from multiple Notes and non-Notes database into a Word letter. For instance, a statement of outstanding invoices of a client selected at runtime by the end-user (from a pull down box in a user dialogue box) also lists out the balance of that particular client, which was worked out, during the report-process (using LotusScript) from a SQL database. The calculated values are than not only displayed in the statement, but also updated into a Notes document. This obviously could be done by one user who is using his Notes client, while the other launches the report via the web browser (Explorer, Firefox).
Lotus Notes Office Integration using MS-Excel Based Reports
Lotus Notes lacks reporting capabilities as commonly found in traditional applications. Lotus Notes provides views, which can be printed. However, Lotus Notes views are limited in their functionality. For instance, category totals can only be displayed at the top of a category and data cannot be displayed from multiple databases within a single view. In addition, one can show only a selection of the fields in a view. New views and modifications always require a developer.
Integra for Notes allows data in Lotus Notes databases to be collected together and pushed into a pre-formatted Excel spreadsheet. Under fully automated control, the data pushed to Excel can be placed into defined areas of a spreadsheet template which would already have additional formulas, formatting, sorting, color schemes etc, allowing the flexibility of reporting available in Excel to be extended seamlessly to Notes data. Charts, pivot tables, sorting, subtotalling and all other such features of Excel can then be utilized.
Have a look at the evaluation version to see all sorts of usage scenario's. Check the download page.
| Learn more about Integration.. |
|
|
|
. |
|
|
|
|
| |