On Mon, 31 Jan 2022 01:32:15 -0800 (PST), NArshad
declaimed the following:
>What about CGI?
>Do you know any Library Management System based on CGI just like the one on
>Django?
Pure CGI is 30 year old technology...
https://en.wikipedia.org/wiki/Common_Gateway_Interface
To use
On Tue, 1 Feb 2022 at 02:38, NArshad wrote:
>
> What about CGI?
> Do you know any Library Management System based on CGI just like the one on
> Django?
>
Have you done any research, or are you just picking up a new acronym
to see if you can suck some more volunteer time out of this list?
ChrisA
What about CGI?
Do you know any Library Management System based on CGI just like the one on
Django?
--
https://mail.python.org/mailman/listinfo/python-list
On Fri, 28 Jan 2022 14:31:20 -0700, Cousin Stanley
declaimed the following:
>Dennis Lee Bieber wrote:
>
>> Ignoring the code spam I presume
>>
>
> I'm an sqlite user myself and was glad to see
> the code you posted and have a couple of tiny example
> book/author sql3 databases but noth
Dennis Lee Bieber wrote:
> Ignoring the code spam I presume
>
I'm an sqlite user myself and was glad to see
the code you posted and have a couple of tiny example
book/author sql3 databases but nothing resembling
an actual library check in/out program
I've never used PySi
On Fri, 28 Jan 2022 09:34:39 -0700, Cousin Stanley
declaimed the following:
>
> Your patience and willingness to help and guide someone else
> with such a complete and understanable post is hihgly commendable.
>
Ignoring the code spam I presume
I seem to have scared off the O
Dennis Lee Bieber wrote:
>
> How would you do this assignment on paper ?
>
Your patience and willingness to help and guide someone else
with such a complete and understanable post is hihgly commendable.
Thanks
--
Stanley C. Kitching
Human Being
Phoenix, Arizona
--
htt
On Sun, 23 Jan 2022 09:17:38 +1100, Chris Angelico <>
declaimed the following:
>
>Absolutely agree with making a console app first. Though I rather
>suspect the OP doesn't want to write any code at all.
>
I am not writing any code because I don’t know what code to do next. Still, I
have made a
On Mon, 24 Jan 2022 00:25:34 -0800 (PST), NArshad
declaimed the following:
>
>I am not writing any code because I don’t know what code to do next. Still, I
>have made a dictionary now searching for what to do next in which one choice
>is MS SSIS and the second is numpy or pandas which AGross ha
On Sun, 23 Jan 2022 09:17:38 +1100, Chris Angelico
declaimed the following:
>
>Absolutely agree with making a console app first. Though I rather
>suspect the OP doesn't want to write any code at all.
>
Oh, it's gone beyond suspicion -- considering that, at just 10 lines
per day, over th
On Sun, 23 Jan 2022 at 09:15, Dennis Lee Bieber wrote:
> A web
> application has every action as a distinct connection and needs identifying
> tokens [cookies] to let the logic know what was done previously
>
Usually. Fortunately, we have SOME features that can make life easier,
but in general, y
On Sat, 22 Jan 2022 02:22:14 -0800 (PST), NArshad
declaimed the following:
>
>The user is going to enter the book name as the input of an HTML form on a
>website and I have to check whether the book is present or not in the Excel
>table
As written, the user will have to know the exact
AGross
-Original Message-
From: NArshad
To: python-list@python.org
Sent: Sat, Jan 22, 2022 5:22 am
Subject: Re: What to write or search on github to get the code for what is
written below:
The user is going to enter the book name as the input of an HTML form on a
website and I have to check
On Sun, 23 Jan 2022 at 07:47, Dennis Lee Bieber wrote:
> If you are doing a web application, how are you going to host it? Who
> is responsible for managing the web server? Domain name? Firewalls?
> Certificates if you need HTTPS rather than plain insecure HTTP.
>
> I have a Raspbe
On Sat, 22 Jan 2022 02:22:14 -0800 (PST), NArshad
declaimed the following:
>
>The user is going to enter the book name as the input of an HTML form on a
>website and I have to check whether the book is present or not in the Excel
>table. openpyxl preferred pandas is also fine anything left. Cas
The user is going to enter the book name as the input of an HTML form on a
website and I have to check whether the book is present or not in the Excel
table. openpyxl preferred pandas is also fine anything left. Case sensitivity
is not required. I tried to find code or tutorial on google searc
- I will try to follow all that you people are saying, but it will take time or
next time. The chance of concurrency is very less. Kindly don't write big
descriptions.
- The weblink Avi Gross has given is very useful.
--
https://mail.python.org/mailman/listinfo/python-list
2022 2:44 pm
Subject: Re: What to write or search on github to get the code for what is
written below:
On Tue, 18 Jan 2022 07:37:07 -0800 (PST), NArshad
declaimed the following:
>Avi Gross:
>
Not Avi Gross, but that is partly because you replied to Chris
Angelico, who was replying to
o/~ talking to myself in public o/~
On Mon, 17 Jan 2022 15:39:25 -0500, Dennis Lee Bieber
declaimed the following:
> In one respect, given the limited functionality stated, one gets the
>impression of a class GROUP assignment, in which the individual functions
>w
On Tue, 18 Jan 2022 07:37:07 -0800 (PST), NArshad
declaimed the following:
>Avi Gross:
>
Not Avi Gross, but that is partly because you replied to Chris
Angelico, who was replying to my post replying to an earlier one of
yours...
>What does the website "https://mail.python.org/mailman/li
Avi Gross:
What does the website "https://mail.python.org/mailman/listinfo/python-list";
do?
Can I use this for the discussions which I require?
--
https://mail.python.org/mailman/listinfo/python-list
On Tue, Jan 18, 2022 at 7:44 AM Dennis Lee Bieber wrote:
> Heroku-Specific note: a recent web-page I encountered searching for
> information for a different question indicates that Heroku does not support
> SQLite3 and, by extension, ANY file-based dynamic data storage (so, no
> Excel files either
On Mon, 17 Jan 2022 01:55:15 -0800 (PST), NArshad
declaimed the following:
>This is due to the time factor
And that opens another can of worms... Before this "assignment" was
given to you, surely someone made some sort of estimate of how long it
would take to produce, taking into accoun
working set of software
first.
Good luck with that.
-Original Message-
From: NArshad
To: python-list@python.org
Sent: Mon, Jan 17, 2022 4:55 am
Subject: Re: What to write or search on github to get the code for what is
written below:
Avi Gross:
-“They just were hoping someone would post
On Tue, 18 Jan 2022 02:51:22 +1100, Chris Angelico
declaimed the following:
>
>I strongly encourage everyone to stop helping the OP until there's
>some code to help with.
>
Well, we did squeeze about four lines of code from the OP -- though
still incomplete (no import statements so we hav
On Tue, Jan 18, 2022 at 2:46 AM NArshad wrote:
>
> Avi Gross:
>
> -“They just were hoping someone would post complete code and they could then
> move on without learning anything.”
>
> This is due to the time factor
Then pay someone to write it. There are plenty of contractors out
there. You can
Avi Gross:
-“They just were hoping someone would post complete code and they could then
move on without learning anything.”
This is due to the time factor
--
https://mail.python.org/mailman/listinfo/python-list
On Sat, 15 Jan 2022 02:38:34 -0800 (PST), NArshad
declaimed the following:
A bit of an improvement -- actual code...
But... still not a minimal /runnable/ example...
>
>Why does the code written below is not giving any output?
>
>xls = ExcelFile('ABC.xlsx')
Where is
since it was asked here, someone suggesting Python was a pretty
expected outcome...
> -Original Message-
> From: Mats Wichmann
> To: python-list@python.org
> Sent: Sat, Jan 15, 2022 3:05 pm
> Subject: Re: What to write or search on github to get the code for what is
> written
On 15Jan2022 02:38, NArshad wrote:
>Why does the code written below is not giving any output?
>
>xls = ExcelFile('ABC.xlsx')
>df = xls.parse(xls.sheet_names[0], index_col=1)
>x=df.to_dict()
>print (x)
>
>Only the contents of the first column and the column number is required
>in t
To: python-list@python.org
Sent: Sat, Jan 15, 2022 3:05 pm
Subject: Re: What to write or search on github to get the code for what is
written below:
On 1/13/22 16:08, Avi Gross via Python-list wrote:
>
> I am not replying to anything below so I have removed it.
> Instead, someone sug
On 1/13/22 16:08, Avi Gross via Python-list wrote:
>
> I am not replying to anything below so I have removed it.
> Instead, someone suggested Python which indeed, with lots of work, can open
> just about ANY nonsensical file and diddle around and rewrite it, but WHY?
well, the topic *was* rais
What Dennis Lee is saying I will see to it later.
Right now what mrabarrnett is saying is of use.
Why does the code written below is not giving any output?
xls = ExcelFile('ABC.xlsx')
df = xls.parse(xls.sheet_names[0], index_col=1)
x=df.to_dict()
print (x)
Only the contents o
On Thu, 13 Jan 2022 23:08:19 + (UTC), Avi Gross
declaimed the following:
>So the suggestions to copy the data ONCE into something else (a CSV, database,
>whatever) that can be used externally are reasonable but seem to be resisted.
>I would guess some of the "missing" functionality others w
On 14/01/22 12:23 pm, dn wrote:
On 14/01/2022 09.48, Dennis Lee Bieber wrote:
On Thu, 13 Jan 2022 15:22:50 -0500, Dennis Lee Bieber
declaimed the following:
Talking to myself in public again... Bad habit...
Recommend that you not start any arguments then
- they will be unwinnable!
On 14/01/2022 09.48, Dennis Lee Bieber wrote:
> On Thu, 13 Jan 2022 15:22:50 -0500, Dennis Lee Bieber
> declaimed the following:
>
> Talking to myself in public again... Bad habit...
Recommend that you not start any arguments then
- they will be unwinnable!
--
Regards,
=dn
--
https://ma
I am not replying to anything below so I have removed it.
So I need to remind people of the topic and how it has wandered.
Someone has data in a not particularly great format in an EXCEL spreadsheet.
They want to somehow use an external language like Python to manipulate the
contents from outsid
On Fri, 14 Jan 2022 08:24:43 +1100, Chris Angelico
declaimed the following:
>On Fri, Jan 14, 2022 at 7:56 AM Dennis Lee Bieber
>wrote:
>>
>> On Thu, 13 Jan 2022 15:22:50 -0500, Dennis Lee Bieber
>> declaimed the following:
>>
>> Talking to myself in public again... Bad habit...
>
>Not
On Fri, Jan 14, 2022 at 7:56 AM Dennis Lee Bieber wrote:
>
> On Thu, 13 Jan 2022 15:22:50 -0500, Dennis Lee Bieber
> declaimed the following:
>
> Talking to myself in public again... Bad habit...
Not as bad as singing choruses in public, which - or so I'm told, by a
mad girl in opera - i
On Thu, 13 Jan 2022 15:22:50 -0500, Dennis Lee Bieber
declaimed the following:
Talking to myself in public again... Bad habit...
> As you've described this system, the only thing your application will
>do is record "check-outs" by tracking available copies of books, and the
>name (
On Thu, 13 Jan 2022 10:44:01 -0800 (PST), NArshad
declaimed the following:
Please arrange to use some client that does proper quote attribution.
It gets difficult to read these when you have snippets from multiple posts
with no attribution of who wrote the snippet, and when it was posted,
- “if you are deploying to something like Heroku for the application -- the
Excel file will have to be deployed also, and no one except your application
will be able to see it there. Under this situation, there is no reason/excuse
to keep the data in the very inefficient format you've defined i
On 2022-01-11 06:31, NArshad wrote:
-“How are the relevant cells identified in the spreadsheet?”
The column headings are:
BOOK_NAME
BOOK_AUTHOR
BOOK_ISBN
TOTAL_COPIES
COPIES_LEFT
BORROWER’S_NAME
ISSUE_DATE
RETURN_DATE
-“It's often the case that the cells on the first row contain text as column
*** Going back to the post in the thread as I've other concerns (and
have turned off the old X-NoArchive setting ***
On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad
declaimed the following:
>All this is going to be in python’s flask and HTML only
>
>1. First, I have to check in
-“How are the relevant cells identified in the spreadsheet?”
The column headings are:
BOOK_NAME
BOOK_AUTHOR
BOOK_ISBN
TOTAL_COPIES
COPIES_LEFT
BORROWER’S_NAME
ISSUE_DATE
RETURN_DATE
-“It's often the case that the cells on the first row contain text as column
labels.”
These I have written above
*** Apologies for the repost. Since Gmane made the list a read-only
group, I finally broke down and reinstated Giganews comp.lang.python.
Unfortunately I'd missed that this came back with X-NoArchive active and
Google doesn't even let such messages show up for a day -- so the OP hasn't
see
On 2022-01-10 16:39, NArshad wrote:
Using openpyxl is pretty straightforward:
from openpyxl import load_workbook
wb = load_workbook(spreadsheet_path)
sheet = wb.active
# Reading the values in cells:
print('Cell A1 contains', sheet['A1'].value)
print('Cell A2 contains', sheet['A2'].value)
prin
Using openpyxl is pretty straightforward:
from openpyxl import load_workbook
wb = load_workbook(spreadsheet_path)
sheet = wb.active
# Reading the values in cells:
print('Cell A1 contains', sheet['A1'].value)
print('Cell A2 contains', sheet['A2'].value)
print('Cell B1 contains', sheet['B1'].valu
On 09Jan2022 13:08, Dennis Lee Bieber wrote:
>>Only the four functions that I have written below I have to make and
>>that’s it. All the input will be entered by the user on a website:
>>1. First, I have to check in the Excel sheet or table whether the book user
>>has entered is present in the b
: Re: What to write or search on github to get the code for what is
written below:
On Sun, 9 Jan 2022 08:53:58 -0800 (PST), NArshad
declaimed the following:
>
>I cannot change the column names.
>
But you can change the values under those columns? And that implies...
>
>
>N
On 2022-01-09 13:08:51 -0500, Dennis Lee Bieber wrote:
> there are multiple ways to have Python access Excel -- from simple
> read and write modules xlrd/xlwt, (which is out-dated; xlrd does not
> work with .xlsx format, only the older .xls format).
This is not true. xlrd has supported .xlsx since
On 2022-01-09 07:04, NArshad wrote:
On Friday, 7 January 2022 at 02:59:17 UTC+5, alister wrote:
On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad wrote:
> All this is going to be in python’s flask and HTML only
>
> 1. First, I have to check in the Excel sheet or table whether the book
> user
-Whose time??
My time
I do not have not time to switch to a database but if necessary I can use the
database to make changes in Excel column entries.
-No changes??
I cannot change the column names.
-“maybe the point is that at any time one has to be able to re-export to the
original excel
On Sun, 9 Jan 2022 08:53:58 -0800 (PST), NArshad wrote:
> -Whose time??
> My time I do not have not time to switch to a database but if necessary
> I can use the database to make changes in Excel column entries.
>
> -No changes??
>
> I cannot change the column names.
>
>
> -“maybe the point is
On Sat, 8 Jan 2022 23:04:20 -0800 (PST), NArshad wrote:
> On Friday, 7 January 2022 at 02:59:17 UTC+5, alister wrote:
>> On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad wrote:
>>
>> > All this is going to be in python’s flask and HTML only
>> >
>> > 1. First, I have to check in the Excel sheet
On Friday, 7 January 2022 at 02:59:17 UTC+5, alister wrote:
> On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad wrote:
>
> > All this is going to be in python’s flask and HTML only
> >
> > 1. First, I have to check in the Excel sheet or table whether the book
> > user has entered is present in
ost of the work and is just stuck somewhere, I,
personally, feel no need to offer any guidance.
-Original Message-
From: Chris Angelico
To: python-list@python.org
Sent: Fri, Jan 7, 2022 2:57 pm
Subject: Re: What to write or search on github to get the code for what is
written below:
O
On 2022-01-06 18:55, NArshad wrote:
All this is going to be in python’s flask and HTML only
1. First, I have to check in the Excel sheet or table whether the book user has
entered is present in the book bank or not.
2. If a book is present and the quantity of the required book is greater than
On Sat, Jan 8, 2022 at 6:50 AM NArshad wrote:
> - All functions mentioned above are to be deployed on the website
> pythonhow.com so make according to
> https://pythonhow.com/python-tutorial/flask/web-development-with-python-and-flask/
>
> - Do you know any other websites to deploy a python web
On Thu, 6 Jan 2022 10:55:30 -0800 (PST), NArshad wrote:
> All this is going to be in python’s flask and HTML only
>
> 1. First, I have to check in the Excel sheet or table whether the book
> user has entered is present in the book bank or not.
>
Excel is the wrong application for storing this da
All this is going to be in python’s flask and HTML only
1. First, I have to check in the Excel sheet or table whether the book user has
entered is present in the book bank or not.
2. If a book is present and the quantity of the required book is greater than 0
(COPIES_LEFT column in excel file)
61 matches
Mail list logo
