Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Answered

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

(0) ShareShare
ReportReport
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,308 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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans