Subscribe: Karl's Place
http://blogs.kranich.org/karl/feed/
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
api access  api  appeared karl  appeared  google sheets  google  karl place  karl  place  sheets api  sheets  solved  windows 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Karl's Place

Karl's Place



Technology, DIY, etc



Last Build Date: Sun, 25 Feb 2018 19:35:27 +0000

 



Solved: Mac option key not working on Nixeus MODA Pro keyboard

Sun, 25 Feb 2018 19:35:27 +0000

There are plenty of articles and Youtube videos showing how to switch the Option and Command keys when you adapt a PC keyboard for use on the Mac.  (System Prefs – Keyboard – Modifier Keys – Choose the correct keyboard, then switch Command and Option). But even after doing that, the Options key wouldn’t work.  […]

The post Solved: Mac option key not working on Nixeus MODA Pro keyboard appeared first on Karl's Place.




iPhone tip: disable the extra click needed to unlock your phone

Mon, 24 Oct 2016 15:00:58 +0000

In a recent iOS update, Apple started requiring an extra click of the home button to unlock your iPhone, instead of just allowing a “click with finger resting on Touch ID” to unlock the phone.  It’s not a big change, but just different enough to be frustrating. To go back to the original behavior, go […]

The post iPhone tip: disable the extra click needed to unlock your phone appeared first on Karl's Place.




How to move a Windows EC2 instance to another AWS account

Fri, 16 Sep 2016 01:37:30 +0000

Here are the steps that I’ve used to move some Windows Server EC2 instances to a different AWS account.  This method should work for any OS, but I’ve only tested with Server 2008 R2. The simple version: In the source account, stop the instance Make a snapshot of the instance’s system volume Share the snapshot with […]

The post How to move a Windows EC2 instance to another AWS account appeared first on Karl's Place.




Ultimate Guide to Google Sheets

Fri, 29 Jul 2016 13:04:14 +0000

Zapier has published a free ebook called The Ultimate Guide to Google Sheets, and it mentions my “Insert and Delete Cells” Sheets Add-on! The book takes readers first through a detailed Google Sheets tutorial, then dives into deeper features that help readers build their own custom tools and apps using Google Sheets’ most powerful features. […]

The post Ultimate Guide to Google Sheets appeared first on Karl's Place.




Sheets API access with PHP part 5: Querying rows

Sun, 06 Mar 2016 01:24:52 +0000

The Google Spreadsheets API allows you to send simple queries to retrieve subsets of the rows in your sheet – it’s as easy as appending the query to the end of the URL. For example, if I have a column called “Quantity” and want rows with Quantity greater than 9, I would append ?sq=quantity>9 to the end […]

The post Sheets API access with PHP part 5: Querying rows appeared first on Karl's Place.




SNI with Rackspace Load Balancers: racklb.sh script

Fri, 04 Mar 2016 00:55:57 +0000

The Rackspace web dashboard allows you to attach a certificate and private key to a cloud load balancer for ssl offloading.  But even though the load balancers support SNI and multiple certificates, neither the web console nor the “rack” command line scripts expose this functionality. If you want to attach additional certificates to a load balancer […]

The post SNI with Rackspace Load Balancers: racklb.sh script appeared first on Karl's Place.




Solved: cURL error 60 with Sheets API access from Windows

Mon, 22 Feb 2016 00:56:27 +0000

It turns out that my Google Sheets API instructions don’t work right away on Windows.  People running WAMP or XAMPP have been reporting “cURL error 60: SSL certificate problem: unable to get local issuer certificate”. For some reason, cURL on Windows doesn’t come with a certificate bundle, so it can’t verify Google’s certificate to establish a […]

The post Solved: cURL error 60 with Sheets API access from Windows appeared first on Karl's Place.




Sheets API access with PHP part 4: Editing Cells

Sat, 16 Jan 2016 20:29:48 +0000

Here’s how to get up to speed with the Google Sheets cell-based feed and PHP. My previous posts have illustrated the use of Google’s PHP API client to interact with Google Sheets using list-based feeds.  This method is ideal for reading from and writing to spreadsheets that have a single header row, but isn’t useful […]

The post Sheets API access with PHP part 4: Editing Cells appeared first on Karl's Place.




Parsing Google Sheets data with PHP’s SimpleXML

Sun, 10 Jan 2016 22:24:27 +0000

AKA: Sheets API access with PHP part 3 Continuing my series on using PHP to manipulate Google Spreadsheets, I’ve added a section to my code that reads the XML representation of a spreadsheet and then parses out the rows and columns.  Note that whenever you’re working with list-based feeds, we’re assuming that the first row contains […]

The post Parsing Google Sheets data with PHP’s SimpleXML appeared first on Karl's Place.




Solved: How to Map a Drive from Windows 10 to OS X 10.10.5 Yosemite Server

Fri, 13 Nov 2015 20:59:04 +0000

We have an increasing number of Windows 10 machines in our office, and realized that we couldn’t get them to connect to shares on our OS X 10.10.5 (Yosemite) server.  We have a bunch of Local Network Users, and had no problem connecting as them from Windows 7 machines.  But Windows 10 machines would just pop […]

The post Solved: How to Map a Drive from Windows 10 to OS X 10.10.5 Yosemite Server appeared first on Karl's Place.




Google Updates PHP API Client

Wed, 04 Nov 2015 21:46:18 +0000

Yesterday I updated my example PHP code for manipulating Google Spreadsheets with the Google-provided PHP API client.  If you tried getting it to work recently and were frustrated, take another look.  Google made major changes to the client that required changing my code. Very soon I hope to figure out and demonstrate Google’s new Execution […]

The post Google Updates PHP API Client appeared first on Karl's Place.




Create a Video DVD with DVD Flick

Fri, 16 Oct 2015 16:34:17 +0000

Every once in a while I need to create a video DVD that will work in a standard DVD player.  With Windows 10, Microsoft no longer provides Windows DVD Maker, so I needed to find a replacement. DVD Flick does the job quickly and easily.  It’s simple to add titles (individual videos), add regularly spaced […]

The post Create a Video DVD with DVD Flick appeared first on Karl's Place.




Solved: Vostro 3550 black screen with Windows 10

Mon, 24 Aug 2015 01:38:12 +0000

A friend brought over his Dell Vostro 3550 that he’d just upgraded to Windows 10. After the upgrade, the machine would show the spinning dots of the Windows 10 boot, but then go to a black screen before the login screen showed up.  External displays worked fine, but some exploration with an external display showed […]

The post Solved: Vostro 3550 black screen with Windows 10 appeared first on Karl's Place.




Sheets API access with PHP part 2: Editing Rows

Sat, 22 Aug 2015 01:52:00 +0000

My previous Sheets API post demonstrated how to add rows to Google Sheets with PHP.  Some readers were interested in editing or deleting rows. Google has a very informative reference here that describes the list-based feed for manipulating sheets.  All of my scripts have been using this method, which requires the sheet to have a single […]

The post Sheets API access with PHP part 2: Editing Rows appeared first on Karl's Place.




Dreaded Google Apps error: “We’re sorry, a server error occurred. Please wait a bit and try again.”

Fri, 21 Aug 2015 01:50:27 +0000

People who use my Insert and Delete Cell Add-on for Google Sheets have been reporting this error.  I was unable to recreate the error until someone shared a spreadsheet with me and I found the culprit: merged cells. What’s going on? When you insert cells and shift the existing contents down, my Add-on selects the […]

The post Dreaded Google Apps error: “We’re sorry, a server error occurred. Please wait a bit and try again.” appeared first on Karl's Place.




Google Sheets API access with PHP

Fri, 17 Apr 2015 01:33:26 +0000

Note on 8 February 2017: Google has released the Sheets API v4 and is now providing PHP sample code and improved PHP support for Sheets in the PHP API client.  My series of articles is now largely obsolete.  See https://developers.google.com/sheets/api/quickstart/php ========================== Google has been sending out messages saying that several of their APIs are going to be […]

The post Google Sheets API access with PHP appeared first on Karl's Place.




Solved: “ORA-28001: the password has expired” on Windows 8.1

Wed, 18 Feb 2015 00:11:44 +0000

While working with the development version of a document library that uses Oracle for storage on a Windows 8.1 laptop, we ran into the error “ODBC error: [Oracle][ODBC][Ora]ORA-28001: the password has expired”. It turns out that up until Oracle 10, the default password policy was no password expiration.  Starting with Oracle 11, there is a […]

The post Solved: “ORA-28001: the password has expired” on Windows 8.1 appeared first on Karl's Place.




Solved: How to recreate the recovery partition on OSX Mavericks after a time machine restore to a blank drive

Sat, 14 Jun 2014 18:22:57 +0000

My Macbook Pro (mid-2009) hard drive crashed a few weeks ago.  Since I had a current Time Machine backup, I figured that it would be super-simple to install a new hard drive and do a restore.  Well, it wasn’t as simple as I’d hoped. After installing a new solid state drive (all you need is […]

The post Solved: How to recreate the recovery partition on OSX Mavericks after a time machine restore to a blank drive appeared first on Karl's Place.




How to Insert and Delete Cells from Google Spreadsheets

Fri, 02 May 2014 13:59:58 +0000

[update on 9/24/2014:  This has now been published as a Google Add-on.  Please see this page.  To install the Add-on, just search for “insert cells” when browsing for Add-ons from Google Sheets] I haven’t been able to find a way in Google Spreadsheets to insert a cell (or cells) in the middle of a spreadsheet […]

The post How to Insert and Delete Cells from Google Spreadsheets appeared first on Karl's Place.




Google Apps Script to monitor an email box and send notifications

Fri, 21 Mar 2014 22:58:13 +0000

Here’s the scenario: you have a second gmail account that gets email infrequently, but you need to monitor it.  For whatever reason (company policy, in my case), you can’t forward the email to your main account. I discovered that I could log into the second Google account and attach a Google Apps Script to a […]

The post Google Apps Script to monitor an email box and send notifications appeared first on Karl's Place.