Salesforce Automation - Calendar Import

Calendar Import and Export in ICS Format

If you have your events or tasks in iCalendar (ics) format, you can import them into your Calendar Module in Bz CRM. Additionally, you can also export your calendar records in Bz CRM into .ics format.

Import Process

  1. Click on icon
  2. Click on List View option in the left nav bar
  3. Click on Import button from top right corner
  4. In the popup, select ics file type
  5. Click on Select from MyComputer button, choose your ics file to import
  6. Click Import
Note!
  • Make sure that your .ics file addresses all mandatory fields in your Calendar module.
  • The Activity Type is set to Meetings and the Assigned To value is the username who performs import.
  • Export Process

    If you ever want to transfer your calendar records, you can simply export them to .ics file.

    1. Click on icon
    2. Click on List View option in the left nav bar
    3. Click on More and select Export option
    4. Select ics radio button, by default the Export all data options will be selected
    Note! While exporting records in ics format only Export all data option will be available. The other 2 options are frozen, this is a limitation, for now.
    1. Click on Export Calendar

    Points to Remember

    1. All the mandatory fields have to be mapped during import.
    Note! Activity Type is a mandatory field
    1. A new Activity type (say, Demo meeting) can be imported. This value will be added in Event > Activity Type picklist value.
    2. If a Task record is being imported, mention the Activity type as Task, else an event record will be created with Activity Type value specified in csv file.
    3. Send Reminder, Repeat and Invite User field values can neither be imported nor exported. Import fails, if Visibility field is empty or contains improper value.

    Date and Time Field Values

    1. Start Date, Due Date, Time Start and End time are all different fields which has to be mapped individually during import.
    2. On import, the Time start and End time fields remains same as specified in csv file irrespective of the time zone configured in My Preference.
    3. Date field values depend on date format configured in My Preference. Any other format found during import, the date field value will be empty.
    4. If My preference date format is mm-dd-yyyy or dd-mm-yyyy, system can auto detect the value from csv file and import the values as in My preferences.
      • You can import values like – 21.10.2010 or 21/10/2011 where as you cannot import values like – 8 June 2013
    Note! The csv file should always contain the Time values in 24-hour format only.
    1. On import if the date field contains wrong date values like 36-45-2016, then the value will be overwritten as 01-01-1970
    2. On import if the time field contains wrong time values like 50:89:00, then the import fails.
    Note! If the End Time is not mapped/empty, then import considers it as a Task, irrespective of it being a task/event.

    Related To Fields

    1. Relate an event to more than one contact record while import by following the below mentioned structure.
      Contacts::::Jessie Stokes,Contacts::::Daniel Avasti
    2. For related to field, if no prefix is given (say in above example, if Contacts is not specified), then system will search for that value in following order- Organization, Campaign, Cases, Invoice …. Services (as mentioned in the Related To block).
      • If no record found, then it will create new record in Service with that name and relate event to it (as service is last in the list).
      • If there exist a new custom module (with no mandatory reference fields), then a record will be created for that module.