SQL Database Integration

Re: Insert Data In XML

shailaja — Tue, 09 May 2006 12:44:32 GMT

Hello dkumar,
After designing the form you have to publish it to local machine or share point. If you have published to local machine then double click the xsn file to open new form. If you have published to share point site then click on “Fill out this form” to open new form. You cannot use the xml with which you have designed the form because that xml does not have InfoPath Processing Instruction. In order to relink your xml file (XML file which you have initially used to design the form) to the share point site use the tool present athttp://www.infopathdev.com/webstore/detail.aspx?itemid=22 location.

Hope this helps!

Re: Insert Data In XML

dkumar4uin — Fri, 05 May 2006 14:59:00 GMT

Thank you for answars.
Actually one of my mainframe system generates below type of xml file
===================================================
<?xml version="1.0" encoding="utf-8"?>
<records>
<record>
<field name="doccreated" type="DateTime">2006-04-27T19:45:07.5000000-04:00</field>
<field name="docmodified" type="DateTime">2006-04-28T16:02:43.0800000-04:00</field>
<field name="ModifiedBy" type="String">CN=G Subbu/O=tcs</field>
<field name="noteid" type="Double">2302</field>
<field name="unid" type="String">0c2208760ff0c3b48525715d006c805e</field>
<field name="parentnoteid" type="null" />
<field name="parentunid" type="null" />
<field name="isread" type="Double">1</field>
<field name="Date" type="DateTime">0001-01-01T00:00:00.0000000-05:00</field>
<field name="txt_Attachment" type="String" />
<field name="txt_Author" type="String">Tom</field>
<field name="txt_Category" type="String">Category 1</field>
<field name="txt_ContentOwner" type="String" />
<field name="txt_DocDate" type="DateTime">2006-04-29T00:00:00.0000000-04:00</field>
<field name="txt_LastContentReview" type="DateTime">2006-04-30T00:00:00.0000000-04:00</field>
<field name="txt_Link" type="String" />
<field name="txt_SubCategory" type="String">Sub Category 1</field>
<field name="txt_Title" type="String">Canadian Rules & Guidelines</field>
<field name="txtSort" type="String">2.0</field>
</record>
<record>
<field name="doccreated" type="DateTime">2006-04-27T19:45:00.7800000-04:00</field>
<field name="docmodified" type="DateTime">2006-04-28T15:56:32.1600000-04:00</field>
<field name="ModifiedBy" type="String">CN=G Subbu/O=tcs</field>
<field name="noteid" type="Double">2298</field>
<field name="unid" type="String">830c5f1a3e8730618525715d006c7dbe</field>
<field name="parentnoteid" type="null" />
<field name="parentunid" type="null" />
<field name="isread" type="Double">1</field>
<field name="Date" type="DateTime">0001-01-01T00:00:00.0000000-05:00</field>
<field name="txt_Attachment" type="String" />
<field name="txt_Author" type="String">Subbu</field>
<field name="txt_Category" type="String">Category 2</field>
<field name="txt_ContentOwner" type="String" />
<field name="txt_DocDate" type="DateTime">2006-04-28T00:00:00.0000000-04:00</field>
<field name="txt_LastContentReview" type="DateTime">2006-04-28T00:00:00.0000000-04:00</field>
<field name="txt_Link" type="String" />
<field name="txt_SubCategory" type="String">Sub Category 2</field>
<field name="txt_Title" type="String">Introduction To National Instrument 43-101</field>
<field name="txtSort" type="String">1.0</field>
</record>
<record>
<field name="doccreated" type="DateTime">2006-04-27T19:44:51.4600000-04:00</field>
<field name="docmodified" type="DateTime">2006-04-28T15:59:22.9700000-04:00</field>
<field name="ModifiedBy" type="String">CN=G Subbu/O=tcs</field>
<field name="noteid" type="Double">2294</field>
<field name="unid" type="String">6463bf89b639a6798525715d006c7a1a</field>
<field name="parentnoteid" type="null" />
<field name="parentunid" type="null" />
<field name="isread" type="Double">1</field>
<field name="Date" type="DateTime">0001-01-01T00:00:00.0000000-05:00</field>
<field name="txt_Attachment" type="String" />
<field name="txt_Author" type="String">Bob</field>
<field name="txt_Category" type="String">Category 3</field>
<field name="txt_ContentOwner" type="String" />
<field name="txt_DocDate" type="DateTime">2006-04-06T00:00:00.0000000-04:00</field>
<field name="txt_LastContentReview" type="DateTime">2006-04-15T00:00:00.0000000-04:00</field>
<field name="txt_Link" type="String" />
<field name="txt_SubCategory" type="String">Sub Category 3</field>
<field name="txt_Title" type="String">Qualified Persons</field>
<field name="txtSort" type="String">3.0</field>
</record>
</records>
=============================================
Can I use this XML directly or I have to change this xml to Infopath XML?

I tried to use the XML directly in Infopath using ur adviced step but I got some funny result. Then I mannually change the XML file to Infopath XML and designed the form.

After designing form How can I Add and modify record in the XML file?

I want to design a form with above XML and want to add/modify file in same XML file?

Please help me

Re: Insert Data In XML

shailaja — Fri, 05 May 2006 05:25:58 GMT

Hello dkumar welcome to Forums
Answers to your questions.
1. You can use existing XML only to design InfoPath forms. To do this Open InfoPath -> Design a Form -> Select New from XML Document or Schema from task pane.
2. One question that I have for you is – You said add, edit/modify data what does that mean. If you are trying to add, edit / modify just the data in the nodes then you can do that via InfoPath if you have field for that in UI. If you are trying to add, edit/modify nodes in XML then each time to add, edit/modify a node you need to design the form as I said in 1st point.
3. In order to add, edit/ modify data to a new sql server database you need design a form using Data connection. To do this Open InfoPath form -> Design a Form -> New from Data connection. In this case you should have a sql server database created before hand.

Hope this helps!

Insert Data In XML

dkumar4uin — Thu, 04 May 2006 21:34:53 GMT

I am new to InfoPath. I need below answars to my questions.
1.How to use external XML to design infopath form? Is it require to convert existing XML to infopath XML?

2.I want to design a infopath form from an existing XML file and add,edit/modify data of that xml file.Please tell me how to do that?

3.I want to design a infopath form from an existing XML file and add,edit/modify data to a new sql server database.Please tell me how to do that?

Please help me