Syncing my work calendar (Microsoft Outlook) with my Google Calendar so I can have my meetings on my phone is a must for me. Since August 1, 2014 when the Google Calendar Sync quit working I have used a lot of different offering that tried to solve this problem. Outlook Google Sync by rantsi was the closet to how I wanted it to work but it had a few issues. I committed a few fixes but then started working on how I would want it to work. Marble is the result of that effort. It uses the Google Calendar API v3 and either native Outlook Interop or NetOffice. NetOffice is still a bit experimental so use with caution.
Marble is available on GitHub, and at this time version 0.0.1.8 is stable using Outlook Interop (the default). Source Code, Binary, and Setup packages are all available on the release tab.
The Setup Screen
As you can see it is very simple, once you launch the Settings Screen you will be taken to your Google Account to authorize Marble to have access to manage your Calendars. You will then select which calendar you want events to be synchronized to.
Enable the Sync very hour and provide when on the hour you want it to sync. The screen shot will sync every hour at 10 minutes past.
The Days in Future and Days in past allows you to control the rolling window of time that events are synced in. This allows you to make update quickly.
Start with windows, really? I not going to explain that one.
There is no User Interface other than the Settings and About screens. Everything else is handled in the System Tray.
Please download it and give it a try. If you encounter issues please log them here
I have also used this in trouble shooting browser issues with clients, the easiest way to know for sure they have cleared their browser cache.
Today I came across the need to be able to upload documents to a SharePoint list. Not so bad, I have done this before, but this time I also need to populate some custom metadata about the document. After a lot of looking, searching and exceptions I finally found the answer and here it is.
Add References to Microsoft.SharePoint.Client Library
Define a form
The important part I always forget is the enctype=”multipart/form-data”.
1: <form id="formUpload" method="POST" enctype="multipart/form-data ">
2: <input type="file" id="fileUpload" name="fileUpload" runat="server"/>
3: <input type="submit" value="upload"
4: OnServerClick="btnUploadTheFile_Click" runat="server"/>
The btnUploadTheFile_Click Handler
1: private void UpLoadToSharePoint()
3: var fileName = Path.GetFileName(fileUpload.PostedFile.FileName);
4: var fileStream = new FileStream(fileUpload.PostedFile.FileName, FileMode.Open);
5: var byteStream = new byte[fileStream.Length];
6: fileStream.Read(byteStream, 0, byteStream.Length);
8: var serverRelativeUrl = "/MySite/MyDocumentLibrary/" + fileName;
10: var fileCreationInformation = new FileCreationInformation
12: Content = byteStream,
13: Overwrite = true,
14: Url = serverRelativeUrl
17: var file = _sharePointList.RootFolder.Files.Add(fileCreationInformation);
18: file.ListItemAllFields["Column 1"] = "Value 1";
19: file.ListItemAllFields["Column 2"] = "Value 2";
This simple example shows how easy it is to upload a file to a SharePoint document list and provide additional column information.
Last Friday I presented on Domain Events at the Northwest Arkansas Techfest and there was a lot of interest and good discussions. Thanks to everyone who attended the session. I have updated the nuget packages to the latest release and have created some initial documentation located here. From there you can find links to the project site (full source available) and wiki.
The source also includes an example application as well as the demo script for the demo I used in my presentation. The demo script is step by step instructions to re-create the demo from the presentation.
As I mentioned in the session this code is publicly available and I do accept feature and pull request, see the project wiki for how you can contribute.
How to Host a Community Leadership Town Hall
I was recently asked if I would be hosting a Community Leadership Town Hall in Tulsa again this year. I will not be attending so I thought I would share what is needed and how to host a Community Leadership Town Hall in case there are others that would be interested in doing so.
Things you need:
- Category Signs: Membership, Leadership, Speakers, Sponsors, Meetings, Other
- 4x4 or 3x3 Sticky Notes, enough for everyone to write topics, questions, etc.
- Pens, I usually have a bundle of about 20 pens
- Color Coding Labels, i.e. dots used for voting
Stick up the Category signs around the room. Be sure to allow enough room for people to walk around and look over each others shoulders. These areas get pretty crowded during the Topic\Question and Voting sections.
Get 4 chairs that you can setup in the center of the room. This is the fish bowl and is where the main discussions will happened once the topics are organized. This is also a good way to keep the discussion close to microphones if you plan on recording it.
Time: 5 Minutes
In this section of the event you want to welcome everyone and let them know how the night will go. You can also ask if any of them are familiar with Open Space Technology events. This is a variation of that formula. This event is going to be only as good as what the attendees put into it, stress that and let them know they have a critical part to play in making it a success.
Time: 10 Minutes
Let them know that you will give them 10 minutes to write down questions or topics they would like to discuss. They don’t have to lead the discussion, just have the need or knowledge to share. Tell them they will need to write down the Topic\Question\Idea on a sticky note and then stick it on the wall under the Category that if best fits into. The things you want on the sticky notes; The topic/question and who wrote it. This helps later when you ask them to go over it in more detail and to take a set in the fish bowl to start the discussion.
Time: 10 Minutest
During the voting each person should read over the sticky notes posted and if they feel strongly about a topic they can vote on it by putting one of their dots on it. Once time is up have everyone return to their sets.
Time: 5 Minutes
Now you need to look over each category and find like items. Those that are similar or have a common theme and group them together. Once you finish that make a tally of which sticky notes have the most votes, counting similar themes as a single item. Organize the sticky notes in order from largest number of votes to smallest. This is now your agenda for the rest of the event. You want to do this quickly since everyone else is sitting around waiting, help can make this go faster.
The Fish Bowl
The fish bowl is where the real discussion happens. This is also a great way to control the amount of time spent on each topic making sure that everyone topics get a chance to be covered. Remember the 4 chairs? Ask the person that wrote the sticky to take a seat. Explain the fish bowl, only those seated in a chair can comment and one chair must remain empty at all times. Simple rules but it can make for some confusion. This is much like Survivor, if someone new shows up (sits in the empty chair) someone must vote themselves off the island (leave their chair). A great way to wind the discussion down and keep it on time is to pull the empty chair away every 5 minutes. Remember one chair must remain empty, since the empty chair is gone, someone has to get up. Continue this until there is one person and one chair left. When they finish, they have to get up the discussion is over.
Reset the chairs and start the next topic.
This a great open format for experts and those interested in a topic to share information. The events I have hosted in Houston, Dallas, and Tulsa have not only been informative they have been a lot of fun. You can also get a sponsor to cover food if you want to offer a meal to you attendees. This is an attendee lead event and the more input you get from them the better the event is. You job for hosting a Community Leadership Town Hall is well to host. You are just there to get everyone else talking, and they will just give them the floor and see what happens.