Coastal & Marine Geology InfoBank

Home FACS Activities Atlas Geology School Related Sites More

USGS CMG InfoBank Management of Materials

Skip navigational links
Loading
Uses: Find it   Learn more   Get answer  
CMG Staff: Nationwide   Pacific   St. Petersburg   Woods Hole  
CMG Facilities: Offices   Research Libraries   Research Platforms  
CMG Directions: to Menlo Park   to Santa Cruz   to St. Petersburg   to Woods Hole   to MARFAC   to MOF   to O'Brien  

This provides details about InfoBank's management of materials Materials

InfoBank Terminology for Materials

InfoBank Databases for Materials

InfoBank Management of Materials


InfoBank's management of materials includes
  1. Content information -- the user managed component about...
    • Descriptions
    • Items
    • Containers
  2. Geospatial information -- the system managed component about...
    • Areas
    • Locations
    • Databases

Content information
Description new
  1. Use EXCEL to edit the /infobank/holdings/<database>.txt file.
edit  
move  
delete  
Item new
  1. On SQUID, run "newitem" to obtain item numbers.
  2. If needed, print label(s) for the item(s).
edit
  1. Add descriptions, FACS ID, etc. to new item numbers listed at the bottom of designated holdings .txt file.
  2. On SQUID, run "updateholdings" to associate location information with the new additions.
  3. On SQUID, run "parseholdings" to create thematic groupings of holdings items.

  4. On SQUID, run "containerhtmls4activities"
  5. On SQUID, run "webupdate" of "/infobank/programs/html/containerhtmls4activities"

  6. On SQUID, run "containers2html"
  7. On SQUID, run "webupdate" of "/infobank/programs/html/containers2html"

  8. On SQUID, run "elevations4activities"
  9. On SQUID, run "webupdate" of "/infobank/programs/html/elevations4activities"

  10. On SQUID, run "elevations4containers"
  11. On SQUID, run "webupdate" of "/infobank/programs/html/elevations4containers"
move
  1. If needed, change the "container number" and the "container type" information.
  2. Use EXCEL to sort by "container number", then "item number".
  3. Save the file from EXCEL as tab-delimited text to SQUID.
  4. On SQUID, run "updateholdings"
  5. If the "container type" information was changed, copy the updated records from the .txt file into the .txt file.
delete  
Container new
  1. On SQUID, run "newcontainer" to obtain container number(s).
  2. Use EXCEL to edit the "/infobank/holdings/container_locations/<database>.txt" text file.
  3. Print label(s) for the container(s).
edit  
move  
delete  

Geospacial information
Area new Do the following steps to define a new area in a location (e.g.: areas E, F, G, and H in FACS Rm. 1133).
  1. Contact Clint Steele
  2. with area information.
edit Do the following steps when area definition information changes.
  1. Contact Clint Steele with information about why.
move Do the following steps to rename an area.
  1. Contact Clint Steele with information about why.
delete Do the following steps to remove an area definition.
  1. Contact Clint Steele with information about why.
Location new Do the following steps when a new building or room is added to the database.
  1. Contact Clint Steele with location information.
edit Do the following steps when updating the information and/or links about a location.
  1. Contact Clint Steele with location information.
move Do the following steps when materials are moved into a new location. (e.g., MarFac Refers relocated to 1020 O'Brien Drive)
  1. Contact Clint Steele with information about why.
delete Do the following steps when a location is no used for FACS materials (e.g. MarFac Refer #1, MarFac Refer #2).
  1. Contact Clint Steele with information about why.
Database new Do the following steps when:
  • there is a new type of holding (e.g.: maps, black boxes, D-tubes)
  • new data does not fit within fields of existing databases (see InfoBank Databases for Materials)
  • database file becomes so volumnious that it is best subdivided (e.g.: boxes1020, boxes1030, boxes1040)
  • an individual or group is the primary maintainer (e.g.: woodshole, stpete)
  1. Decide what the database should be named (see InfoBank Databases for Materials for a list of existing databases).
  2. What fields (columns) should there be in the new database? (columns A thru I in all databases are ...
  3. A B C D E F G H I
    !Item Number !Container Number !Container Area !Container Type !Container Location !Container Column !Container Row !Date Updated !Database
    • Columns C thru G are defined in /infobank/programs/keep/containers_list.keep and are required for InfoBank.
    • Customized field names in columns J and beyond should not start with an "!".
    • Use clear, descriptive field names because they will appear on InfoBank pages.
  4. Contact Clint Steele
  5. about the database name and fields.
edit Do the following steps to rename, remove, rearrange, or add entire fields (columns) in a database.
  1. Check the list of existing databases
  2. (see InfoBank Databases for Materials) to determine the database name and fields.
  3. Decide which will be renamed in, removed from, rearranged in, or added to the database.
  4. Contact Clint Steele for approval of the suggested changes.
  5. Make the changes.
    • To rename a field in the database -- change the column header cell using VI or Excel.
    • To remove a field from the database -- delete the entire column using Excel.
    • To rearrange fields in the database -- rearrange the columns using Excel.
    • To add a field to the database -- insert a column using Excel.
rename Do the following steps to rename a database.
  1. Check the list of existing databases
  2. (see InfoBank Databases for Materials) to determine the database name.
  3. Decide the new name for the database.
  4. Contact Clint Steele
  5. for approval with information about why.
  6. Replace all the entries in column I (!Database) of the old database with the new database name.
  7. Move the old database into a new database
  8. ("mv /infobank/holdings/container_locations/<olddatabase>/.txt /infobank/holdings/container_locations/<newdatabase>.txt").
remove Do the following steps to remove a database.
  1. Check the list of existing databases (see InfoBank Databases for Materials) to determine the database name.
  2. Contact Clint Steele
  3. for approval with information about why.
  4. Remove the old database
  5. ("rm /infobank/holdings/container_locations/<olddatabase>.txt").

Skip footer navigational links

Coastal and Marine Science Centers:  Pacific   St. Petersburg   Woods Hole  
InfoBank   Coastal and Marine Geology Program   Geologic Information   Ask-A-Geologist   USGS Disclaimer  


Accessibility FOIA Privacy Policies and Notices

Take Pride in America logo USA.gov logo U.S. Department of the Interior | U.S. Geological Survey
URL: http://walrus.wr.usgs.gov/infobank/programs/html/main/materials_management.html
Page Contact Information: InfoBank staff
Page Last Modified: Wed Feb 12 07:39:08 PST 2014  (chd)