Jump to content

1 Screenshot

About This File

Tools to import/export contacts from/to vcf files and calendar events from/to ics files (former name: iCal UDF).
Note: This is a beta version - script breaking changes may occur at any time!
Prerequisite: OutlookEX UDF.

ICS (iCalendar) import:
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 test script iCal_VEventImport.au3 creates the test iCal file (Test.ics) on the fly holding two events.
When you run the example script only one event for today gets written to your default calender. 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

VCF (vCard) import:

The following components and properties have been implemented (full or partial).

COMPONENT:PROPERTY  SECTION IN RFC 6350  OUTLOOK PROPERTY               COMMENT
------------------  -------------------  -------------------------      ---------------------------------------------
VCARD:FN            Section 6.2.1        fullname
VCARD:N             Section 6.2.2        lastname, firstname,           Family Names, Given Names, Additional Names, 
                                         middlename, title              Honorific Prefixes, and Honorific Suffixes.
VCARD:ADR           Section 6.3.1
  TYPE=WORK                              BusinessAddressPostOfficeBox,
                                         BusinessAddress,
                                         BusinessAddressStreet,
                                         BusinessAddressCity,
                                         BusinessAddressState,
                                         BusinessAddressPostalCode,
                                         BusinessAddressCountry
  TYPE=HOME                              HomeAddressPostOfficeBox,
                                         HomeAddress,
                                         HomeAddressStreet,
                                         HomeAddressCity,
                                         HomeAddressState,
                                         HomeAddressPostalCode,
                                         HomeAddressCountry
VCARD:TEL           Section 6.4.1
  TYPE=HOME                              PersonalHomePage
  TYPE=WORK                              BusinessHomePage
VCARD:EMAIL         Section 6.4.2        Email1Address
VCARD:ORG           Section 6.6.4        CompanyName
VCARD:TITLE         Section 6.6.1        JobTitle
VCARD:CATEGORIES    Section 6.7.1        Categories
VCARD:URL           Section 6.7.8
  TYPE=HOME                              PersonalHomePage
  TYPE=WORK                              BusinessHomePage

The test script vCardImport.au3 creates the test vCard file (Test.vcf) on the fly holding a single vCard.
Debugging is enabled, so you get a full listing on the SciTe console how the iCal file gets processed:


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 :)


What's New in Version 0.3.0.0

Released


GENERAL

  • Name: The UDF has been renamed to OutlookTools.au3
  • Magic Numbers:  Have been replaced with constants named $OLT*

NEW FUNCTIONS

  • _vCard_Import: Import vCard contacts to an Outlook contacts folder.

FIXED BUGS

  • None

CHANGED FUNCTIONS

  • Callback Function: Now needs to be defined with 2 parameters.



User Feedback

You may only provide a review once you have downloaded the file.

There are no reviews to display.

  • Similar Content

    • By water
      I just noticed that Outlook does not allow to import iCal events programmatically.
      I might implement some of the iCalendar data format (RFC 5545) if someone is interested
      Please post here or click the "Like" button if you think this is a good idea
      Edit: For download please see my signature
    • 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
    • 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
    • By mLipok
      Has anyone tried to do VCF files parser?
      I and my colleagues serve about 60 clients but in the address book we have about 800 phone numbers.
      Mostly these are the same numbers but different names.
      Sometimes after changing the device (mobile phone), it turns out that it could have used to change names.
      Sometimes such conversion are dictated by changing the type of customer (type of services).
      It requires the ability to mass changes in the contacts, and the best fit would be able to parse VCF files.
      So maybe someone has something in this regard already created?
      Or do I have to go about it from scratch?
       
      Regards,
      mLipok
×
×
  • Create New...