Page 1 of 1

XML troubles "One top level element"?

Posted: Wed Jun 07, 2006 7:38 am
by hydroxide
Why would this:

Code: Select all

<?xml version="1.0" encoding="ISO-8859-1"?>

<METADATA>

		<FIELDS>

		<FIELD attrname='company_name' fieldtype='varchar' required='true'/>

		<FIELD attrname='client_id' fieldtype='varchar' WIDTH='23' required='true'/>

		<FIELD attrname='contact_name' fieldtype='varchar' required='true'/>

		<FIELD attrname='phone' fieldtype='varchar'  required='true'/>

		<FIELD attrname='orig_call_in' fieldtype='varchar' required='true'/>

		<FIELD attrname='orig_begin' fieldtype='varchar' required='true'/>

		<FIELD attrname='orig_end' fieldtype='varchar' required='true'/>

		<FIELD attrname='orig_check' fieldtype='varchar' required='true'/>

		<FIELD attrname='orig_delivery' fieldtype='varchar' required='true'/>

		<FIELD attrname='new_call_in' fieldtype='varchar' required='true'/>

		<FIELD attrname='new_begin' fieldtype='varchar' required='true'/>

		<FIELD attrname='new_end' fieldtype='varchar' required='true'/>

		<FIELD attrname='new_check' fieldtype='varchar' required='true'/>

		<FIELD attrname='new_delivery' fieldtype='varchar' required='true'/>

		<FIELD attrname='proc_location' fieldtype='varchar' required='true'/>

		<FIELD attrname='false_start' fieldtype='varchar' required='true'/>

		<FIELD attrname='date' fieldtype='varchar' required='true'/>

		</FIELDS>

		<PARAMS DEFAULT_ORDER='1' PRIMARY_KEY='1' LCID='1033'/>

		</METADATA>


<RECORD>
<company_name>xxxxx</company_name>
<client_id>21-11-041</client_id>
<contact_name>xxxx</contact_name>
<phone>555-555-5555</phone>
<orig_call_in>01/10/2006</orig_call_in>
<orig_begin>01/02/2006</orig_begin>
<orig_end>10/08/2006</orig_end>
<orig_check>01/13/2006</orig_check>
<orig_delivery>01/12/2006</orig_delivery>
<new_call_in>01/17/2006</new_call_in>
<new_begin>01/09/2006</new_begin>
<new_end>01/15/2006</new_end>
<new_check>01/20/2006</new_check>
<new_delivery>01/19/2006</new_delivery>
<proc_location>bradenton, </proc_location>
<false_start>Wednesday, January 11, 2006 at 11:53:41 (EST)</false_start>
<date></date>

</RECORD>
Give me this?
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.


--------------------------------------------------------------------------------

Only one top level element is allowed in an XML document. Error processing resource 'file:///C:/Documents and Settings/jimm...

<RECORD>
-^

I can't find out what it means by "one top level element".

Posted: Wed Jun 07, 2006 8:11 am
by twigletmac
You need to wrap it all in one top level (root) element, so you could have something like:

Code: Select all

<?xml version="1.0" encoding="ISO-8859-1"?>
<RECORDS>
    <METADATA> 
        ....
    </METADATA>
    
    <RECORD>
        ...
    </RECORD>
</RECORDS>
Mac

Posted: Wed Jun 07, 2006 8:28 am
by hydroxide
Thanks! I have one more question, if you would.

Code: Select all

Whitespace is not allowed at this location. Error processing resource 'file:///C:/Documents and Settings/jimmy/Desktop/revi...

<company_name>G & R Stucco Inc</company_name>
-----------------^
How can I make this acceptable?

Posted: Wed Jun 07, 2006 8:52 am
by hydroxide
I figured it out... it's because of the ampersand.