# Batch Processing Tool

The workflows for Geocoding and Territory Assignment designed can be used on a day-to-day basis for addresses that are changed or added occasionally. However, for bulk geocoding/territory assignment on data, we recommend using the Batch Processing tool. This tool ensures that the bulk geocoding on records is handled in single batch. While in the territory assignment, this tool helps to assign the respective territories to all the selected records based on their Latitude and Longitude values***.***

{% hint style="info" %}
***To run this tool, the user needs to make sure that machine has Microsoft .net framework 4.0 and Maplytics installed in Dynamics CRM.***
{% endhint %}

*To run the tool, Extract the Batch Processing tool .zip file and run the BatchProcessingTool application.*

![](https://gblobscdn.gitbook.com/assets%2F-M0QoyqUVI8_HaZ9FOSL%2F-MJPpfSqiBGdrw7Pv62d%2F-MJPtvQw-c2kH4pPPUAH%2Fassets2F-M0QoyqUVI8_HaZ9FOSL2F-MFQ9TAa4RoQN_9uwABx2F-MFQ9d67sz_QsXi02-xc2F10.jpg?alt=media\&token=c9fd32da-3538-47c7-91a7-4fc6c2681ad9)

### Executing Batch Processing Tool:

**Connection Details:** Please enter the CRM details on this screen. The users have to enter the following details:

Deployment Type: The user can select either of the options given in below screenshot depending on their deployment.

1. ***Office365***

Show Advanced: The user can select the Online Region and proceed to enter the ‘Username’ and the ‘Password’

Organization: The organization list will be auto-populated with the organizations available in CRM on selecting the checkbox. Select the organization for which Maplytics is to be or already has been installed.

Username: Username of a valid CRM user. For example <mollyc@mollyc.onmicrosoft.com>

Password: Password of CRM user

2. ***On-premises***

Server: Please enter the server url of CRM. For example, http\://\<servername>:\<port> or https\://\<orgname>.crm.dynamics.com&#x20;

Organization:

When the user enters the server URL  in the case of *On-premises* deployment model, the organization list will be auto-populated with the organizations available in CRM on selecting the checkbox. Select the organization for which Maplytics is to be or already has been installed.

Username: Username of a valid CRM user. For example: <mollyc@mollyc.onmicrosoft.com>

Password: Password of CRM user

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FbOlgrBpPMps2T2F5DkYK%2Fimage.png?alt=media&#x26;token=c9fad987-52e3-4f27-8f4a-475da2110c2f" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FF5PcGj4N7tPNicKLUz1D%2Fimage.png?alt=media&#x26;token=74886521-64a9-4292-b8df-c8c62b621397" alt=""><figcaption></figcaption></figure>

**Make A Selection:** Here, the user can make a selection whether they would like to run this tool for Geocoding (Batch Geocode) or Territory Assignment. The third option is available for installing/ uninstalling Territory Distribution Windows Service. In this example, we have chosen Batch Geocode as shown below:

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FZFyMFgaXBNf8yhoevnTl%2Fimage.png?alt=media&#x26;token=a24cd46a-4755-4503-bd68-247402372132" alt=""><figcaption></figcaption></figure>

**Choose Entity and Filtering:**

Please find the details of the same below:

·       **Entity:** Select the entities on which the user would like to run this tool.

·       **Views:** Once the user selects the entity, all the views defined for this entity are populated in the list of views. Select the required view.

&#x20;The plus sign can be clicked upon to add more entities and views. The check box at the bottom allows the records to be shared with the user, if required.

&#x20;Non-Geo coded Records have a separate view ‘Non Geocode’ for Batch Geocoding for all the Entities. All the non-geo coded records of multiple entities can be processed together.

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FHocKmXd7Sz4h5tGRlNmC%2Fimage.png?alt=media&#x26;token=29eb20d7-5bb1-4556-98a5-3e5c583f0dd2" alt=""><figcaption></figcaption></figure>

Users can enter the email address, if they would like the job results to be mailed to them.

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FJOZgSMreyJrgQhXuLpap%2Fimage.png?alt=media&#x26;token=5f1ac95a-e84b-4e3b-a3a4-bfb3ca067301" alt=""><figcaption></figcaption></figure>

The user can go back to the previous stage while in the ‘Make A Selection’ and ‘ Choose Entity And Filtering’ stages of the process. Returning from Processing and Result stage is not possible.

&#x20;**Processing :**

In this section, the user can see the progress of the geocoding process. User can quit the process anytime by clicking on the option at the bottom.

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FrYL3mhsXp8DpYs4v6SmT%2Fimage.png?alt=media&#x26;token=22dbe4c0-364b-4c8d-b148-85df10f0b33b" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
***The Batch Processing Tool takes time to process based on the number of records selected. Please do not close the window until this process is completed.***
{% endhint %}

**Record Summary:**

**Geocoding:**

**Bing Status:** This shows the number of records for which the geocoding from Bing Maps was a success or a failure.

**CRM Status:** This shows the number of records for which the updation of geocoordinates (Latitude & Longitude) to the respective CRM records was a success or a failure.

After completing the geocoding process, the user can download the results. The results will be downloaded in Excel format. User can check the columns of CRMDescription and BingDescription in the result to check the reason for failure of processes on the records. &#x20;

&#x20;With the options at the bottom, the user can return home, download the result in an Excel format, or exit the process.

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2Fr9lvS42qSCnMiSZrOM9I%2Fimage.png?alt=media&#x26;token=78e8e583-62fe-43d0-844d-014d94f946cd" alt=""><figcaption></figcaption></figure>

**Territory assignment:**

**CRM Status:** This shows the number of the records for which the updation of Territories for the respective CRM records was successful or failed.

<figure><img src="https://3017709171-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPnKwzedQAh8ohtXMDq%2Fuploads%2FeKCx3OjipCzpqjvCLuEB%2Fimage.png?alt=media&#x26;token=b3b2cada-f1e7-459d-bd4c-a97ce27f6453" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

1. ***The Non Geocode records can be processed in a separate view for all Entities***
2. ***Non Geocode View is not applicable for Territory Assignment while running the Batch processing tool***
   {% endhint %}

**Related Posts:**

* [Geocode Bulk Dynamics 365 CRM or PowerApps records for OOB/custom entities in a single batch with our new Batch processing tool!](https://www.maplytics.com/blog/geocode-bulk-dynamics-365-crm-powerapps-records-for-oob-custom-entities-in-a-single-batch-with-batch-processing-tool/)
* [Run workflow on individual records on maps within Dynamics CRM](https://www.maplytics.com/blog/run-workflow-on-individual-records-on-maps-dynamics-crm/)
* [Geocoding Records in Dynamics CRM](http://www.inogic.com/blog/2016/06/geocoding-millions-of-dynamics-crm-records-using-maplytics/)

{% hint style="success" %}
For any queries, reach out to us at <crm@inogic.com>
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.maplytics.com/features/batch-processing-tool.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.