Konuyu Oyla:
  • Derecelendirme: 0/5 - 0 oy
  • 1
  • 2
  • 3
  • 4
  • 5
XMLSchema SQL import
#1
Herkese Merhabalar , 

Web servis üzerinden sorguladığım veri cevapları bu şekilde geliyor bunları SQL e import etmek veya Delphi içinde daha kolay parçalayıp işlemek istiyorum. Normal XML Dosyaları SQl aktarılabiliyor denemiştim ama bu dosyayı aktaramadım. Bu konuda yardımınızı rica ediyorum. İlgilenen arkadaşlar olursa diye örnek dosyayı aşağıya ekliyorum. 

Herkese çok teşekkürler ve kolaylıklar diliyorum.

xml1.xml]Örnek Dosya



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

-<soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">


-<soap:Body>


-<GetMenuResponse xmlns="http://tempuri.org/">


-<GetMenuResult>


-<xs:schema xmlns="" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:xs="http://www.w3.org/2001/XMLSchema" id="Menu">


-<xs:element msdata:UseCurrentLocale="true" msdata:IsDataSet="true" name="Menu">


-<xs:complexType>


-<xs:choice maxOccurs="unbounded" minOccurs="0">


-<xs:element name="Products">


-<xs:complexType>


-<xs:sequence>


-<xs:element name="Id" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="128"/>

</xs:restriction>

</xs:simpleType>

</xs:element>


-<xs:element name="Name" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="128"/>

</xs:restriction>

</xs:simpleType>

</xs:element>


-<xs:element name="Title" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="128"/>

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Price" minOccurs="0" type="xs:decimal"/>


-<xs:element name="Description" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="2000"/>

</xs:restriction>

</xs:simpleType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>


-<xs:element name="Options">


-<xs:complexType>


-<xs:sequence>


-<xs:element name="Id" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="50"/>

</xs:restriction>

</xs:simpleType>

</xs:element>


-<xs:element name="ProductId" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="128"/>

</xs:restriction>

</xs:simpleType>

</xs:element>


-<xs:element name="Name" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="2000"/>

</xs:restriction>

</xs:simpleType>

</xs:element>

<xs:element name="Price" minOccurs="0" type="xs:decimal"/>


-<xs:element name="Type" minOccurs="0">


-<xs:simpleType>


-<xs:restriction base="xs:string">

<xs:maxLength value="50"/>

</xs:restriction>

</xs:simpleType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>


-<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">


-<Menu xmlns="">


-<Products diffgr:id="Products1" msdata:rowOrder="0">

<Id>6ce83bbe2dc88b96f4dfd2e83519dda4</Id>

<Name>Karışık Pide</Name>

<Title>Pideler</Title>

<Price>25.0000</Price>

<Description>Kuşbaşı , kıyma , kaşar peyniri</Description>

</Products>


-<Products diffgr:id="Products2" msdata:rowOrder="1">

<Id>3ab12f4b4032f630981b54c059e5493e</Id>

<Name>Adana Kebap</Name>

<Title>Kebaplar & Izgaralar</Title>

<Price>20.0000</Price>

<Description>Tavuk kıymasından hazırlanmaktadır.</Description>

</Products>


-<Products diffgr:id="Products3" msdata:rowOrder="2">

<Id>3ab3c2b535915be36412d7aae8a32a99</Id>

<Name>Urfa Kebap</Name>

<Title>Kebaplar & Izgaralar</Title>

<Price>20.0000</Price>

<Description>Tavuk kıymasından hazırlanmaktadır.</Description>

</Products>


-<Products diffgr:id="Products4" msdata:rowOrder="3">

<Id>5a580a687d58e39f39941660bf4e396b</Id>

<Name>Tavuk Döner</Name>

<Title>Kebaplar & Izgaralar</Title>

<Price>13.0000</Price>

<Description>...</Description>

</Products>

</Menu>

</diffgr:diffgram>

</GetMenuResult>

</GetMenuResponse>

</soap:Body>

</soap:Envelope>
Cevapla


Bu Konudaki Yorumlar
XMLSchema SQL import - Yazar: Bay_Y - 22-07-2020, Saat: 16:17
Cvp: XMLSchema SQL import - Yazar: TescilsizUzman - 22-07-2020, Saat: 17:58
Cvp: XMLSchema SQL import - Yazar: Bay_Y - 22-07-2020, Saat: 18:37
XMLSchema SQL import - Yazar: Bay_Y - 30-07-2020, Saat: 11:31
Cvp: XMLSchema SQL import - Yazar: TescilsizUzman - 07-08-2020, Saat: 17:20
XMLSchema SQL import - Yazar: Bay_Y - 07-08-2020, Saat: 22:50

Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Son Yorum
  Excel import yapma (Güncelleme) cinarbil 3 3.162 27-11-2021, Saat: 10:34
Son Yorum: Mr.X
  WSDL dosyasını import ederek web servise veri gönderme. KUNTAY 3 1.052 28-07-2021, Saat: 16:21
Son Yorum: KUNTAY
  Import WSDL m_ekici 2 1.021 14-06-2021, Saat: 14:20
Son Yorum: mrmarman
  Soap servis import sorunu klavye 0 607 29-03-2021, Saat: 15:29
Son Yorum: klavye
  SOAP WSDL | Tarihi sorunu ve C# import sorunu hk. pro_imaj 2 2.150 24-10-2019, Saat: 08:51
Son Yorum: sabanakman



Konuyu Okuyanlar: 1 Ziyaretçi