So the next year will that be a good to discuss about is the apex data order and just a quick recap
of.
They fix data order.
It's a desktop application falling bulk imports and exports.
Can you use it for greater than 50 get a cart and you can use it for all the standard and custom objects
without any restriction and you get a very detailed log off your job.
Well if your success at cards offer yet out their cards in all these you can also get you love regular
data loads and lightly imports.
And like it has got a boost in the CSP file you view lot of it and you can you know actually do the
mappings very easily.
One main difference between the import wasn't on the data load as an import was added in but also it
was.
So that is no special don't order required for that but for those Apex data in order to basically go
to download the application and use it.
So what we go through the list go to the application inside a go for a data order data management data
order and they really have options for downloading the application.
So if it is what Windows use this option if it's for Mac use the other option and the X5 we get downloaded
and you go to use the application once it is automatically set up you only get the icon in your desktop.
So a large cyclone then use the application and for that let's quickly see the steps that we use to
use the data loader.
Pretty much the same that we have for the import was there because a little process is the same.
We got to prepare the data fight.
We go to select the standard object because select activity to be performed and you go to do the mapping
and then visit it does import that update on delete on which operation and do more.
That began to delete when using a data order we cannot do or delete using the import of the set and
the new guard to monitor the job status entry What about the header records if any.
OK let's be larger decided on the activity that we are going to do.
Let me know do a different activity no let's do the same activity that we did where input was it only
then they'll be able to do it I exactly see the differences between the import was it and their data
loading.
So the activity that we did via they import to visit.
Here's what importing some then leads into this a step.
So the same then leads.
I'm going to leave put it into the system.
So effectively we're doing what I did as I basically deleted all that end records that we created previously
using the import.
Was that okay.
No let's redo it where it makes data loaded so launch the data order.
You will have a shot code in your desktop basically and as you can see here that if we do windows that
will open the second window like you can very much close that and the floors window that opens you know
that you'll have the option of settings in the second we know you don't have that.
So what is the settings the settings basically Nobel Zoo Lake of which environment do you like.
You are basically going to load the information safe it is at best dark sense was dark on order for
does logging but sensible outcome and what does a bad size.
Basically all the settings that you want to use the data that you can do it right here.
So let me go.
Okay.
Because we are using the devil relations so it does log in boxes full circle.
So you know the item expedients if you are going to do the data or for your test environment then you
got to give it for ducks in order for this sort of protection than it is lugging boxes full circle.
Ok so I know that this I think is done.
The first thing that we got to do is to select operation that we have going to do using the data I load
it either it does insert a bit upset a delete export or export.
As you can see here that I've many other options available given their data load and if it does not
data in in it was at the exact date I imported the SEC the data and blood was that you can insert update
all upset only the first thing you can do using their data important was it.
But if you log or delete what if you go to export or if you go to export on and then you've got to use
the Apex data load.
And there might be a question like What's the difference between export and export on export basically
exports of data from your system and export all takes off they export from the recycling business.
If the criteria is matching that I can't say because then the recycling bin then you pull out all those
in a car accident OK.
No but our target is to insert the required once you click on insert it will ask for the user name and
password.
So what does this user name and password this user name and password is basically the credentials that
you use for logging into this Interpol's application.
So they use a name like you know you've got to give it was a name whatever and the password is just
not the password.
It does password bless your security token.
And as we discussed in the previous lectures the security token is important whenever you use these
desktop applications.
OK so just a quick recap like if you are really not able to reset your security token if you're not
able to do the security open go here go for my settings go for security token reset my security token
when you click on D user do security open automatically as I could do token will be sent out to get
in it.
So you going to use the security token as it say for example your password is the same mountain and
your security talking to some like 24 digit character stolen or something like this.
So you know you've got to upend your password with your security token.
So that all we want to signal orderly work.
So the logging.
Yes you know you have your username and the password is password plus security.
OK.
So once you give your user name password and the security token click on log in log and completed successfully.
So go next in step will be guard to select the data object means which object basically we are going
to work.
So if you select this option select a social all a object you do basically list on all the objects that
are there any IT organization.
So they're definitely very very efficient to have here we are working with leads.
So let me select leads.
So the object the selected that does leave and then you got to choose this yes we fight so upload this
yet CSP file it is giving you a process in this that lays it in succeeding good operation we can't defend
regards yes other CSC file has got then track actually it is basically showing that click on OK.
No like we got on the map the feeds that does data on the object the CSP columns there does that your
CSB fight.
So here we have got two options one is choose an existing map or create a map.
So what does this say already highlighted using that what was it.
Here we have options of saving the mapping.
So you just got to do the mapping only the first time you do the job the next time.
Like it then you repeatedly do the same job you can't see if the mapping and then uses option photo
using the mapping.
So no this being the flooding.
Let me do the mapping.
So the company we got the Metro map it with the companies will just drag and drop it here and the lead
status.
So this is the lead status and the name and the name.
Okay now that the mapping is that's what you can do is you can save them epic.
Click on Save mapping and you can see the mapping in any one of your obligations.
Say lead is important and you can save this mapping.
And next thing then you do the same job.
You can use the option choose an existing mapping and you can automatically do this mapping so it definitely
saves a lot of time.
So once done click OK so the mapping is done.
Go next.
And it is asking you to please bed and like against all these X's on the other files.
So let me say stay with the defaults.
Yes.
OK.
So he does giving me a status update of that.
So processing then offender a that it ends up with in 0 8.
OK.
And that operation is fully completed dividends that's as William says in 0 8.
So when you click on view success it opens up a file that Nicholas done on that at cards that got there
as part of your data fight.
So that identity cards and these are all the sales bills I.D. of the vendor cards.
What does a name company lead status and this data state does this item of and view errors.
Basically it doesn't contain anything because it ended up in a class.
Now you can see that log files that I created in my system in the in the place that we basically give
the location one of those close fight on the other day they had a fight and it gives off any errors
that give you good very detailed a message of why that edit basically happened because of some data
type mismatch or because of some pick list value incorrectly or because of some minded reveals missing.
Well I could give you the exact error message of white basically happened.
OK.
So this is about insect.
But what about update upset and delete you know for a day got upset our daughter deleted them basically
the records up existing in the system.
Right.
We have got some bad leads in the system and now that we want to update all the 10 leads from the state
as I said and not contacted could contact say for example.
So what we got to do.
So it gives us updates and deletes you know the input that you got to give you the sands pulls at a
guard I.T. from the value to be changed.
So in other case you know we got to given the values of all the I.D. of all the lead at a card I.D.
the sample societies and then we got to say the state does this say contact it.
So if we just want to update the status of the lead right records then that will be one two columns
that does I.T. and the status.
So your data finally will look something like this what an upset operation like the I.D. the samples
ideals that I got and the two columns that you want to update say for example I want to update the lead
status to looking contacted and you got to given the values and in case of it being a daily job then
even this column is not required.
Just the idea of the guards act you want to delete in the system just that is sufficient for a daily
job.
So this is about the insert update on their daily operations but that is one other thing that you can
do using a data loader that does the export operation.
So having to make it happen.
So go to the data to use the option export.
And you got to select which Sandoval's object that you are basically going to work on.
So let's say for example I want to little export all accounts and you got to choose a fine go next
and here like you have an option that and you can flamed equity.
This single will list on all the fields that are present in the object.
And here you have options that and you can add some conditions to that here for an example let me select
all the fields so select all fields so you'll get the query frame both here and you can add some conditions
to that say for example code type which is a pick list so equals and he did automatically list on all
the big list values that you have.
Say for example individual broker and add condition.
OK.
So now you can see that condition that an icon type equals individual broker that could automatically
be added up to equity.
So all the fees of equity.
And then finally to account type equals individual broker.
So it is not essential that you frame antiquity you know you can just choose the fields and the conditions
and equity would automatically be populated but then it only does it doesn't stop you from writing your
own goodies also here.
You can very much a right deal in equities in the window.
No.
So go finish.
Yes operation in progress OK.
Tells you that our students that's as well instructions and do it basically because I do not have any
of that class in the system let into account type equals individual.
That is a reason that is a zero successful extractions.
But still let me open the Excel CSP file until you do.
This is the CSA fight.
And as you can see he had a list of all the fields of the icons object and that are basically not at
guards because you know the criteria that they gave you did not match any records.
So that is the reason I'm not able to see any ID cards.
But otherwise if you do not give that back to you and probably you would pick up on that at cards off
you are going to object.
So this is the concept of export.
So this is all about it because a lot of it and you can insert update absurd export details from your
dance was application.