pyright

 I had a project where I needed to generate some draft emails programmatically in Outlook. Inserting the company logo and some content related images took some googling to sort through. Ideally...

http://pyright.blogspot.com/2021/08/embedding-image-in-outlook-email.html

A while back I did a post on using sqlcmd and dumping data to Excel .  At the time I was using Microsoft SQL Server's bcp (bulk copy) utility to dump data to a csv file. Use of bcp is blocked ...

http://pyright.blogspot.com/2017/12/powershell-encoded-command-sqlcmd-and.html

This is another simple but common problem in certain business environments: 1) Data are presented via a Microsoft SQL Server Reporting Services report, BUT 2) The user wants the data in Exce...

http://pyright.blogspot.com/2017/02/filling-in-missing-grouping-columns-of.html

In engineering and business environments, it is common to have to 1) recreate an equivalent calculation in a different format for a different purpose and check the results against the original ...

http://pyright.blogspot.com/2017/02/crude-testing-of-equivalent-code-with.html

Lately I had another Excel-VBA-Python one off hack project.  Once again there was the dilemma of not being able to use MSSQL's bcp because my query string was too long.  sqlcmd can run a query ...

http://pyright.blogspot.com/2016/08/sqlcmd-faux-csv-dump-and-parsing-with.html

I have some mining drill hole data that I need to merge into an old vendor FORTRAN input format.  Basically I do a series of SQL pulls from the drillhole database to csv files, then merge the da...

http://pyright.blogspot.com/2016/07/using-generators-and-coroutines-to.html

I have a set of multi-GB Windows folders that I need to archive in 7-zip format each month.  I'd prefer not to use the mouse to compress the folders "manually."  Also, I didn't want to use t...

http://pyright.blogspot.com/2016/04/7-zip-jbinding-api-with-jython-on.html

Last post I brute forced the storage of binary image (jpeg) data as text in a Postgresql database, and accordingly brute forced the data's display in the Unix image viewer feh from output from a...

http://pyright.blogspot.com/2015/12/improved-storing-and-displaying-images.html

Last post I set up a toy (literally) Postgresql database for my model train car collection.  A big part of the utility of the database is its ability to store images (pictures or photos) of the...

http://pyright.blogspot.com/2015/10/storing-and-displaying-images-in.html

This isn't a Python scripting post, but the next one will be on the same topic.  In this post I get a Postgresql database set up on my OpenBSD laptop and get familiar with the Postgresql environ...

http://pyright.blogspot.com/2015/10/setting-up-toy-postgresql-database-on.html

A couple months back I had a one-off assignment to dump some data from a vendor provided relational database to a csv file and then from there to Excel (essentially a fairly simple ETL - extract,...

http://pyright.blogspot.com/2015/09/mssql-sqlcmd-bcp-csv-dump-excel.html

This is not a Python-related post per se, but it may be useful to people getting started with UNIX-based, open source software, or even a Windows user who happens to be using a Thinkpad X201 lapt...

http://pyright.blogspot.com/2015/05/lenovo-thinkpad-x201-fan-replacement.html

I've blogged previously about getting information off of a distant server on my employer's internal SharePoint site.  Automating this can be a little challenging, especially when there's a chan...

http://pyright.blogspot.com/2015/03/ie-and-getting-text-file-off-web.html

The other day I saw a something retweeted by @leppie (I think) about an experimental hyper-fast vector math driven 3D engine for the dot Net Framework.  This led me to investigate whether there...

http://pyright.blogspot.com/2014/11/polygon-offset-using-vector-math-in.html

A few years back I did two or three posts on polygon offset.  It was a learning experience that I never quite completed to my satisfaction.  A kind visitor to my last post on the subject, Mr. ...

http://pyright.blogspot.com/2014/11/polygon-offset-with-pyeuclid-revisited.html

I am returning from MeetBSD in San Jose, California.  This isn't a Python-related post per se, but the BSD family of operating systems maintains packages and ports for Python and Python thi...

http://pyright.blogspot.com/2014/11/meetbsd-california-2014-recap.html

The post immediately prior to this one was an attempt to reproduce Windows.Forms Calendar controls in Gtk for cross platform (Windows/*nix) effective rendering. This time I am attempting to get...

http://pyright.blogspot.com/2014/10/gtktreeview-grid-view-with-mono-gtk.html

A number of years ago I did a post on the IronPython Cookbook site about the Windows.Forms Calendar control .  I could never get the thing to render nicely on *nix operating systems (BSD family)...

http://pyright.blogspot.com/2014/10/mono-gtk-sharp-ironpython-calendarview.html

Each month I redo 3D block model interpolations for a series of open pits at a distant mine.  Those of you who follow my twitter feed often see me tweet, "The 3D geologic block model interpolati...

http://pyright.blogspot.com/2014/10/subprocesspopen-or-abusing-home-grown.html

A mining bud Jen wrote a blog post lamenting the difficulty of learning a foreign language as an adult in a far off land.  This inspired me to clean up my "download the Foreign Service Institut...

http://pyright.blogspot.com/2014/10/downloading-bunch-of-mp3s-off-internet.html

I managed to squeeze in a 4 day stop in Johannesburg on a recent trip that happily coincided with pycon.za.  I love pycon.us and all the other big conferences, but for value, these smaller loca...

http://pyright.blogspot.com/2014/10/event-report-pyconza.html

I blogged before about PyPDF2 and some initial work I had done in response to a request to get a report from Microsoft SQL Server Reporting Services into PDF format.  Since then I've had better...

http://pyright.blogspot.com/2014/09/pdf-removing-pages-and-inserting-nested.html

At work we use Internet Explorer 9 on Windows 7 Enterprise.  SharePoint is the favored software for filesharing inside organizational groups.  Our mine planning office is in the States; the min...

http://pyright.blogspot.com/2014/08/internet-explorer-9-save-dialog.html

I'm working with a report published with SQL Server Reporting Services (SSRS).  The report is located on a remote server in Africa.  It is inconvenient for management in North America to view t...

http://pyright.blogspot.com/2014/03/editing-pdf-file-with-python-with.html

A twitter acquaintaince @zippy1981 recommended the Window's software LogParser as a replacement for MSSQL bcp for my data transfer needs.  I downloaded the msi file from Microsoft and tried to...

http://pyright.blogspot.com/2014/03/windows-logparser-install-without-admin.html