Page Comparison

...

• OBJECTS (OC to CS Migration)
  • There are 138 objects total that have "unknown" as the accession number and have NO location. Many of these can be deleted. See list.
  • Objects that are not collection objects*** FP (film program photographs)
    • WA (digital media?)
  • Artifact Class/Work Type and Collection Category
    • Artifact Class and Work Type appear in a single cell in each object record row in the excel doc reports from OC. They cannot be sorted separately.
    • Many objects have "artifact class" but have not been assigned a work type. When this the case, only the "artifact class" appears in the "artifact class/work type" cell in the report. For this reason, it's impossible to determine based on the reporting function how many objects have a classification for "Artifact Class" and yet lack a classification in "Work Type."
    • Because "artifact class" is a controlled list, it is impossible to not choose a value for artifact class. The default choice is "*Undetermined." Over 13,000 records have this default classification. Most of these records also lack classification for "collection category" (see below).
    • Because "collection category" is a controlled list, it is impossible to not choose a value for collection category. The default choice is "*Not yet assigned." About 13,000 records have this default classification. Most of these records also lack classification for "artifact class" and "work type."
    • CLASSIFICATION:
      • Most of the uncategorized objects can be categorized using the attributes "Category" and "Subcategory." See Classification Walkover (simple), and a more detailed, object-by-object walkover which shows how many objects are in each artifact class/work type. Many of these objects on this list can be classified by hand (where there are too few objects in a category to justify automating their classification).
      • Many objects will have to be classified by hand by a cataloger before the migration, or else left undetermined. There is one list of assorted objects to classify and one list of books to classify. See full list of objects to classify and list of books to classify.
  • Dimensions - In OC, "Dimensions" is a single field containing up to three values. In CS, there will be multiple fields for dimensions that will be named according to type (e.g., height, width, depth, diameter, etc). We will need to separate each of the three values into its own field.
    • ASSIGNING MEASUREMENT TYPES
      • In most cases, each value will go in its own field WITHOUT a measurement type. This is because, while most OC records list the values in a specific order (height, width, then depth), many records do not follow this rule.
      • Fields that contain all three characters (H, W, and D): We can assign a measurement type to the value based on the character.
      • Fields that contain the word "Diameter" or "Dia": We can assign a measurement type to the value based on that word. (Given that the letter "D" repeats in both "D" for "Depth," as above, and in "Diameter," will it be possible to automate measurement type?)
      • CS Field: Dimension Measured By: Is there a way to pull this information from "Object Histories"?
    • FORMATTING MEASUREMENT VALUES
      • In all cases we can convert fractions (1/2) into decimals (.5). If we do so, we will have to delete the space before the decimal, unless the fraction is the first value in the list of 2-3 lengths listed in the "dimensions" field. However, many values include fractions in increments of smaller than 1/4 (e.g., 3/8 or 5/8).
      • Many decimal values are displayed in increments smaller than .25 (e.g. .125, .375). Should we round these up or down?
  • Extent - Many objects have no extent. (Extent report.)
    • Some of these objects are records in lots that have not yet been numbered. Thus, the lot will contain multiple objects with the same 7-digit accession number.
      • According to Megan, many of these lots contain extent info for the entire lot, listed in the access database order, in their "Administrative remarks" fields. However, this is not a consistent pattern. See attached report. (Here.)extent report on lots or groups of objects that have inventory extent info from the access database in the admin notes field here. We need to go through this data by hand and try to assign it to its proper place. 
    • For many of these objects, it is obvious from the title that the extent is "1." However, these records number in the thousands.
  • Registrar Status - Delete this field entirely.
  • Phys_remarks - This is a hidden data field on OC -- it appears in the database and in reporting, but cannot be edited through the OC user interface. Over 5000 records contain information in this field. About 5000 records have information in this field, so it would be difficult to move this information by hand. See report.
    • Without exception the field contains information that can be moved to attributes. In reporting, all this information appears in the same cell. The attribute value appears after the attribute type. These are the attribute types:
      • Format Gauge:
      • ModelNumber:
      • Material:
      • Markings:
      • Serial Number:
      • Weight:
    • Repeated values are recorded in the report separated by semicolons. Example:
      • Material: Tin; porcelain; wood ModelNumber: 1912
    • Within the attribute field "materials," values are often separated by commas. Example:
      • Material: wood, metal, glass
    • "Markings" often contains a comma as a part of the value rather than as a symbol that denotes two separate values. Example:
      • Markings: 'Nite Lite' Exclusively Distributed by LECO Electric Manufacturing Co., Florida, NY.  Copyright by Kagran Corporation.  Made in Japan.
  • Condition/Artifact Needs - "Artifact Needs" information can be fed into "Condition" where it matches up with one of the four fields in "Condition." See artifact needs report.
    • Adding value to the "Condition" field
      • Where the exact phrase "Exhibitable/Needs Work" appears in "Artifact Needs," delete the phrase and the change value in "Condition" to 1.
      • Where the exact phrase "Needs No Work" appears, delete the phrase and change the value in "Condition" to 0.
      • Where the exact phrase "In Jeopardy/Unstable" appears, delete the phrase and change the value in "Condition" to 3.
      • Where the exact phrase "Not Exhibitable/Stable" appears, delete the phrase and change the value in "Condition" to 2.
      • Keep in mind that these phrases occasionally appear in the field "Artifact Needs" with other text. The other text should not be deleted.
    • Adding values for "Marking" and "Tagging"
      • "Marking," "Tagging," "Needs marking," "Needs tagging," "Marking and tagging," "Marking & tagging," "Needs marking and tagging," "Needs marking & tagging."
    • Keep remaining values in "Artifact needs" and keep field.
  • Accession date.  - Delete this field entirely.
  • Attributes. (Data below comes from looking at each field on this report of all objects with all attribute fields.)
    • The following attributes fields are available for inclusion in reports run on OBJECTS. These are: Category, Components, Copyright date, Copyright holder, Copyright Statement, Creation date, Credit line, Dimensions (in), Display Date, Extent, Format, Manufacturer, Material, Other physical details, Photo credit, Publication date, Publisher, Serial number, Subcategory, Subject, Technique
    • The following attributes fields are a part of the database structure but are NOT available in reports run on OBJECTS. These are: Color, Color/BW, Country, Creator, Date of birth, Date of death, Director, Distributor, Form, Genre, Historical notes, Key, Label and caption, Language, Licensor, Medium, Network/Cable service, Place name, Principle cast, Production company, Production date, Release date, Running dates, Running time. Most of these attributes are in use in other data sets (Entities, Occurrences, etc). It is unknown whether or not any object records have data in any of these fields, but it is unlikely (the database structure probably does not allow it).
    • All attribute fields are repeatable. When exporting this data via the OC "reporting" function, however, each object record has only one cell per attribute field. In cases in which a field has been repeated in an object record, both pieces of data will appear in a single cell separated by a semicolon.
      • CATEGORY: We will be able to delete this category after we finish the classification walkover.
      • COMPONENTS: If we are using Excel to store data at any point in migrating this field: Be aware that Excel's auto-formatting will convert all page number values up to 12 p. (1 p. - 12 p.) automatically into times (1:00 PM - 12:00 PM). Simply reformatting the cells after exporting the data will not restore the data to its original form (instead, 12:00 PM becomes "0.5," and so on).
      • CREDIT LINE: This field is completely empty -- it holds no data. Delete.
      • DIMENSIONS: Some of the data contained in this field repeats data in the "Dimensions" field in the Objects > Basic tab. Some of it does not, and instead provides different measurements for an additional component of the object (e.g., the packaging for a toy, where the "Dimensions" field in Basic contains the dimensions of the toy itself). Since dimensions is repeatable in OC, we should export the data there.
      • All Dates:  This includes DISPLAY DATE, COPYRIGHT DATE, CREATION DATE, and PUBLICATION DATE: Many object records contain multiple dates.
      • EXTENT: It appears that in MOST cases the cataloger mistakenly put the data for "Components" into this field instead. None of the objects that have data in "Extent" have data for "Components," so we could move the data into the "Components" field without worrying about writing over more recent/relevant data. There are relatively few fields with data for "Extent" (68 total), so we could easily move this data by hand. Still must do all the extents from 2002.007.
      • OTHER PHYSICAL DETAILS: Most of this data belongs in other fields (such as dimensions, components, copyright statement, etc), but there is no way to sort it automatically. Move this data by hand. Other data remains that could be moved automatically:
        • Alternate dimensions (eg: "Bowl: Diameter 5.5 x 2; Cup: 4.25 x 2.25 x 2.25," or "Box: 1 x 7.25 x 7.25")
        • Clothing sizes (eg: "Adult size medium (38-40)," "Children's large.")
        • See "Other phsyical details" objects list for the remaining items. This may need to be moved by hand.
      • PUBLISHER: This field is blank. Delete.
      • SUBCATEGORY: We will be able to delete this field after we complete the classification walkover.
      • SUBJECT: In all but a few cases this field is blank or contains irrelevant info. A few lots contain data we would like to preserve. I've listed these lots below along with information on the nature of the data and how we should migrate it. See subject report.
        • 1989.26: Lists associated individuals, productions, corporations, collections, and subjects in "Subject." Each of these strings of names is preceded by one of the following four phrases: "By Corporation Name:", "Miscellaneous:", "By Personality/Character Name:", "By Production Title:". However, these typologies only refer to the first item in each list and the list may contain other names, production names, and subject keywords. There are over 1000 objects, so it would be possible (though difficult) to move this data by hand. Here are a few examples: 
          • "By Personality/Character Name:  Lombard, Carole ; Carole Lombard; Sports/Exercise/Martial Arts; Home/Family Life"
          • "By Production Title:  STAR MAKER, THE; Linda Ware; Louise Campbell; Bing Crosby; Ned Sparks; Walter Damrosch (Conductor/ Actor); Gus Edwards (Songwriter); Teenagers"
          • "By Personality/Character Name:  Bennett, Constance; Constance Bennett; Joan Bennett; Barbara Bennett; Children/Babies"
        • 1986.59: "Subject" field gives more specific info than the "Subcategory" field. This info is not repeated elsewhere and would map better onto Work Types. The values listed in this lot under "Subject" include: Behind the Scenes Photo, Behind-the-Scene Photograph, Behind-the-Scenes, Behind-the-Scenes Still, Candid Portrait, Cast and Crew Photo, Production Photo, production photograph, Publicity Color Transparency, Publicity Portrait, Publicity Still, Scene Still, Scene Stills. The values listed under "Subcategory" include "Industry and Production Photographs" and "Scene Stills." There are 270 objects, so this data is easy to move by hand.
        • 1992.6: "Subject" field contains entity information. 95% of this information appears to have been entered by hand  into "Entities" for each record. I think it is safe to delete everything in "Subject" for this -- we may lose one or two terms, but that would be it.
        • 1994.2: Same as 1992.6.
        • 1995.7: Can delete all.
        • 1996.3: There is some data in "Subject" for many items in this lot but it is not consistent in nature. The lot is small and someone should go through it by hand in order to move the information to the proper fields.
        • 1998.5: Entity info in "Subject": this is a small lot and it's easier to move this information by hand.
      • TECHNIQUE: Can replace all instances of "lithograph" with "lithography.
  • History.
    • LOANS: In order to NOT migrate the "Loans" history data, we'll have to delete only the "history" records with a type_id of 1 (Loans).
      • LOCATION: Standardize format for "location"

...