General

Re: URGENT Help Required! Retrieve data from an XML file

smods — Thu, 03 Dec 2009 16:54:04 GMT

ErnestoM:

I imagine that you already have a rule that sets a field's value based on the data retrieved.

If so, then you just need a second rule, in case a match is not found. When that happens, insted of setting the fields equal to the value retrived, you'll set it equal to "no match found".

RULE 1: Set a field's value to the value retrieved from the xml
Condition: there is a match in the xml file

RULE 2: Set a field's value to "No match found"
Condition: there is no match in the xml file

Hi Ernesto,

At the moment I have the default value in the two data fields (e-mail and name) as:

@AGName[@AGLan = AGLANID]

@AGMail[@AGLan = AGLANID]

So from the @AGName & @AGMail are retreived from the secondary data source (the XML file) where @AGLan (Text box in primary data source) matches AGLANID from the secondary data source (the XML file).

Where you say "Condition: there is a match in the xml file" - What is the criteria you set in the rule as I cannot figure out how to do this.

Many thanks for your help!

Re: URGENT Help Required! Retrieve data from an XML file

ErnestoM — Thu, 03 Dec 2009 16:39:17 GMT

I imagine that you already have a rule that sets a field's value based on the data retrieved.

If so, then you just need a second rule, in case a match is not found. When that happens, insted of setting the fields equal to the value retrived, you'll set it equal to "no match found".

RULE 1: Set a field's value to the value retrieved from the xml
Condition: there is a match in the xml file

RULE 2: Set a field's value to "No match found"
Condition: there is no match in the xml file

Re: URGENT Help Required! Retrieve data from an XML file

Hilary Stoupa — Thu, 03 Dec 2009 16:38:42 GMT

Hi -- Hide the fields if they are blank and the LAN ID field is populated. Add expression boxes that say 'No Match Found' that display when the fields are blank and the LAN ID field is populated.

Re: URGENT Help Required! Retrieve data from an XML file

smods — Thu, 03 Dec 2009 15:35:42 GMT

Thanks for replying Patrick.

Basically I have an infopath form with a receive data connection that receives data from an XML file.

I have a text box where the user types in their LAN ID and if a match is found it displays their name and contact e-mail address in two other fields (information from the XML file). However when a user types in a value that isn't found in the XML list then nothing is returned in the other two fields.

I need to understand the best way to get the get the name and e-mail fields to display "No Match Found" when the user enters a value not found in the XML list.

Thanks, if you need any further information then please let me know

smods!

Re: URGENT Help Required! Retrieve data from an XML file

Patrick Halstead — Thu, 03 Dec 2009 13:49:47 GMT

Hi Smods,

I have no idea what you are talking about. Please take a deep breath and explain in detail what you would like your form to do and what it is currently doing.

Thank you!

Re: URGENT Help Required! Retrieve data from an XML file

smods — Thu, 03 Dec 2009 11:55:33 GMT

Can anyone help with what I need to do?

Thanks

Re: URGENT Help Required! Retrieve data from an XML file

smods — Tue, 01 Dec 2009 08:10:45 GMT

I'm unsure as to what rules I would use for this?

At the moment the default value of the text box is "@AGName[@AGLan = AGLANID]"

Any help you can offer with the rules would be appreciated

Re: URGENT Help Required! Retrieve data from an XML file

ErnestoM — Mon, 30 Nov 2009 15:10:51 GMT

You are querying an XML list. There are two possible outcomes:

1. A record is found. So you create a rule to display the data retrieved.

2. A record is not found. So you create a rule to display a dialog box or an expression box with a message.

Here's a link that might prove useful: http://www.bizsupportonline.net/blog/2009/08/infopath-rules-conditions/

Re: URGENT Help Required! Retrieve data from an XML file

smods — Mon, 30 Nov 2009 15:04:04 GMT

Displaying no match found would be ideal.

How would I do this?

Re: URGENT Help Required! Retrieve data from an XML file

Patrick Halstead — Mon, 30 Nov 2009 13:53:58 GMT

Ummmm... how about displaying "no match found" using conditional formatting or red guidance text?

URGENT Help Required! Retrieve data from an XML file

smods — Mon, 30 Nov 2009 13:48:37 GMT

Hi all,

I have a data connection to retrieve data from an XML file. My users type in their LAN id into a field and it looks at their LAN id and returns their name and contact details. What I need to know is what is the best option for when no match is found?

Regards

Chris