I’ve created Plotly Dash integration apps for Frappe and ERPNext.
I’ve been using ERPNext for almost 2 years now, it’s a great ERP apps though it’s lack of dashboard feature.
Plotly Dash is a great dashboard tools which allow programmer to easily create interactive dashboard but it lack of general web feature such as authentication or user-permission.
Integrating Frappe web framework with Plotly Dash is result in great ERP app with powerful dashboard tools.
Dashboard template using CoreUI admin template
Authentication from Frappe web framework
Dashboard permission using user roles from Frappe
Embedded Dash Dashboard into Frappe page
Access Frappe data from dash environment
Pros and Cons
- Plotly Dash comes with a big Graphing Library
- Plotly Dash is a really great dashboard tools
- You can manipulate data using python then using that data in dashboard
- It work well with multi tenant setup
- There are no web UI to create dashboard, dashboard need to written in python
Any feedback or suggestions are welcome.
I’ve also created Metabase integration for Frappe and ERPNext.
Metabase is easy to use and easy to setup dashboard tools which comes with web-ui which make it easy create dashboard.
Whoa! And YES! Yes and yes! Thank you
Best of luck! Make sure you get enough sleep though
is it possible for version-11 ?
It should work with version 11.
Any idea why I get Page Not found error? I followed all the steps (I think). The provided dashboard (Testing 1 and Testing 2) also are not found
Just installed the plotly dash integration but I am unable to find a way to actually load data into the dashboard.
I am able to access the dashboard page where I can select the testing dashboard but that page just shows the desk page.
I am unable to figure out how to connect the data and link it with the dashboard any help on this would be great since I can’t find any documentation for the same.
What would it take to integrate superset? It looks lighter than metabase (resource-wise)
Ah yes, I certainly vote for Apache Superset.
Currently, we use Superset, but externally. We simply connect it to the database, but it would be wonderful to have it integrated.
See this post Dashboard Options for ERPNext
Apache Superset Integration
Doing a superficial go through I think the approach to integrate would be along the same lines as was used for plotly. viz. using iframe integration
I plan to fork from here the Git repo above and muddle along.