Suljettu

Updating XSD Schema file for SQLXMLBulkLoad

Hi,

We have been provided access to a XML feed and have been provided the XML schema file require to updat to work with SQLXMLBulkLoad.

The prodived schema file has listed all the attributes already and we have setup an SQL server with identical fieldnames to these attributes.

I will provide test XML, the XSD, connection details to a SQL server, the asp file handling the SQLXMLBulkLoad process and a test hosting enviroment for you to test your xsd schema is working with the provided files.

The database tables and relationships we require you to define in the XSD are

- TblWeb_DMUsedVehicles

- TblWeb_DMUsedVehiclePhotos

Where [url removed, login to view] = [url removed, login to view]

The XML file used for the bulk upload looks like this

<?xml version="1.0"?>

<Cars xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Page="1">

<Car Id="5994328" Make="CAR BRAND" Model="CAR MODEL" BodyType="WAGON" EngineSize="1910" Transmission="Automatic" FuelType="Diesel" Price="49990.000000" BasisOfQuotation="Excluding Government Charges" Description="WAGON 4doors 5seats" Year="2008" Location="NSW" PostCode="2000" Mileage="680" Badge="GT" LastModified="2009-07-21 17:12:17">

<Photos>

<Photo>http://images.thewebsite.com.au/car/dealer/13156034.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156035.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156036.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156037.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156038.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156039.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156040.jpg</Photo>

<Photo>http://images.thewebsite.com.au/car/dealer/13156041.jpg</Photo>

</Photos>

</Car>

And the XSD provided that needs updating looks like this

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns="http://thewebsite.com.au/cars"

elementFormDefault="qualified"

targetNamespace="http://thewebsite.com.au/cars">

<xs:element name="Cars">

<xs:complexType>

<xs:sequence>

<xs:element maxOccurs="unbounded" ref="Car"/>

</xs:sequence>

<xs:attribute name="Page"/>

</xs:complexType>

</xs:element>

<xs:element name="Car">

<xs:complexType>

<xs:sequence>

<xs:element minOccurs="0" maxOccurs="1" ref="Photos"/>

</xs:sequence>

<xs:attribute name="Badge"/>

<xs:attribute name="BasisOfQuotation"/>

<xs:attribute name="BodyColour" />

<xs:attribute name="BodyType"/>

<xs:attribute name="Cylinders" />

<xs:attribute name="Description"/>

<xs:attribute name="EngineSize"/>

<xs:attribute name="FuelType"/>

<xs:attribute name="Id"/>

<xs:attribute name="LastModified"/>

<xs:attribute name="Location"/>

<xs:attribute name="Make"/>

<xs:attribute name="Mileage"/>

<xs:attribute name="Model"/>

<xs:attribute name="Photo"/>

<xs:attribute name="PostCode"/>

<xs:attribute name="Price"/>

<xs:attribute name="Rego"/>

<xs:attribute name="Seats"/>

<xs:attribute name="Series"/>

<xs:attribute name="StockNumber"/>

<xs:attribute name="Transmission"/>

<xs:attribute name="TrimColour" />

<xs:attribute name="VIN"/>

<xs:attribute name="Year"/>

</xs:complexType>

</xs:element>

<xs:element name="Photos">

<xs:complexType>

<xs:sequence>

<xs:element name="Photo" type="xs:string" maxOccurs="unbounded"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Taidot: ASP, SQL, Tietojen kaavinta verkosta, XML

Näytä lisää: www vin com, www car org, work in nsw, price file, model your brand, element 8, car id, a used car dealer, xml xsd file sql database, updating, Transmission, server wagon, schema, process photos, postcode, name for brand, file server, Diesel , car dealer, bulk file, asp sql connection, government type, xml schema access database, xmlns, connection string access

Tietoa työnantajasta:
( 0 arvostelua ) Mosman, Australia

Projektin tunnus: #486361

2 freelancers are bidding on average $350 for this job

Mohanarangan

As i'm new service provider, i would like to take up challenges and utilize my potential to provide the solution with high quality at low cost. I would like to work on this project and looking forward for the opport Lisää

300 $ USD 5 päivässä
(0 arvostelua)
0.0
techags

Hi, we can start ASAP. Please check PMB to know more about our technical expertise and capalbilities.

400 $ USD 5 päivässä
(0 arvostelua)
0.0