Data Loader Command Line

  *[  
 Place all the BAT files in the ‘bin’ folder of Data Loader.  
 Place Mapping file & XML file in Conf folder 
Create a new folder ➡️ Place CSV file ➡️ Give its path in the XML file correctly.
 ]
1.   Create a text file ➡️ Write any long word/number ➡️ Save 

  2.    Open CMD & run ➡️ encrypt.bat -k [path of file created in step 1]

  3.    Continue in CMD ➡️ encrypt.bat -e [OrgPassword] [Path of file generated in step 2]

  4.    Encrypted value is returned in step 3 ➡️ Save it for further use.

  5.    Open Data Loader (desktop version) ➡️ Create mapping file (.sdl format)

  6.    Configure ‘process-conf.xml’ file as per requirement 
(Fill the required Username, Password, Action, Path etc) 

  7.    Create a text file (ex-Filename) & write ➡️ call [name of your main .bat file] [path of Conf folder] [process-name you assigned in XML file] [path of the CSV to upload] [path where you want error files to be generated] [path where you want success files to be generated]

  8. Filename.bat

Comments

Post a Comment

Popular posts from this blog

SF Einstein ChatBot Setup & Training

Image
1.Go to Einstein Bot from Setup -> Enable the Bot -> Enable Log Conversation & Live Agent. 2.Create new Bot (Complete all the steps) 3.Once Bot is created all the basic operations/features of Bot can be used, except Training Chatbot. Create “Dialogs” & and interlink them according to requirement using following 4 functionalities. 4.To start Training the Bot, follow these steps: a . Enable “Dialog Intent” of the respective dialog, on which bot should learn. b . Sign-up for “Einstein Platform Services” by visiting the following Link: https://api.einstein.ai/signup c . After downloading the KEY (.pem file) & we have to upload it to our Salesforce Org -> By going to ‘Files’ by clicking 5. Go to Setup -> Create a ‘Remote-Site’. ·          Remote Site Name: EIS_API ·          Remote Site URL: https://api.einstein....
Read full article »

Re-Captcha in Salesforce

Image
RE-CAPTCHA IN SALESFORCE ( WEB-TO-LEAD )   Register with Google Account for an API Key :   Go to this link -  https://www.google.com/recaptcha/admin#list   Fill the form & Register   You will  receive ‘Site Key’ & ‘Secret Key’   Generate Web-To-Lead form:   Go to Setup -> Web-to-lead -> Click on ‘Create Web-to-lead form’   Follow the screenshots         Save & Generate .   You will receive HTML Code .   Copy-Paste the code in registered Domain site & Run .  
Read full article »

Calling REST API in one Org from another Org

Image
1. Write an API as per requirement & expose it. 2. Create 'CONNECTED APP' in Target Org. (Org where you have exposed API) 3. In Source Org (Org from where you are call API in Target Org), create 'REMOTE CONNECTION' of Target Org. 4. Create Apex class in Source Org to call API in Target Org. ---------------------------------------------------------------------------------------------------------------- public class AccountRestExampleConsumeFromOtherSFOrg{          public String AccountRestExampleConsumeFromOtherSFOrg(){                  String endpoint='https://login.salesforce.com/services/oauth2/token';                  String username = '***********';          String password = 'password+securitytoken';         String ClientId= '************';         String ClientSecret = '***********...
Read full article »