EAD data migration

No project numbers need be listed in the detailed description of drawings, unless that is the only identifying piece of information about a project.

Collection codes should be used for container type, with roll numbers or other information as the content – to create a break between projects and apply meaningful AAA data that will not change to each project. See example, from the Max M. Sandfield records (00123.xml) below:

            <container type="SAND">   r077     </container>

Drawing database records can be exported from Filemaker Pro for entry into XML finding aids in Oxygen. The process is outlined below:

            In Filemaker Pro, select Records> Show all records, then Records, Sort Records.

            Sort Records by Project name.

Select File> Export Records. A box will pop up to allow you to name the resulting file. Choose a destination and a name for the file, making sure to select Excel Files (*.xls) as file type.

When given the option to Specify Field Order for Export, select the following order:

            Group by: Project Name

            Field Export Order:

                        AAA roll #

                        Project name

                        Date on drawings

                        Primary archt/firm

                        Client

                        Street address

                        City

                        County

                        State/Province

                        Country

Click Export to generate the Excel file.

Open the Excel File.

Add columns containing XML tags around the drawings metadata field data. See example of the first tags added for the first project from the Sandfield record.