Kumar A. ADempiere 3.6 Cookbook
Подождите немного. Документ загружается.
Mondrian Integration for Analysis
288
How to do it...
1. On the Order Analysis page, click on the button. This will present the current data
set in the form of chart:
2. To change the chart type or to congure a chart, click on the button. This will
present the following options:
Chapter 9
289
3. Say, you change the Chart Type to Stacked Vertical Bar 3D and checked the
Enable Drill Through. Click on the OK button after changing these values.
This shall present the chart in the selected form, and clicking on the bar shall
show you the drill through information.
Mondrian Integration for Analysis
290
4. Click on the icon in the Quantity column header to drill through the quantity.
Creating reports from the analyzed data set
Apply lters, change column orders, apply sorting, and the like on the crosstab representation
that represents your current analysis outcome at a given instance of time. Once you have got
your data set, it may be required to print a report from it so that the same can be shared with
others. The Web interface provides support for printing the reports in PDF and the MS-Excel
format. This recipe describes the steps to print reports using Mondrian and JPivot.
Chapter 9
291
How to do it...
1. Prepare your crosstab view after your analysis and click on the button, which
presents the data in PDF form.
2. To produce an MS-Excel sheet, click on the button.
3. To change the print settings, click on the button.
10
E-mail Integration
with Mozilla
Thunderbird
In this chapter, we will cover:
f Setting up the environment
f Extending the Thunderbird toolbar
f Working with ADempiere contacts from Thunderbird
Introduction
Sending e-mail to the outside world is present in ADempiere and works great for the e-mail
notication, alerts, and reminders. We already made use of it in our previous chapter to send
mail to the users. However, many a time, it is very convenient to use the full-edged mail
clients like, Mozilla Thunderbird, MS Outlook, Evolution, and so on for two different reasons:
1. More people use these mail clients than ADempiere and there is almost certain
probability that an ADempiere user might already be using (and still using) a mail
client before and after he/she became an ADempiere user, as well.
2. They are more complex and more complete than ADempiere's Send Mail capability.
The bottom line is that we use them and it would be good if we can have a two-way integration
with ADempiere so that things like outbound and inbound messages, tasks, and events can
be in sync between both. This gives the user the access to the same data from two different
places, depending upon which software he/she is using at a given instance.
E-mail Integration with Mozilla Thunderbird
294
In this chapter, we'll cover a few items related to the integration between a mail client and
ADempiere. I have selected Mozilla Thunderbird because of its popularity, simplicity, and
the extensibility support. We will see how we can pull out the users detail from ADempiere
and use them in sending bulk messages. For example, if you want to send a mail to all your
prospects, then you can pull out the prospects from the ADempiere database and use them
to send e-mails.
To achieve the goal, we will be developing a Thunderbird add-on. The details about how to
develop a Thunderbird add-on/extension can be found at
https://developer.mozilla.
org/En/Building
_an_Extensionhttps://developer.mozilla.org/En/Building_
an_Extension
.
Setting up the environment
As we are going to develop a Thunderbird plug-in and also work with the ADempiere database
to pull out the contact detail, this recipe focuses on setting up the right environment for the
work. We will install the development tools for Thunderbird and for ADempiere integration.
This time, we'll keep it simple and straightforward by integrating it with a PHP backend, which
directly queries the ADempiere database. Alternatively, you may integrate the add-on with the
ADempiere Web services, which we saw in
Chapter 4, Web Services.
How to do it...
1. Download and install Mozilla Thunderbird from the URL http://www.
mozillamessaging.com/en-US/thunderbird/
. This recipe uses the latest
3.1.4 version.
2. Set up your favorite e-mail account in it.
Chapter 10
295
3. Click on the Tools | Add-ons menu and add the following add-ons:
f DOM Inspector
f JavaScript Debugger
On the Extensions(screentext style) tab, verify that the add-ons have been added, as shown in
the following screenshot.
4. Verify that the entries are created in the Tools menu of Thunderbird for the newly
installed add-ons.
Down l o a d f r o m Wow ! e B o o k < www. w o w e b o o k . com>
E-mail Integration with Mozilla Thunderbird
296
5. Click on the Tools | DOM Inspector menu. The DOM Inspector window comes up.
6. On the DOM Inspector window, click on Inspect Chrome Document | Inbox |
Mozilla Thunderbird.
You shall see the DOM for the Thunderbird main window.
7. Click on the Tools | JavaScript Debugger menu. The JavaScript Debugger window
comes up and you shall be able to open the source code of any le being shown in
the Loaded Scripts tree.
Chapter 10
297
8. Install XAMPP from http://www.apachefriends.org/en/xampp.html URL in
say, c:\xampp folder. We'll refer this folder as XAMPP_HOME. This recipe uses the
latest version - 1.7.
9. Run XAMPP_HOME\xampp-control.exe and start Apache.