Wednesday, December 5, 2018

Get to Any Google Cached Page

I needed to read a post that had been deleted and see all the pages in the thread. Even if you click the link in the cached version, it does not link to the cached version of that link, but the live version. To get to any google cached page you can enter the following:

You can access the cached version for any page that has been saved by Google with this:
http://webcache.googleusercontent.com/search?q=cache:http://example.com/
Change http://example.com/ to any URL. You can also create a custom search engine on Chromeor a Firefox keyword to go to cached versions automatically by adding a keyword before the current URL address.
 Source: link

Thursday, November 29, 2018

Outlook 2016 Search Does Not Find Recent Emails

Had an issue where the search feature was not finding mails earlier than "Two Weeks Ago" solved with the following link

  • File > Account Setting
  • Then under the email tab click on the email account and select Change...
  • Uncheck the box for "Use Cached Exchange Mode".
  • Click Next and finished.
  • Close and restart Outlook.
  • It should now bring up recent emails

Sunday, November 11, 2018

Powerpoint 2016 Flashes Table Before It Appears

This is not a post with a solution, just noting I'm not the only one seeing it: https://answers.microsoft.com/en-us/msoffice/forum/all/table-flashes-in-powerpoint-2016-presentation/214e3675-eacb-4a5d-89e1-2c001f53dbc4

Monday, November 5, 2018

Display or Hide Zero Values in Excel

Annoying issue where when I changed the formatting to Scientific, all the blank cells became 00E00. I didn't want that crowding my spreadsheet.

Solution:
  • File > Options > Advanced 
  • Under Display options for this worksheet, select a worksheet, and then do one of the following:
    • To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
    • To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.
Source

Thursday, August 2, 2018

Github Backup for Organization with Script

I'm not a github wizard, but I needed to backup the repos on our organization by cloning them all, where most of the repositories are private. After playing around I found a script that would work in the windows git console below. The text in read is what you change.

  1. Go to: https://github.com/settings/tokens and generate a personal access token. Make sure you write it down because it will disappear afterwards
  2. In the below code, orgname is the name of your organization, and your_access_token is the token you just generated, you will also need to run it for each page.

CNTX=orgs; NAME=orgname; ACCESS_TOKEN=your_access_token; PAGE=1
curl "https://api.github.com/$CNTX/$NAME/repos?page=$PAGE&per_page=100&access_token=$ACCESS_TOKEN" |
  grep -e 'clone_url*' |
  cut -d \" -f 4 |
  xargs -L1 git clone

Echo Dots Not Turning On After Switching Location, Solid Blue Ring

When I moved, my Echo Dots were only giving me a solid blue line instead of activating. Turns out you really need to use the USB cables that come with them. I had tried to use some random ones that were lying around.

Comcast Xfinity Illogical Equipment Transfer

Long story short, I moved from one location to another and tried to use my modem. Because Comcast services are incredibly unhelpful, instead of allowing me to use my original account, they made me create a new account and transfer the credentials. When they removed my modem off my old account and I tried to activate the services at the new location they got 'illogical equipment transfer'

I spent over an hour on the phone with them not being able to figure it out. This is more or less the same issue documented on reddit here, they wanted me to drive to a service center and have it scanned :(

The solution? Use the Chat tool! The person in the chat window managed to resolve the problem in like 15 min.