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 ie - 'Nursing, Department of' must be replaced with 'Nursing|| Department of'.

Multiple arguments within one column can be separated with a tilde (~). However, this may yeild unexpected results (missing XML attributes, improper nesting) if used outside the following fields: FAX, PHONE, EMAIL, POSITION.

STATUS
POSITION
EMAIL
BUILDING ROOM_NUMBER
IDENTIFIER
TERM_OF_ADDRESS
GIVEN_NAME
FAMILY_NAME
FAX
PHONE
DISPLAY_NAME
DEPARTMENT
BUILDING
CAMPUS
NAME_DATE
STREET
CITY
STATE
COUNTRY
POSTCODE
START_DATE
END_DATE
ROOM_NUMBER
BUILDING
CAMPUS

...

Code Block

language	xml
title	Sample MADS output
collapse	true

<mads xmlns="http://www.loc.gov/mads/v2" xmlns:mads="http://www.loc.gov/mads/v2"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink">
    <authority>
        <name type="personal">
            <namePart type="given">[GIVEN_NAME]</namePart>
            <namePart type="family">[FAMILY_NAME]</namePart>
            <namePart type="termsOfAddress">[TERM_OF_ADDRESS]</namePart>
            <namePart type="date">[NAME_DATE]</namePart>
        </name>
        <titleInfo>
            <title>[DISPLAY_NAME]</title>
        </titleInfo>
    </authority>
    <affiliation>
        <organization>[DEPARTMENT]</organization>
        <position>[POSITION]</position>
        <address>
        <email>[EMAIL]</email>
        <phone>[PHONE]</phone>
        <fax>[FAX]</fax>
        <street>[STREET]</street>
        <city>[CITY]</city>
        <state>[STATE]</state>
        <country>[COUNTRY]</country>
        <postcode>[POSTCODE]</postcode>
        <start_date>[START_DATE]</start_date>
        <end_date>[END_DATE]</end_date>
    </address>
    </affiliation>
    <note type="address">[ROOM_NUMBER] [BUILDING] [CAMPUS]</note>
    <identifier type="u1">[IDENTIFIER]</identifier>
    <note type="status">[STATUS]</note>
</mads>

Multiple arguments within one column can be separated with a tilde (~) e.g. meat~cheese~pickles. However, this may yield unexpected results (missing XML attributes, improper nesting) if used outside the following fields: FAX, PHONE, EMAIL, POSITION. The following is the result of including two values in each field can be seen below:

Code Block

language	xml
title	Sample MADS output with multiple values
collapse	true

<?xml version="1.0" encoding="UTF-8"?>
<mads xmlns="http://www.loc.gov/mads/v2" xmlns:mads="http://www.loc.gov/mads/v2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xlink="http://www.w3.org/1999/xlink">
  <authority>
    <name type="personal">
      <namePart>[GIVEN_NAME1]</namePart>
      <namePart type="given">[GIVEN_NAME2]</namePart>
      <namePart>[FAMILY_NAME1]</namePart>
      <namePart type="family">[FAMILY_NAME2]</namePart>
      <namePart>[TERM_OF_ADDRESS1]</namePart>
      <namePart type="termsOfAddress">[TERM_OF_ADDRESS2]</namePart>
      <namePart>[NAME_DATE1]</namePart>
      <namePart type="date">[NAME_DATE2]</namePart>
    </name>
    <titleInfo>
      <title>[DISPLAY_NAME1]</title>
      <title>[DISPLAY_NAME2]</title>
    </titleInfo>
  </authority>
  <affiliation>
    <organization>[DEPARTMENT1]</organization>
    <organization>[DEPARTMENT2]</organization>
    <position>[POSITION1]</position>
    <position>[POSITION2]</position>
    <address>
      <email>[EMAIL1]</email>
      <email>[EMAIL2]</email>
      <phone>[PHONE1]</phone>
      <phone>[PHONE2]</phone>
      <fax>[FAX1]</fax>
      <fax>[FAX2]</fax>
      <street>[STREET1]</street>
      <street>[STREET2]</street>
      <city>[CITY1]</city>
      <city>[CITY2]</city>
      <state>[STATE1]</state>
      <state>[STATE2]</state>
      <country>[COUNTRY1]</country>
      <country>[COUNTRY2]</country>
      <postcode>[POSTCODE1]</postcode>
      <postcode>[POSTCODE2]</postcode>
      <start_date>[START_DATE1]</start_date>
      <start_date>[START_DATE2]</start_date>
      <end_date>[END_DATE1]</end_date>
      <end_date>[END_DATE2]</end_date>
    </address>
  </affiliation>
  <note>[ROOM_NUMBER1]</note>
  <note>[ROOM_NUMBER2] 
[BUILDING1]</note>
  <note>[BUILDING2] 
[CAMPUS1]</note>
  <note type="address">[CAMPUS2]</note>
  <identifier>[IDENTIFIER1]</identifier>
  <identifier type="u1">[IDENTIFIER2]</identifier>
  <note>[STATUS1]</note>
  <note type="status">[STATUS2]</note>
</mads>

Dependencies

...

Child pages

Versions Compared

Old Version 2

New Version 3

Key

Dependencies