XML Export Options

(2 posts) (2 voices)

Tags:

No tags yet.

  1. ChrisFSB, Member

    Following the tutorial I'm unable to get myDBR to use the specified headers.

    For example (Output as SQL):

    select 'dbr.export.options', 'xml.declaration', '<?xml version="1.0" encoding="utf-8"?>';
    select 'dbr.export.options', 'xml.root_tag', 'dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filmlist.xsd"';

    select '9511' as 'description'
    union all
    select 'International 24\''
    union all
    select '9510'
    union all
    select '9557'
    union all
    select 'Transit';

    Exports as (Source):
    <report><resultset name="resultset0"><row number="1"><attribute name="description" type="">9511</attribute></row><row number="2"><attribute name="description" type="">International 24'</attribute></row><row number="3"><attribute name="description" type="">9510</attribute></row><row number="4"><attribute name="description" type="">9557</attribute></row><row number="5"><attribute name="description" type="">Transit</attribute></row></resultset></report>

    Where am I going wrong?

  2. myDBR Team, Key Master

    If you add entry:

    $mydbr_defaults['export']['xml']['compatibility_mode'] = false;

    into the mydbr/user/defaults.php, you will get support for all xml-features. The compatibility_mode is an old restricted xml-version. We just did not want to break existing installations.

    --
    myDBR Team


Reply

You must log in to post.