{
      "status_changed": "2009-12-30 14:33:32",
      "event_dates": "6-8 May 2009",
      "divisions": [
        "eluna_conf"
      ],
      "eprintid": 227,
      "item_issues_count": 0,
      "title": "Aleph Reports Combining SQL and Excel",
      "eprint_status": "archive",
      "datestamp": "2009-12-30 14:33:32",
      "full_text_status": "restricted",
      "metadata_visibility": "show",
      "subjects": [
        "aleph"
      ],
      "event_type": "conference",
      "documents": [
          {
            "relation": [
              {
                "uri": "/id/document/1858",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1858",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1858",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "All Scripts",
            "docid": 298,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_ALL_Scripts.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 298,
                  "fileid": 4120,
                  "mime_type": "application/pdf",
                  "filesize": 67717,
                  "uri": "https://beta-documents.el-una.org/id/file/4120",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 1,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/298",
            "main": "ELUNA_2009_A15a_ALL_Scripts.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1859",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1859",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1859",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "Using Excel to Prepare a Report of Duplicate Books",
            "docid": 299,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_Dup_Report_steps.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 299,
                  "fileid": 4124,
                  "mime_type": "application/pdf",
                  "filesize": 202308,
                  "uri": "https://beta-documents.el-una.org/id/file/4124",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 2,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/299",
            "main": "ELUNA_2009_A15a_Dup_Report_steps.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1860",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1860",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1860",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "General Excel Tips",
            "docid": 300,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_General_Excel_Tips.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 300,
                  "fileid": 4128,
                  "mime_type": "application/pdf",
                  "filesize": 1159973,
                  "uri": "https://beta-documents.el-una.org/id/file/4128",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 3,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/300",
            "main": "ELUNA_2009_A15a_General_Excel_Tips.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1861",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1861",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1861",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "Using Excel to Prepare a Loan Report",
            "docid": 301,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_Loan_Report_steps.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 301,
                  "fileid": 4132,
                  "mime_type": "application/pdf",
                  "filesize": 571758,
                  "uri": "https://beta-documents.el-una.org/id/file/4132",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 4,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/301",
            "main": "ELUNA_2009_A15a_Loan_Report_steps.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1862",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1862",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1862",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "Using Excel with Data from the Serial/Periodicals Script",
            "docid": 302,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_Periodicals_steps.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 302,
                  "fileid": 4136,
                  "mime_type": "application/pdf",
                  "filesize": 907512,
                  "uri": "https://beta-documents.el-una.org/id/file/4136",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 5,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/302",
            "main": "ELUNA_2009_A15a_Periodicals_steps.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1863",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1863",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1863",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "Using Excel with Output from Permissions Script",
            "docid": 303,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_Premissions_steps.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 303,
                  "fileid": 4140,
                  "mime_type": "application/pdf",
                  "filesize": 455052,
                  "uri": "https://beta-documents.el-una.org/id/file/4140",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 6,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/303",
            "main": "ELUNA_2009_A15a_Premissions_steps.pdf"
          },
          {
            "relation": [
              {
                "uri": "/id/document/1864",
                "type": "http://eprints.org/relation/hasVolatileVersion"
              },
              {
                "uri": "/id/document/1864",
                "type": "http://eprints.org/relation/haspreviewThumbnailVersion"
              },
              {
                "uri": "/id/document/1864",
                "type": "http://eprints.org/relation/hasVersion"
              }
            ],
            "content": "supplemental",
            "security": "validuser",
            "eprintid": 227,
            "language": "en",
            "formatdesc": "Using Excel to Prepare a \u201cRelated Items\u201d Report",
            "docid": 304,
            "rev_number": 5,
            "files": [
                {
                  "filename": "ELUNA_2009_A15a_Related_items_steps.pdf",
                  "mtime": "2016-05-27 21:03:46",
                  "objectid": 304,
                  "fileid": 4144,
                  "mime_type": "application/pdf",
                  "filesize": 224067,
                  "uri": "https://beta-documents.el-una.org/id/file/4144",
                  "datasetid": "document"
                }
            ],
            "mime_type": "application/pdf",
            "pos": 7,
            "format": "application/pdf",
            "uri": "https://beta-documents.el-una.org/id/document/304",
            "main": "ELUNA_2009_A15a_Related_items_steps.pdf"
          }
      ],
      "ispublished": "pub",
      "abstract": "Steve Thomas, Local Systems Development Coordinator, University of Tennessee.\r\n\r\nThis presentation will show how a few simple SQL scripts, when combined with the sort and compare features of Excel, may be used to prepare some powerful reports.  For example, in answer to a request for a report of duplicate holdings, the presenter was able to reduce the initial output file of over 69,000 book items into a report of less than 12,000 duplicate items by comparing call number and description data. ",
      "event_title": "ELUNA 2009",
      "refereed": "FALSE",
      "dir": "disk0/00/00/02/27",
      "event_location": "Richmond, Va.",
      "rev_number": 28,
      "date": "2009-05-08",
      "lastmod": "2016-05-27 21:03:46",
      "creators": [
        {
          "name": {
            "family": "Thomas",
            "lineage": null,
            "given": "Steve",
            "honourific": null
          }
        }
      ],
      "pres_type": "speech",
      "userid": 4,
      "uri": "https://beta-documents.el-una.org/id/eprint/227",
      "type": "conference_item"
    }