Sfdc_05 (Data Loader)

Many beginners contact SFDC development time is very confused do not know how to build a table, do not know how to build the field and how to manipulate the data, the following one by one.

When the table name is selected instead of edited, go directly to the table

Now that you have created a table, you can view it in Eclipse.

Find your project and the bottom one is. Wait a moment after clicking.

Then first click on refresh First

Before creating the form, the name is labels, select the field you want to view, there is only the field, and there is no value.

When the field is selected, the SQL text is automatically produced. Click Run me to execute the SQL text.

There are several ways to insert data into a table. 1

Create a new class, write an insert method in it, and execute it with execute. You can insert the data

No_1 is the data.

2 Write the INSERT statement directly in Execute

This is the way no_2 is implemented.

3 operation with Data Loader

The first thing to do is to export the table first.

Password is your password + security tag

The security mark is in your registered email when you apply for the account.

Browse is the storage path where you export this table.

You can choose the field you exported this table, as well as the conditions, only the value is manually added, the others are automatically generated, add condition added to the following statement

Yh

The exported file is a CSV style because the insert must be in CSV format before it can be inserted, so make changes directly on the original file

ID is automatically generated, I removed him, Name_c to No_3

And then perform the insert operation

Select the table you want to insert, and insert the file

You are prompted that there is only one piece of data in the inserted file

Automatically put the field of the data you inserted on the field that exists in the original table

After the insert is complete, you have completed a data operation and succeeded.

You can then view this data in eclipse.

No_1

No_2

No_3

The three data are operated in different ways, and we'll introduce other methods later.

Sfdc_05 (Data Loader)