Erm's I.T. Girl – Zelna Ellis

Don't fear when Zel is near…

Sync Facebook Events With Google Calendar

In a few steps you see your Facebook Events in Google Calendar.

  1. After you log into Facebook, go to Facebook Events
    Facebook Events
  2. Click on Export Events and copy the URL (which you will use later). Keep the address of the URL to yourself!!!
    Export Events
  3. Log into Google Calendar.
    Google Calendar
  4. Click on Add, and then click on Add by URL
    Add calendar by URL
  5. Paste the URL you copied from Facebook and click Add Calendar
    Add calendar
  6. Esta bom, that’s it!
    You will see a notification at the top that it will be indexed by Google Calendar.
    The Facebook Events URL will appear under Other Calendars.
    Google Calendars


  • You can also add single events, one by one, by opening the Facebook Event, and copy the Export link for the event.
    Export Events

Now your Google calendar will update automatically every time you accept or decline an event in Facebook.

25 June 2010 Posted by | Facebook, Google | , , , | Leave a comment

Create and Share Google Calendars

One of the easiest way to create a calendar, is to create .CSV file in your spreadsheet programme.
For row headings you will type the following:

  1. Create Row Headings
    • Cell A1 = Subject
    • Cell B1 = Start Date
    • Cell C1 = Start Time
    • Cell D1 = End Date
    • Cell E1 = End Time
    • Cell F1 = Location
  2. Type in the details
  3. Create new Google Calendar
  4. Upload the .CSV file
  5. Get your calendar id
  6. Go to Google’s EventPublisher Guide to get URL
  7. Share the URL with your friends

Watch the video here.

23 June 2010 Posted by | Google | , , | Leave a comment

Read, Edit, Save Open Documents in Microsoft Office

It is possible to open, edit and save the ISO-standard Open Document Format, such as Open Office, Google Docs in Microsoft Office. This is for the users of Microsoft Office Word, Excel and PowerPoint. File extensions include .odt (text/word processing), .ods (spreadsheet), and .odp (presentation).

It might not have the same formatting as it did in the original application it was created in. This is because of the differences between applications that use the OpenDocument Format.

Method 1 – For MS Office 2007 users
After you installed MS Office 2007 Service Pack 2 you can open, edit and save documents, spreadsheets and presentations straight in the Microsoft Office Suite.

Method 2 – Sun ODF Plugin for Microsoft Office
This plugin works with Microsoft Office 2000, XP(2002), 2003, 2007 SP1 or higher.
Just download and install the Sun ODF Plugin here.

Method 3 – Online Convertors
You can also try out an online convertor such as Media-Convert or Zamzar.

17 September 2009 Posted by | Software | , , , , , | Leave a comment

Create Proffesional Looking Slideshows with MS Photo Story

We all have photos and with Photo Story 3 it is so easy to create a professional-looking slide-show, no matter what your level of experience.

Download it here.
Price: Free
Prerequisites: Windows XP , Windows Media Player 10, DirectX 9

Photo Story can hold up to 300 pictures, stored in a range of file formats such as BMP, EPS, GIF, JPEG, PCD, PCX, PNG, PSD, TGA and TIFF. Allows you to add effects, transitions, captions, narration to any or all of the slides. You can import music – MP3, WAV or WMA format or you can choose to create a custom music, to play along with your show.

Launch PhotoStory

  • Select Begin a new story.
    Begin New Story
  • Select Import Pictures and browse and select the pictures you want to use. Click OK.
    Repeat this step until you have all your pictures you want.
    Select Remove Black Borders, if necessary and Select which ones.
    Import Pics, Remove black borders
  • Click OK.
  • You can also Autocorrect Color Levels, Remove Redeye, Rotate the picture.
  • Select Next, to add captions and/or effects. In the captions it will allow you to format the font, and specify the text alignment. Effects you can choose a from a few presets (Black and White, Chalk and Charcoal, Coloured Pencil, , Diffuse Glow, Negative, Outline Black, Outline Grey, Sepia, Washout and Watercolor) to apply to your picture.
    Add Titles and/or Effects
  • Select Next, to add narration. Select the picture, click the record button, talk into the mic and stop when finished.
  • Select Customize Motion to adjust the start and beginning points. Save when finished with the pic.
    Start and End Positions
  • Select Next, to add or create music. With Add you choose an existing file, and with create there are a few options you can play around with.
    Add music
  • Select Next, to choose Save Options.
    You can save it to your computer, as an e-mail attached, Pocket PC or Smartphone with Windows Media 10, or Portable Media Center.
  • Select Next, Wait, Preview, Start or Exit.

When you finished with your Photo Story you can write it to CD, DVD. To create a VCD or DVD you will need software, e.g. Nero, that supports these formats.

You can watch the example I’ve compiled here.

Remember, at any time you can go back to your project, and edit it. Enjoy!

17 August 2009 Posted by | Multimedia | , , , , | Leave a comment

File Storage, Sharing, Collaboration

There are several ways you can store, share, collaborate files online. The list is endless. Just Google, Bing, Yahoo it or whatever search engine you use, and the results are …

Before you choose a service, at least answer this:

  • Why do you want to store files online?
  • Is there a need for online collaboration?
  • Do you need to access the files offline?
  • Is purely for easy access, for yourself or to share with other users as well?

Depending on your needs here is a few Services you can look at using :

  • Google Docs
    Support documents, spreadsheets and presentations, online and offline, and collaboration.
    Read here about the file size limitations.
  • Google Desktop
    With Google Desktop you have the option to Search Across Computers. This option is turned off by default. All the computers must have Google Desktop installed. (Options | Preferences | Google Account Features)
    But there are some privacy concerns!
    You have some customisation options here to keep your data private.

    • Search Gmail – Disable!
    • Specify what the others can search: My other computers can search this computer’s…

    More Options (Options | Preferences | Desktop Search):

    • Specify Search Types
    • Specify Search Location – Do not search the following files, folders or web sites
    • Remove deleted items
    • Google Integration – Turn it off
    • Encrypt Index – Enable
    • Remove Deleted Files

    Read more here.

  • GMail Drive by
    With GMail Drive you can easily copy files to your Google Mail Account and retrieve them again. Remember you have to give Windows Explorer access to the web in your Firewall.
    After installation, GMail Drive will appear as an icon under My Computer, Right-click on the icon, Login. Now you just copy the files to the GMail Drive and it will be in your Gmail.
  • Gspace – Firefox Add-on
    This Firefox Add-on allows you to store a document on you Google Mail Account. After installation:
    Select Tools | GSpace
    Select Manage Accounts
    Fill in your information and close the dialog box
    Select Log-in
    Select the files you want to transfer and select the Upload button
  • Note:
    If you decide to use your Gmail account as storage (file send as message to your account) you have a few limitations:
    •Gmail doesn’t allow .exe files to be uploaded – of course you can rename the file extension and then upload.
    •File size is limited to 19MB

  • MediaFire
    This one is a personal favourite. Unlimited space for free! You are limited to 100MB per file for the free account. Check it out for yourself. You can specify whether or not you want to sign up (free or paid account). You have the option to make a folder and/or file private or public.
  • MS Windows Live SkyDrive
    If you have a Hotmail, Messenger, Xbox LIVE or Windows Live account just login to Windows Live and you have 25GB free storage. The same counts here as above. You can choose whether a file is personal, shared or public.
  • Microsoft Office Live
    Have 5GB storage space, and to my knowledge a 25MB file size limitation. Under correction in comparison with Google Docs only one person can work on a file per time. Only once that person is finished editing and saved it, it will be available to another person to edit.
  • USB Memory Stick
    Another personal favourite, just have to mention it.
  • DimDim Web conferencing
    Let you deliver synchronized live presentations, whiteboards and web pages while sharing voice and video over the internet with nothing to download. Free for upto 20 persons.

The few services mentioned here is just a drop in the bucket.
To name another few, have a look at:

13 August 2009 Posted by | Tools | , , , , , , , | Leave a comment

Integrated Gmail – Firefox Add-on

This is a definite must have for Firefox and Gmail users.
This add-on allows you to make the Inbox Collapsible and loads your choice of Google Reader, Notebook, Groups, Maps, Picasa, Site, News, Portfolio, Custom, Gadget.
You can find Integrated Gmail add-on here by Michael A. Balazs.

To install:

  • Just select the Add to Firefox button
  • Select Install
  • Select Restart Firefox

Configure Integrated GMail

  • In the Firefox Add-on Dialog Box, select Integrated GMail, select Options.
    Firefox Add-ons Dialog Box
  • Here you will be able to add an item and configure it, or remove an item.
    Integrated GMail Options
  • Click Ok when you are done, and close the Add-on dialog box

Let’s have a look at GMail in the browser, refresh if necessary.
GMail View with Integrated GMail Add-on installed.

As you can see, you can view the items you’ve selected in the Integrated GMail Options on one page, instead of clicking on top. This is just fabulous!

Thanks to Michael A. Balazs for this great Add-on!

7 August 2009 Posted by | E-Mails, Google | , , , , , | Leave a comment

Sync Google Calendar With MS Outlook

Google Calendar Sync System Requirements:
Microsoft Outlook 2003 or 2007
Microsoft Windows XP (32-bit only) or Vista

Download here.

Take note that only one pop-up reminder per event will be sync. And only pop-up reminders, even if you have multiple reminders in your Google Calendar, and/or e-mail and/or SMS remainders. Outlook only supports pop-up reminder and you can only set one reminder in Outlook.

To Install

  • Close Microsoft Outlook if it is opened.
  • Run the setup file
  • After reading the License Agreement, Select I Agree.
  • You can select whether or nut to create Menu and Desktop Shortcuts.Select Next.
  • You can choose an alternative directory if you want you. Select Install.
  • Wait for installation… Select Close.
  • The app will automatically launch. Remember to give it access in your Firewall.
  • Enter your username and password.
  • Select the way you want to sync.
  • Select the interval time. Minimum interval time is 10 minutes.
  • Select Save
  • Google Sync Options

You can fire up MS Outlook if you want to.
You will notice a Google Sync icon in the statusbar.
If you double click on it, it will open the Google Sync Options Dialog Box.

If you right click on it, you will get a pop-up menu, where you can choose to start a synchronising manually, stop a synchronising, etc.
Google Sync Pop-up Menu

When your events aren’t actively syncing the icon will look like this:
Google Sync Not Syncing

When your events are actively syncing the icon will look like this:
Google Sync Busy Syncing

If you run into problems you can find the logfile at: C:\Documents and Settings\yourusername\Local Settings\Application Data\Google\Google Calendar Sync\logs
Note: Show hidden files and folders must be turned on in Folder Options | View.

Remember Google Sync use Internet Explorer Settings e.g. If Internet Explorer is set to Work Offline, you won’t be able to connect even if you use another browser and/or another browser is your default browser.

Happy syncing.

6 August 2009 Posted by | E-Mails, Google | , , , , , , | Leave a comment

Access multiple Gmail accounts on one PC

There are several ways one can check multiple Gmail accounts from one pc. Here is my shortlist.

Use different web browsers
You can fire up several browsers, e.g. Firefox, Opera, Flock, Internet Explorer, Google Chrome, Safari, etc. But remember this will consume the computer’s resources.

Use IE Tab – Firefox Add-on.
This add-on embeds Internet Explorer inside Firefox. You can have e.g. one account open in a Normal Tab page and another in an IE Tab page.

Use Gmail Manager – Firefox add-on.
This enables you to configure different gmail accounts and receive notifications. After installation you will notice a shortcut in the statusbar of Firefox, where you can manage your accounts.

Use Notifier2.
This programs allows you to manage multiple e-mail accounts(besides GMail) and affiliate accounts as well. Read more at their website. It does require JRE (Java Runtime Environment), which most of us have already installed.

Althought there are CookiePie and CookieSwap as well, they are not compatible with the latest version of Firefox.

For sure that there are many more programs that can be added to the list. Feel free to leave a comment if you know of any other programs.

28 July 2009 Posted by | E-Mails, Software | , , , , | Leave a comment

MS Excel 2007 : Where is the stuff?

This is just a short list of features people sometimes struggle to find in Excel 2007.

  • Office Assistant: It has been dropped in Office 2007 Suite
  • Custom Lists: Office Button -> Excel Options, Popular category, Edit Custom Lists
  • Template File Locations: You need to open MS Word 2007 to change this.
    In Word: Office Button -> Advanced Category. Scroll down to the General Section. Select File Location. Read more here.
  • AutoFormat: Home Ribbon, Style Group, Format as Table. Also have a look as Cell Styles.

17 July 2009 Posted by | Microsoft Office Excel 2007 | , , , | 1 Comment

Firefox, Screengrab and Save Google Maps


Screengrab is a Firefox add-in that captures (save or copy) anything in the Firefox browser as a picture. You can save an entire page, what is visible or select what you want to save. In this example we are going to save a Google map as an image.

Install Stronggrab

  1. To install go here
  2. Select Add to Firefox
  3. Select Install
  4. Select Restart Firefox
  5. Select Screengrab Options to specify whether you want to save it as .png or .jpeg
  6. Close the Add-ons window
  7. At the bottom right of the browser you will see an icon for Screengrab

Try It – Save large Google maps

  1. Go to Google Maps
  2. Open a map of the location you want
  3. Zoom in and out for the purpose you want the map for
  4. Select "link" at the top right of the map display
  5. Select "Customize and preview embedded map"in the pop-up window
  6. Google map Link

  7. Select "Custom"
  8. Specify the width and height you want
  9. Google map Custom size

  10. Scroll down and copy the html code
  11. Google map HTML Code

  12. Open your favourite text editor and paste the code in it
  13. Save the file in html format e.g. as maps.html
  14. Open this file in Firefox. Once loaded you will see the map in the size specified in Step 7.
  15. Click on the Screengrab icon at the bottom right of Firefox window
  16. Select Save > Complete Page/Frame…
  17. Screengrab

  18. A Save screenshot as… dialog box will appear soon. Save the image as JPG or PNG.


That’s it! The map is save.

25 June 2009 Posted by | Browsers | , , , | 2 Comments