|
Home > Archive > Commerce Server General > September 2006 > Catalog import error - I cant figure what it means
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Catalog import error - I cant figure what it means
|
|
| CodeDigger 2006-09-16, 7:28 pm |
| I am trying to send catalog data to Commerce Server from Biztalk. I have set
the Pipelines to be XmlReceive and XmlTransmit.
When I drop in a Catalog import xml file, I get this -
"<CommerceServerCatalogImportResponse><CatalogImportError LineNumber="13"
Message="Invalid column name 'NewCallout'.
Invalid column name
'PromoCallout'." /></CommerceServerCatalogImportResponse>"
For the life of me I cannot figure out what this message means. NewCallout
and PromoCallout are 2 optional custom properties defined, but with or
without them the import fails.
Here is a sample of the Product data I send in. If you want the complete
Catalog schema and the Import XML, they are here -
http://www.percepsys.com/marketing/CatalogXML.zip
<Product Definition="Appliance Product" ProductId="A8461"
UseCategoryPricing="0" listprice="99.9500" lastmodified="2006-09-12T17:48:07"
BrandCode="1" BrandName="Solano" FolicaWarrantyAvailable="0" FreeShipping="1"
IsAvailable="1" IsDiscontinued="0" IsHazardous="0"
ManufacturerSKU="SO-1875-747" NewCallout="Great Hairdryer"
PackageWeight="3.0" ProductName="Solano Platinum Professional Hair Dryer"
ProfessionalOnly="0" PromoCallout="Best Hair Dryer" ShowAvailableQuantity="0"
SuggestedRetailPrice="115.0000" TriggerAmazon="0" TriggerYahoo="0"
Visible="1" id="Id_8461">
<DisplayName Value="Solano Platinum Professional Hair Dryer"
language="en-US" />
<ImageURL Value="2973-A8461.gif" language="en-US" />
<LongDescription Value="Made in Italy. The most powerful professional
hair dryer that features stunning metal design with maximum turbo power."
language="en-US" />
<Power Value="1875 watts" language="en-US" />
<SellingFeatures Value="1875 watts provides powerful airflow for fast
drying" language="en-US" />
<ParentCategory rank="0">hairdryers</ParentCategory>
</Product>
| |
| Laura T 2006-09-16, 7:28 pm |
| Stupid question:
Did you generate the new XML schemas for Biztalk adapter, like
DefaultCatalog.xsd and so on.
"CodeDigger" <CodeDigger@discussions.microsoft.com> ha scritto nel messaggio
news:41C7FC8F-A31A-4A1B-8D4A-D33E1D61376C@microsoft.com...
>I am trying to send catalog data to Commerce Server from Biztalk. I have
>set
> the Pipelines to be XmlReceive and XmlTransmit.
>
> When I drop in a Catalog import xml file, I get this -
>
> "<CommerceServerCatalogImportResponse><CatalogImportError LineNumber="13"
> Message="Invalid column name 'NewCallout'.
> Invalid column name
> 'PromoCallout'." /></CommerceServerCatalogImportResponse>"
>
> For the life of me I cannot figure out what this message means. NewCallout
> and PromoCallout are 2 optional custom properties defined, but with or
> without them the import fails.
>
> Here is a sample of the Product data I send in. If you want the complete
> Catalog schema and the Import XML, they are here -
> http://www.percepsys.com/marketing/CatalogXML.zip
>
>
> <Product Definition="Appliance Product" ProductId="A8461"
> UseCategoryPricing="0" listprice="99.9500"
> lastmodified="2006-09-12T17:48:07"
> BrandCode="1" BrandName="Solano" FolicaWarrantyAvailable="0"
> FreeShipping="1"
> IsAvailable="1" IsDiscontinued="0" IsHazardous="0"
> ManufacturerSKU="SO-1875-747" NewCallout="Great Hairdryer"
> PackageWeight="3.0" ProductName="Solano Platinum Professional Hair Dryer"
> ProfessionalOnly="0" PromoCallout="Best Hair Dryer"
> ShowAvailableQuantity="0"
> SuggestedRetailPrice="115.0000" TriggerAmazon="0" TriggerYahoo="0"
> Visible="1" id="Id_8461">
> <DisplayName Value="Solano Platinum Professional Hair Dryer"
> language="en-US" />
> <ImageURL Value="2973-A8461.gif" language="en-US" />
> <LongDescription Value="Made in Italy. The most powerful professional
> hair dryer that features stunning metal design with maximum turbo power."
> language="en-US" />
> <Power Value="1875 watts" language="en-US" />
> <SellingFeatures Value="1875 watts provides powerful airflow for fast
> drying" language="en-US" />
> <ParentCategory rank="0">hairdryers</ParentCategory>
> </Product>
| |
| CodeDigger 2006-09-16, 7:28 pm |
| Yes, sorry forgot to mention that. Just added some properties, is all.
"Laura T" wrote:
> Stupid question:
> Did you generate the new XML schemas for Biztalk adapter, like
> DefaultCatalog.xsd and so on.
|
|
|
|
|