Siebel eAuction Guide > Creating an Auction > Using Bulk Upload to Add Multiple Auction Items >

Setting Up the Files for Bulk Upload


To set up the XML file used in to bulk upload auction items, use the format in the following sample XML file:

<?xml version="1.0" encoding="UTF-8"?>
<SiebelMessage MessageId="" MessageType="Integration Object" IntObjectName="eAuction File Att Integration Object">
<ListOfEauctionFileAttIntegrationObject>
<AuctionAttachment>
<Description>Default Test 1<Description>
<AuctionItemDetail>
<ItemName>Default Test 1</ItemName>
<ItemLocation>Durham, NC</ItemLocation>
<StartingPrice>1</StartingPrice>
<ShippingandhandlingAmount>5</ShippingandhandlingAmount>
<PurchaseTerms>buy</PurchaseTerms>
<ShippingTerms>ship</ShippingTerms>
</AuctionItemDetail>
</AuctionAttachment>
<AuctionAttachment>
<AuctionFileName>Complete Test 1</AuctionFileName>
<Description>Complete Test 1</Description>
<AuctionFileExt>png</AuctionFileExt>
<AttachmentId Encoding="Base64" Extension="png" ContentId="001" AttachmentIsTextData="false">

iVBORw0KGgoAAAANSUhEUgAAAGwAAAAVCAIAAAAsKZyTAAABN0lEQVR4nO1YQQ7DIA wj0x7Oz9kBqUIhOAZSVZ2weikDh5mYUCSlnA728Hl6Av+AI2IAjogB+Kr3UrLZT8Ru j4KKGx7u4l9mBgxsJo7EDUFPfmu4cAxFFMn1uXsG7Qq34V6ko7Yzj5EB+7SfspJIHs nnWr4fiCPyhJhnsbAAA6p4vIKl5PqYJnAtb0oP0nmKENtimIlglUa5Vv9220t9errV ESQiZmCRdFbDHSImrbMi1srgFzeJiaFdkZbDIJiNiuAJlTIKQ7nMwggAcL0XphSUGn OWUcvOaMJxgDuoRTcAoLTpCr8aoJow4MmM5uxFlRXEJmbquccgDikm6U5d5NrOPm7x k5WH21pUvFjNqT7TjC4YNt6hfyVMBbgH8 euC5T9zHucUJwBExAEfEAEgp5ek5vB4// 2UNn3QSMNMAAAAASUVORK5CYIJ=

</AttachmentId>
<AuctionItemDetail>
<ItemName>Complete Test 1</ItemName>
<Description>This item exploits all of the fields, and fills in all non-required data</Description>
<ItemLocation>Durham, NC</ItemLocation>
<ItemFeatures>features</ItemFeatures>
<ItemWarranty>warranty</ItemWarranty>
<ItemCondition>condition</ItemCondition>
<IsFeaturedOffer>Y</IsFeaturedOffer>
<AuctionTypeCode>Reverse</AuctionTypeCode>
<CurrencyCode>IEP</CurrencyCode>
<StartingPrice>10000</StartingPrice>
<ReservePrice>9000</ReservePrice>
<BidIncrement>100</BidIncrement>
<Quantity>10</Quantity>
<SealedFlag>Y</SealedFlag>
<MinimumBidQuantity>2</MinimumBidQuantity>
<AuctionPreviewDate>11/24/2001 14:00:00</AuctionPreviewDate>
<AuctionStartDate>11/26/2001 09:00:00</AuctionStartDate>
<AuctionEndDate>11/30/2001 17:00:00</AuctionEndDate>
<AutoCloseFlag>N</AutoCloseFlag>
<DynamicCloseCheckInterval>5</DynamicCloseCheckInterval>
<DynamicCloseExtensionPeriod>10</DynamicCloseExtensionPeriod>
<DynamicCloseStopDate>12/01/2001 13:00:00</ DynamicCloseStopDate>
<ShippingInternationalFlag>Y</ShippingInternationalFlag>
<ShippingandhandlingAmount>500</ShippingandhandlingAmount>
<PurchaseTerms>buying</PurchaseTerms>
<ShippingTerms>shipping</ShippingTerms>
</AuctionItemDetail>
</AuctionAttachment>
</ListOfEauctionFileAttIntegrationObject>
</SiebelMessage>

NOTE:  In the line <?xml version="1.0" encoding="UTF-8"?> the default encoding is UTF-8. If the customer is using UTF-8 for their XML file, this line is not needed. However, if the customer wants to use another encoding, like UTF-16, then the line is required (with encoding="UTF-16").

The parameters within the AttachmentId tag require a unique ContentId. For example, if a user has an XML file with 25 items in it, each with an image attachment, then each AttachmentId should contain ContentId=001 through ContentId=025, consecutively. This is for reference within the individual file.

If you want to use graphics with the auctions you are creating through bulk upload, you will first need to convert the graphics to ASCII Base64 format. Images do not display when uploading auction items using bulk upload.

To set up a Base64 graphic to ASCII for bulk upload

  1. Use a Base64 converter, such as base64, to convert the image file to ASCII.
  2. NOTE:  You can find free Base64 converters on the Internet by performing a search for "Base64" in a search engine such as Yahoo or Google.

  3. Copy the file and paste it into the XML file between the <AttachmentId> tag and the </AttachmentId> tag.
  4. For example, the initial tag would be: <AttachmentId Encoding="Base64" Extension="png" ContentId="001" AttachmentIsTextData="false"> followed immediately by the Base64 data, and then the </AttachmentId> tag.

  5. Save the XML file in a convenient location on your system.

 Siebel eAuction Guide 
 Published: 18 April 2003