Salesforce Smart Importer – 1-Drag to import Excel / CSV in Salesforce, supports both Classic and Lightning!
- Jun
- 01
- Posted by Lin
- Posted in Apps, Salesforce
This is my third Chrome Extension named Salesforce Smart Importer (Other two popular extensions are Salesforce Mass Editor and Salesforce DevTools), it is designed for Salesforce not only admin but also normal user, supports :
・1-Drag to import any Excel / CSV data on anywhere in Salesforce, both Classic and Lightning.
・Automatize reference field value to lookup Id convertion.
・Mapping fields between sObject and Excel / CSV header only needs to be set once.
Notice : In Classic, don not check on “Require HttpOnly attribute” option in “Session Settings”.
If you login with a Non-Admin user, make sure “API Enabled” in profile has been checked.
Install From Chrome Web Store
Sample CSV is HERE
Once mapping was set, it will automatize fileds mapping next time. You can also use reference record Name instance of Id, it will do the convertion for you, as below :
Please feel free to comment at below with Facebook, if you have any questions or advices.
Install From Chrome Web Store
Enjoy it. : )
・1-Drag to import any Excel / CSV data on anywhere in Salesforce, both Classic and Lightning.
・Automatize reference field value to lookup Id convertion.
・Mapping fields between sObject and Excel / CSV header only needs to be set once.
Notice : In Classic, don not check on “Require HttpOnly attribute” option in “Session Settings”.
If you login with a Non-Admin user, make sure “API Enabled” in profile has been checked.
Install From Chrome Web Store
Sample CSV is HERE
Tips for using
In Classic
In Claasic, you can active it by clicking Extension icon, no needs any setting additional.Once mapping was set, it will automatize fileds mapping next time. You can also use reference record Name instance of Id, it will do the convertion for you, as below :
In Lightning or Community Cloud
If you are using Lightning Experience or Salesforce Community Cloud, it needs login once before using, as below :Issues
If you have any question, requirement and issue, report it HERE (Github) , that will be fixed ASAP!Please feel free to comment at below with Facebook, if you have any questions or advices.
Install From Chrome Web Store
Release Note
2018/07/02
・ Add Excel import feature.2018/06/13
・ Add feature of Upsert by External Id. ・ Add feature of automatize reference External Id field value to lookup Id convertion. ・ Fix bugs in Lightning.2018/06/01
・ Beta released.Enjoy it. : )
Post Tagged with Classic, Community, CSV, Data Import, Data Importer, Dataloader, Lightning, Mapping, Salesforce, データ導入
Recent Posts
- Salesforce DevTools Release Notes (version 3.10.0) – mass edit custom fields on lightning
- Salesforce DevTools Release Notes (version 3.9.0) – Object Fields, SOQL Query Editor
- Salesforce DevTools Release Notes (version 3.8.0)
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- Using Promise for Apex Server-Side request in Lightning Component
Top Posts
- Salesforce DevTools – Powerful Salesforce developer tools, loved by over 50K developers - 219.6K views
- Date format and DateTime format - 204K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 158.4K views
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 122.3K views
- Writing a Schedulable Batch Apex in Salesforce - 118.8K views
Categories
- APEX
- Apps
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- Event
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DevTools
- Salesforce DX
- SOQL
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress
You must be logged in to post a comment.