I've recently been toying with Qt5. I'm in a position where I am not allowed to show you what I'm working on. So once this all comes together, I'll start making mini apps and explain, as well as show you, exactly what I'm doing. Just give me time. I'm currently out of my element with the tools that I'm using right now. But they're coming together nicely and I'm excited to talk about them on a personal level outside of work.

The project I am working on will use Qt5 for the graphical interface. This way any user who needs to generate this specific report can without having to run the script from a command line. This Python app will utilize PyODBC and OpenPyXl as well as other components within the Standard Library that aren't worth mentioning on the back-end.

The data generated will output to a Microsoft Excel Spreadsheet that will interpret that data and output it to Pivot Tables and Pivot Charts which in return will use Slicers allowing the end user to, in a sense, query the data. Thus, making the output very visual and pleasing to the eye.

I cannot show the output as it contains private data. Once finished, I'll make another post showing the process using some dummy data.



This image is so great that I am more than happy to share the cause, FlashDrivesForFreedom


I need to get my hands on a Summer Convention, Limited Edition, Rat Fink by Funko. These turned out awesome and I want one!

Rat Fink (Funko Pop)


I utilize the Brave web browser on all of my PC's (Linux, Mac, and Windows) as well as on all of my mobile devices. It's fast, safe, secure, and follows W3C standards for a better viewing experience. I highly recommend watching the below interview with, Yan Zhu (BCRYPT) and consider giving Brave a try!


Microsoft PowerShell

I've used PowerShell in the past on projects at work. Mainly searching through multiple documents looking for certain patterns and outputting the files that matched those patterns. This week I had a task of pulling 154 records out of a document that had 156,000 records total. The script would then need to write those 154 records to a new text file keeping the exact same format as they were in the original document.

I originally thought about doing this with Python but I wanted to try with PowerShell. With the help of online docs and PowerShell's help pages I was able to piece together the code to do this in about 10 lines. I loaded the entire file into a variable first. I then used a foreach loop to loop through each line/row of that variable. Within that loop I had another foreach loop looping through each word in that line comparing them against an array containing the 154 unique keys. If one of those keys was located on the current line of the cursor it would output that line to a text file and append it to the end of the file if data was currently in it.

This ran in under a minute and worked beautifully. I must say PowerShell is definitely a step in the right direction for Microsoft. Working on a command line and having many tools available to me really made me feel as if I were back working on one of my Linux workstations.

I highly recommend PowerShell for developers working in a Microsoft Windows environment. Especially if you're working with large amounts of data.

Page: 1  2  3  4  5