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> |
||