Updating Occurrences Date & Time - Using the Import Wizard
Often you find yourself in a situation where you need to update the start or end dates for a number of occurrences associated with a Volunteer Opportunity.
Building the Report
The key to any data update is to build the correct report. For this example we will be creating a new report. From the Reports tab click on "Create New Report". On the Create New Report, type in "Occurrences" to create a report based on the Occurrence object, then click "Continue".
In the report itself make the following changes:
1) Show Me: All Occurrences
2) Date Field: End Date & Time
3) End Date & Time: Whatever criteria you choose. Leave at All Time to see all occurrences, or if you are updating future occurrences, change the range to Custom, use today's date as the Start Date and leave End Date blank. Click Apply.
5) Add Filter: Enter whatever filtering criteria you'd like such as Volunteer Opportunity, Recurrence, Managing Organization, etc. For this example we are filtering for the occurrences associated with the Volunteer Opportunity: Field Day Volunteers.
Volunteer Opportunity EQUALS Field Day Volunteers
The only column that is initially present is the Occurrence: Occurrence ID column. You can leave this in the table for easier reference or remove it if you prefer.
6) Add these columns:
Start Date & Time
End Date & Time
****Update all existing connections? In the event that the occurrences you are updating currently have active connections and you want the date information to be reflected on all of those existing connection, an additional data load must be made to those connections when using the Import Wizard.
7) Once you have all the columns and desired filters, click on "Run" (You can save this report if you feel that you will be using it often to update occurrences and just modify the filters as needed the next time)
Once you've run the report, export it as a .csv file.
Open the file and make the necessary changes to the start and/or end dates & times.
Formatting the Date and Time columns
After you make the necessary updates to your data table, you need to ensure that the Date & Time fields are in the right format for salesforce to recognize the new values.
This note is from the Salesforce.com Help & Training post.
When importing Date/Time values into Salesforce using the import wizard, you cannot format the cells using the 24 hour clock. The import wizard requires the AM and PM nomenclature in the field. Do this by formatting the cells so that the mask used is: m/d/yyyy h:mm AM/PM
To do this in Excel, follow the instructions below:
1. Highlight the column in question.
2. Right click and select the "format cells".
3. Select the "custom" option and place your cursor in the Type field on top of the list and add the value:
m/d/yyyy h:mm AM/PM
5. When done, click OK, and your column will be properly formatted.
Now save your file and prepare to import the new dates and times.
Importing the Updated Data
We will use the Salesforce Import Custom Objects wizard.
Go to Setup then type Import Wizard in the quick find on the left.
Then click Launch Wizard! to begin.
- Select the Custom objects tab and scroll to the Occurrences object. This list is not in alphabetical order, but in the order they exist in your instance. HandsOn Connect package objects will be grouped together.
- Select to Update Existing Records
- Match by Salesforce.com ID (this is the 15- or 18-digit unique ID from your file)
Since we are ONLY updating date information, the rest of those options can be left alone.
Drop or select your file and click Next to continue to mapping your fields.
The auto mapping may LOOK perfect, but you must change the Occurrence ID and map it to the Salesforce.com ID. Type in salesforce.com into the Find Field box and be sure to click on the "X" to remove the Occurrence ID mapping. Click Map, followed by Next.
Click on Start Import and you will be greeted with a "Congratulations, your import has started!" window. Click OK and you will be automatically taken to your Bulk Data Load Jobs page where you can see the status of your job.
On the Bulk Data Load Jobs page, you'll have an overview of the data load just completed using the Data Import Wizard.