wrapped columns, study import and list.xml error

LabKey Support Forum
wrapped columns, study import and list.xml error Ben Bimber  2010-03-18 12:23
Status: Closed
 
here's a portion of list.xml from a study import. near the bottom I try to alias 2 fields using XML that works when i do it through the GUI or cut/paste in metadata (search wrappedColumnName). However, it throws an error when i use this for a study import. The error is:

Error creating list "project": Unknown property type "null" for property "totalAssigned". Can I define these wrapped columns on import?


    <table tableName="origin" tableDbType="TABLE">
      <tableTitle>Origin Codes</tableTitle>
      <columns>
        <column columnName="code">
          <datatype>varchar</datatype>
          <columnTitle>Code</columnTitle>
          <nullable>false</nullable>
          <isKeyField>true</isKeyField>
        </column>
        <column columnName="meaning">
          <datatype>varchar</datatype>
          <columnTitle>Meaning</columnTitle>
        </column>
      </columns>
      <pkColumnName>code</pkColumnName>
    </table>
    <table tableName="project" tableDbType="TABLE">
      <tableTitle>IACUC Projects</tableTitle>
      <columns>
        <column columnName="pno">
          <datatype>varchar</datatype>
          <columnTitle>Project</columnTitle>
          <nullable>false</nullable>
          <isKeyField>true</isKeyField>
        </column>
        <column columnName="protocol">
          <datatype>varchar</datatype>
          <columnTitle>Protocol</columnTitle>
          <fk>
            <fkDbSchema>lists</fkDbSchema>
            <fkTable>protocol</fkTable>
            <fkColumnName>protocol</fkColumnName>
          </fk>
        </column>
        <column columnName="account">
          <datatype>varchar</datatype>
          <columnTitle>Account</columnTitle>
        </column>
        <column columnName="inves">
          <datatype>varchar</datatype>
          <columnTitle>Investigator</columnTitle>
        </column>
        <column columnName="avail">
          <datatype>varchar</datatype>
          <columnTitle>Availability</columnTitle>
          <fk>
            <fkDbSchema>lists</fkDbSchema>
            <fkTable>avail</fkTable>
            <fkColumnName>code</fkColumnName>
          </fk>
        </column>
        <column columnName="title">
          <datatype>varchar</datatype>
          <columnTitle>Title</columnTitle>
        </column>
        <column columnName="research">
          <datatype>boolean</datatype>
          <columnTitle>Research</columnTitle>
        </column>
        <column columnName="reqname">
          <datatype>varchar</datatype>
          <columnTitle>Requestor Name</columnTitle>
        </column>
        <column columnName="totalAssigned" wrappedColumnName="pno">
          <columnTitle>Animals Assigned</columnTitle>
          <fk>
            <fkDbSchema>lists</fkDbSchema>
            <fkTable>projectTotalAssigned</fkTable>
            <fkColumnName>pno</fkColumnName>
          </fk>
        </column>
        <column columnName="lastAssignment" wrappedColumnName="pno">
          <columnTitle>Last Assignment Date</columnTitle>
          <fk>
            <fkDbSchema>lists</fkDbSchema>
            <fkTable>projectLastAssignmentDate</fkTable>
            <fkColumnName>pno</fkColumnName>
          </fk>
        </column>
      </columns>
      <pkColumnName>pno</pkColumnName>
    </table>