Page History

...

Prepare a comma-delimited CSV file using the column names below. Only columns with names in the list will be processed; all others will be ignored. Any comma within a field must be replaced with a double pipe. For example, 'Nursing, Department of' must be replaced with 'Nursing|| Department of'.

• STATUS
• POSITION  (
  
  • Note:  In the MADS schema,
  this
  • <position> is an uncontrolled field
  ;
  • .  The csv importer treats <position> as uncontrolled, which is valid with MADS.  However, the default Scholar MADS Form in Islandora treats
  it
  • <position> as a controlled field, and if used to touch up a record with an uncontrolled value for <position>, the default
  form
  • Scholar MAD Form will delete the position information out of the metadata.  If you use the csv importer to fill position with an uncontrolled value, then you will need to modify the Scholar MADS Form, in order to allow
  this field
  • <position> to be edited later in Islandora.
  )
• EMAIL  (Note:  batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS)
• IDENTIFIER
• TERM_OF_ADDRESS
• GIVEN_NAME
• FAMILY_NAME
• •   The recommended quick fix is to edit the Scholar MADS Form and delete the portion of the form which edits <position>.
• EMAIL
  • Note:  The
  FAX  (Note:  batch
  • csv importer will store this to the incorrect MADS field, resulting in invalid MADS
  )
• PHONE  (Note:  batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS)
• DISPLAY_NAME
• DEPARTMENT
• NAME_DATE
• STREET
• CITY
• STATE
• COUNTRY
• POSTCODE
• START_DATE  (Note:  batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS)
• • .  Further, since the default Scholar MADS Form is designed around valid MADS, you will not later be able to touch up this field using the Islandora MADS forms.  A quick fix is not to load Excel records with an EMAIL column, and instead include email in the ROOM_NUMBER or BUILDING or CAMPUS column, which will store to a <note type="address"> field in the MADS.  The better fix is to modify the code for the csv importer.
• IDENTIFIER
• TERM_OF_ADDRESS
• GIVEN_NAME
• FAMILY_NAME
• FAX
  • Note:  The csv importer will store this to the incorrect MADS field, resulting in invalid MADS.  Further, since the default Scholar MADS Form is designed around valid MADS, you will not later be able to touch up this field using the Islandora MADS forms.  A quick fix is not to load Excel records with a FAX column, and instead include fax number in the ROOM_NUMBER or BUILDING or CAMPUS column, which will store to a <note type="address"> field in the MADS.  The better fix is to modify the code for the csv importer.
• PHONE
  • Note:  batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS.  Further, since the default Scholar MADS Form is designed around valid MADS, you will not later be able to touch up this field using the Islandora MADS forms.  A quick fix is not to load Excel records with a PHONE column, and instead include phone number in the ROOM_NUMBER or BUILDING or CAMPUS column, which will store to a <note type="address"> field in the MADS.  The better fix is to modify the code for the csv importer.
• DISPLAY_NAME
• DEPARTMENT
• NAME_DATE
• STREET
• CITY
• STATE
• COUNTRY
• POSTCODE
• START_DATE
  
  • Note:  Batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS.  Further, since the default Scholar MADS Form is designed around valid MADS, you will not later be able to touch up this field using the Islandora MADS forms.  A quick fix is not to use this field with the csv importer.  The better fix is to modify the code for the csv importer.
• END_DATE
  • Note:  Batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS.  Further, since the default Scholar MADS Form is designed around valid MADS, you will not later be able to touch up this field using the Islandora MADS forms.  A quick fix is not to use this field with the csv importer.  The better fix is to modify the code for the csv importer.
  END_DATE  (Note:  batch csv importer will store this to the incorrect MADS field, resulting in invalid MADS)
• ROOM_NUMBER
• BUILDING
• CAMPUS

This will result in the following MADS datastream:

...