SQL query to django

Dear all, I have a table let call it *YY*. Some fields in this table are status, time_frame, etc. time frame is in terms of years and status are Not started, In progress and Completed. I want to display all services Not started, in progress and completed in each year. And at the end to display thi

Re: SQL query to django

Thank y'all On Sun, 10 Oct 2021 at 11:49, Sebastian Jung wrote: > Hello Eugene, > > You can also take a raw query... > > https://docs.djangoproject.com/en/3.2/topics/db/sql/ > > Regards > > Eugene TUYIZERE schrieb am Sa., 9. Okt. 2021, > 10:52: > >>

Child data table in Django

Dear All, Kindly assist me to have a tutorial or code to make this kind of table in django. I failed to do this from the datatable .net tutorial. [image: image.png] regards, -- * Eugene* -- You received this message because you are subscribed to the Google Groups "Django users" group. To uns

Re: Child data table in Django

Python 2 > return "%s (%s)" % ( > self.name, > ", ".join(topping.name for topping in self.toppings.all()), > ) > > and run: > > >>> Pizza.objects.all() > > Url : https://docs.djangoproject.com/en/1.10/ref/models/q

Re: Child data table in Django

: > Hello eugene, > > You have implement also jquery >= 3.5.1 and datatablea.min.js > > Please show us your html code and javascript code that open row when you > click on this item... > > Regards > > Eugene TUYIZERE schrieb am Mi., 13. Okt. 2021, > 14:05: > >&g

jquery and django challenges

Dear all, on the code below I want to replace the code: "ajax": "nestedData.txt", with the url (a python function created) How can I do it? Please help /* Function for child row details*/ function getChildRow(data) { // `data` is the data object for the row

Paid assistance

I need someone to help me to use the ajax datatable view package in my project. Reference on the link below. https://github.com/morlandi/django-ajax-datatable#basic-ajaxdatatableview Please write to me personally. Regards, -- *Eugene* -- You received this message because you are subscribed to

Edit data from django-ajax-datatable

Dear Team, I am using django-ajax-datatable and I have this: [image: image.png] The *Edit *button is added from server side as follow: def customize_row(self, row, obj): row['edit'] = """ Edit """ the table itself is rendered to html from: $(document).ready(function() { AjaxDatatableViewUti

django datatable

Please suggest a good CSS for the datatable below [image: image.png] Regards, -- *Eugene* -- 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+unsubsc

Exported filtered by date data in django

Dear Team, I am trying to export filtered data from a django model, but I get an empty file. But when I remove the filter and add all, it works. Kindly assist to know how to export filtered data. Below is my code def exportexpenes(request): filter_val1=request.POST.get("filter1") filter_val2=req

Re: Exported filtered by date data in django

cts.filter(Q(created_at__range=[filter_val2,filter_val1])) > > On 20 Nov 2021, 10:04 +0300, Eugene TUYIZERE , > wrote: > > Dear Team, > > I am trying to export filtered data from a django model, but I get an > empty file. But when I remove the filter and add all, it works. > > Kindly

Pagination on different cards reside on the same template

Dear Team, I have 4 cards on a single html page. I want to display data on each one but since the data has many rows I want to apply pagination on each card. How can I achieve this? I was thinking of using ListView but this displays pagination on the whole page. I did not try any other codes becau

Re: Pagination on different cards reside on the same template

ards, David > >> On Fri, Nov 26, 2021 at 6:41 AM Eugene TUYIZERE >> wrote: >> Dear Team, >> >> I have 4 cards on a single html page. I want to display data on each one but >> since the data has many rows I want to apply pagination on each card. How &

Where to deploy django application

Dear Team, This is just for advice. I would like to know any other hosting provider that uses GitHub to update the app like we do on Heroku. Thank you -- *Eugene* -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this grou

Re: Where to deploy django application

start at $5. > > On Mon, Nov 29, 2021, 14:19 Eugene TUYIZERE > wrote: > >> Dear Team, >> >> This is just for advice. >> >> I would like to know any other hosting provider that uses GitHub to >> update the app like we do on Heroku. >> >> Than

Get data from table rows and save in database

Dear Colleagues, I have data in the table. I want to get the rows value and save them in the database. How can I do this with jquery? The table I have is like this [image: image.png] This is what I have in HTML. The total is automatically calculated as I type the amount Description Amount Sc

Student Management System kin Django

Dear Team, I am developing a student management system and I am stuck at the point below which I need your idea. I need to record school fees every semester and promote a student from one level (year) to the next level every year. Like 1st Year to second year. How can I achieve this to avoid dat

Re: Student Management System kin Django

739 116 | * > *~~“The mind is its own place and in itself can make a heaven of hell, a > hell of heaven…”~~John Milton * > > > On Mon, Dec 6, 2021 at 1:14 PM Eugene TUYIZERE > wrote: > >> Dear Team, >> >> I am developing a student management system and I am

Allow scroll on jQuery fancy Table

Dear Team, I am using jquery fancyTable in the django app but I searched everywhere and I did not find how to allow the scroll bar when fancyTable is used in django. Does anyone know how to do that? This is the code I have and I what to allow scroll bar: const itemsPerPage = 12; if (100 > items

Django reportViewer

Dear Team, Is there anyway I can use reportViewer in Django application so that I can have something similar to below image: [image: image.png] Let me know how I can do it if it is possible in the django app. Regards, *Eugene* -- You received this message because you are subscribed to the G

Permissions front end management in Django

Derar Team, I have a django application and I want the admin to manage the permissions for different functions. This should be done in way way like below: [image: image.png] by editing you can allow the user access,view, create, modify or delete the particular view. How can I achieve this in dj

Re: An error with my code

May be polls is the name of your app and you forgot to register it in settings.py Sent from my iPhone > On 26 Feb 2022, at 15:53, Kin Zinzombe wrote: > > ^[[23~Traceback (most recent call last): > File > "/data/user/0/ru.iiec.pydroid3/files/accomp_files/iiec_run/iiec_run.py", line > 31, in

Django Due control in Django

Dear all, I want to make an application that requires 2 person to complete the user creation. I mean when initiator creates a user, for a user to login in application, it requires that an authorizer authorizes the user creation. This can also work in case a user is disable in the system. But I

Re: Django Due control in Django

able to access the django app. > > On Thu, Oct 1, 2020 at 8:46 PM Eugene TUYIZERE > wrote: > >> Dear all, >> >> I want to make an application that requires 2 person to complete the user >> creation. I mean when initiator creates a user, for a user to login in >

JavaScript

Dear All, I did form validation where I can not save empty value. And When I try a message displays under the text field. What I want is, in case I type at least a single character, the error message to disappear and when I delete again, the error to be show, etc If someone can share with me t

Re: JavaScript

Merci reka ngere murugo ndi munzira ntaha! Ndayiguha kandi merci bcp Sent from my iPhone > On 2 Oct 2020, at 18:03, Chris Franklin wrote: > > Nyohereza screenshot ndakurabire > > >> On Oct 2, 2020 17:32, "Eugene TUYIZERE" wrote: >> Dear All, >> &g

Re: Ajax, jQuery and Django

https://simpleisbetterthancomplex.com/tutorial/2018/01/29/how-to-implement-dependent-or-chained-dropdown-list-with-django.html check this also On Mon, 5 Oct 2020 at 11:25, RANGA BHARATH JINKA wrote: > Hi, > > Check this. This may be useful for you. > > All the best > > > https://www.youtube.com

Retrieval of Date and data in select text field

I always struggle to retrieve from database to html text field or date field data when I want to edit these data. Only text field data display. Please advise how to display these fields. When I use: value = "{{ list.date_of_birth }}" or value = "list.gender" for example, I get an empty field

Re: Need Guidance to setup Django with MS SQL server

try this https://django-mssql.readthedocs.io/en/latest/quickstart.html#dependencies OR https://stackoverflow.com/questions/43430091/connecting-django-with-mssql-server On Wed, 7 Oct 2020 at 20:36, arun sahu wrote: > Hi Geeks, > > I need your support for setting up my django project with MS SQL s

Re: Retrieval of Date and data in select text field

No one to assist please? Sent from my iPhone > On 7 Oct 2020, at 19:02, Eugene TUYIZERE wrote: > > I always struggle to retrieve from database to html text field or date field > data when I want to edit these data. Only text field data display. Please > advise how to displ

populate select field based on the selection option

Dear Team, I have se;ection option where I need to select an option and populate the other selection field this the html code Country_name Othe

Password policy enforcement in django app

Dear Team, I have an application that I want to validate the password when users are creating new passwords. I do not want to use the build in one, I want the customized one. Someone to help please? Thank you -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *African Institute for M

Deploy a finished django application

Dear Team, I hope you are doing well. I have a question that I need guidance from you: I have a web application that is currently done and ready to be used. I want to deploy (make it productive) on the company server. This company has very strong security on their private network. My question is:

Re: Deploy a finished django application

m_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Thu, 3 Dec 2020 at 11:09, Kasper Laudrup wrote: > Hi Eugene, > > On 03/12/2020 09.28, Eugene TUYIZERE wrote: > > I have a web ap

Date validation in javascript

Dear Team, In my project, I have the date format MM. How to validate that the MM part cannot exceed 12? I think this can be done in javascript but don't know how. Assist please. Thank you -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *African Institute for Mathematical Scien

django app deployement

Team, I have an issue to disploy django app using IIS on Windows server 2019. I am using python 3.8.3 and django 3.0.8. Please assist on this challenge. regards, -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal Gar

Re: Python Django Training

add me please On Mon, 7 Dec 2020 at 10:10, narendra thapa wrote: > hello please add me also in training group? > > > On Fri, Feb 21, 2020 at 7:27 PM Bharati Nilam > wrote: > >> Hi, >> I also from Hyderabad and I'm also interested in the training. please >> tell me how to join? >> >> Regards, >>

Cache pages for fast loading

Dear team, I deployed a django application on windows server with IIS web server. But the app is slow and I want to implement django redis for web page caching. Please assit how i can do this. Thank you -- You received this message because you are subscribed to the Google Groups "Django us

Re: Cache pages for fast loading

No I only use IIS > On 7 Jan 2021, at 17:18, gabriela...@gmail.com > wrote: > > Eugene: > is IIS a Microsoft server ? Have you tray this with other server? for > example, APACHE. There are a lot of hosting they give host service. > >> El jueves, 7 de enero de 2021 a las 12:10:19 UTC-3, euge

Django app deployment

Dear Team, How to connect a django application to a Database that is on a different machine with an application file? I mean, if the application files are on the machine(server) A and database is on the machine(server) B Regards, -- *TUYIZERE Eugene* *Msc Degree in Mathematical Science* *Afr

Django Search Between 2 Dates

Dear Team, I need help. I have a list of Items in a table. And I want to filter some data between dates (start and end date). Please help me to do a search between the two date. I am using Data table but I can use the other way if possible for this purpose. Regards, -- *TUYIZERE Eugene* *Msc

Re: Django app deployment

Dear Kasper, Thank you very much for the documentation. regards, On Mon, 1 Feb 2021 at 13:54, Kasper Laudrup wrote: > On 01/02/2021 12.49, Eugene TUYIZERE wrote: > > > > How to connect a django application to a Database that is on a different > > machine with an applica

Re: Django Search Between 2 Dates

Dear Thiago, Can I have some documentations or sample codes please? On Wed, 3 Feb 2021 at 15:16, Thiago Luiz Parolin wrote: > Hi... > Normally i use field__lte and field__gte > > Em qua, 3 de fev de 2021 08:11, Eugene TUYIZERE > escreveu: > >> Dear Team, >> &g

Re: login and signup form in one view

Then, what is the problem Sent from my iPhone > On 5 Mar 2021, at 17:31, Kasper Laudrup wrote: > >> On 05/03/2021 13.59, uma shankar wrote: >> i have two forms in one html file and i want to write both of them in single >> view with and without submit buttons >> > > OK. Sounds simple enough.

Re: Building reports in Django / Python

Pandas and matplotlib can solve your problem Sent from my iPhone > On 24 Apr 2021, at 22:53, Benny M wrote: > > Ah! Had to go back and read again. I think I misunderstood. > > While I don’t have a ton of experience with either, Pandas and Prometheus are > popular analysis libraries. I’ve seen

use of annotate in django query

Dear Team, I need help. I am working on a project where one of the tables is about requests. I want to have a report of the number of requests on each day in the last 30 days, something like this: [image: image.png]I I used the code below just before displaying on the chart but the code gives me w

Re: use of annotate in django query

2 GROUP BY `crms_customer_requests`.`arrival_date` ORDER BY NULL On Wed, 2 Jun 2021 at 21:53, Sebastian Jung wrote: > Hi Eugene, > > Please make Print(report.query) then you get SQL querys and Most of time i > get an Idea what's wrong > > Regards > > Eugene TUYIZERE schr

Re: use of annotate in django query

in brief, I want to transform this query in django query [image: image.png] On Wed, 2 Jun 2021 at 21:56, Eugene TUYIZERE wrote: > Dear Sebatian, > > This is what I get: > > SELECT `crms_customer_requests`.`arrival_date`, > COUNT(`crms_customer_requests`.`request_name

Re: use of annotate in django query

valent to this query in django > > Customer_Requests.objects.values("arrival_date").annotate(num_req=Count("request_name")) > > > On Thu, 3 Jun 2021 at 02:02, Eugene TUYIZERE > wrote: > >> in brief, I want to transform this query in django query &g

Re: use of annotate in django query

Count("request_name")).order_by("-id")[:30:-1] > > On Thursday, 3 June 2021 at 11:37:26 UTC+5:30 abubak...@gmail.com wrote: > >> to display last 30 records you can write your code like this: >> Customer_Requests.objects.all()[-30] >> >> On Thu, Jun

Re: use of annotate in django query

tistics'}, >> 'xAxis': {'datesb': datesb}, >> 'series': [arriva_days] >> } >> dump3 = json.dumps(chart3) >> return render(request,'summarizedchart.html',{'chart3': dump3}) >> >> Please once again &

Re: use of annotate in django query

the chart? can I see the code inside > "summarizedchart.html" > > On Thu, 3 Jun 2021 at 17:43, Eugene TUYIZERE > wrote: > >> Dear Suthar, >> >> You saved my day. Once more, the chart is displayed but the date is not >> displayed on Xaxis. This h

Re: use of annotate in django query

: 'Previous statistics'}, > 'xAxis': {'replist': replist}, > 'series': [arriva_days] > } > with > chart = { > 'chart': {'type': 'column'}, > 'title': {'text': 'Pre

Re: use of annotate in django query

Dear Suthar, Can I have your private contact? regards, On Fri, 4 Jun 2021 at 06:25, Lalit Suthar wrote: > my pleasure :) > > On Thu, 3 Jun 2021 at 20:28, Eugene TUYIZERE > wrote: > >> Dear Suthar, >> >> Thank you very much. It works well. >> >>

Drop down dependent of more than 2 drop downs

Hello team, Am having trouble implementing drop down dependent on more than 2 drop downs. I successfully did for two but the 3rd one which should depend on the second does not work. Is there someone who has successfully implemented this and share with me the way I can do it? Thank you -- *TUYIZ

Send login email notification

Team, I need to include email notification every time user logs in in django app! Help to achieve please. Regards, T.E -- 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

django cron Job Functionality

Dear Team, In my application, I want a user to set for example a leave plan in the system and the system notify the user by email for example one day before the start leave date. At the same time the system disables the user in the system. Here I have a field *is_active *and I want the system to s

Re: django cron Job Functionality

>> Then set the cron job to run this function every day, every hour, or >> however you'd like. >> On Fri, Jun 11, 2021 at 15:10 Chetan Ganji wrote: >> >>> This will help you >>> >>> https://pypi.org/project/django-celery-beat/ >>>

Re: django cron Job Functionality

how to schedule a task or function in your Django >>> project, I’m sure it will have the answer to your question: >>> >>> >>> >>> >>> On Sat, 12 Jun 2021 at 08:41, Eugene TUYIZERE >>> wrote: >>> >>>> Thank y

Allow field validation in ajax.

Friends, The ajax codes below successfully save the records in the database without page loading. But what I want is to validate the fields first before saving. The codes do not validate the empty field. How can I include that validation ? please help $(".submit_btn").click(function(){ var form=

Find number of days between two date excluding weekend days and display the number in text field

Team, I have date1 and date2 fields. I am able to calculate number of days between the two dates using relativedelta as shown below: date1 = datetime.datetime.strptime(str(end_date), '%Y-%m-%d') date2 = datetime.datetime.strptime(str(start_date), '%Y-%m-%d') r = relativedelta.relativedelta(date1,

Django Query vs SQL query

Team, I am a little bit confused: I have a table callect Projects and another called Staffs. I want a particular staff member to view only the project he/she has a role in. In the Staffs table I have a project foreign key project_id. But I am confused about how to construct the query. I think of t

Re: Find number of days between two date excluding weekend days and display the number in text field

Dear NA, I accomplished this with numpy. How can I get the value (difference between the two dates) when I select the second date for example in the text field? I know Javascript can be used but how? On Tue, 15 Jun 2021 at 11:14, Nikeet NA wrote: > You need to loop through the dates maintain a

Django chart using chart.js

Team, I have a table called Indicators. This includes indicator, target and progress. Both target and progress are numbers. What I want is to display a chart target and progress for every indicator. With the code below I only get indicators I failed to display the bars (columns). Please assist [i

Fwd: Django chart using chart.js

please assist -- Forwarded message - From: Eugene TUYIZERE Date: Thu, 17 Jun 2021 at 11:15 Subject: Django chart using chart.js To: Team, I have a table called Indicators. This includes indicator, target and progress. Both target and progress are numbers. What I want is to

Re: Allow field validation in ajax.

Dear NA, still it does not wark On Sun, 13 Jun 2021 at 03:20, Nikeet NA wrote: > You are not submitting your form which Inturn is not validating. For > validations to run you need to submit a form. > > Give the submit button attribute type="submit", then add an event listener > for form submit

Re: Django chart using chart.js

On Thu, 17 Jun 2021 at 11:15, Eugene TUYIZERE wrote: > Team, > > I have a table called Indicators. This includes indicator, target and > progress. Both target and progress are numbers. What I want is to display a > chart target and progress for every indicator. With the code bel

Deploy Django app using cpanel

Dear Team, I have an issue. I want to make my app productive. I bought a domain and I got cpanel credentials. The problem I have now is that I do not know how I can configure the app in cpanel so that users can start browsing it. I tried to connect to the database and I loaded the application file

Re: Deploy Django app using cpanel

please assist On Tue, 22 Jun 2021 at 13:03, Eugene TUYIZERE wrote: > Dear Team, > > I have an issue. I want to make my app productive. I bought a domain and I > got cpanel credentials. The problem I have now is that I do not know how I > can configure the app in cpanel so that

Re: Deploy Django app using cpanel

> On Wed, Jun 23, 2021 at 9:54 AM Eugene TUYIZERE > wrote: > >> please assist >> >> On Tue, 22 Jun 2021 at 13:03, Eugene TUYIZERE >> wrote: >> >>> Dear Team, >>> >>> I have an issue. I want to make my app productive. I bought a d

Re: Deploy Django app using cpanel

unio de 2021 11:37 a. m., Franck Tchouanga < > ftchoua...@gmail.com> escribió: > >> I see. >> >> On Wed, Jun 23, 2021, 11:38 AM Eugene TUYIZERE >> wrote: >> >>> Dear Franck, >>> >>> The problem I have now is to configure the djang

Diploy django on DigitalOcean

Hello Team, I need some tutorials and steps to deploy a django app on DigitalOcean. Note that I already have the domain what it remaining is only to host. Thank you -- *Eugene* -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe f

Re: Multiple websites but one authentication system

My suggestion is that you can create a single entry where after login the system redirects users to the home page containing all these domains as icons and then the user selects the one he wants. On Thu, 26 Aug 2021 at 10:18, Isaac wrote: > Am working on a company website and there will be havin

List Index out of Range

Good day all, I need assistance. Am trying to save data from the below form but I am getting *list out of range* error can someone help me to write a successful save function? here is the code I am using: def submit_work(request): if request.method != "POST": return HttpResponse("Method Not Al

Django Query

Team, Assume you have 3 tables PROVINCES, DISTRICTS, and SECTORS and you have Province, District and Sector field names respectively in each table. How can you display in the Django template the following table? Province District Sectors A A1 A11 A12 A2 A21 A22 A3 A31 A32 Any assistance will be

Re: Django Query

Is there any one with a typical example or tutorial (of Django mptt) that tolks on the similar issue as mine and share with me? regards, On Tue, 5 Oct 2021 at 01:00, Sebastian Jung wrote: > Hello Eugene, > > I think that django mptt can Store and display such a tree. > > Reg