Jump to content
water

Outlook: Import iCal events

Recommended Posts

FrancescoDiMuro

@water

It surely could be a good feature to add to your (already) amazing Outlook UDF :)


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites
Skysnake

importing iCal would make my life a lot easier. :)

 


Skysnake

Why is the snake in the sky?

Share this post


Link to post
Share on other sites
water

Hope I can soon provide an early alpha Version :) 

Edit: For download please see my signature ;)

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
Starstar

Great idea


Life is like a coin. You can spend it Anyway as you wish and for your kind information. "you can spend it only once."

Share this post


Link to post
Share on other sites
water

First alpha test script:

Edit: For download please see my signature ;)

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
water

Version 0.1 released. Edit: For download please see my signature ;)

ADDED:

  • Supports the DURATION property
Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
water

Please post example .ics files you would like to import to Outlook.
So I can check and add the properties still missing in my UDF.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
water

Do you think it is sensible to implement a callback function so you can decide how to process each event from an iCal file?
An array holding the properties to create the Outlook event item would be passed to the function (read only) .
You can then decide how to continue processing by setting @error:

0 - Create the Outlook event item
1 - Do not create the Outlook event item - continue processing the next event
2 - cancel processing the iCal file and return to the calling function

 

  • Like 1

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
argumentum
2 hours ago, water said:

think it is sensible to implement a callback function so you can decide how to process each event

Yeap  :)

Share this post


Link to post
Share on other sites
water

Great :) WIll be added.

  • Thanks 1

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
water

Version 0.2.0.0 of the UDF has been uploaded. Have fun :)

  • Like 1

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
water

At the moment the UDF only supports "floating" DATE-TIME values as described in the RFC (Section 3.3.5. - FORM #1: DATE WITH LOCAL TIME).
Support for UTC will follow quite soon (Same section - FORM #2: DATE WITH UTC TIME).

Is there a need for FORM #3: DATE WITH LOCAL TIME AND TIME ZONE REFERENCE (e.g. DTSTART;TZID=America/New_York:19970714T133000)?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
argumentum
6 hours ago, water said:

Is there a need for .......

If is within possibility, the more complete, the better  :)

Share this post


Link to post
Share on other sites
water

I will do my very best ;)

Next on the list:

  • VCard import
  • Putting everything together into a single UDF (iCal import, VCF import etc.) and rename the thing to OutlookTools.au3.
  • Add timezone support

What do you think?

  • Like 2

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
FrancescoDiMuro

@water

MVP is not enough ^_^


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites
water

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
iCal (2019-01-22 - Version 0.1.0.0) - Download - General Help & Support
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • water
      By water
      Library to import iCal files and create events in your Outlook calendar.
      Note: This is a beta version - script breaking changes may occur at any time!
      Prerequisite: OutlookEX UDF.
      The following components and properties have been implemented (full or partial).
      iCal PROPERTY SECTION IN RFC 5545 OUTLOOK PROPERTY COMMENT ------------------ ------------------- ------------------------- --------------------------------------------- VEVENT:CATEGORIES Section 3.8.1.2. Categories VEVENT:CLASS Section 3.8.1.3. Sensitivity olNormal, olPrivate or olConfidentional. olPersonal not used. VEVENT:DESCRIPTION Section 3.8.1.5. Body VEVENT:LOCATION Section 3.8.1.7. Location VEVENT:PRIORITY Section 3.8.1.9. Importance VEVENT:SUMMARY Section 3.8.1.12. Subject VEVENT:DTEND Section 3.8.2.2. End specifies the non-inclusive end of the event VEVENT:DTSTART Section 3.8.2.4. Start VEVENT:DURATION Section 3.8.2.5. End used to calculate the end property VEVENT:TRANSP Section 3.8.2.7. BusyStatus VALARM:TRIGGER Section 3.8.6.3. ReminderMinutesBeforeStart Only the minutes section of the duration is processed The download contains 2 files: The UDF (iCal.au3) and an example script (iCal_VEventImport.au3).  The test iCal file (Test.ics) is created on the fly holding two events.
      When you run the example script only one event gets written to your default calender for today. The second event is suppressed by the callback function.
      Debugging is enabled, so you get a full listing on the SciTe console how the iCal file gets processed.
      Format of the example iCalendar file:
      BEGIN:VCALENDAR VERSION:2.0 ; Ignored METHOD:PUBLISH ; Ignored PRODID:-//iCal UDF//iCal Generator//DE ; Ignored BEGIN:VEVENT CLASS:PRIVATE ; Sensitivity: Private PRIORITY:3 ; Importance: High CATEGORIES:TEST ; Categories: Test (needs to be modified to your liking) CREATED:20190110T032002Z ; Ignored LAST-MODIFIED:20190110T032002Z ; Ignored DTSTAMP:20190110T032002Z ; Ignored SUMMARY:HOLIDAY ; Subject DTSTART;VALUE=DATE:20190118 ; Start date DURATION:P2D ; Duration: 2 days. Is used to calculate the end date URL:http://www.google.com ; Ignored DESCRIPTION:All Holidays ; Body TRANSP:OPAQUE ; BusyStatus: Busy LOCATION:Room 123 ; Location UID:TEST_2019_5c36abd73c75e ; Ignored BEGIN:VALARM TRIGGER:PT30M ; Alarm: 30 minutes prior to the event ACTION:DISPLAY ; Ignored DESCRIPTION:Reminder ; Ignored END:VALARM END:VEVENT END:VCALENDAR Links:
      https://tools.ietf.org/html/rfc5545

      Threads: General Help & Support
       
      Known Bugs: (last changed: 2019-01-22)
      None
        Things to come: (last changed: 2019-02-08)
      None
      BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort
    • water
      By water
      Outlook does not allow to import vCard/VCF-files programmatically.
      I might implement this format (RFC 6350) as I did with the iCalendar data format if someone is interested
      Please post here or click the "Like" button if you think this is a good idea
    • water
      By water
      For my iCal UDF I need to translate rfc 2445 duration format to an array holding the possible values (week, day, hour, minute, second):
      Has anyone already written some code to to this?
      "P15DT5H0M20S" should be translated to [0, 15, 5, 0, 20] ; week, day, hour, minute, second
      Some RegExp guru around?
      Any help is greatly appreciated
    • Shirdish_chakravarthi
      By Shirdish_chakravarthi
      Hello Friends,
      I am having a requirement where i have to automate outllook.I have to send mail using outlook.Whe i went through the forum i got OutLookEx.au3 but when i am trying to use this i am getting error can anyone help me in using this? @water
    • Gowrisankar
      By Gowrisankar
      Dear members of the forum,
      I'm working on a project where incoming emails are to be analyzed based on the subject line and moved to various folders in a shared mailbox.
      I'm using "OutlookEx.au3" of @water. The macro can can move emails  to any folder that I newly create. But the macro couldn't move emails to specific folders that are already existing.
      I checked the permission levels of those folders and found that nothing is wrong with that. The function I use is _OL_ItemMove.
      Please guide me how to proceed further. Thanks in advance.
      -Gowrisankar.
       
×