The MassEffect module is the ultimate data loading tool with full support for advanced file formats. Due to it's many unique features, MassEffect is used by the serious administrator looking for full data loading power and is fully international character capable.
Capabilities & Features
- Option to use the Salesforce Bulk API: BULK API is not supported by Salesforce in Professional Edition, therefore this option will not work for PE users.
- Insert/Import
- Update
- Upsert
- Delete & Hard Delete
- Export
- Including deleted and archived records
- Ability to decode attachments, documents and content upon export
- Undelete (ONLY soft deleted records (those still in the recycle bin) can be undeleted)
- Advanced right click options for ease of use and data retention
- Add constant values on insert/update/upsert
- Update if Empty, Merge with existing data
- Apply popular formulas to transform data on import/update
- Ability to see field attributes (Field Type, Size, Required, Unique, Calculated etc.)
- All operations can be scheduled through Windows Task Scheduler and/or DemandTools JobBuilder
Compatible Data Sources
- .xls
- .xlsx
- .csv
- .mdb (read/write support in 32bit DemandTools, NOT AVAILABLE in 64bit DemandTools)
- .accdb
- .udl
- .tab
Common Uses
- Migrate data from legacy systems
- Insert Products and Pricebooks
- Insert Attachments from files that resides locally on your PC (includes image files, xls, word documents etc.)
- Insert Salesforce Content that resides locally on your PC
- Mass upload new Tasks and Events to any object in Salesforce
- Link Contacts or Leads to a Campaign
- Add or reassign Account Teams
- Mass delete a subset of records (including the ability to hard delete)
- Mass delete archived tasks to free up Salesforce storage
- Populate newly created custom fields
- Update an object using something other than the Salesforce ID as a 'key'
- Export the full or partial contents of any table
- Including multi-table join capabilities (e.g. when exporting Cases, select fields from the related Contacts and Accounts)
- Export Account hierarchies using the Parent Account ID to grab fields from the related Accounts
- Schedule regular exports
- Schedule regular data loads, such as nightly imports
- Repair incorrectly imported data
- Save field mapping for future use (a great time saver, especially when a standard template is used for all imports and updates)
Click on the Links Below for more information on these MassEffect Features:
MassEffect Bulk API
MassEffect Results Files
MassEffect Transform Formulas
MassEffect Update
MassEffect Insert
MassEffect Upsert
MassEffect Delete
MassEffect Export
MassEffect Undelete
