---
schema_version: "1"
id: e8c4bb8915161fd7c789184d4106ccffb6d16c913a8f75a710f552797bf0fc0a
title: Pre-Import Validate VersioningDate
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/ind/264-0-0/comms_pre_import_validate_versioningdate.md
canonical_url: https://help.salesforce.com/s/articleView?id=ind.comms_pre_import_validate_versioningdate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e7268c8c6eeda8390cd61fa5a5870388823a73f054cf8d7470ae6933e1a77717
description: Used before importing products from other orgs, this report checks that the product data to be imported has valid versioning dates. The global keys must be the same across the two orgs. It validates each product version’s date range against dates on line items in the org. It then sends an email with a list of products to be imported whose versioning dates are invalid.
products:
  - Communications
  - Media
  - Energy and Utilities
release: "264"
---
# Pre-Import Validate VersioningDate

Used before importing products from other orgs, this report checks that the product data to be imported has valid versioning dates. The global keys must be the same across the two orgs. It validates each product version’s date range against dates on line items in the org. It then sends an email with a list of products to be imported whose versioning dates are invalid.

This report requires that the input file GlobalKeysToVersionDates.csv is uploaded in the Static Resource folder in Setup. This file has a list of global keys, versioning start dates, and versioning end dates for product versions that will be imported into the org.

The file must use the format shown in the following example. The locale for both the orgs should be same. The accepted format for version dates is `YYYY-MM-DD HH:MM:SS`. The script throws an exception if date is entered in any other format.

The file name and the static resource name have to be the same, and both must be named GlobalKeysToVersionDates. Otherwise, the job doesn't work.

```
"GlobalKey","VersionStartDate","VersionEndDate"
"1bda99bd-b75d-d940-5736-9d48ad81c65c","2021-04-01","2021-04-20"
"2bacfded-4719-74fa-8bcb-f5731f881fb7","2021-04-01",""
"6eecb743-01d6-307e-8473-20412c9fa791","","2021-04-20"
"09087665-859c-07dd-0ca0-207302dc6412","2021-04-01","2021-04-20"
"8bdc35ca-bef0-f25a-de0f-ba50640b9d90","",""
```

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col>
        <col>
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d305895e50">
            <p style="margin-bottom:0;">Applies to</p>
          </th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d305895e56">
            <p style="margin-bottom:0;">Salesforce Industries Communications, Media, and Energy Summer
              '21
            </p>
          </th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">Apex Name</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p style="margin-bottom:0;">PreImportValidateVersioningDataBatchJob</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">Where to Run This Job</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p style="margin-bottom:0;">Reports Jobs link on the Vlocity CMT Administration page &gt; Admin
              Console table.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">Risks of Running This
              Job</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p style="margin-bottom:0;">No Risk</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">When Not to Run This
              Job</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p style="margin-bottom:0;">When you're not importing product data from another org.
            </p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">When to Run This Job</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p style="margin-bottom:0;">After you have enabled the versioning feature and before importing
              products into your Production org from other orgs.</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">How to Run This Job</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <ol>
              <li>
                <p>Manually create the <samp class="filepath">csv</samp> file
                  (<samp class="filepath">GlobalKeysToVersionDates.csv</samp>) which has data
                  from the Master org with modified version dates.</p>
              </li>

              <li>
                <p>From Setup, search for and open <strong class="uicontrol">Static
                    Resources</strong>.</p>
              </li>

              <li>
                <p>Click <strong class="uicontrol">New</strong>, and add a new static resource
                  named <kbd>GlobalKeysToVersionDates</kbd>.</p>
              </li>

              <li>
                <p>Upload the file named
                  <samp class="filepath">GlobalKeysToVersionDates.csv</samp> into the static
                  resource.
                </p>
                <p>The locale should be same for both orgs.</p>
              </li>

              <li>
                <p>For the Pre-Import Validate VersioningDate job in CMT Admin
                  Console &gt; Report Jobs, click <strong class="uicontrol">Start</strong>.</p>
              </li>

            </ol>
          </td>

        </tr>
        <tr class="">
          <td data-label="Applies to" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e50 ">
            <p style="margin-bottom:0;">More Information</p>
          </td>

          <td data-label="Salesforce Industries Communications, Media, and Energy Summer '21" class="slds-cell-wrap" style="vertical-align:top;" headers="d305895e56 ">
            <p>An email is sent to the user running the job with a report of
              products that pass or fail the validation.</p>
            <div>
              <a name="comms_pre_import_validate_versioningdate__uuid-3a9653a6-38cf-645e-fa56-55f70f4d562e-en.png__d42e592374a1310"><!-- --></a><img id="comms_pre_import_validate_versioningdate__uuid-3a9653a6-38cf-645e-fa56-55f70f4d562e-en.png__d42e592374a1310" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-comms_media_energy_managed-264-0-0-production-enus/ff4079f6-a384-475c-b863-578bbbb0ef9b/resources-product/images/cme_preimport_validate_job_email_success.png" alt="Invalid product email example.">
            </div>
            <p>An email is sent if there's an error, such as the
              incorrect date format in the input file.</p>
            <div>
              <a name="comms_pre_import_validate_versioningdate__uuid-31f2917f-2128-9e5b-f8b4-4ee76004fb45-en.png__d42e592379a1310"><!-- --></a><img id="comms_pre_import_validate_versioningdate__uuid-31f2917f-2128-9e5b-f8b4-4ee76004fb45-en.png__d42e592379a1310" src="https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-ind-comms_media_energy_managed-264-0-0-production-enus/ff4079f6-a384-475c-b863-578bbbb0ef9b/resources-product/images/cme_preimport_validate_job_email_error.png" alt="Invalid date format email example.">
            </div>
          </td>

        </tr>
      </tbody>
    </table>