Results 1 to 1 of 1

doctype declaration issues in xml

Threaded View

  1. #1
    Registered User
    Join Date
    11-24-2008
    Location
    california
    Posts
    1

    doctype declaration issues in xml

    I have bene trying to generate a customized xml code with excel.

    I want to have output in exact format our machine responds to. Excel generates xml but there is a problem with the top 4 lines. So I have to manually copy those lines. The xml genearted by excel is as follows

    ========================================================================================

    Excel generated xml
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    
    <SIS_EventImport_1_0 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    
    <EventSchedule sService="401" tStart="2008.10.24-0:00:00" tEnd="2008.11.01-00:00:00">
    
    <Event uId="1" tBoxStart="2008.11.03-23:30:00" dBoxDur="0:30:0" sTitle="Telebrands">
    
    <ShortDescriptor sLang="eng" sName="Telebrands">Family Entertainment</ShortDescriptor>
    
    <ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>
    
    </Event>
    
    </EventSchedule>
    
    </SIS_EventImport_1_0>
    ========================================================================================

    Machine acceptable code
    <?xml version="1.0" encoding="ISO-8859-15"?>
    
    <!DOCTYPE SIS_EventImport_1_0 SYSTEM "SIS_EventImport_1_0.dtd">
    
    <SIS_EventImport_1_0>
    
    <?comvenient.parser CharCoding="ISO8859_15" TimeZone="LOCAL"?> 
    
    
    <EventSchedule sService="401" tStart="2008.10.24-0:00:00" tEnd="2008.11.01-00:00:00">
    
    
    <Event uId="1" tBoxStart="2008.10.25-00:00:00" dBoxDur="0:30:0" sTitle="Teleshopping">
    
    <ShortDescriptor sLang="eng" sName="Teleshopping">Family Entertainment</ShortDescriptor>
    
    <ExtendedDescriptor sLang="eng">Not Available</ExtendedDescriptor>
    
    </Event>
    
    </EventSchedule>
    
    </SIS_EventImport_1_0>
    ========================================================================================

    see the top four lines are different.

    Is there a way to customize namespace and add doctype declaration at the top via excel in the format our machine accepts it.


    Please help.
    Last edited by Leith Ross; 11-24-2008 at 03:01 AM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1