 Hello, hi everyone. I am Sanjay Gupta. I welcome you on Sanjay Gupta Tech School. As you can see today we have day number 13 session and for this session topics are data import, wizard and data loader. So till now we have gone through lots of data creation in Salesforce org. So in this session you will get to know how we can import and export data. So we will be importing data outside Salesforce org. So we'll be creating data through Excel sheet and those data we will be importing in Salesforce and we can also export data from Salesforce to your local system. So export we saw through reports as well but through data loader we can perform both the operations in import as well as export and through data import wizard we can do import operation. So these two topics I will be discussing with you and very good evening, good morning, good afternoon to everyone those who have joined the session. Okay so moving forward this is me. These are my details. Then I hope you are following all the best practices and I can see like in each session more than 150 concurrent user joins and when I end the stream so the total count is more than 500. So thank you for making this bootcamp a success and like we are in week number five sorry we are in week number four and like in two sessions we discussed about data security and today we will be discussing about data import and export. So I think you are doing all the exercises and I would request you to please share the feedback about exercise sheet and frequently ask questions document that I prepared for you. So is it fruitful for you or do we need some updates? So please share your suggestions in the chat so that basis on your chat I will try to improve upon those. So today also I will be explaining the topic and will give you the demonstration and after completion I will take your question and answers. Okay so please subscribe follow and share the social media channels and so that you can follow and you can have all the information with you and here you can see we are about to complete week four today and next week I will be completing remaining admin concepts as well and week six will be for admin projects. So I think by the end of this month admin part will be totally completed and from next month we will be starting Flow Builder. Okay so I didn't see any feedback so I think everything is going good right. So please share your feedback timely so that it will motivate me as well as it will give me suggestions so that I can improve upon. So let's start with the session. So first I will be discussing data import wizard and then we'll do some hands-on with data loader right. So what is data import wizard? So it is basically a tool which helps to import data from Excel or CSV format into Salesforce. One can find this in setup so this is inbuilt tool which is available inside Salesforce so you don't need to install any additional software for this. One can import up to 50,000 records at a time so this is the limitation and one can perform insert update and absurd operations. So insert I think it is very easy if you want to create new records that process is known as insert. If you want to modify or edit existing records then that process is known as update and absurd means both insert as well as update right. So we'll do this hands-on together. So for this I have created some exercises for you that we will be doing in this session and later on you can also try these yourself. So here you can see with data import wizard we need to create an Excel sheet having account information and sheet should contain account name, account revenue, type, rating, employees and description. So these are some fields those we will be having an Excel sheet and that Excel sheet will be having some data and I will be downloading that sheet as CSV format and then I will be importing that into Salesforce right. So let me take you here and last week so I'm just making one announcement last week few people asked me to put some trailhead modules so instead of mentioning those trailhead modules session wise here you can see I just created a tab and this is named as trailhead modules and here I listed all important trailheads modules those you need you can go through and here you can see lots of trailhead projects are available that you can complete and super badges are also available so these super badges are also equivalent to projects okay and later on when we will be starting development part so I will be adding more trailhead links here. For today's session I created this sheet for you so here you can see name, rating, type, annual revenue, employees and here I'm going to add a description as well so description I'm adding insert right now I'm going to have one more information abc2 rating I'm having as warm type I'm copying as prospect so I'm just increasing the size as well so that you will be able to view it clearly okay then annual revenue number of employees let's say 100 and description insert right so this way these two rows are available here so my requirement is I need to import two records those are available in this excel sheet into Salesforce right so what I can do I just need to download this sheet so to download this you just need to click on file and from here you need to go to download and here you will find this option comma separated values so just click on it your excel file this particular sheet where we are working right now so you can see this sheet label is account so in your system you can create the sheet it is a google sheet and I just downloaded and at the bottom you can see this download option is available like it is downloaded now after this what I need to do I just need to go to setup and here I'm going to search data import wizard right so at top left corner you can see I searched about data import wizard okay so yesterday I got one more suggestion like sometimes when I don't zoom my screen so things are not visible clearly when you watch the recording later on so I'm trying to zoom everything so that everything will be available clearly with you so you can see you need to search for data import wizard then this option will be available just click on it and data import wizard option will be available so here you can see if you have any recent import jobs so those will be available here and everything will be available status object records created updated failed start date processing time so information will be available then here you can see brief information about data import wizard is available so you can see this is written over here don't import too many records at once using the data import wizard import up to 50,000 records at a time right importing too many records can slow down your org for all users especially during periods of peak uses so basically whenever you want data import so we select off hours when people are not using your org in a particular organization right so it can be night hours or early morning hours when people generally don't use all so you can see these are the steps to import data so first you need to prepare your data for import so we already did this then choose data to import then we need to map the fields and we need to review and start import right so here we have this button launch without launch wizard if you click on this button so you will see another UI here and this is interesting and here you can see we have two options on left hand side you can see we have list of standard objects and list of custom objects so data import wizard is having another limitation like very few standard objects data you can import and custom objects I think all are available which we created in during this boot camp so I just created four custom objects in this org so all are available here so if you have created data for these objects you can import I'm going to give you a demo for account right so if I click on account accounts and contacts so here you can see these three options are available add new record update existing then third is add new as well as update existing so this third option is known as absurd okay so I'm just clicking on this first option add new record because right now I just want to add some new record I just want to insert those records in the org right so here you can see we have certain options match contact by so in this sheet I don't have any contact related information I just have account related information and here also like we can just ignore just just go through this help text it says unique values in your data for example id values or email values help Salesforce determine whether to add new records or update existing so what does it mean if you have id is already populated in that excel sheet so if record id is there it means that record is already there in the org so that won't be insert operation it will be update operation so right now I'm not selecting anything here because I just want to insert and I don't have any id in that data then here you can see we have two more options trigger workflow rule and processes so these are some automation tools so why importing data if you want to run these you can just enable this checkbox if you don't want to run workflow rules and processes so you can just leave it as is then if you are importing contacts if you want to assign them to campaign so campaign is parent to contact object so if you want to link the contacts with campaign so you can just select it right so right now we are not doing this as well and allows assigning a contact to a campaign during the import so you just need to select which campaign will be having the contacts okay so right now in case of insert we are leaving it as is we are not doing any change if I scroll to right so here we have where is your data located so choose the file containing the data you want to import you can import up to 50,000 records at a time right so this you need to go through okay now you have certain options available here drag csv file here to upload so you can drag and drop if you don't want to drag you can just click on this first option so it will open up a pop up sorry it will it will show you this option and if you click on choose file so it will open up pop up and here you can see this is the latest file which I downloaded right and you just need to identify the name I just downloaded it earlier as well that's why like it is named as two and I am opening it so it is just selected now I am just clicking on next now this is important so here you need to do field mapping so you can see many fields are mapped automatically like account name rating type annual revenue employees description these are mapped automatically okay now if you want to change so you can just click on change and you can change mapping as well but it is done automatically and you can see some sample data which is available in our csv file it is also available here now you just need to click on next okay so here you can see if you forget to map particular field that is required so it is giving error as well right so in my org active field is marked as required how we can identify like for one of the demonstration on account object I just marked active as required so we can just verify it from here I am searching for active and if I open this field so here you can see it is marked as required so that's why whenever you are uploading data or importing data you just need to provide value to this active field as well so what I am going to do I am moving to my sheet and here I am filling active underscore underscore c and here I am writing yes okay so now I need to download this file again and I need to import it or upload it again so I am clicking on file downloading it and here I am moving back sometimes this also happens like you won't see error here and what will happen like when you complete the import operation then you will see the error so we'll see that also like how we can identify so this time I am selecting this number three file I am opening it clicking on next now here you can see this active field is not mapped here it is showing unmapped so what you can do click on map click on map and through this box you can just search for that field and you can select it and click on map so now you can see that field is mapped so if any particular field is not mapped so you can do that manually and mapping is important so here at top you can see this is mapped Salesforce object fields and this is csv header that we created in form of excel now if I go and click on next so you can see a few more information are available so everything is correct mapped fields are seven unmapped are zero and if I click on start import so it is showing me this option click okay to view your import status on the bulk data load job page and click on okay now here after import whenever your import operation completes so you will see this kind of page right so I am just zooming it so that you can see we have job id submitted by start day start time and time object then content type right so everything is mentioned here then operation we performed insert then completed batch 1 progress 100% record processed 2 and if something is failing so that failed record count will be available here and if any record fails so here you can see we have this option view request view results so if you click on this view result option it will show you success and failure results right and if you scroll to right so here everything in every information is available so this way you can identify the status of your bulk data load job right now this process is complete so whenever this process is completed just refresh your account page and you will see those records here so you can see abc1 and 2 are available one abc1 was already there because I just tested prior to session but these are created today and if I add field created date so that we can identify created date I am saving it so here you can see so right now we just added these two which are on 717717 and on 522 I added one more right so these two are added at same time so there here you can see the timing okay so this way whenever you complete import operation so you can just check it in your org as well now I am moving here now if you want to perform update operation so for update operation you need to consider like your data is already available in org and that data you need to update so right now you can see description is having insert so if I take you here again and if I open this record so in the description you will see it is having insert text right now what I need to do I am going to update this description to update I am going to update this description to update right so this field should be updated and will have value as update but if you want to update particular record so you need to know the ID of that record like which record you want to update so here what I am going to do insert one column to left and here I am placing ID now I don't know ID of these records so in data import wizard we don't have export operation like we cannot export data from Salesforce to Excel but this option is available with data loader when I will be explaining about data loader so we won't be manually copying the ID here instead we will be exporting the whole data so here I am going to manually copy these IDs from the URL so I am copying ABC1 ID and I am going to paste it here right so this records ID is available here now I am going to open another account and from URL I am going to copy and paste it right so these two records are available here and I just updated this description information okay now again what I need to do I need to download this and I need to perform update operation so I just need to click on file download and here I am selecting comma separated values then going here again I am searching for data import wizard and one more thing I just want to show you if you go here on accounts tab so here also you will see this button import so if you click on this button so automatically your data import wizard will be launched right so this way you can launch import wizard now what I need to do here I am launching the wizard and this time I am going to perform update operation so update existing records and now here we will be matching them with salesforce.com ID so you need to select this option right then if you select this option so selecting this option updates existing account information with the account data in the current import leave this option deselected if you don't want to update existing account information so we need to update so I am selecting this checkbox rest I am leaving as is and from here I need to select the CSV file so this is the latest one number four and I am opening it so I just need to click on next okay so this field is unmapped so I am just going and mapping it and this time you can see ID is also mapped automatically and here you can see ID's and this description field will get updated and it will be having value as updates so clicking on next and start import then okay so here you can see it is showing record process two and record failed two so our process is completed and it is successful now what I need to do I just need to refresh the records so you can see there is no new record created if I sorted basis on created it so there are existing records if I open the abc to go to details so here you can see in the description I have this update so this way I just updated uh existing records and third operation is absurd so for that I am going to create one more abc hot then prospect so this way I have three records now and here I am writing absurd absurd so these two records which are existing records they will be updated and their description will be having absurd as a value and this one is not having ID so this will be created as a new record so in which row ID is available that will be updated if you updated some value here if row is not having ID it means that row will be inserted as a new record right so this way we need to process the sheet now so I am going to download it moving here and again I am going to choose data import bizarre so I am going to launch the bizarre and selecting the object and this time I am selecting third option match accounts by ID update existing account information so these options I am selecting here and rest I am leaving as is and generally like we don't select these options because whenever we mass upload data so we don't want to run our workflow rules and process so from here I am going to select the CSV file so it is number five and I am just going to open it now clicking on next so mapping will be done so it is unmapped so I am again mapping the active field so here you can see for two records ID is available for third one ID is not available so two will be updated and one will be inserted now I am clicking on next and start import okay so here you can see three record persist and this time operation was absurd here you can see right and if I go to the org and do a refresh so you will see the results so I am just clicking on accounts tab so you can see ABC three is created so only one record is created at time seven to six and those two records which were created earlier they got updated right so if I open ABC one this one and if I go to details so in the description I will find absurd right so this way through this data import wizard I just explained you all three steps insert update and absurd and we can do only three operations through this tool now if you want to import a used number of records so we have another tool that is known as data loader right so through this we can upload like five million records so it helps to import data from excel or csv format into salesforce one has to install it in the computer through downloading from internet right so you just need to install this software and we can import up to five million records at a time and we can perform insert update absurd delete export and export all and export will export the data which is available under object and export all will export the data which is available under particular object as well as the data which is available in recycle bin which you have already deleted right so these operations we can do through data loader and for a few insert update absurd we prefer data import wizard but majorly we prefer data loader because through this we can have we can do more operations and on large number of records right so now I'm going to show you how you can download and install so in your salesforce or you can just search for data loader option and if you click on this data loader option so here you will find this option so data loader is a client application for the bulk import or export of data use it to insert update delete or export salesforce records so if you want to download if you want to read the developer guide or help guide so these three links are available so if you click on downloads so it will give you it will redirect you to the page from where you can download so here you can see we have two download options mac os and windows and all the downloading details are available if you want developer guide so it will be opened and here you will find all the steps so if you go to this option installing data loader so here installing data loader on mac os and install data loader on windows both the options are available so if you go to windows so here you will see all the steps you need to follow these steps and your data loader will be available and if you are using mac so you need to follow these steps okay and these are simple steps you just need to follow them line by line and everything will be done and your data loader will be working right so now if i go and check the exercise sheet so here you can see uh data import wizard i completely explained now we need to go to data loader and we need to perform all the operations right so i am going to use the same sheet and from here i am going to delete it right and i am going to change the names to xyz1 xyz2 xyz3 right so these three records i will be first inserting so i am writing insert okay so this data i created now i will be inserting it with the help of data loader right now data loader is not available in your org so what you need to do first of all you need to install it and then after installation you need to log in with your org right so here in my system you can see data loader is already installed and i'm going to open it so this way it will look like so these options will be available insert update absurd delete export export all right so if i click on insert so first of all it will ask me to do this login process so we have two options you can authorize the org and you can provide password information so what i'm going to do i'm going to select the environment first so right now the developer edition org which we are using it is a production org so i'm just clicking on logging in and i will be filling my username and password and will be logging in so i'm not sharing that information with you so you will be seeing a pop-up where you can just fill the information and you can just log in so i'm just providing that information and it will ask deny and allow so you just need to select allow option and here you can see it is showing login successful now i just need to click on next so i selected insert operation so now from this tool i will be selecting the object so you saw like in data import without there was limitation it was showing only four standard object but here you will see all the standard objects and right now it is showing a few objects but if you click on this checkbox show all salesforce objects so it will be showing you all available salesforce object and you can see the like how use this list is right so so now what i need to do i just need to select my object as account right and when i selected account as object so after that i just need to select the csv file so i'm just clicking on browse and here downloaded files are available so let me first download the latest one so moving back here and i'm going to download this as csv and here i'm going to browse it so it is number six i'm opening it so it is selected now i'm just going to click on next okay so here you can see initialization succeeded it is showing your operation will contain three records i'm clicking on okay now here we need to do mapping so you saw in data import wizard we did mapping so here also we need to do mapping here we have option to choose existing mapping as well so whenever you create any mapping and if you use that mapping frequently so you can save that as well so i'm i don't have any mapping so i'm just going to click on create or add it a map and here you can see we have option to auto map so i'm just clicking on this and you can see all the csv headers are mapped with a particular field of that object right if something is wrong wrongly matched so you can just click and you can drag and drop right so i'm just clicking on okay then clicking on next and finish so it is saying you have chosen to insert new records click yes to begin do you want to proceed yes so insert operation is completed and you can see three successful inserts and zero errors if you want to view errors and successes so we have these buttons so if you click you will see error and success messages right so clicking on okay now what i need to do i just need to go to the org and i will be checking whether records are inserted or not so i'm refreshing the page and here you can see three records are inserted right and they are having same time date so this way i was able to import the records right now if i want to update so again i need to apply the same process so i'm just okay so here we have one option like instead of copying each and every id so here you can see we have export option available right so if you export and then like you will be having id of particular records so what you need to do you just need to modify the data and same file you can use for update purpose okay so how we can export so right now what i did i just clicked on this export option from here i'm choosing account and it is saying choose a target for expression right so i'm choosing target as desktop so i'm going to choose desktop right i'm clicking on save then next now here we need to choose the fields which we want to have in the excel sheet so i'm choosing active i'm choosing account source annual revenue and i'm going to choose id as well because id is required if you want to update something so i'm choosing id so account source active annual revenue id and let's say i'm choosing description as well okay and from here i can select the field so let's say i'm choosing active then here i am i can choose the operator like equals and value as yes if you create this condition where clause so you can just click on add so this way your soql that we will be discussing while learning apex so it is created automatically through point and click you don't need to remember how to create it you just need to select the options which are listed over here right if you want to add one more condition so you can just change these values and click on add condition so it will be added here now what will happen few account records will be exported where active underscore underscore c equals to yes will be there so you can just click on finish and yes so here you can see total 17 records are extracted okay and if you want to view extraction just click on it and here you will see your data right so we have a row number we have account source we have active annual revenue and description and at last you can see we have id as well okay so this is csv viewer i think we cannot update things here but what you can do you can just open this in excel or google sheet you can just update any field and then same csv you can use for update so from here you can go and select account as object then click on browse and from here you will be selecting this extract dot csv that is available on desktop if you click on open so it will be selected then go to next then okay and then you need to map the fields so auto map then okay and next so i just did not update any record i'm just showing you how you can export and i'm assuming like in whenever you will be practicing so you will be updating that that excel sheet and then you will be using that for upload okay so i just clicked on finish and yes so update operation is performing and it is saying all 17 records were updated successfully okay so this way you can export and that exported data you can use for update and same if you want to do absurd so i think you understood how we can do absurd with data import wizard so in case of absurd what we need to do uh the data which we exported having id and after that we can have few more uh rows where we won't be providing id so that file we can use for absurd okay so the steps will be same so now what you need to do you need to perform all these operations so here every state statement is written so you need to do this step by step and for update you can do both you can manually put the id's or you can just export and then update some data and then you can use that exported file for update or maybe for absurd right now if you want to delete so what you can do you can just export the data and you can perform delete operation so here in our process what i can do delete select the object and select the csv file that we downloaded open next okay then we need to map so auto map so id is mapped so in delete we just need id which record we want to delete so id will be mapped out only click on okay next and finish so records will be deleted and they will be moved to recycle bin and here you can see nine successes and eight errors right now why errors came so what you need to do just click on view errors and you will see the error messages if you scroll to write so these these records were not deleted and why this happened because those records were having some validation rule or something like that right now if you want to check the deleted records so what you need to do first of all you can refresh it so just click on this tab and you can see there are very few records most of the records are deleted now if you want to check the deleted records so you can just search for recycle bin and here you can see the deleted records and see the date and time and this time is basically showing am time because my org time zone is pst which is pacific zone so their morning is happening so that's why this time is available and you can see nine records are deleted if you want to restore you can select and you can just click on restore so they will move back to your object right so i'm restoring them so they moved and if i come here so you can see now those records are available under the object and similarly if you use export all so export all will be exporting the data which is available under object as well as the records which are available under recycle bin so this way this data loader you need to practice with the help of this exercise sheet and if you will be having any question so you can just ask that question in the comment section of this video or you can use the telegram group so that you can do some communication right and like i i can see like this desktop is not showing this screen in zoom format so like this is this is the limitation so i have another video for this so if you go to my website study salesforce.com and if you go to administrator then lightning experience so there you will find two more videos so for data loader i would prefer to go through this recording because it will be having zoom data right now i won't be like i was not able to zoom that desktop so because of screen limitation so if you if you're not able to see this clearly so you can just watch this row number 59 video so these are basically videos which are available here and you can see lots of videos are available here so we understood them with the help of practical demonstration and if you if you want to revise particular topic again so from here also you can just go through from these recordings okay so i would request like this is last session of this week so you will be having enough time to practice day 13 right and next week we will be having two sessions only and then our admin basic admin stuff will be completed after that week we will be doing a project and then we will be starting flow and flow is basically part of admin as well as app builder right once flow will be completed then i will be guiding you on this certification stuff okay so so this is all about today's session and those who understood everything they can leave and if you have any question then you can ask in the chat so now i'm going to take questions from the chat and we'll try to answer and there may be some questions i just need to figure out the solutions so i'm like updating that live question and answer document on daily basis so you can just go through that as well it is being updated so yesterday's session questions like a few questions i added few i will be adding tomorrow because like in remaining three days of this week i will be having enough time to prepare all the material for you so today's session question answers will be there by the end of this week so there is one question from sort of unable to see app manager option in salesforce setup so if you login with system admin user so you will be able to yeah so thank you crypto university for this suggestion for feedback form yeah like in the middle of this bootcamp i will do that flow will also come under admin yeah flow are part of admin as well as app builder so ashish is asking difference between salesforce admin and business and and so maybe when i will be discussing about different roles later in this bootcamp then i will be explaining this in detail dharini is saying please take more examples so i'm trying to have enough example but because of the limitation of time i'm trying to put them in the exercise sheet and when we will be learning about flow and other development tools so i will try to have more examples yeah dori update absurd means both insert and update right together jigna thank you i'm also waiting for the mvp result so it will be coming next week so let's see hope for the best please pray pray for me uh sandeepa asking okay thank you sandeepa for appreciating our surah is having a question is there any limit for metadata fields like for records it is 50 000 no no surah's limitation is for record only ferris is asking if we have many active validation rule trigger flow and process builder would you recommend turning them off before bringing the data yes so ferris best practice is turn off those because if you don't turn off them in that case there may be lots of issues and you won't be able to successfully import your data umka is asking if i want to map the field but doesn't show certain field for example employee how can i solve it so i i think i already showed you if field are not mapped so it will show you unmapped and it will give you a button for mapping so through that you can do uh sujith is asking if we provide wrong id so if you provide wrong id or for that particular record your absurd operation will be failed and uh like uh i don't think it will be inserted because you are providing id so that that operation won't be insert so i would suggest like try this practically and let everybody know through telegram group like what happens so this is nice scenario sujith is asking if we put wrong id for absurd operation like if we are updating particular record with id but id is wrong so what will happen it will be giving error or creating new record so everybody please try this and let me know as well i will also try and put the answer in the document yeah amya org time is not in india time it is in psd time zone can we import all types of objects through the detail order yes yes ashish we can both wizard mary's asking both wizard and loader can use for the same object or for certain standard object you have to choose one yes so we use excel when we are working in detail order wizard or so what function do we mostly use most of them to ask about no excel function i don't think they will be asking because we are not using any excel function we are just creating data and we are using insert update absurd delete extract these operations if we want to import accounts with its own id field how we can avoid duplicate during the import so i think you know id's are already unique so i just selected that option while importing right so if you select if you provide id so that is always unique and if id is available then you won't be able to insert it means you will be able to update or delete only if we want to import accounts with its own id how can we avoid duplicate doing it will be failed only few yeah so if there is some issues so record will be failed otherwise they will be successfully performing perspective operation so if you provide id then there won't be any case of duplicacy and if you have duplicate rules then there may be chances of duplicacy so because of that if you have selected allow so your record will be created if in your duplicate rule you have selected block so your record won't be inserted and you will receive an error Lalith i was not able to zoom the screen in the last when i showed a data loader so like what you can do i just showed you study salesforce.com website so they are in lightning experience section a row number 59 video you can see there everything is explained in zoom and you can follow the exercise which is available in the document what happened with pick list or validation rules so if validation rule is there that will fire you can deactivate it before importing and if you have pick list so while importing account so we were using type as a pick list so you need to provide valid pick list values so if you remember when we create pick list so we have a checkbox like restrict values so that is for data loading like if you check that checkbox so your pick list will be restricted like whatever values are available in the pick list you can have only those values in your excel not other than that alias thank you for donating some amount for for coffee surely i will buy a coffee this weekend thank you Lalith for appreciating my efforts as it is asking doubt in user password reset i'm unable to reset password so i think you can search for video i think study if you go to study salesforce there you will find video otherwise you can just search for a blog jigna thank you again next is while importing data if data errors then all the saved data rollback or data being saved stays in the db so like for this question if we are if you are working on 10 records if five are successful so they will be inserted updated or upset it if five are failing so they will be failed so this way it works she thought data loader requires jr11 all later showing this error after installation so i just showed you like you just need to go through the steps so just search for data loader in the setup you will see the download documentation guide through that you can just install akshay thank you for appreciating and in 2020 i was also learning so like it took me three years to create lots of content on youtube and in 23 i got enough confidence like i can go live and teach people and answer these much of questions so like right now i am able to do this bootcamp that's why i am doing but don't worry this year you will have admin development sales cloud service cloud omni studio marketing cloud so i am trying to give you as much as a content icon so you will not regret this year sonali's asking i already solved hands-on data import export but today clear all things of the data okay thank you sonali we have data export option which is built-in yes so that you can also use and data export option is available with the reports as well i think no dory we cannot import data about history tracking because it is created when you do some changes in the org praveen for admin certification i think fees is 200 dollar and if you fail so second time you need to pay 75 dollar okay so next is difference between export and export all so prana i already explained if you do export so it will export the data which is available under object if you do export all so it will pick data which is available under object as well as under recycle bin so deleted data will also be included in export all bishal mvp is a program it it stands for most valuable professional so sales force award this title for certain professionals those are doing good for the community free of cost like i'm doing this bootcamp so for this year i i already got nomination i'm just waiting for announcement so it will be happening next week like by the end of this month it will be announced if i become so i will also share my journey with you but i'm not sure hope for the best shubham is asking what are the expected question ask okay so shubham like whatever we are discussing right now these are the questions that will be asking that interview will be asking asuras thank you how to update checkbox field so you just need to provide true and false value for checkbox so just create a column in excel and type true or false yes bishal we can map master detail and look up as well but in those fields you need to fill the ids then only they will be mapped rahul singh pommar thank you for appreciating my efforts yesterday we used data loader when we have lots of records and you say like record to update as it requires id and it's tough to copy id so you don't need to copy id for all you will be exporting the data in export you will select the id right so if you see the recording again i just exported first and then used that data for update if you have many to many relationships so what you need to do in case of many to many relationship first you will be importing parent first parent then second parent and then junction junction when you will be importing junction so you need to just fill those ids so you can just export your parent records so that you can have ids in excel in two different excel so you can just copy and you can paste them together in one excel sheet and you can import shriveli is asking there is hard delete option in data loader which is disabled uh yeah this this basically uh deletes your data and it won't go to recycle then right so when you apply export all i think then it will be enabled i also never used it so just try to do export all then i think it will be enabled uh next question is while inserting new data through data loader sometimes it gives error related to external id can you please explain this so in that case like i also encountered this but when i researched so it is related to like required field or validation rule not exactly related to external id if your org is having integration with other systems then you will receive error for external id but i think it will be for some required field only ashish no i think in interview interviewer won't be asking about excel so you don't need to learn about we look up it is related to excel refresh is there a way to generate pdf pdf through excel or salesforce please specify this and we need resume building session one or two yeah so i will be giving resume building sessions as well but not now it will be uh and at the end of this bootcamp because before creating a resume we need to know the things as well yeah so nali thank you and i also request everybody please like the sessions and share session recordings with everyone those who want to learn salesforce uh superja metadata means api name whenever we create any object field tab or app so we have their api names that is basically known as metadata next question is there is any way to generate pdf without vf for a custom object okay no i don't know like through visual force only we are able to create pdf's aksha thank you for appreciating mary next week i will be taking only two session and those session dates are available in the excel sheet it will be on tuesday and thursday yeah so amya thank you for sharing this information so salesforce days is coming and if you participate so you will be having voucher with less price so go through and just check for uh certificate certification days thank you mary amya is asking when are the days okay yeah yrs is asking when are the days so you can just search that uh in the google and you will find that information uh ana just try this yourself and if you get any issue so reach out to me with any uh platform whichever you like linkedin telegram youtube i will try to answer your question so rama uh answer this hard delete steps so i also never used hard delete so just go through settings check the checkbox use bulk api so then this option will be enabled thank you rama for answering this question okay sujeet just tried uh inserting sorry upsetting operation with the wrong id so he's saying it is failing not creating new record so uh like if you provide id then either it will be updating or upsetting but won't be creating new record thank you ana uh praveen for mvp like nominations are done i also got nominated uh now it's on salesforce they whether they select me or not so i'm not thank you ashish for appreciating uh sonali metadata is about data about data so generally in salesforce metadata means the api names which are available with particular entity vipul actually we import one object at a time so uh first you need to import parent and then only you will be able to import child uh girinath which document you are asking like excel sheet which is having uh the data which i created uh it is already shared with you uh so it is available in the description of this video so you can just search it there thank you lias thank you sneha uh thank you rama for this update like with bulk api hard delete will work umma thank you okay so if there are more questions uh how to see the exercise so exercise sheet link is also available in the video description so session tracker exercise sheet and frequently asked like the question you are asking here those questions are also uh available in a document with answers so you can find all the links in the description of the video just marry if i win so i will be having separate session for you so we'll share my journey with you for sure so apanna below 50 000 records we use data loader or not yes we can so data loader you can use for one to five million and uh data import wizard you can use for uh one to 50 000 rika is asking when we updating records using uh both of tools so mention record id is necessary in csv yes yes rika uh thank you umka uh girinath uh so can you please tell how to see documents for exercise okay so uh these these documents are available in the video description let me copy and paste them here so i'm just copying and pasting them here so okay this is too no i'm not able to copy the whole link so i think if you go to the description of this video you can find just see that there if not uh you can just ping me on um like uh linkedin i will share information with you linkedin or instagram or telegram wherever you want yeah sometimes uh header fails so yeah shortly we need to fix it okay guys so thank you i need to take one more session after 30 minutes so i'm just ending this session here only thank you so much for being such a wonderful uh uh like students for me asking uh really good questions and i will try to uh collect all these questions in that document along with the answers okay thank you so much so