×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!

wrapped columns, study import and list.xml error

LabKey Support Forum (Inactive)
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>