Category Archives: Social Media

Add a Google Calendar to a Facebook Page

 

Adding a public Google Calendar is a great way to present activities in an easily shared fashion.

To add a Google Calendar to your Facebook Page, you will first need a Facebook Page (not a personal profile page) and a Google (Gmail) account.

Create the Google Calendar

Make a public calendar. This can be an existing calendar or one created for this purpose.

Make the Calendar Public

After the calendar has been created, click on the drop-down arrow beside the calendar name and choose Calendar Settings. The Calendar Details page will open.

Click the Share this Calendar link.

The checkbox turning on Public Access
Making a Google Calendar Public

 

Enable the Make this calendar public checkbox.

Click the Save button.

The calendar view will be displayed.

Customize the Calendar HTML Code

Return to the calendar’s details page.

Click on the drop-down arrow beside the calendar name and choose Calendar Settings. The Calendar Details page will open:

finding the HTML to display the Google Calendar
Locate the Embed this Calendar section

Scroll down the page and find the Embed This Calendar section.

Click on the Customize the color, size, and other options link.
A new window or tab will open, the Google Embeddable Calendar Helper:

Google Embeddable Calendar Helper
Google Embeddable Calendar Helper

 A preview of your calendar is visible. You can change the title, default view and other elements of the calendar. The view will update to show you what your calendar will look like when the changes are applied. If you do make changes, be sure to press the UPDATE HTML button to ensure those changes are reflected in the HTML.

Be prepared to copy and paste the HTML code. However, do not do so yet.

Add the iFrames Tab app to your Facebook Page

From your Facebook page go to https://www.facebook.com/StaticHtmlThunderpenny/

Click the Use App link on the left hand side of the page.

The Static HTML: iframe tabs page will appear:

view of Thunderpenny app installation page
Static HTML: iframe tabs, Add Static HTML to a Page

Click the Add Static HTML to a Page button.

The Add Page Tab window will open:

Add Page Tab dialog box
Choose your Facebook Page to add the Page Tab too.

Click on the drop-down Facebook Pages Button and select your Facebook Page.

Click the Add Page Tab button.

You will be routed to the Set Up Tab view. Click the Set Up Tab button.

Follow the instructions in the index.html area

Copy the HTML code that you customized previously for your Google calendar into the index.html area.
Replace the instructions with your code (or the instructions will appear along with your calendar).

The Static HTML customization window.
The Static HTML window. Paste your calendar code here.

Click the Save & Publish button.

Name the Tab

From your Facebook Page, select Settings.

Finding the App Settings after installation
Return to Settings to Name the Tab

Click on the Apps category on the left.

Apps that have been added will be listed on the right.

From the Static HTML: iframe tabs app section, click on the Edit Settings link.

The Edit Static HTML: iframe tabs Settings dialog box will appear:

The Edit Static HTML: iframe tabs Settings dialog box
The Edit Static HTML: iframe tabs Settings dialog box

Enter the name of your calendar in the Custom Tab Name: text box.

Click the Save button.

Click the OK button.

You can also add an image that will appear beside the link on the right hand side of your page.

Additional Ideas

Now the App code has been connected to your Facebook page, additional tabs can be added. Any piece of embeddable HTML code can be used. For example; on-line catalog search code. To add additional tabs, return to the page Settings and select Apps.

Click the Go to App link for the Static HTML: iframe tabs app.

The app will walk you through creating an additional tab.

Woobox has an app called Tweet Feed for Pages, which will embed your Twitter feed into a tab on your page. The concept is similar to embedding a Google Calendar. Woobox’s app will walk you through the process of adding the tab.

Tweet Cruncher

I have a Social Media project on the go (waves at https://twitter.com/librarytrustees) that is going to involve tweeting sections of existing documents.

I really hate counting characters. So I decided it was time to make myself a tool for the job.

Original Document and Result after Tweet Cruncher is run on the selected text
Original Document and Result after Tweet Cruncher is run on the selected text

You can see above what I have; the selected area of the original document is highlighted in varying colours, corresponding to the resulting text broken up into tweets. Additionally, I have inserted my chosen hashtag and a count of the sequence of tweets.

Dialog box for Tweet Cruncher
Tweet Cruncher Dialog

The length of the tweets and the Hashtag are entered in a dialog box when the Tweet Cruncher runs. This information is saved with the document, for consistency with subsequent tweets. The Tweets are not exactly the tweet length; I’ve added a bit of code to “round off” each tweet to whole words. The hashtag and sequence count are additional to the length.

And realistically, there will still be editing for content and meaning. Nevertheless, this tool should save me a ton of counting and get the project going faster.

Sub BreakIntoTweets()
Dim IntSelection As Integer
Dim IntPostNumb As Integer
Dim IntPostCount As Integer
Dim IntCharCount As Integer
Dim IntTweetLength As Integer
Dim rngSelectedRange As Word.Range
Dim strPostText As String
Dim intColourPick As Integer
Dim docNewDoc As Word.Document
Dim docWorkingDoc As Word.Document
Dim strPropertyName As String
Dim strHashTag As String
Dim blnWord As Boolean
Dim intActualLength As Integer

Dim arrColourOptions As Variant
arrColourOptions = Array(wdBrightGreen, wdPink, wdTurquoise, wdYellow)
   
Set docWorkingDoc = ActiveDocument
strPropertyName = "HashTag"
strHashTag = frmStartCrunchingTweets.txtHashTag
docWorkingDoc.CustomDocumentProperties(strPropertyName) = strHashTag
IntTweetLength = frmStartCrunchingTweets.txtTweetLength
Set rngSelectedRange = Selection.Range
MsgBox rngSelectedRange.Characters.Count & " characters are selected. Including Paragraph Marks"
IntSelection = rngSelectedRange.Characters.Count
IntPostNumb = IntSelection / IntTweetLength
MsgBox IntPostNumb

rngSelectedRange.Characters(1).Select
IntCharCount = 1
Documents.Add DocumentType:=wdNewBlankDocument
Set docNewDoc = ActiveDocument
docWorkingDoc.Activate
For IntPostCount = 1 To IntPostNumb
    Selection.MoveRight unit:=wdCharacter, Count:=IntTweetLength - 1, Extend:=wdExtend
    If (Right(Selection.Text, 1) <> " ") Then blnWord = True ' extend to word
    If (Right(Selection.Text, 1) <> ".") Then blnWord = True
    If (Right(Selection.Text, 1) <> "?") Then blnWord = True
    If (Right(Selection.Text, 1) <> vbCr) Then blnWord = True
    If (Right(Selection.Text, 1) <> "!") Then blnWord = True
    If blnWord = True Then
        Selection.MoveRight unit:=wdWord, Count:=1, Extend:=wdExtend
        intActualLength = Selection.Characters.Count
    Else
        intActualLength = IntTweetLength
    End If
    blnWord = False
    strPostText = Selection.Text & frmStartCrunchingTweets.txtHashTag & " " & IntPostCount & "/" & IntPostNumb
    'get rid of any hard returns
    strPostText = Replace(strPostText, vbCr, " ")
    docNewDoc.Activate
    Selection.TypeText (strPostText) & vbCr
    docWorkingDoc.Activate
    intColourPick = IntPostCount - (4 * Int(IntPostCount \ 4)) 'note this is why no base 1 option for array here, also \ means different than / (truncation function)
    Selection.Range.HighlightColorIndex = arrColourOptions(intColourPick)
    IntCharCount = IntCharCount + intActualLength
      On Error Resume Next
    rngSelectedRange.Characters(IntCharCount).Select '(errors on final character of selection)
Next IntPostCount

End Sub

Update: A New Free to use Photo Site

I just came across a new free photo site called https://unsplash.com/  if you are creating visuals for your library’s social media feed, they have great pictures of books and people reading. Perfect for combining pictures and quotes. I was inspired by the picture below:

Books Stacked Everywhere - from unsplash.com
Books Everywhere

So I headed off to the internet to find a quote that I thought was perfect for these random stacks of books.

“The old man was peering intently at the shelves. 'I'll have to admit that he's a very competent scholar.' Isn't he just a librarian?' Garion asked, 'somebody who looks after books?' That's where all the rest of scholarship starts, Garion. All the books in the world won't help you if they're just piled up in a heap.” ― David Eddings, King of the Murgos
Organization – the secret power of Librarians!

Using the tip I mentioned in this post, I combined the text and image into a picture sized for Twitter.

And then because I’d fallen down into the internet quote-hole I used another picture from unsplash and a terrific quote from the always library friendly Neil Gaiman.

“It's still National Library Week. You should be especially nice to a librarian today, or tomorrow. Sometime this week, anyway. Probably the librarians would like tea. Or chocolates. Or a reliable source of funding.” ― Neil Gaiman
We love Neil Gaiman

If you want to look back – I have a previous post on other free graphics sites.

Google Slides vs PowerPoint for Social Media

Over the last few weeks I’ve been sharing tips for using PowerPoint for social media. Which leads naturally to asking about using Google Slides the same way.

And Google Slides offers comparable features; in particular it does support saving slides as JPG’s and custom dimensions.

What doesn’t Slides have? The photo editing tools and artistic filters that come with PowerPoint are not available, so you’ll have to pre-edit in another application.  And you’ll find that your capabilities are limited on the mobile versions of Slides, so you’ll be forced back to the desktop version.

PowerPoint: Make it Fit

I’ve mentioned it before, but PowerPoint can be a handy graphic editing tool. Especially when you want to combine pictures and text. The question is;  how do you get perfectly sized pictures every time?

Most people don’t play with the Page Setup options other than to swap their slides between a 4:3/16:9 ratio. However you can input your own custom dimensions.

Navigate to the Page Setup Dialog box
Make your own Custom Sized PowerPoint Templates

Go to the Design ribbon and open the Page Setup dialog box. The last choice in the Slides sized for drop down is Custom. Once this is selected you can input your own dimensions (within limits). To create the Twitter header photo template, I researched the dimensions of a Twitter header photo (500px by 1500px). Then I used this website to convert the pixel measurement to centimeters. The website also converts to inches, if that is your preferred measurement.

Now I can easily size my photos for Twitter! (Or Facebook, or Pinterest etc.)

 

Social Media tips – free photo resources

  • Library and Archives Canada –Image Search
  • New York Public Library  – Search Page
  • The Rijkmuseum in Amerstdam has digitized its collection. All of its works are free to use. Its’ policy “If you use our images for publication, then we request that you acknowledge the source (Rijksmuseum, Amsterdam). We would also like to receive a copy of the publication for our library.”
  • Try the Creative Commons search tool.
  • This post from Hootsuite offers a list of 20 different Free Stock Photo websites. The one I like the best is Pexels, which is where I found this posts’ featured image.
  • University of Alberta Peel Image search.

PowerPoint: Save a Slide as a JPG

Do you like those inspiring combinations of words and pictures you see on many social media sites?

Photo courtesy of National Archives of Canada. Children Reading Art books 1931-1959. Superimposed quote "There are many little ways to enlarge your child's world. Love oa books is hte best of all. - Jacqueline Kennedy Onassis"
Photo courtesy of National Archives of Canada. Children Reading Art books 1931-1959. Quote courtesy of ebookfriendly.com

You can use PowerPoint to combine pictures and words and then use the Save As command. Select the JPG type.  Perfect for  uploading to your social media feeds. Here’s a  link to the PowerPoint template  sized for Twitter pictures I used to create the above  sized for Twitter pictures I used to create the picture above. You are welcome to download and use it.

Also, here’s a link to the image search page at the Library and Archives Canada.  And for my fellow book nerds – quotes about reading.

 

Excel: Frozen

Freezing panes is a basic tool to make a large spreadsheet easier to work with. In my social media spreadsheet I like to freeze the header row into position. Then no matter how far I scroll down the sheet, the columns are labelled.

To turn on frozen panes, select the cell below the row & column you wish to freeze into position. Since I don’t want to freeze any columns, I select cell A2.

Freezing Panes using the Active Cell position
Freezing Panes using the Active Cell position

Select the View Ribbon, Click on the Freeze Panes button, and choose Freeze Panes (or Freeze Top Row in this scenario).

Freezing Panes Results
Freezing Panes Results

Now you can scroll for hundreds of rows, and each column is nicely labelled – no guessing!

Excel: Select Visible (2)

The Select Visible Cells Only button on the Quick Access Toolbar
The Select Visible Cells Only button on the Quick Access Toolbar

The Select Visible Cells Only function is so useful, I like to add it to the Quick Access Toolbar (QAT) in Excel. These instructions are based on Excel 2010, but will be similar in all current versions of Excel.

Quick Access Toolbar Customization
Quick Access Toolbar Customization

The Quick Access Toolbar starts in the top right corner of the Excel window.  The customize button is circled in red. Clicking on that button displays the menu shown below.

Move the QAT under the ribbon
Move the QAT under the ribbon

The first change I like to make is to its’ position. I like to move it under the Ribbon, since there will be more room for buttons there. Over time I tend to fill the QAT up with frequently used tools.

After I move the QAT below the ribbon, I go hunting for useful commands to add.  Click the More Commands… option and the Customize the Quick Access Toolbar dialog opens up.

Customize the Quick Access Toolbar - Popular Commands
Customize the Quick Access Toolbar – Popular Commands

The dialog box defaults to Popular Commands.  Try scrolling through this list and find the Format Painter. Press the Add button, to add it to the Quick Access Toolbar. This is a useful tool to have at hand!

By clicking on the Choose commands from drop-down list, a selection will be displayed.

Drop-down list of source commands.
Drop-down list of source commands.

Select All Commands from this list. Hundreds of Excel commands will display, and this is where it is useful to know the name of the command you are looking for. Scroll until you find Select Visible Cells.

Finding the Select Visible Cells command
Finding the Select Visible Cells command

Select it, Click on the Add button, and click OK.

Simply select the cells you wish to copy and press the Select Visible Cells button. Paste your information and only what you see will be pasted.

Excel: Select Visible (1)

I built my Social Media spreadsheet in an Excel spreadsheet with all the tools I want built in (formulas, conditional formatting and data validation). Ultimately, I will transfer my information into a stripped down spreadsheet in csv (comma separated) format. This is the format that Google Calendars will accept.

When I transfer my posts to this spreadsheet, I don’t want to include any blank rows AND I only want to copy and paste once. How do I perform this little piece of magic? I use the Excel command for selecting visible cells only.

Go To Special Dialog, select Visible cells only
Go To Special Dialog, select Visible cells only

Tucked away in the Go To Special dialog is the option for selecting only the visible cells in a region. This takes what could be multiple copy/paste operations and condenses them into one step.

First filter your data so that blanks do not appear, then press the F5 function key to bring up the Go To dialog box.

GoTo Dialog - Special Button
GoTo Dialog – Special Button

Press the Special button to open the Go To Special dialog box, choose Visible cells only and press OK. Now when you copy the selected cells, only the cells you can see are copied.

In my next post I’ll show the method to put this useful button on your Quick Access Toolbar.