soliantconsulting/SimpleFM

View on GitHub
test/Client/ResultSet/TestAssets/projectsampledata.xml

Summary

Maintainability
Test Coverage
<?xml version ="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "http://shn.serveftp.net:80/fmi/xml/fmresultset.dtd">
<fmresultset xmlns="http://www.filemaker.com/xml/fmresultset"
    version="1.0">
    <error code="0"></error>
    <product build="06/21/2012" name="FileMaker Web Publishing Engine"
        version="12.0.2.228"></product>
    <datasource database="FMServer_Sample_Web" date-format="MM/dd/yyyy"
        layout="Project" table="Projects" time-format="HH:mm:ss"
        timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="3"></datasource>
    <metadata>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="PROJECT ID MATCH FIELD" not-empty="no"
            numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="Created By" not-empty="no"
            numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="Creation TimeStamp" not-empty="no"
            numeric-only="no" result="timestamp" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="Project Name" not-empty="no"
            numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Description" not-empty="no"
            numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="Status" not-empty="no" numeric-only="no"
            result="number" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="yes" four-digit-year="no"
            global="no" max-repeat="1" name="Status on Screen" not-empty="no"
            numeric-only="no" result="text" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Start Date" not-empty="no"
            numeric-only="no" result="date" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Due Date" not-empty="no"
            numeric-only="no" result="date" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Days Remaining" not-empty="no"
            numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Days Elapsed" not-empty="no"
            numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Project Completion" not-empty="no"
            numeric-only="no" result="number" time-of-day="no" type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Tag" not-empty="no" numeric-only="no"
            result="text" time-of-day="no" type="normal"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Start Date Project Completion"
            not-empty="no" numeric-only="no" result="date" time-of-day="no"
            type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="1" name="Due Date Project Completion"
            not-empty="no" numeric-only="no" result="date" time-of-day="no"
            type="calculation"></field-definition>
        <field-definition auto-enter="no" four-digit-year="no"
            global="no" max-repeat="9" name="Repeating Field" not-empty="no"
            numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
        <relatedset-definition table="Tasks">
            <field-definition auto-enter="yes" four-digit-year="no"
                global="no" max-repeat="1" name="Tasks::Task Name" not-empty="no"
                numeric-only="no" result="text" time-of-day="no" type="normal"></field-definition>
            <field-definition auto-enter="yes" four-digit-year="no"
                global="no" max-repeat="1" name="Tasks::TASK ID MATCH FIELD"
                not-empty="no" numeric-only="no" result="number" time-of-day="no"
                type="normal"></field-definition>
            <field-definition auto-enter="no" four-digit-year="no"
                global="no" max-repeat="9" name="Tasks::Repeating Field" not-empty="no"
                numeric-only="no" result="number" time-of-day="no" type="normal"></field-definition>
        </relatedset-definition>
    </metadata>
    <resultset count="3" fetch-size="3">
        <record mod-id="5" record-id="7676">
            <field name="PROJECT ID MATCH FIELD">
                <data>1</data>
            </field>
            <field name="Created By">
                <data>Tim Thomson</data>
            </field>
            <field name="Creation TimeStamp">
                <data>02/22/2012 17:19:47</data>
            </field>
            <field name="Project Name">
                <data>Launch web site</data>
            </field>
            <field name="Description">
                <data>Launch the web site with our new branding and product line.

                    Third line</data>
            </field>
            <field name="Status">
                <data>4</data>
            </field>
            <field name="Status on Screen">
                <data>Overdue</data>
            </field>
            <field name="Start Date">
                <data>04/13/2011</data>
            </field>
            <field name="Due Date">
                <data>05/02/2012</data>
            </field>
            <field name="Days Remaining">
                <data>0</data>
            </field>
            <field name="Days Elapsed">
                <data>275</data>
            </field>
            <field name="Project Completion">
                <data>.48</data>
            </field>
            <field name="Tag">
                <data>marketing</data>
            </field>
            <field name="Start Date Project Completion">
                <data>04/13/2011</data>
            </field>
            <field name="Due Date Project Completion">
                <data>05/02/2012</data>
            </field>
            <field name="Repeating Field">
                <data>A1</data>
                <data>B2</data>
                <data>C3</data>
                <data>D4</data>
                <data>E5</data>
                <data>F6</data>
                <data>G7</data>
                <data>H8</data>
                <data>I9</data>
            </field>
            <relatedset count="5" table="Tasks">
                <record mod-id="1" record-id="14999">
                    <field name="Tasks::Task Name">
                        <data>Site map sketch</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>2</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>1</data>
                        <data>2</data>
                        <data>3</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15000">
                    <field name="Tasks::Task Name">
                        <data>Send art to vendor</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>4</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>4</data>
                        <data>5</data>
                        <data>6</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15001">
                    <field name="Tasks::Task Name">
                        <data>Review mock ups</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>5</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>7</data>
                        <data>8</data>
                        <data>9</data>
                    </field>
                </record>
                <record mod-id="0" record-id="15002">
                    <field name="Tasks::Task Name">
                        <data>Write page text</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>6</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
                <record mod-id="0" record-id="15003">
                    <field name="Tasks::Task Name">
                        <data>New logo art</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>3</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
            </relatedset>
        </record>
        <record mod-id="4" record-id="7677">
            <field name="PROJECT ID MATCH FIELD">
                <data>7</data>
            </field>
            <field name="Created By">
                <data>Tim Thomson</data>
            </field>
            <field name="Creation TimeStamp">
                <data>02/22/2012 17:19:47</data>
            </field>
            <field name="Project Name">
                <data>Prototype</data>
            </field>
            <field name="Description">
                <data>Build a working prototype of the new product.


                    Fourth line.</data>
            </field>
            <field name="Status">
                <data>4</data>
            </field>
            <field name="Status on Screen">
                <data>Overdue</data>
            </field>
            <field name="Start Date">
                <data>02/06/2012</data>
            </field>
            <field name="Due Date">
                <data>02/17/2012</data>
            </field>
            <field name="Days Remaining">
                <data>0</data>
            </field>
            <field name="Days Elapsed">
                <data>9</data>
            </field>
            <field name="Project Completion">
                <data>.32</data>
            </field>
            <field name="Tag">
                <data>manufacturing</data>
            </field>
            <field name="Start Date Project Completion">
                <data>02/09/2012</data>
            </field>
            <field name="Due Date Project Completion">
                <data>02/17/2012</data>
            </field>
            <field name="Repeating Field">
                <data>*1</data>
                <data>-2</data>
                <data>+3</data>
                <data>.4</data>
                <data>/5</data>
                <data>=6</data>
                <data>=7</data>
                <data>-8</data>
                <data>`9</data>
            </field>
            <relatedset count="5" table="Tasks">
                <record mod-id="1" record-id="15005">
                    <field name="Tasks::Task Name">
                        <data>Build prototype</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>9</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>a</data>
                        <data>b</data>
                        <data>c</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15006">
                    <field name="Tasks::Task Name">
                        <data>Review sketches</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>8</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>d</data>
                        <data>e</data>
                        <data>f</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15007">
                    <field name="Tasks::Task Name">
                        <data>Complete sketches</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>7</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>g</data>
                        <data>h</data>
                        <data>i</data>
                    </field>
                </record>
                <record mod-id="0" record-id="15014">
                    <field name="Tasks::Task Name">
                        <data>Draft requirements</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>16</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
                <record mod-id="0" record-id="15015">
                    <field name="Tasks::Task Name">
                        <data>Review requirements</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>17</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
            </relatedset>
        </record>
        <record mod-id="4" record-id="7678">
            <field name="PROJECT ID MATCH FIELD">
                <data>13</data>
            </field>
            <field name="Created By">
                <data>Tim Thomson</data>
            </field>
            <field name="Creation TimeStamp">
                <data>02/22/2012 17:19:47</data>
            </field>
            <field name="Project Name">
                <data>Investor meeting</data>
            </field>
            <field name="Description">
                <data>This is important. We need the investors to have confidence.
                    Second line.</data>
            </field>
            <field name="Status">
                <data>4</data>
            </field>
            <field name="Status on Screen">
                <data>Overdue</data>
            </field>
            <field name="Start Date">
                <data>12/12/2011</data>
            </field>
            <field name="Due Date">
                <data>03/22/2012</data>
            </field>
            <field name="Days Remaining">
                <data>0</data>
            </field>
            <field name="Days Elapsed">
                <data>73</data>
            </field>
            <field name="Project Completion">
                <data>.4285714285714286</data>
            </field>
            <field name="Tag">
                <data>finance</data>
            </field>
            <field name="Start Date Project Completion">
                <data>01/02/2012</data>
            </field>
            <field name="Due Date Project Completion">
                <data>03/22/2012</data>
            </field>
            <field name="Repeating Field">
                <data>a1</data>
                <data>b2</data>
                <data>c3</data>
                <data>d4</data>
                <data>e5</data>
                <data>f6</data>
                <data>g7</data>
                <data>h8</data>
                <data>i9</data>
            </field>
            <relatedset count="7" table="Tasks">
                <record mod-id="1" record-id="15004">
                    <field name="Tasks::Task Name">
                        <data>Gather requirements</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>1</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>*</data>
                        <data>-</data>
                        <data>+</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15008">
                    <field name="Tasks::Task Name">
                        <data>Investor meeting</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>13</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>`</data>
                        <data>=</data>
                        <data>-</data>
                    </field>
                </record>
                <record mod-id="1" record-id="15009">
                    <field name="Tasks::Task Name">
                        <data>Final draft of slides</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>12</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data>(</data>
                        <data>)</data>
                        <data>^</data>
                    </field>
                </record>
                <record mod-id="0" record-id="15010">
                    <field name="Tasks::Task Name">
                        <data>Complete business plan</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>10</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
                <record mod-id="0" record-id="15011">
                    <field name="Tasks::Task Name">
                        <data>First draft of slides</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>11</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
                <record mod-id="0" record-id="15012">
                    <field name="Tasks::Task Name">
                        <data>Market research</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>14</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
                <record mod-id="0" record-id="15013">
                    <field name="Tasks::Task Name">
                        <data>Competitive analysis</data>
                    </field>
                    <field name="Tasks::TASK ID MATCH FIELD">
                        <data>15</data>
                    </field>
                    <field name="Tasks::Repeating Field">
                        <data></data>
                        <data></data>
                        <data></data>
                    </field>
                </record>
            </relatedset>
        </record>
    </resultset>
</fmresultset>