Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Output SQL to csv or xls file?
Post: RE: Output SQL to csv or xls file?

Thank you for getting back to me. This is probably my 20-25th try just to get sql results into a .csv, and unfortunately, I don't keep code after continuous failures (at some point I have to go back ...
JP_ROMANO General Coding Help 4 2,580 Aug-02-2019, 01:58 AM
    Thread: Output SQL to csv or xls file?
Post: RE: Output SQL to csv or xls file?

Thank you, I have read through as much of the csv documentation as I can find, but I cannot get it to work. Literally every time I run it, I fix some syntax error, then get another one. It seems tha...
JP_ROMANO General Coding Help 4 2,580 Aug-02-2019, 01:33 AM
    Thread: Output SQL to csv or xls file?
Post: Output SQL to csv or xls file?

Hi, Have a bit of code that runs a sql query - can't seem to get it to output to a .csv or an .xlsx file. Any help is appreciated The window has several buttons, each of which should generate a repo...
JP_ROMANO General Coding Help 4 2,580 Aug-01-2019, 11:13 PM
    Thread: Pyinstaller failing
Post: RE: Pyinstaller failing

3.5 - I got an answer (or somebody helping me) on that link I noted in my original posting - so please don't waste any time - if it gets resolved, I'll post the answer here, and if not, will follow up...
JP_ROMANO General Coding Help 2 4,053 Jan-16-2019, 06:07 PM
    Thread: Pyinstaller failing
Post: Pyinstaller failing

Hello ... Finally finished a script that I want to convert to .exe using Pyinstaller, as I've done in the past. However, when I run it, the same way I had before, I get the following error "Attribu...
JP_ROMANO General Coding Help 2 4,053 Jan-16-2019, 05:28 PM
    Thread: 2 buttons to run 2 different functions?
Post: RE: 2 buttons to run 2 different functions?

Just to follow up - I would not recommend using the code I posted above. Not sure if the problem is the script, python itself, the PySimpleGui library, my environment/setup, or the IDE (Spyder). I c...
JP_ROMANO GUI 2 4,179 Jan-10-2019, 02:25 PM
    Thread: 2 buttons to run 2 different functions?
Post: RE: 2 buttons to run 2 different functions?

I think I figured it out. Will post here for anybody else who may stumble upon this. The way to get the two buttons to do 2 different function calls is to read the text of those buttons - in my case...
JP_ROMANO GUI 2 4,179 Jan-08-2019, 10:15 PM
    Thread: 2 buttons to run 2 different functions?
Post: 2 buttons to run 2 different functions?

Good day all, It seems like the cleanest, easiest way for me to build a GUI is with PySimpleGui, and it's well underway, but I'm having some trouble getting mutliple buttons do run different function...
JP_ROMANO GUI 2 4,179 Jan-08-2019, 07:33 PM
    Thread: ComboBox example?
Post: RE: ComboBox example?

Nilamo (or anybody else kind enough to get this far) - since I'm just getting started, and am HORRIBLE at python, do you think PySimpleGUI would be a better approach? I'm wide open to suggestions. T...
JP_ROMANO GUI 4 4,461 Jan-07-2019, 06:17 PM
    Thread: ComboBox example?
Post: RE: ComboBox example?

It does indeed, thank you so much
JP_ROMANO GUI 4 4,461 Jan-07-2019, 05:04 PM
    Thread: ComboBox example?
Post: ComboBox example?

Hi all - I have to rebuild a little utility I created because my source code was wiped out, and I cannot extract the original script from the .exe I converted it to. The original tool was built using...
JP_ROMANO GUI 4 4,461 Jan-07-2019, 04:34 PM
    Thread: Count of unique items based on condition
Post: RE: Count of unique items based on condition

FOLLOW UP - sorry I manually opened myfile.csv, deleted the content of 1 column (I did NOT delete the column, and left the header alone). Saved the file with the same filename, in the same location....
JP_ROMANO General Coding Help 3 6,264 Dec-31-2018, 08:11 PM
    Thread: Count of unique items based on condition
Post: RE: Count of unique items based on condition

This is fantastic, thank you! I'm going to try to understand the code a bit more thoroughly, but this is spot on. Really appreciate it!
JP_ROMANO General Coding Help 3 6,264 Dec-31-2018, 07:04 PM
    Thread: Count of unique items based on condition
Post: Count of unique items based on condition

Hello all, trying to convert a VBA/Excel process to use python and am stuck, I think, on the syntax. Any help is appreciated! I have a .csv file that contains about 70k rows and 23 columns (row coun...
JP_ROMANO General Coding Help 3 6,264 Dec-31-2018, 04:32 PM
    Thread: Run interpreter from Network?
Post: RE: Run interpreter from Network?

micseydel - thank you for the feedback and suggestion. I am really, really bad at anything related to python, so the trial and error would probably not be too beneficial as I wouldn't know if any pro...
JP_ROMANO Networking 3 3,765 Nov-13-2018, 07:53 PM
    Thread: Run interpreter from Network?
Post: Run interpreter from Network?

Good day, let me first apologize for any incorrect terminology below. I'm neither a python user nor a network engineer. I hope there is enough detail in my query, but if not, I'm happy to answer wh...
JP_ROMANO Networking 3 3,765 Nov-13-2018, 05:32 PM
    Thread: Read and tokenize doc/docx?
Post: RE: Read and tokenize doc/docx?

Thank you, appreciate that!
JP_ROMANO General Coding Help 10 6,565 Oct-25-2018, 07:32 PM
    Thread: Read and tokenize doc/docx?
Post: RE: Read and tokenize doc/docx?

Lazr60 - thanks for the link, I'll give it a read through when my blood pressure returns to a normal state :-) Buran - thank you, again, for the 4 points, I'll send them over to my coworkers who live...
JP_ROMANO General Coding Help 10 6,565 Oct-25-2018, 07:10 PM
    Thread: Read and tokenize doc/docx?
Post: RE: Read and tokenize doc/docx?

One of the users, who is much more experienced than I am, was able to get past the SSL error, but then ran into another set of exceptions - and the deeper we go, the more problems we see. So, we're g...
JP_ROMANO General Coding Help 10 6,565 Oct-25-2018, 05:32 PM
    Thread: Read and tokenize doc/docx?
Post: RE: Read and tokenize doc/docx?

buran - seems that internal users here in our office get "pip install fails with “connection error: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:598)” when they try to install do...
JP_ROMANO General Coding Help 10 6,565 Oct-25-2018, 05:08 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020