Skip to main content

Notifications

Announcements

No record found.

Supply Chain Management forum
Answered

Error during "Vendor Catalogs" CMR file import (CatVendorCatalogEntity)

Posted on by 925

Hello, 

Has anybody been able to configure and run the vendor catalogs import recently? I have the PU40 installed, followed all the instructions from the Microsoft blog, tried all the file examples (samples and the actual CMR) available in this world, but still getting an error.

Here is what I have done: 

1. Enabled the vendor for catalog import,
2. Added the vendor to procurement categories,
3. Generated the *.xsd file for the vendor,
4. Generated the sample *.xml file from it,
5. Deleted the namespaces, added the <UploadDateTime> for "template",
6. Created Data Management project for "Vendor Catalogs" composite entity, everything is mapped, 
7. Uploaded the actual CMR file (without <UploadDateTime> section) from catalog level.

After importing I am getting the "There are no valid products to import" error in the vendor catalog event log. When I check the import project log, there is an error "Input string was not in a correct format." for the composite entity. The system didn't even start to import data into staging tables. However, the same file is imported into staging tables when I run it from the Data Management project level. It fails because this entity should be used only for the import from the vendor catalog level (where the vendor party is automatically passed), but the staging data is there. 

The only difference I found between PU40 and the manuals from the earlier versions is that product number fields on the staging tables became mandatory (it is a related field), but even after adding this field to the file, the import fails. 

Any ideas? Maybe somebody managed to configure this functionality recently?

Here is my "sample" file with <UploadDateTime>:

<?xml version="1.0" encoding="utf-8"?>
  <Document>
    <CatVendorCatalogMaintenanceRequestEntity>
    <UploadDateTime/>
    <CatVendorProductCandidateEntity>
      <ProductCategoryHierarchyName>Procurement - Office Supplies</ProductCategoryHierarchyName>
      <ProductCategoryName>Cleaning</ProductCategoryName>
      <ProductNumber>ProductNumber1</ProductNumber>
      <SearchName>SearchName1</SearchName>
      <CatVendorProductCandidatePurchasePriceEntity>
        <CurrencyCode>AED</CurrencyCode>
        <Price>1</Price>
        <UnitSymbol>1/2 cu. in</UnitSymbol>
      </CatVendorProductCandidatePurchasePriceEntity>
      <CatVendorProductCandidateSalesPriceEntity>
        <CurrencyCode>AED</CurrencyCode>
        <Price>1</Price>
        <SuggestedPrice>1</SuggestedPrice>
        <UnitSymbol>1/2 cu. in</UnitSymbol>
      </CatVendorProductCandidateSalesPriceEntity>
      <CatVendorProductCandidateDefaultOrderSettingsEntity>
        <OrderQuantityMultiples>1</OrderQuantityMultiples>
        <MinimumOrderQuantity>1</MinimumOrderQuantity>
        <StandardOrderQuantity>1</StandardOrderQuantity>
        <MaximumOrderQuantity>1</MaximumOrderQuantity>
        <LeadTime>1</LeadTime>
        <UnitSymbol/>
      </CatVendorProductCandidateDefaultOrderSettingsEntity>
      <CatVendorProductCandidateTranslationEntity>
        <Description>Description1</Description>
        <LanguageId>af</LanguageId>
        <ProductName>ProductName1</ProductName>
      </CatVendorProductCandidateTranslationEntity>
    </CatVendorProductCandidateEntity>
  </CatVendorCatalogMaintenanceRequestEntity>
</Document>

Any the actual CMR file: 

<?xml version="1.0" encoding="utf-8"?>
  <Document>
    <CatVendorCatalogMaintenanceRequestEntity>
    <UploadDateTime/>
    <CatVendorProductCandidateEntity>
      <ProductCategoryHierarchyName>Procurement - Office Supplies</ProductCategoryHierarchyName>
      <ProductCategoryName>Cleaning</ProductCategoryName>
      <ProductNumber>ProductNumber1</ProductNumber>
      <SearchName>SearchName1</SearchName>
      <CatVendorProductCandidatePurchasePriceEntity>
        <CurrencyCode>AED</CurrencyCode>
        <Price>1</Price>
        <UnitSymbol>1/2 cu. in</UnitSymbol>
      </CatVendorProductCandidatePurchasePriceEntity>
      <CatVendorProductCandidateSalesPriceEntity>
        <CurrencyCode>AED</CurrencyCode>
        <Price>1</Price>
        <SuggestedPrice>1</SuggestedPrice>
        <UnitSymbol>1/2 cu. in</UnitSymbol>
      </CatVendorProductCandidateSalesPriceEntity>
      <CatVendorProductCandidateDefaultOrderSettingsEntity>
        <OrderQuantityMultiples>1</OrderQuantityMultiples>
        <MinimumOrderQuantity>1</MinimumOrderQuantity>
        <StandardOrderQuantity>1</StandardOrderQuantity>
        <MaximumOrderQuantity>1</MaximumOrderQuantity>
        <LeadTime>1</LeadTime>
        <UnitSymbol/>
      </CatVendorProductCandidateDefaultOrderSettingsEntity>
      <CatVendorProductCandidateTranslationEntity>
        <Description>Description1</Description>
        <LanguageId>af</LanguageId>
        <ProductName>ProductName1</ProductName>
      </CatVendorProductCandidateTranslationEntity>
    </CatVendorProductCandidateEntity>
  </CatVendorCatalogMaintenanceRequestEntity>
</Document>

Thank you in advance!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error during "Vendor Catalogs" CMR file import (CatVendorCatalogEntity)

    Hi ,

    I am trying to import multiple Products in one CMR/XMl file.Only the 1st record gets created .Could you please help me with the format .

  • MATTGUO Profile Picture
    MATTGUO 22,298 on at
    RE: Error during "Vendor Catalogs" CMR file import (CatVendorCatalogEntity)

    Thank you for the update.

  • Verified answer
    axk Profile Picture
    axk 925 on at
    RE: Error during "Vendor Catalogs" CMR file import (CatVendorCatalogEntity)

    My sufferings are over. Upgrading from 10.0.16 to 10.0.17 resolved the issue.

    Update 07.04.2021: Probably it was not a problem with the Platform Update. The Data Management module does not tell anything about it, but the configurations keys mentioned below are required to avoid the CMR import errors:

    - Product dimension - color, 
    - Product dimension - configuration, 
    - Product dimension - size, 
    - Product dimension - style. 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans