General

Re: Reading data from XML Datasource

dsk96m — Wed, 30 Nov 2011 19:25:19 GMT

This is how my data comes:

Manager Employee

Adams word

Adams straw

Adams snyder

anderson arther

anderson thomas

and so on. What i can do is export that into excel, manipulate it so that it is in the correct format, add the schema file, then export the xml for use by the form. I just need to know how the data needs to be arranged and what the schema should be so that i can get it in the form that you mentioned above.

Re: Reading data from XML Datasource

dsk96m — Wed, 30 Nov 2011 18:57:16 GMT

What does the xml look like for that?

Re: Reading data from XML Datasource

Skarn — Wed, 30 Nov 2011 01:21:11 GMT

Here's an example made with 'browser compatibility' setting on and using conditional formatting.

Re: Reading data from XML Datasource

Skarn — Tue, 29 Nov 2011 23:55:22 GMT

mm - I didn't know that sorry.

if conditional formatting works then you might be able to use repeating sections/table instead.

Re: Reading data from XML Datasource

dsk96m — Tue, 29 Nov 2011 18:59:53 GMT

Now I know why it worked for you. You are using filters. Cant use filters in browser enabled forms.

Re: Reading data from XML Datasource

dsk96m — Tue, 29 Nov 2011 18:30:40 GMT

What would the schema look like for your suggest hierarchy

<?xml version='1.0' encoding='UTF-16'?>


<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element nillable="true" name="data">
  <xsd:complexType>
   <xsd:sequence minOccurs="0">
    <xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="staffMember" form="unqualified">
     <xsd:complexType>
      <xsd:simpleContent>
       <xsd:extension base="xsd:string">
        <xsd:attribute name="id" form="unqualified" type="xsd:integer"/>
        <xsd:attribute name="manager" form="unqualified" type="xsd:integer"/>
       </xsd:extension>
      </xsd:simpleContent>
     </xsd:complexType>
    </xsd:element>
   </xsd:sequence>
  </xsd:complexType>
</xsd:element>
</xsd:schema>

Re: Reading data from XML Datasource

dsk96m — Tue, 29 Nov 2011 18:12:23 GMT

I would just need to redo my schema.

Got to figure that one out.

Re: Reading data from XML Datasource

dsk96m — Tue, 29 Nov 2011 17:24:02 GMT

yea, i took the names out for privacy reasons. they would be all different names

Re: Reading data from XML Datasource

dsk96m — Tue, 29 Nov 2011 17:22:28 GMT

awesome, i will take a look.

The xml i can arrange it anyway you want. The data comes out of a db, sort of hard to get levels from it, but i was able to get the xml like what i showed you, i can change it around if that is easier

Re: Reading data from XML Datasource

Skarn — Tue, 29 Nov 2011 13:45:01 GMT

hmm only 1 attachment per post allowed. Here's the datasource.

Re: Reading data from XML Datasource

Skarn — Tue, 29 Nov 2011 13:43:25 GMT

Hmm well, the datasource was all id's and people with the same name ;-) so it's hard to tell if this is working perfectly.

But it looks correct. Attached.

I had to add a dummy '1st level' person as the list box control wouldn't let me use the datasource with only one.

Also note I've let the template have the secondary datasource xml file included in the template so you can use it right out, but included the file separately as well for your reference.

Re: Reading data from XML Datasource

Skarn — Tue, 29 Nov 2011 13:11:15 GMT

I'll have a stab at it. I'm not even sure you need to use code. I'll use your first set of data. Though normally I would expect to see this kind of hierarchical data presented in a different way. I assume you get this XML from another source and this is the format it comes in?

The way I usually see it something like this:

e.g.

Re: Reading data from XML Datasource

dsk96m — Wed, 23 Nov 2011 18:16:13 GMT

would it work better if the xml was like

<Roster>
<manager id="1">OAKLEY, VINCENT</manager>
  <manager2 manager="1" id="1">BRUNER, ERICH</manager2>
   <manager3 manager2="1" id="1">Name</manager3>
   <manager3 manager2="1" id="2">Name</manager3>
    <manager4 manager3="2" id="1">Name</manager4>
    <manager4 manager3="2" id="2">Name</manager4>
    <manager4 manager3="2" id="3">Name</manager4>
    <manager4 manager3="2" id="4">Name</manager4>
    <manager4 manager3="2" id="5">Name</manager4>
    <manager4 manager3="2" id="6">Name</manager4>
    <manager4 manager3="2" id="7">Name</manager4>
    <manager4 manager3="2" id="8">Name</manager4>
    <manager4 manager3="2" id="9">Name</manager4>
    <manager4 manager3="2" id="10">Name</manager4>
    <manager4 manager3="2" id="11">Name</manager4>
   <manager3 manager2="1" id="3">Name</manager3>
   <manager3 manager2="1" id="4">Name</manager3>
   <manager3 manager2="1" id="5">Name</manager3>

</roster>

Re: Reading data from XML Datasource

dsk96m — Wed, 23 Nov 2011 18:09:29 GMT

Did you see my xml file? Can you help make cascading list boxes based off of that xml. Do I need to change the format of the xml?

Re: Reading data from XML Datasource

dsk96m — Wed, 23 Nov 2011 16:55:44 GMT

I am so lost now. I need a different way to do these cascading list boxes. Nothing I try works. I am fried.