Event Sublists
When using the CSV Import Assistant to work with events records, you can interact with three sublists:
Attendees
You use the Attendees sublist to invite people to the meeting. Each sublist record represents a single attendee. Important fields in this sublist are:
-
Attendance Status — Indicates whether the invitee is required to attend. Possible values are Optional and Required. If you do not map a value for this field, the Import Assistant sets a value of Required.
-
Attendee — Identifies the person invited. This field is required. Valid values are active Employee IDs, Customer IDs, and so on. Note that each attendee of a single event record must be unique. If you mistakenly include the same person twice, the import of the record fails. Note that the owner of the record (the person doing the import) is always listed as an attendee.
-
Response Status — Indicates whether the invitee is planning to attend. Possible values are Accepted, Declined, No Response, and Tentative. If you do not map a value for this field, the system creates a default mapping of No Response.
This sublist is selectively updatable based on the Attendee field.
Resources
You use the Resources sublist to reserve things needed for the event, such as a conference room or projector. This sublist has only one field (Resource). This field must reference a record listed at Activities > Setup > Resources. For details on resource records, see Using Resource Records on Events.
This sublist is selectively updatable based on the Resource field.
Time Tracking
You use the Time Tracking sublist to charge employee time for the meeting. Required values include:
-
Duration — The amount of time for which to charge, in hours and minutes, separated by a colon. For example, to specify four and a half hours, use the following value: 4:30.
-
Employee — The ID of the employee for whom time is being charged. The employee does not have to be an attendee.
-
Location — Must identify a location listed at Setup > Company > Locations.
-
Date — If you do not map a value for this field, the system sets the value to today’s date.
The Time Tracking sublist is not keyed, which means that you cannot selectively update individual records in this sublist. For more details on non-keyed sublists, see Sublist Data Import.
For More Information
For details on other fields available for mapping, see the following:
-
For details on the event date and time fields, see Event Date and Time Fields.
-
For details on other required body fields, see Event Body Fields.
-
For help with additional body and sublist fields available for import, see the SOAP Schema Browser’s calendar event reference page. For help working with this tool, see SOAP Schema Browser.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.