Expand my Community achievements bar.

Referencing XML data nodes

Avatar

Former Community Member
I've created a form using Designer 7.1 that needs two sources of XML data:<br />1) Data to fill a dropdown list and other fields<br />2) Submitted data from another form<br /><br />I have no problem with these separately, but merged the two xml files because only one can be imported at a time.<br /><br /><PayerForms><br /> <Payer><br /> <FormName>...</FormName><br /> <CoverPage>...</CoverPage><br /> <PayerID>...</PayerID><br /> <SubmitterID>...</SubmitterID><br /> <ExtraText>...</ExtraText><br /> <FormDate>...</FormDate><br /> </Payer><br /> <Payer></Payer><br /> <Payer></Payer><br /></PayerForms><br /><br />and<br /><br /><Enrollment><br /> <MainPage><br /> <ProviderInfo><br /> <txtProvider>...</txtProvider><br /> <txtPrvAddress>...</txtPrvAddress><br /> </ProviderInfo><br /> <OtherInfo><br /> <txtOther1>...</txtOther1><br /> <txtOther2>...</txtOher2><br /> </OtherInfo><br /> <PayerInfo><br /> <SelectedPayers><br /> <Payer><br /> <PayName>...</PayName><br /> <ProviderID>...</ProviderID><br /> </Payer><br /> <Payer></Payer><br /> </SelectedPayers><br /> <PayerTotal><br /> <MonthlyPayerFee/><br /> <TotalPayers>...</TotalPayers><br /> <TotalFee>...</TotalFee><br /> </PayerTotal><br /> </PayerInfo><br /> </MainPage<br /></Enrollment><br /><br />became<br /><br /><Enrollment><br /> <MainPage><br /> <ProviderInfo><br /> <txtProvider>...</txtProvider><br /> <txtPrvAddress>...</txtPrvAddress><br /> </ProviderInfo><br /> <OtherInfo><br /> <txtOther1>...</txtOther1><br /> <txtOther2>...</txtOher2><br /> </OtherInfo><br /> <PayerInfo><br /> <SelectedPayers><br /> <Payer><br /> <PayName>...</PayName><br /> <ProviderID>...</ProviderID><br /> </Payer><br /> <Payer></Payer><br /> </SelectedPayers><br /> <PayerTotal><br /> <MonthlyPayerFee/><br /> <TotalPayers>...</TotalPayers><br /> <TotalFee>...</TotalFee><br /> </PayerTotal><br /> </PayerInfo><br /> </MainPage<br /> <PayerForms><br /> <Payer><br /> <FormName>...</FormName><br /> <CoverPage>...</CoverPage><br /> <PayerID>...</PayerID><br /> <SubmitterID>...</SubmitterID><br /> <ExtraText>...</ExtraText><br /> <FormDate>...</FormDate><br /> </Payer><br /> <Payer></Payer><br /> <Payer></Payer><br /> </PayerForms><br /><Enrollment><br /><br />A dropdown is dynamically populated with PayerForms.Payers[*].FormName. Data from MainPage populates fields. What I cannot get to work since combining the files is populating certain fields with the other PayerForms.Payer data values when a dropdown selection is made.<br /><br />The change event of the dropdown begins with <br /><br />var payers = xfa.datasets.data.resolveNodes("PayerForms.Payer[*]");<br /><br />and cycles through the data, finds a match to the selected text and fills fields with CoverPage, PayerID, SubmitterID, ExtraText, and FormDate of that record.<br /><br />This worked before with the separate PayerForms xml. Now payers.length is 0 and nothing happens. I'm thinking that the "PayerForms.Payer[*]" needs to change, but I don't know how to reference the Payer records in this new schema. <br /><br />Any input would be appreciated.
1 Reply

Avatar

Former Community Member
Laura_Lillie@adobeforums.com wrote:<br />> I've created a form using Designer 7.1 that needs two sources of XML data:<br />> 1) Data to fill a dropdown list and other fields<br />> 2) Submitted data from another form<br />> <br />> I have no problem with these separately, but merged the two xml files because only one can be imported at a time.<br />> <br />> <PayerForms><br />> <Payer><br />> <FormName>...</FormName><br />> <CoverPage>...</CoverPage><br />> <PayerID>...</PayerID><br />> <SubmitterID>...</SubmitterID><br />> <ExtraText>...</ExtraText><br />> <FormDate>...</FormDate><br />> </Payer><br />> <Payer></Payer><br />> <Payer></Payer><br />> </PayerForms><br />> <br />> and<br />> <br />> <Enrollment><br />> <MainPage><br />> <ProviderInfo><br />> <txtProvider>...</txtProvider><br />> <txtPrvAddress>...</txtPrvAddress><br />> </ProviderInfo><br />> <OtherInfo><br />> <txtOther1>...</txtOther1><br />> <txtOther2>...</txtOher2><br />> </OtherInfo><br />> <PayerInfo><br />> <SelectedPayers><br />> <Payer><br />> <PayName>...</PayName><br />> <ProviderID>...</ProviderID><br />> </Payer><br />> <Payer></Payer><br />> </SelectedPayers><br />> <PayerTotal><br />> <MonthlyPayerFee/><br />> <TotalPayers>...</TotalPayers><br />> <TotalFee>...</TotalFee><br />> </PayerTotal><br />> </PayerInfo><br />> </MainPage </Enrollment><br />> <br />> became<br />> <br />> <Enrollment><br />> <MainPage><br />> <ProviderInfo><br />> <txtProvider>...</txtProvider><br />> <txtPrvAddress>...</txtPrvAddress><br />> </ProviderInfo><br />> <OtherInfo><br />> <txtOther1>...</txtOther1><br />> <txtOther2>...</txtOher2><br />> </OtherInfo><br />> <PayerInfo><br />> <SelectedPayers><br />> <Payer><br />> <PayName>...</PayName><br />> <ProviderID>...</ProviderID><br />> </Payer><br />> <Payer></Payer><br />> </SelectedPayers><br />> <PayerTotal><br />> <MonthlyPayerFee/><br />> <TotalPayers>...</TotalPayers><br />> <TotalFee>...</TotalFee><br />> </PayerTotal><br />> </PayerInfo><br />> </MainPage <PayerForms><br />> <Payer><br />> <FormName>...</FormName><br />> <CoverPage>...</CoverPage><br />> <PayerID>...</PayerID><br />> <SubmitterID>...</SubmitterID><br />> <ExtraText>...</ExtraText><br />> <FormDate>...</FormDate><br />> </Payer><br />> <Payer></Payer><br />> <Payer></Payer><br />> </PayerForms><br />> <Enrollment><br />> <br />> A dropdown is dynamically populated with PayerForms.Payers[*].FormName. Data from MainPage populates fields. What I cannot get to work since combining the files is populating certain fields with the other PayerForms.Payer data values when a dropdown selection is made.<br />> <br />> The change event of the dropdown begins with<br />> <br />> var payers = xfa.datasets.data.resolveNodes("PayerForms.Payer[*]");<br />> <br />> and cycles through the data, finds a match to the selected text and fills fields with CoverPage, PayerID, SubmitterID, ExtraText, and FormDate of that record.<br />> <br />> This worked before with the separate PayerForms xml. Now payers.length is 0 and nothing happens. I'm thinking that the "PayerForms.Payer[*]" needs to change, but I don't know how to reference the Payer records in this new schema.<br />> <br />> Any input would be appreciated.<br /><br />I noticed a couple typos in your xml...<br /> </MainPage <PayerForms> (No closing tag for MainPage)<br /><br />Also, the last tag should be </Enrollment> rather than <Enrollment>.<br /><br />Were these just typos when you typed up the email? I'm assuming that is the case.<br /><br />You may want to try changing your resolveNodes call to the following and see if this works:<br /> var payers = xfa.datasets.data.resolveNodes("Enrollment.PayerForms.Payer[*]");<br /><br />-- <br />Justin Klei<br />Cardinal Solutions Group<br />www.cardinalsolutions.com