|
Subject:
|
Loading Infopath xml form to SQL server?
|
|
Posted By:
|
elxany
|
Post Date:
|
1/24/2007 1:59:31 AM
|
Hi everyone,
I am new in infopath 2003 solution development. I would appreciate any replies to the following problem that I am experiencing so far.
I want to load xml data (that I get after I fill in self-designed infopath template) to the tables in MS SQL Server 2005 as a relational data.
In fact, there are some solutions where you may load entire xml to sql server 2005 as an xml data type. However, it is required from me to load this infopath xml data as relational data to tables.
Till now, I have tried xml bulkload (SQLXML 4.0) - http://msdn2.microsoft.com/en-us/library/ms171806.aspx
However, problem occurs when I want to use construct an xsd schema that supports above bulkload operation on the following infopath xml data:
<?xml version="1.0" encoding="UTF-8"?><?mso-infoPathSolution solutionVersion="1.0.0.58" productVersion="11.0.6565" PIVersion="1.0.0.0" href="file:///C:\RIAIS\Sablon\S1_GeneralInfo.xsn" name="urn:schemas-microsoft-com:office:infopath:S1-GeneralInfo:-myXSD-2006-12-13T05-53-51" ?><?mso-application progid="InfoPath.Document"?><my:RegionInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2006-12-13T05:53:51" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">
<my:CreationDate>1961-01-18</my:CreationDate>
<my:Area>111111</my:Area>
<my:AreaDivison>
<my:CityNum>12</my:CityNum>
<my:DistrictNum>37</my:DistrictNum>
<my:VillageNum>24</my:VillageNum>
<my:StateDelegateNum>2</my:StateDelegateNum>
<my:MunicipalNum>8</my:MunicipalNum>
</my:AreaDivison>
<my:regions>
<my:name>7</my:name>
</my:regions>
<my:FormID>Forma S1</my:FormID>
<my:FormDate>2007-01-04</my:FormDate>
<my:FilledBy>Vusa Akimo</my:FilledBy>
</my:RegionInfo>
I may suppose that probelm occurs due to namespace “my:” that standad xsd schema does not accept... :(
Please, suggest a solution or example how to handle this xml namespace “my:” in Inoptah 2003 forms...
Thank you for your time..
With Regards
|
|
