วีดีโอ

What is the error message you are getting ? Which line of code you are getting the error ?

Glad you found it helpful!

If you have installed python and reportlab then the code should work, are you running the code and what is the error message you are getting in your firend PC ? Since you have python and reportlab in your friend PC , so try to run any basic code and see how it is working. YOu must be getting error message when PDF generation fails.

@@plus2net1 I haven't encountered any error messages. I will try to run the basic code as you suggest.

@@Subagyo-Tepil Here the code is keept simple for better understanding , some changes like path to generate output and save file is bound to change at different system. So these steps will generate error message if not take care. So better is to check the error generated and then work on it.

@@plus2net1 Thank a lot for more detail explanation.

ok , we will include that next, thanks

​@@plus2net1thanks mister❤❤❤❤

NotebookLM , notebooklm.google.com/

Got this sample and it is working .... from reportlab.lib.pagesizes import letter from reportlab.lib import colors from reportlab.platypus import SimpleDocTemplate, Table, TableStyle from reportlab.pdfgen import canvas my_path='E:\\testing\\my_pdf\\my_pdf7.pdf'# file path # Define a custom draw method def draw_on_canvas(canvas_obj): # Draw custom elements canvas_obj.setFont("Helvetica-Bold", 14) canvas_obj.drawString(100, 750, "Custom Drawing Above the Table") canvas_obj.setFillColor(colors.red) canvas_obj.rect(50, 700, 500, 20, fill=True, stroke=False) # Create the PDF document pdf = SimpleDocTemplate(my_path, pagesize=letter) # Define the table data data = [ ['ID', 'Name', 'Age', 'City'], ['1', 'Alice', '30', 'New York'], ['2', 'Bob', '25', 'Los Angeles'], ['3', 'Charlie', '35', 'Chicago'] ] # Create the table table = Table(data, colWidths=100) table.setStyle(TableStyle([ ('BACKGROUND', (0, 0), (-1, 0), colors.grey), ('TEXTCOLOR', (0, 0), (-1, 0), colors.whitesmoke), ('ALIGN', (0, 0), (-1, -1), 'CENTER'), ('FONTNAME', (0, 0), (-1, 0), 'Helvetica-Bold'), ('BOTTOMPADDING', (0, 0), (-1, 0), 12), ('BACKGROUND', (0, 1), (-1, -1), colors.beige), ('GRID', (0, 0), (-1, -1), 1, colors.black) ])) # Combine the table and custom drawing class CustomDocTemplate(SimpleDocTemplate): def onFirstPage(self, canvas_obj, doc): draw_on_canvas(canvas_obj) # Call the custom draw method # Add the table to the story story = [table] # Generate the PDF pdf = CustomDocTemplate(my_path, pagesize=letter) pdf.build(story)

In ReportLab, you can define a custom page size by specifying a tuple containing the width and height in points (1 point = 1/72 inch). To set the page size to a width of 595 and a height of 841 points, you can create a custom size like this: # Custom page size: width=595, height=841 custom_size = (595, 841) c = canvas.Canvas(my_path,bottomup=1,pagesize=custom_size)

​@@plus2net1 Okay but what is the number type width and height in pixels or cm or mm or inch?

@@sam_100ali_10 All dimensions can be used. Try different dimensions like this . from reportlab.lib.units import inch from reportlab.lib.units import inch, cm, mm # Set up a canvas with A4 dimensions in points c = canvas.Canvas("dimensions_example.pdf", pagesize=(21*cm, 29.7*cm)) # A4 size in cm

Glad to know that, thanks. BTW I have also done some changes on how to manage cusomization and adding those in next Video. If possible send me the link of your Video. Thanks.

Not tried before but before hand we can calculate the size or end point of the page by considering the font family used, font size and number of lines etc. Height of all components are know before so end point can be calculated. Let us know what you think.

@@plus2net1 thank a lot for response

All details are tehre in this page. www.plus2net.com/python/tkinter-listbox.php To read the selected element ( lb1 is the listbox here ) print(lb1.get(tk.ACTIVE)) # The selected element Or for multiple selection. selected_indices = lb1.curselection() # index of selected print(selected_indices) # the tuple with selected index print(lb1.get(selected_indices)) # value Let us know if you are facing any issue here.

Glad to know you like it, thanks

You're welcome

That problem will be anyway there and depends on the application ( amount of data generated at a time ) and database used. SQLite is not for big applications or more storage. Time to time data can be shifted or archived to relieve the active tables.

The limitation here is html can't receive the data submitted to server side, some backend script is required. Here in this case PHP is used but any other server side script can handle this. No need to learn one complete language to handle . The key is how data is submitted to server end from the front end html code.

thanks

Sorry , not worked in these area...

Windows often flags shared .exe files as potential viruses because of security measures designed to prevent harmful software. Executable files can modify system files or install malware, so Windows and antivirus programs are cautious with unknown or unsigned code. Sharing an .exe without a digital signature or from a new source increases the chance it will be flagged, as reputation-based systems favor widely recognized files. To avoid this, you can sign your application, compress it into a .zip or .rar file, or share it with clear instructions in a secure cloud folder.

@@plus2net1 How can I have the application signed? Is it also possible to create a setup instead of an .exe file?

@@autarroy You can get a code-signing certificate from a trusted Certificate Authority (CA) like DigiCert, Sectigo, or GlobalSign. Once you have the certificate, it will include a .pfx file containing your private key and digital certificate. To add a setup or installation package for an .exe or application file created using PyInstaller, you can use a tool like Inno Setup, NSIS (Nullsoft Scriptable Install System), or Advanced Installer. I have not tried these tools , but as we are working more on application development, we will try to explore these areas in future.

I hope you can make soon as possible a video. NOT WITH EXE FILE because will get the same problem.

Sir do u have any updates? I have a question: Sir, I have a small application. I want my total stock to also appear on my main screen and I can't do that. Could you help me how to do it?

Code is available here. www.plus2net.com/python/tkinter-Toplevel-data.php

Ok, we will try to create another version of this with more examples.

Glad to know that, thanks, the next part is integrating database with the application, this we will upload shortly. The detail code is here. www.plus2net.com/python/tkinter-pyinstaller-sqlite-bundle.php

by mounting the drive you can upload to the folder. Details about the mounting is here. www.plus2net.com/python/colab.php

You're welcome, glad you found it helpful.

Thanks

Thanks .

Gald to know, thanks

Sure, which database you are using ? You can drop me a message here. www.plus2net.com/contactus.php

Yes

Not sure what you mean by url change but data of child window can be tracked from parent window. See this demo. Data entered in child will be available in parent. www.plus2net.com/javascript_tutorial/window-child3-demo.php Reading the value of child window ( in parent window ) opener.document.f1.p_name.value = document.frm.c_name.value;

Can use pady to maintain gap from top and bottom. widget.grid(row=0, column=0, pady=20) # Adds padding to increase row height or use rowconfigure(), details are here. www.plus2net.com/python/tkinter-rowconfigure.php At the end of this page ... minsize ensures that rows or columns do not shrink below a specified size, even when the window is resized. Please let us know the outcome.

the code to work on MySQL is same, only the connection string changes. In colab platform you can't get MySQL database however you can take one cloud account in google and work on MySQL. OR use the same code in your local machine with MySQL and use the same code. Only change required in connection string. Let us know if you need any thing here.

Glad to know you like it, thanks.

Glad you liked it

Thanks

yes, that is a good idea, now few more are already uploaded, the next group is on MySQL and we will include this . Thanks.

Link is at description

This should work SELECT id, name, class,( social + science + math) AS total FROM student_sum Full details are here . www.plus2net.com/sql_tutorial/sql_sum-multiple.php

thanks

thanks,

Glad to know that, thanks.

sure, working on it.

th-cam.com/video/shA1w8-IXRA/w-d-xo.html Source code here. www.plus2net.com/python/tkinter-pdf.php

Achaa nahi Ata, Bahutu english words a jata hein boleneka smaye.

Sorry, I have no idea on this.