Вернуться   AXForum > Microsoft Dynamics CRM > Dynamics CRM: Blogs
Забыли пароль?
Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 15.10.2015, 02:17   #1  
Blog bot is offline
Blog bot
25,232 / 843 (79) +++++++
Регистрация: 28.10.2006
Microsoft Dynamics CRM Team Blog: Data Loader Service: How to Use (Part 2 of 2)

This blog post is the second in a two-part post about the Data Loader Service. The first post can be found here.

This post details a quick walk-through of how to use the service and various features.

Configuring Data Loader Service

There are 2 steps that need to be completed before this service can be used.

Step 1: Deploy the Data Loader runtime for a specific CRM organization

Data Loader for every CRM organization needs to deploy a new runtime module to ensure data isolation across organizations and to stay closer to the data center of the specified CRM organization.

1. Click on “Deploy runtimes” tile

2. Click on the “+” button and fill in the data in the pop up screen. Select the CRM organization that you would like to import data to and click “Deploy“ button on the page.

3. Deploy will take approximately between 15-30 minutes.

4. Your deploy is ready when the grid reflects “Running” status as below

Step 2. Configure the flat file format.

1. On the main dashboard click on “Configure file format” tile.

2. In the “Configure file format” page, click on “+” and enter the necessary information pertaining the flat file format. Here is the example of the standard CSV format.

3. Click save.

Now you are ready to start importing data into CRM organization.

Importing data

1. Click on the “Import” tile on the dashboard

2. This will start a wizard, follow the steps. Here you can upload data for more multiple entities as needed.

3. On the “3. Map fields” step, the service will do the best effort matching, of the source file columns to the target entity. For the unmapped fields you could choose to complete that mapping or ignore.

Another key point to note is, the drop down for target fields also displays any alternate keys that were defined on the lookup entities. So you can map the alternate keys for your lookup columns.

4. At the end of the wizard, give a name to the project and click on “Start data job”. This will start processing the uploaded files and import them to the cloud staging environment.

This is not starting the “Import to CRM” yet.

Viewing the Job execution details

1. Click on the specific job’s card view on the dashboard.

2. This will open the Job Details page, which is divided into 3 tabs:
  • Source tab. This will display the success or error encountered while processing the files into staging table. If there are any records which the service was not able to import into staging, it will display it as an error with details.
  • Staging tab. This is one of the important part of this service. This reflects all the records that were successfully imported in the cloud staging, in CRM, in errored etc. In this view user can run data quality validations and fix errors.
  • “Import to CRM” tab. This tab displays the progress status after import to CRM has started.
Run data quality services

1. On the Jobs details page, click on “Staging” tab

2. To run DQS, click on “Validate” as shown below. This will validate two things, metadata validation and look up validation. Depending upon the number of records this might take a few minutes, and you could start validate on all the entities parallel if needed.

3. At the end of validate, it will change certain records into “Not Valid” status – see the pic below.

Fix errors in Excel

1. User can fix the errors in Excel, by clicking on “Download to excel” button. This button is in the staging tab as shown below.

2. This will open excel. Click “Sign in” and enter the CRM credentials. Once authenticated, this will load all the errored records.

3. Review the error message and fix the records. After the records are fixed, click on “Publish”. This will publish the fixed records back to staging. You would need to refresh the data in the staging grid to see the changes.

Start Import to CRM

After the data has been validated and fixed in staging, you are ready to start the import to CRM action. This will basically start import for all the entities in the current data job.

1. Click on “Import to CRM” – as seen below.

2. Once the import to CRM has started, the progress of the import can be viewed in “Import to CRM” tab

Any records that did not make it in CRM will remain in the staging grid in “Errored” status with detail error message that was received from CRM web service. The user can review the error messages and fix the records again in Excel and retry import. This service enables iterative import of data until all the records that are required are imported.

Refresh CRM Metadata in Data Loader

Once the Data Loader runtime is deployed, and thereafter if there are metadata changes or customization added on CRM side, then you would need to follow the steps below to refresh the metadata in Data Loader.

1. Click on “Deployed runtimes” on the main dashboard

2. Select the CRM organization in the grid and click on the refresh icon over the grid.

This will start refreshing the metadata. It might take several minutes before the refreshed metadata is reflected.


CRM Product Team

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
atinkerersnotebook: Walkthrough & Tutorial Summary Blog bot DAX Blogs 1 09.09.2013 09:11
atinkerersnotebook: Using Service Management to Track Service Orders Blog bot DAX Blogs 1 25.08.2013 19:16
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 14 Blog bot Dynamics CRM: Blogs 0 12.07.2013 07:13
crminthefield: Podcast and Overview: Microsoft Dynamics CRM 2011 Update Rollup 12 Blog bot Dynamics CRM: Blogs 0 30.01.2013 01:11
Microsoft Dynamics CRM Team Blog: Create Sample Data for your Solution Blog bot Dynamics CRM: Blogs 0 01.12.2011 05:14
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 13:49.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.