Hi everyone,
I am new in development of infopath 2003 solutions. 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.aspxHowever, problem occurs when I want to use xsd schema that should support (but in fact, not :(( ) 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>Vusala Axundova</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..