Re: Please HELP!!! Need to populate info from XML Data Source based on an input string

Rahil — Thu, 22 Jul 2010 21:06:24 GMT

Thank you! I finally figure it out! I think its the same as the tutorial there. Create the filter for the query on the secondary source! Thanks again!!

Re: Please HELP!!! Need to populate info from XML Data Source based on an input string

Jo-Anne Alfafara — Wed, 21 Jul 2010 09:07:07 GMT

Hi Rahil,

Welcome to our forums!

Actually, there are lots of related blogs and threads which have some tips on how to auto-populate fields from an XML secondary source. Check this out:

http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspx

This tutorial uses a dropdown selection, just change it and use your SSN field.

Hope this helps.

Thanks,

Please HELP!!! Need to populate info from XML Data Source based on an input string

Rahil — Tue, 20 Jul 2010 16:42:47 GMT

Hi,

I'm not very savvy with InfoPath or XML so I am extremely lost at this point. I'm currently working on a project where it is required to populate basic info i.e last name, first name based on an input string of the persons SSN. I have conditions and rule setup to where if I input the SSN and it's equal to the data source SSN it populates the fields I want, although it only populates the first record of my XML source. I was told that I need to setup an XPath query filter, but I have absolutely no idea how to code it. The auto-populate would occur when the user inputs an SSN and hits the submit button to retrieve the data.

Here's the XML Data source:

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

- <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="MCTFS.xsd" generated="2010-07-07T12:48:36">

- <MCTFS>

<Last_x0020_Name>Jones</Last_x0020_Name>

<First_x0020_Name>Jane</First_x0020_Name>

<Race>White</Race>

</MCTFS>

- <MCTFS>

<Last_x0020_Name>Kane</Last_x0020_Name>

<First_x0020_Name>Joe</First_x0020_Name>

<Race>Black</Race>

<Subunit>Maintenance Det</Subunit>

</MCTFS>

- <MCTFS>

<Last_x0020_Name>Smith</Last_x0020_Name>

<First_x0020_Name>John</First_x0020_Name>

<Race>White</Race>

<Command>MCIWest</Command>

</MCTFS>

</dataroot>

its just a sample I made up to work with it, but I really need help!!! Thank you!!

Data Connections

Re: Please HELP!!! Need to populate info from XML Data Source based on an input string

Re: Please HELP!!! Need to populate info from XML Data Source based on an input string

Please HELP!!! Need to populate info from XML Data Source based on an input string