[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 379: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4505: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4507: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4508: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4509: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
From Flames To Fork, Comes Freedom • View topic - Excel Dashboard Integration

Excel Dashboard Integration

The migration of Adempiere modules to iDempiere

Excel Dashboard Integration

Postby red1 » Sun Apr 23, 2017 11:44 pm

Together with Nakarat of Thailand, we began to collaborate on making iDempiere BI layer fully functional and easy to use. No better way than to fuse my Ninja's Info-Window Reporting tool to Excel Interactive Dashboard, pumping raw data one way (for security reasons).

InfoWindowSalesData.png
InfoWindowSalesData.png (156.44 KiB) Viewed 7764 times
The Info-Window Reporting is generated with two Ninja cuts. Resulting as Info-Window and its Reporting output. It is then saved in XLS format and sent to the Excel Dashboard and that is all for the Interative BI show to begin. Special mention of thanks to http://www.myonlinetraininghub.com for its free tutorial on how to do the amazing dashboard in a matter of strokes.

ExcelSalesDashboar.png
ExcelSalesDashboar.png (136.29 KiB) Viewed 7764 times
Download the Interactive BI Dashboard here http://sourceforge.net/projects/red1/files/Business/ with short movie.
Info-Window plugin and a more complete demo movie by tomorrow noon (its late here in Bangkok).

This is just the beginning. Soon we shall cover all critical areas of the ERP including Warehousing and Manufacturing, providing upper management with timely and easy to understand interactive analysis graphs.

PieCharts.png
PieCharts.png (101.49 KiB) Viewed 7764 times
red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Excel Dashboard Integration

Postby red1 » Mon Apr 24, 2017 11:51 am

If you wish to produce the plugin manually that exports out the info data to the Excel template, you may take the Ninja up on this. Here is what you need to set in both ModelMaker and CodeMaker. Otherwise just take the plugin created in this process at the bottom. (Typo:SalesRep_ID not Sales_Rep_ID)

ModelMaker.png
ModelMaker.png (23.9 KiB) Viewed 7704 times

CodeMaker.png
CodeMaker.png (25.91 KiB) Viewed 7704 times

ExcelInfoWindow.png
ExcelInfoWindow.png (280.88 KiB) Viewed 7693 times
Note also that you need to set the sequence to the grid order as shown in the PrintFormat's DisplayOrder tab below. Then it is a matter of copy and paste into the Excel template.

DisplayOrder.png
DisplayOrder.png (36.98 KiB) Viewed 7641 times
Fetch the plugin org.red1.excel and Excel template from http://sourceforge.net/projects/red1/files/Business/

A movie to show how

red1
Site Admin
 
Posts: 2759
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia


Return to iDempiere

Who is online

Users browsing this forum: No registered users and 2 guests

cron