Hi Experts
Just Newbie to XML....Do not know if this is possible!!
I have this XML file, which has it own Schema (*.xsd), Now I want to make template out of this so that more similar data can be converted to XML file with information can be uploaded into SQL Server...Please provide details to the steps.
The Data which I intially have is in Excel format which when entred into the software, gives XML format and the software in which data entry is done provides me XML Imports & Exports.
This is more of solving problem of bulk uploads
Is it possible to have Template in CSV or any other format.
**************
XML File
<?xml version="1.0" ?>
<eExact xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocat
ion="Schem
a.xsd">
<Items>
<Item code="HostName" type="S" searchcode="Hostname">
<Description>Serial_number
</Descript
ion>
<MultiDescriptions>
<MultiDescription number="0">Serial_number</
MultiDescr
iption>
<MultiDescription number="1"></MultiDescript
ion>
<MultiDescription number="2"></MultiDescript
ion>
<MultiDescription number="3"></MultiDescript
ion>
<MultiDescription number="4"></MultiDescript
ion>
</MultiDescriptions>
<Assortment number="225" code="SV200">
<Description>V200 (N32)</Description>
<GLRevenue code=" 105" side="C" type="W" subtype="J">
<Description>Contract Services</Description>
</GLRevenue>
<GLCosts code=" 108" side="D" type="W" subtype="K">
<Description>COGS finished goods - TPM</Description>
</GLCosts>
<GLPurchase code=" 335" side="D" type="B" subtype="G">
<Description>Goods - At Cost</Description>
</GLPurchase>
</Assortment>
<Availability>
<DateStart>2007-08-06</Dat
eStart>
</Availability>
<Condition>A</Condition>
<IsSalesItem>0</IsSalesIte
m>
<IsPurchaseItem>0</IsPurch
aseItem>
<IsSerialNumberItem>1</IsS
erialNumbe
rItem>
<IsBatchItem>0</IsBatchIte
m>
<IsSubAssemblyItem>0</IsSu
bAssemblyI
tem>
<IsAssembledItem>0</IsAsse
mbledItem>
<IsStockItem>0</IsStockIte
m>
<IsBackOrderItem>0</IsBack
OrderItem>
<IsFractionAllowedItem>0</
IsFraction
AllowedIte
m>
<IsPriceRegulationItem>0</
IsPriceReg
ulationIte
m>
<IsTextItem>0</IsTextItem>
<IsDiscountItem>0</IsDisco
untItem>
<IsExplodeItem>0</IsExplod
eItem>
<IsPrintItem>0</IsPrintIte
m>
<RequiresApprovedSupplier>
0</Require
sApprovedS
upplier>
<GLRevenue code=" 105" side="C" type="W" subtype="J">
<Description>Contract Supply</Description>
</GLRevenue>
<GLCosts code=" 108" side="D" type="W" subtype="K">
<Description>COGS finished goods - TPM</Description>
</GLCosts>
<GLPurchase code=" 335" side="D" type="B" subtype="G">
<Description>Finished Goods - At Cost</Description>
</GLPurchase>
<Sales>
<Price type="S">
<Currency code="AUD"/>
<Value>0</Value>
<VAT code="0" type="B" vattype="N">
<Description>GST N/A</Description>
<Percentage>0</Percentage>
<Charged>0</Charged>
<GLToPay code=" 381" side="C" type="B" subtype="N">
<Description>GST Receivale Control Account (new)</Description>
</GLToPay>
<GLToClaim code=" 383" side="C" type="B" subtype="N">
<Description>GST Payable Control Account (new)</Description>
</GLToClaim>
<Creditor code=" 6" number=" 6" type="S">
<Name>Taxation Office</Name>
</Creditor>
<PaymentPeriod>M</PaymentP
eriod>
</VAT>
</Price>
<Unit unit="-" type="O">
</Unit>
</Sales>
<Costs>
<Price>
<Currency code="GB"/>
<Value>0</Value>
</Price>
</Costs>
<Dimension>
<WeightNet>0</WeightNet>
<WeightGross>0</WeightGros
s>
</Dimension>
<Resource number="1345" code = "Name">
<LastName>LName</LastName>
<FirstName>TName</FirstNam
e>
<MiddleName></MiddleName>
</Resource>
<ItemCategory number="3" code="SUN">
<Description>SUN</Descript
ion>
</ItemCategory>
<ItemCategory number="4" code="2">
<Description>Own by Customers</Description>
</ItemCategory>
<ItemCategory number="5" code="Ssp">
<Description>Support Code</Description>
</ItemCategory>
<ItemCategory number="6" code="Acc_code">
<Description>Account Name</Description>
</ItemCategory>
<ItemCategory number="7" code="SERVER">
<Description>SERVER</Descr
iption>
</ItemCategory>
<ItemCategory number="8" code="GB">
<Description>Australia</De
scription>
</ItemCategory>
<ItemWarehouses>
<ItemWarehouse default="1">
<Warehouse code="1001" blocked="0">
<Description>1001</Descrip
tion>
<Address>
<AddressLine1>Contract holding warehouse</AddressLine1>
<AddressLine2>Not for stock</AddressLine2>
<AddressLine3 />
<PostalCode />
<City />
<State code="L" />
<Country code="GB" />
</Address>
</Warehouse>
<WarehouseLocation code="DEPOT">
<Warehouse code="1001">
<Description>1001</Descrip
tion>
</Warehouse>
<Description>Depot</Descri
ption>
</WarehouseLocation>
</ItemWarehouse>
</ItemWarehouses>
</Item>
</Items>
</eExact>
Start Free Trial