Dynamics Community Forum Thread Details

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>