Data Management
Validation Rules
A validation rule allows you to specify your own business-specific criteria to prevent users from saving invalid data in one or more fields
Working Amor bags has a spreadsheet of recent leads they'd like to import to salesforce. How can we do that?
Always import leads with Data import wizard
Data Export Service
An Automated way of receiving a zip file of csv's of all your salesforce data. The data export service: is available within the application Can be scheduled emails you when the zip files are ready zip files are deleted after 48 hours, regardless of whether or not you have downloaded them
Export or Delete Data...import wizard vs data loader?
Apex Data Loader
Load objects such as products or opportunities...import wizard vs data loader?
Apex Data Loader
Load up to 5 mil records.. import wizard vs data loader?
Apex Data Loader
Save Mappings for later use...import wizard vs data loader?
Apex Data Loader
Schedule Imports...import wizard vs data loader?
Apex Data Loader
Data Import/Update best practices
Create any necessary fields prior to import Clean up data prior to import Export any necessary record ID fields Prepare and upload a test batch Do not perform updates to records during normal business hours Deactivate workflow rules before running any import, update, insertion
System Data Validation
Custom fields can be marked as required and/or unique at the system level to force users to always enter a value or prevent records with duplicate values.
AW computing would like to perform an automatic backup of all salesforce data once a week. What tool should
Data Export Service
Load objects such as leads, accts, contacts, solutions, campaigns...import wizard vs data loader?
Data Import Wizard
An administrator needs to import 2,000 leads without triggering any workflow rules. What tool should they use?
Data Import due to workflow
If you want to import fewer than 50k records... import wizard vs data loader?
Data Import wizard is preferred though you can use data loader
AW computing needs to export 50 open opportunities, which tool should they select?
Data Loader due to exporting opportunities
An Administrator wants to back up the manufacturing industry accounts in her organization before she begins a large import. What tools could she use?
Data Loader or reports
AW Computing would like to import 50 new accounts and their associated contacts into salesforce from CSV files. Which records should they import first?
Data import
Choose whether or not to trigger workflow rules.. import wizard vs data loader?
Data import wizard
Prevent duplicates when importing records... import wizard vs data loader?
Data import wizard
AW Computing would like to perform an automatic backup of all salesforce data in one week. Which tool should they choose?
Data loader
For Mass deleting:
Data loader/Dataloader.io - delete specific data from the DB Mass Delete option (up to 250 records at a time) Recycle Bin
Best practice before mass deleting is:
Export the records you want to delete by running a report or using Dataloader.io
Data Quality Dimension: Accuracy
How to asses: Install a data quality app from AppExchange. It can match your records against a trusted source and tell you how your data can be improved.
Data Quality Dimension: Completeness
How to asses: List the fields required for each business use. Then run a report that shows the percentage of blanks for these fields. You can also use a data quality app from AppExchange.
Data Quality Dimension: Age
How to assess: Run a report on the Last Modified Date of records. What percentage of records have been updated recently?
What permissions do I need to import records?
Importing records with Data Loader requires these permissions. "Read," "Create," "Edit," and "Delete" on the objects "API Enabled" "Bulk API Hard Delete" (only if you configure Data Loader to use Bulk API to hard-delete records)
An Administrator incorrectly imported a set of records into salesforce, which tools can the admin use to remove the records form salesforce?
Mass Delete or Data loader
Backup Options
Reports (export specific data to Excel, manual process), Data Loader (export specific data to CSV, Excel, or another database, manual or automated process), or Weekly Data Export Service (obtain a complete set of Salesforce data for archiving, automated process)
The Recycle Bin
Restore, view and manage deleted items
Data Quality Dimension: Usage
Use it or lose it! Is your data being harnessed in reports, dashboards, and apps?
Data Quality Dimension: Duplication
Use the Duplicate Management features in Salesforce and install a duplicate detection app from AppExchange.
Use the import wizards when:
You are loading less than 50,000 records. The object you need to import is supported by import wizards. To see what import wizards are available and thus what objects they support, from Setup, enter Data Management in the Quick Find box, then select Data Management. You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.
Use Data Loader when
You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records. If you need to load more than 5 million records, we recommend you work with a Salesforce partner or visit the AppExchange for a suitable partner product. You need to load into an object that is not yet supported by the import wizards. You want to schedule regular data loads, such as nightly imports. You want to export your data for backup purposes.
Mass Delete Option Definition
allows you to delete standard objects that meet certain criteria. A list will be given to ensure accuracy and alert of any potential child records to be deleted
For working armor bags' cases where Product = "other", support representatives must enter a value in the product description custom field to create a case
validation