Data Management in Salesforce (Import & Export Tools) | Salesforce Administrator скачать в хорошем качестве

Data Management in Salesforce (Import & Export Tools) | Salesforce Administrator

In this video (Episode 52), we kicked off a new chapter in the Admin Journey: Data Management — and explored how to Import and Export data in Salesforce using the right tool for the right job. We compared four key tools side-by-side (Data Import Wizard, Data Loader, Data Loader.io, Salesforce Inspector) and practiced real scenarios like importing Accounts/Contacts & Leads, cleaning data in Excel, exporting data for backup, and handling deletes (soft vs hard). 🎯 Perfect for: Salesforce Admins doing Data Migration / Data Cleanup Admins & Developers working on Integrations and data operations Anyone preparing for the Salesforce Administrator Certification 📌 What You’ll Learn: 🧰 Tool Selection: Which Tool to Use When Data Import Wizard: best for supported objects and ≤ 50,000 records Data Loader: supports up to 150 million records, supports all objects, saves mappings, can run via CLI, can connect to databases Data Loader.io: setup-based tool with a 10,000 record limit before paid tiers Salesforce Inspector: fast SOQL export + paste-to-import for update/upsert/delete/undelete 📥 Data Import Wizard (Hands-On) Supported standard objects: Accounts, Contacts, Leads, Solutions, Campaign Members (+ Custom Objects with permission) Operations: Insert / Update / Upsert Field mapping basics + “repeat mapping every time” limitation (no saved mapping) Import got tracked as a Bulk Data Load Job with results files 🗑️ Mass Delete + Soft vs Hard Delete Mass Delete from Setup using filter criteria Soft Delete: record flagged as IsDeleted = true and moved to Recycle Bin Hard Delete: permanently removed (requires the right permission, especially via Bulk API) 🔍 Salesforce Inspector for Quick Data Work Export data using SOQL Copy to Excel, edit, paste back for Update / Delete / Upsert / Undelete Great for fast cleanup tasks (e.g., filling missing phone numbers) 📦 Data Export Service (Backup & Extraction) Export Now or Schedule Export Schedule frequency depends on license: Weekly or Monthly Output delivered as a ZIP file via email link after processing 🧠 Data Prep Best Practices (Excel + Data Quality) Data profiling before import (duplicates, inconsistent values, normalization) Excel tools used: VLOOKUP to map names → IDs (e.g., Owner Name → OwnerId) Pivot Tables for profiling (e.g., “CA” vs “California”, “SF” vs “San Francisco”) Picklist governance: Restricted picklists block invalid values during import Multi-picklist values stored/imported as semicolon-separated Import rules: Checkbox: 1 = checked, 0 = unchecked Formula fields: cannot import (calculated) Validation rules: in effect unless you use controlled bypass patterns (e.g., settings/permissions for integration users) 🆔 Salesforce IDs (15 vs 18 Characters) 15-char: case-sensitive 18-char: case-insensitive (safer for integrations) 👤 Ownership During Import Owner affects sharing/visibility Import Wizard can map using Owner Name Data Loader typically requires OwnerId (lookup → User ID) ⏱️ Timestamps: 00:00 – Intro Data Management tools 01:10 – Data Import Wizard 07:00– Mass Delete + Soft vs Hard delete (Recycle Bin vs Permanent) 12:00 – Import Custom Object permission 13:46 – Data Export:Export Now vs Schedule Export 15:15 – Salesforce Inspector Reloaded 19:15 – Data Loader Overview 22:30 – Data Import Wizard vs Data Loader 25:32 – Prepare for Data Import 36:57 – Demo Data Import Wizard 51:14 – Data Export 🚀 Related Playlists: Salesforce Flows    • Salesforce Flows   🔗 Follow Us for More Salesforce Insights: LinkedIn: [  / yalla-salesforce  ] LinkedIn: [  / bassem-ismaiel  ] Trailhead: [https://www.salesforce.com/trailblaze...] Trailhead: [https://www.salesforce.com/trailblaze...] #Salesforce #YallaSalesforce #DataManagement #ImportandExport #DataImportWizard #DataLoader #DataLoaderIO #SalesforceInspector #SOQL #DataMigration #SalesforceAdmin #Trailhead #trailblazercommunity