Re: Django Admin Custom View Query Generation

Hello Derek,

Thanks for providing good references for Django Admin Customization. I'm looking for a way to customize the following requirements. I thought you might have some idea of how to achieve this.

1. We extract data from XML files and upload the data into our Django based web app but we do this offline using URL/script name.

2. So we need to add the data generation scripts into admin control so that webmaster can

2.1. run the scripts using actionable buttons on demand > see the progress of the script in log output > this log output should be saved and viewed from admin control only so that webmaster can check if there is any issue while extracting the data

2.2. result of the data generated should be injected into the front end of the web app as well as in admin control. It is almost a replica of the same data between the front end and admin control

2.3. the same actionable buttons can be avoided to run on demand > add the actions/scripts into Cron jobs > I'm not sure whether Cron jobs page can be created and managed from admin control

I appreciate it if you can suggest some examples to achieve the above.

Best regards,

~Ram

On Sat, Dec 14, 2019 at 9:37 AM Derek <gamesbook@gmail.com> wrote:

The first post I came across that helped me before was:

https://hakibenita.com/how-to-turn-django-admin-into-a-lightweight-dashboard

(tip: he has many useful admin-related posts and is worth following)

This seems like a more recent version of the same:

https://findwork.dev/blog/adding-charts-to-django-admin/

I have not used these, but of course third-party apps can save you time:

https://pypi.org/project/django-admin-charts/

and

https://pypi.org/project/django-admin-tools-stats/

(this one is based on other Django stats libraries that could be of help in reporting - look at the Dependencies section)

For a different approach, you can generate your reports in Excel (many of my users seems to want that format):

https://djangotricks.blogspot.com/2019/02/how-to-export-data-to-xlsx-files.html

and then embed charts in the file:

https://www.geeksforgeeks.org/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-1/

https://www.geeksforgeeks.org/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-2/

https://www.geeksforgeeks.org/python-plotting-charts-in-excel-sheet-using-openpyxl-module-set-3/

On Friday, 13 December 2019 21:05:43 UTC+2, Balaji wrote:

Thank you very much Derek.

You always provide nice help.

Can we generate graphs  for reports in  Django Admi n.

On Saturday, December 14, 2019, Derek <game...@gmail.com> wrote:

You can use built-in Django ORM methods to perform calculated operations on existing models (you don't need a new model). See: https://docs.djangoproject.com/en/3.0/topics/db/aggregation/

For more complex operations, you can write "raw" SQL -see https://docs.djangoproject.com/en/3.0/topics/db/sql/

The results can be rendered as HTML or converted to PDF (see: https://codeburst.io/django-render-html-to-pdf-41a2b9c41d16)

The standard Django Admin list is NOT a suitable place to show these outputs directly - I would (and I have before) hook these up to an custom action that lets a user fill in report parameters in a form before generating the HTML (for display) or PDF (for download).

On Thursday, 12 December 2019 19:51:14 UTC+2, Balaji wrote:

Hi

Can anyone please tell me how can we generate Custome Model view for different report where we use avg, min , max, sum, count , group by clause.

We have to generate this report in Django Admin Panel only.

Can we generate respective Graphs also.

Is there any library available.

--
Mr Shetty Balaji
Asst. Prof.
IT Department
SGGS I&T
Nanded. My. India

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8e0b3bb0-07dc-4765-b0a3-82b6dcc95589%40googlegroups.com.

--
Mr Shetty Balaji
Asst. Prof.
IT Department
SGGS I&T
Nanded. My. India

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e63cfa7c-fcde-40d3-81ab-564e5c611bc9%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2BOi5F3BYm6orEj5RR4PK8Bcu2jArwfSjTT3aYr8-HU_whCf5A%40mail.gmail.com.