January 27, 2014
I need to write this while it’s semi fresh and frustrating in my mind. Here’s the task I set myself to:
Create a copy of a file in Google Drive using the API from Python 2.7.
Simple, right? This is where experience necessarily tells us that if it sounds too easy, then it is. It turns out this was a huge dilemma that sent me down one of those filthy rabbit holes into an underground warren maze of shit I really didn’t give, uh, a shit about. Anyway, it turned into this crusade:
Authenticate as myself with Google API using OAuth instead of the [deprecated] ClientLogin.
I created a StackOverflow question to this end that has yet to receive any love. And although I’ve come up with a workaround, I have not been able to answer this question myself. If you’re trying to do something similar and wondering how I solved it: service accounts. Someone called this “bureaucracy in API’s” and asked hypothetically “why do I have to fill out so much digital paperwork just to access my own damn files?” Okay, I’m paraphrasing, emphasis added, yadda yadda.
Read the rest of this entry »
January 22, 2014
I’ve had to look this up too many times, so I’m writing it here. If you’re using Excel on a Mac then you can select only visible (filtered) cells with the hotkey combo COMMAND + SHIFT + z. Alternatively, the menu path is Edit > Go To… > Special > Visible Cells Only.
December 29, 2013
After self-publishing my first ebook, I’ve got a taste for it and I started looking at my old projects, listing them out, and evaluating them. One in particular is “Neil’s C++ Stuff” which is a set of tutorials I wrote in 1998. It had its day and I’ve been dragging around its lost fame ever since. This wasn’t a problem a couple years ago when I was approached for text advertising and made a few hundred bucks for pimping a couple of keywords, but the hosting I use costs $200 a year and every time I look at the dwindling visitor stats and nearly zero ad revenue, I wonder why I am still carrying it around. I can’t “just leave it” because it’s dead, it’s history, most of the links are broken, and when I’m evaluating my server logs I see all kinds of garbage surrounding it. A lot of the material is now simply embarrassing as a live web page rather than, hopefully, nostalgic as an archived document.
The earliest version of it I can find is on Archive.org: https://web.archive.org/web/19990224120458/http://www.cyclone7.com/cpp/.
It isn’t sacred and I don’t suppose it’ll be a terrible amount of work, but every time I set out to do this something stops me. I suppose I’m making this blog post to convince myself that it’s time to go ahead and slay this dragon. It would be the first among many, but certainly the harriest. Next to follow would be my tutorial on VSS, Apache2 SSL on Windows, and some others. Why make these things eBooks instead of web pages? Well, they’re not active and StackOverflow.com has the “dear god help me figure this out” market covered with live assistance.
We shall see … I guess to begin with I could start a Word document and go from there. Heck, I could even make it on CreateSpace.
December 27, 2013
There’s always some sort of hell isn’t there?
I was entering data into the massive form at MyIdentifiers.com for my ISBN and one of the questions was about the format of my paperback. Well, I went to CreateSpace and it shows it as 5×8 … great, but Bowker doesn’t list the size it lists the name of the size. So what is the name of the 5×8 size? I have no damn clue but apparently it’s a “C” format? Whatever, I gave up and left that blank.
The current insanity I’m embroiled in is that my novel source is HTML, looks great in the Kindle viewers, and looks like shit in Word. I can only imagine what a PDF would look like. The HTML is clean, I wrote it from scratch so it’s very basic tags plus CSS. You’d think I’d be able to take that and put it into Word or PDF without much trouble at all but I’m having so many problems I don’t know where to begin. The best I’ve been able to come up with is to copy and paste from HTML in Chrome to TextEdit on the Mac and then copy-paste that into Word. I know, that’s fucking crazy and I realize it. The styles are then fucked for life and I’ll have to manually modify the whole thing. That is theoretically very easy with Word’s concept of “Styles” but it keeps slamming my italics because I have whole sections in italics and it thinks “Oh, this was a style so I’ll override it.” Dammit, no! Argh!
I’m just ranting right now, here, so I don’t end up barfing all over Facebook or something like that. I suppose I’ll figure something out eventually. Damn damn damn, I hate this. I just want to have a clean source for my book and generate both Kindle and PDF formats from it. I am actually considering writing my own PDF writer to do it which is super-nutty, but then that’s the problem when you know how to program …
October 10, 2013
I could not find a one-stop post on figuring this out so after fighting my way, tooth and nail, through it, I wanted to give back. Whew, okay, let’s dive in! This is all about setting up a FTP server on an EC2 instance using Microsoft IIS.
Read the rest of this entry »
December 19, 2012
I bought myself an electric typewriter to use for my first draft.