Re: Saving offline Infopath xml form to SQL Server2005

bobspearing — Sat, 17 Nov 2007 22:34:53 GMT

Patrick

When you say "The developer edition is free" is there not a restriction on the number of records?

Bob

Re: Saving offline Infopath xml form to SQL Server2005

Patrick Halstead — Sat, 27 Jan 2007 06:16:25 GMT

Hi elxany and welcome to our forum!

Have you looked at our Qdabra Database Accelerator Suite? http://www.qdabra.com/proddetail.asp?prod=QDBXL1
It's a set of Web service that speed up integration of InfoPath with SQL.
It supports mapping your forms into relational tables.
The developer edition is free.
Let me know if you would like some help installing it and getting it working for your forms. I'm guessing it will take ~30 minutes but depends on how complex your SQL schema is.

Cheers!

Saving offline Infopath xml form to SQL Server2005

elxany — Wed, 24 Jan 2007 08:08:58 GMT

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.aspx

However, 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..

Newbie Questions

Re: Saving offline Infopath xml form to SQL Server2005

Re: Saving offline Infopath xml form to SQL Server2005

Saving offline Infopath xml form to SQL Server2005