It’s supported by the vast majority of calendar clients and online calendaring services. ICal is a standard for representing and exchanging calendaring and scheduling information such as events, to-dos, journal entries, and free/busy information, independent of specific calendar services or protocols. Let’s take a look at why this feature is important and how you can use it to sync events across multiple calendars. I am still looking for a fix for importing the Ward directory will run through the posts but my problem is in Outlook it downloaded the entire directory but only shows as one entry.We recently made iCalendar (iCal) UIDs available for most user accounts via the Nylas Calendar API, and the impact of this change is much larger tha n simply adding a new attribute to our Events endpoint (which allows developers to build apps that integrate with users’ calendar data from any provider). Please feel free to post any improvements along with explanation of the included improvements. This will allow you to customize it beyond the simple fix I have done. Now when you download the CSV file from the Church calendar you can likewise open in Excel & examine its structure and compare to figure out which columns need renamed, added, split & renamed etc using the wizzard. This will tell you what Outlook needs to properly import. Then open the file in Excel as a CSV file and examine its structure and column names etc. The trick for everyone's benefit on figuring out Excel is to take a working calendar you have the way you want it and export it out as a CSV file from Outlook. Is it possible you clicked on a cell in the downloaded CSV file prior to running the macro which in turn changed the active cell? I never had a problem with it before but I like your suggestion, feel free to implement, test & repost / upload for everyone's benefit as it is now public domain. Outlook converter.XLS (21 KiB) Downloaded 245 times Any questions send me an email through the forum & I will try to add additional information for benefit of all. Suggest you save the downloaded CSV file there as well. Make sure you have a C:\temp directory before starting as the macro is hard coded to export to C:\temp. Once you have the file if you add it to your hidden XLSTART directory (Documents & Settings-Your account-Application Data-Microsoft-Excel-XLstart) you can then run it from within Excel with hot key Cntrl + (lower case letter o) or select from Tools-Macro-Macros after opening the downloaded CSV file from the calendar, to select it.
I attached the macro named Outlook converter.xls to this post. Upside: It will let those who were previously unable to import Church calendars to do so and therefor be able to sync to their Smart phone as well if they have one. All you have to do is take the reformatted file and import into Outlook as a CSV file using the option to replace duplicates.ĭownside: This will not remove previous calendar entries that were downloaded and imported previously but then latter removed from the ward calendar due to cancellation etc. The Macro was written in Excel 2003 & takes the exported CSV file from the calendar and automatically reformats it & spits out a new file in the correct format. Short term: Use my Macro until some one figures out a way to implement it on a Church Server to automatically spit out an Outlook compatible CSV file. Long term: Implementation of the new CalDAV standard across webservers & calendaring applications
Due to the previous problem of duplicates this feature has not been used as well as it could or at all for Outlook users who have experienced this problem. Currently members can only import 12 months at a time & to sync your Outlook calendar on a regular basis requires multiple downloads & imports of files. This is due to the organization and strict column naming requirements of Outlook when importing data. Only problem is the CSV file format exported from the ward/stake calendar is not compatible with MS Outlook 2003 for sure & other versions likely either. When importing iCal files, Outlook does not provide any options such as replace duplicates like you will see when importing a CSV file. This post is for you ).Īpparently the implementation of the iCal standard by Microsoft into its Outlook products was not as robust as it could have been according to an inside authority I will not name here. If you have tried to import the calendar from your ward or Stake website into Outlook 2003 or possibly Outlook 2007 and have seen duplicate entries created each time you import.
0 kommentar(er)
