Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 8 of 8

Thread: Help with XML import

  1. 10-10-2008, 02:19 PM #1
    russell.garrett is offline Member
    Join Date
    Oct 2008
    Posts
    44

    Default Help with XML import

    I can't get the following fields to pass information on an initial Product import. I have the fields below as they appear in my XML import file.


    <Images>
    <ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
    </Images>

    (Nothing in the variants gets passed)
    <Variants>
    <Variant>
    <PriceRef>9.9900</PriceRef>
    <Price>9.9900</Price>
    <SalePriceRef>8.7900</SalePriceRef>
    <SalePrice>8.7900</SalePrice>
    <WeightRef>0.125</WeightRef>
    <Weight>0.125</Weight>
    <CostRef>3.2500</CostRef>
    <Cost>3.2500</Cost>
    <Variant>
    <Variants>
  2. 10-11-2008, 03:18 PM #2
    Rex is offline Banned
    Join Date
    Nov 2007
    Posts
    561

    Default

    That isn't enough to go by.

    What version are you running?
    Attach an entire usable sample of what you are attempting to import in a file.

    Thanks
  3. 10-14-2008, 08:31 AM #3
    russell.garrett is offline Member
    Join Date
    Oct 2008
    Posts
    44

    Default

    Sorry about that, the store front version is 7.0.2.3/ML. Below is the xml file Im using for import.
    Sample:
    Code:
    <?xml version="1.0" encoding="utf-8"?>
<AspDotNetStorefrontImport Version="7.1" SetImportFlag="" AutoLazyAdd="" AutoCleanup="" Verbose="" TransactionsEnabled="">
<Product Action="" EnsureDefaultVariant="" GUID="" ID="">
<Name>LED Retractable Keylight with Belt Clip - As Seen on TV</Name>
<Summary />
<Description>&lt;p&gt;This LED retractable keylight will always be ready to light up your keys and lock to help you get in. With the just a push of a button the super bright LED will allow you to find the right key and see all obstacles in your way. The keylight also has a 9 inch retractable cord with keyring and a handy belt clip. The keylight requires 2 CR2016 lithium batteries that are included. The keylight measures in at 4 inches x 1.375 inches x .875 inches. The LED bulb will never need replacing.&lt;p&gt;Features Include:&lt;ul&gt;&lt;li&gt;Retractable keylight&lt;li&gt;Super bright LED&lt;li&gt;Handy belt clip&lt;li&gt;2 CR2016 lithium batteries that are included&lt;li&gt;Keylight measures 4 x 1.375 x .875 inches&lt;/li&gt;&lt;/li&gt;</Description>
<SpecTitle />
<MiscText />
<Notes />
<IsFeaturedTeaser />
<FroogleDescription />
<SKU>72-0188</SKU>
<ManufacturerPartNumber />
<SwatchImageMap />
<SE>
<SEName />
<SETitle />
<SEKeywords />
<SEDescription />
<SENoScript />
<SEAltText />
</SE>
<SizeOptionPrompt />
<ColorOptionPrompt />
<ProductType Name="Generic Product" ID="" GUID="">
<Name>Generic Product</Name>
</ProductType>
<ProductTypeRef>Generic Product</ProductTypeRef>
<ManufacturerRef>test mfg</ManufacturerRef>
<DistributorRef>Trademark Commerce</DistributorRef>
<CategoryRef>/As Seen on TV</CategoryRef>
<TaxClass Name="Goods" ID="" GUID="" />
<SalesPrompt Name="On Sale For" ID="1" GUID="" />
<SpecCall />
<SpecsInline />
<Display>
<XmlPackage>product.variantsinrightbar.xml.config</XmlPackage>
<ColWidth>3</ColWidth>
<PageSize>20</PageSize>
<SkinID />
<TemplateName />
</Display>
<Images>
<Icon Extension="" Delete="" />
<Medium Extension="" Delete="" />
<Large Extension="" Delete="" />
<ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
<MultiImage>
<Icon>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Icon>
<Medium>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Medium>
<Large>
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="1" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="2" Color="" Extension="" Delete="" />
<Img Index="3" Color="" Extension="" Delete="" />
</Large>
</MultiImage>
</Images>
<QuantityDiscount Name="" ID="" GUID="" />
<RelatedProducts>
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</RelatedProducts>
<UpsellProducts DiscountPercentage="">
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</UpsellProducts>
<RequiresProducts>
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
<CX ID="" GUID="" />
</RequiresProducts>
<InventoryType>
<TrackInventoryBySizeAndColor>0</TrackInventoryBySizeAndColor>
<WarehouseLocation />
</InventoryType>
<IsFeatured />
<IsAKit>0</IsAKit>
<IsSystem />
<IsAPack>0</IsAPack>
<PackSize>0</PackSize>
<ShowInProductBrowser />
<ShowBuyButton />
<Published>1</Published>
<Wholesale />
<RequiresRegistration>0</RequiresRegistration>
<HidePriceUntilCart />
<IsCalltoOrder />
<ExcludeFromPriceFeeds />
<GoogleCheckoutAllowed />
<RequiresTextOption />
<TextOptionMaxLength />
<TextOptionPrompt />
<AvailableStartDate />
<AvailableStopDate />
<Mappings AutoCleanup="" PreserveExistingRecords="">
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
<Entity EntityType="" Name="" XPath="" ID="" GUID="" DisplayOrder="" />
</Mappings>
<ExtensionData />
<ExtensionData2 />
<ExtensionData3 />
<ExtensionData4 />
<ExtensionData5 />
<Kit AutoCleanup="">
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
</KitGroup>
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<TextOptionMaxLength />
<TextOptionWidth />
<TextOptionHeight />
<WeightDelta />
</KitItem>
</KitGroup>
<KitGroup>
<Name />
<Description />
<DisplayOrder />
<KitGroupTypeID />
<IsRequired />
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
<KitItem>
<Name />
<Description />
<PriceDelta />
<IsDefault />
<DisplayOrder />
<WeightDelta />
</KitItem>
</KitGroup>
</Kit>
<Variants AutoCleanup="">
<Variant Action="Add" SKUSuffix="" GUID="" ID="" Name="LED Retractable Keylight with Belt Clip - As Seen on TV">
<IsDefault />
<Name />
<Description>&lt;p&gt;This LED retractable keylight will always be ready to light up your keys and lock to help you get in. With the just a push of a button the super bright LED will allow you to find the right key and see all obstacles in your way. The keylight also has a 9 inch retractable cord with keyring and a handy belt clip. The keylight requires 2 CR2016 lithium batteries that are included. The keylight measures in at 4 inches x 1.375 inches x .875 inches. The LED bulb will never need replacing.&lt;p&gt;Features Include:&lt;ul&gt;&lt;li&gt;Retractable keylight&lt;li&gt;Super bright LED&lt;li&gt;Handy belt clip&lt;li&gt;2 CR2016 lithium batteries that are included&lt;li&gt;Keylight measures 4 x 1.375 x .875 inches&lt;/li&gt;&lt;/li&gt;</Description>
<SE>
<SEName />
<SEKeywords />
<SEDescription />
<SENoScript />
<SEAltText />
</SE>
<FroogleDescription />
<ProductID />
<SKUSuffix />
<ManufacturerPartNumber />
<Price>9.9900</Price>
<ExtendedPrices AutoCleanup="" PullFromVariantID="" PullFromVariantGUID="">
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
<CustomerLevel ID="" GUID="" Price="" />
</ExtendedPrices>
<SalePrice>8.7900</SalePrice>
<Weight>0.125</Weight>
<MSRP />
<Cost>3.2500</Cost>
<Points />
<Dimensions>
<UOM>IN</UOM>
<Length>4</Length>
<Width>1.375</Width>
<Height>0.875</Height>
</Dimensions>
<Inventory />
<InventoryBySizeAndColor MatchKey="">
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
<Inv Size="" Color="" Quantity="" WarehouseLocation="" VendorID="" VendorFullSKU="" WeightDelta="" ExtensionData="" />
</InventoryBySizeAndColor>
<DisplayOrder />
<Notes />
<IsTaxable />
<IsShipSeparately />
<IsDownload />
<DownloadLocation />
<FreeShipping />
<Published>1</Published>
<Wholesale />
<IsRecurring />
<RecurringInterval />
<RecurringIntervalType />
<SubscriptionInterval />
<SubscriptionIntervalType />
<RestrictedQuantities />
<MinimumQuantity />
<Images ClearBeforeImport="">
<Icon Extension="" />
<Medium Extension="" />
<Large Extension="" />
<ImageFilenameOverride>72-0188.jpg</ImageFilenameOverride>
</Images>
<CustomerEntersPrice />
<CustomerEntersPricePrompt />
<ExtensionData />
<ExtensionData2 />
<ExtensionData3 />
<ExtensionData4 />
<ExtensionData5 />
<Sizes>
<Size SKUModifier="" PriceDelta="" />
<Size SKUModifier="" PriceDelta="" />
<Size SKUModifier="" PriceDelta="" />
</Sizes>
<Colors>
<Color SKUModifier="" PriceDelta="" />
<Color SKUModifier="" PriceDelta="" />
<Color SKUModifier="" PriceDelta="" />
</Colors>
<ShippingCosts AutoCleanup="" PullFromVariantID="" PullFromVariantGUID="">
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
<ShippingMethod ID="" GUID="" Cost="" />
</ShippingCosts>
</Variant>
</Variants>
</Product>
</AspDotNetStorefrontImport>
    Last edited by Jesse; 10-14-2008 at 11:29 AM.
  4. 10-15-2008, 10:04 AM #4
    Rex is offline Banned
    Join Date
    Nov 2007
    Posts
    561

    Default

    Product variants should be defined as
    Code:
    <Product>
   <ProductVariant>
   .
   .
   .
   </ProductVariant>
</Product>
  5. 10-15-2008, 04:06 PM #5
    russell.garrett is offline Member
    Join Date
    Oct 2008
    Posts
    44

    Default

    Works like a charm! Thank you sir. I see now how it works, although I still can't get the <ImageFilenameOverride> to pass anything. I know now it has to be something I'm just overlooking.
  6. 10-16-2008, 08:40 AM #6
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    Try ImageFileNameOverride (with a capital 'N')
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>
  7. 10-30-2008, 11:33 AM #7
    Dbennett4995 is offline Member
    Join Date
    Oct 2008
    Location
    Metairie, LA
    Posts
    62

    Default

    Russ,
    Did you construct the XML file you listed on here yourself or was this an XML conversion from another file? I am currently trying to import an xml file from AutoQuotes which contains everything from dimensions, weight, price, and photos. I don't have any experience working with XML as of yet.
  8. 10-31-2008, 11:09 AM #8
    Jesse is offline Banned
    Join Date
    May 2008
    Posts
    1,329

    Default

    That is self constructed following the instructions for XML Importing located in the WSI manual.