Docstoc

Spreadsheet Xml Editor

Document Sample
Spreadsheet Xml Editor Powered By Docstoc
					         Conzul Repositories Forum
                3rd July 2006
           Auckland New Zealand



Bulk Loading into Digital Commons
“Using an XML file to Batch Upload”

             Leonie Hayes
        Digital Access Librarian
        University of Auckland
               Conzul Repositories Forum
                      3rd July 2006
                 Auckland New Zealand

                  Overview
•   Options for populating the repository.
•   What software and skills are needed
•   Sample XML file
•   Digital Commons Admin screens
•   Tips and Hints
•   Questions
           Conzul Repositories Forum
                  3rd July 2006
             Auckland New Zealand

            First challenge
•   How to populate a repository
•   Getting content in quickly
•   Showcase sample collections
•   Gather momentum
•   Provide examples for would-be
    contributors.
           Conzul Repositories Forum
                  3rd July 2006
             Auckland New Zealand

           Software needed
•   Data Massage – whatever you
    have. Spreadsheet, Database.
•   XML document editor – used
    XML Spy and Oxygen
•   Import into XML editor
•   Use Find and Replace or
    manually edit the file.
           Conzul Repositories Forum
                  3rd July 2006
             Auckland New Zealand

           Digital Commons
•   ResearchSpace@Auckland
•   One of our 2 pilots
•   Collections already in digital
    format
•   Sample template from Proquest
•   Using batch upload
           Conzul Repositories Forum
                  3rd July 2006
             Auckland New Zealand

          Software Needed
•   Data Massage – whatever you
    have. Spreadsheet, Database.
•   XML document editor – used
    XML Spy and Oxygen
•   Import into XML editor
•   Use Find and Replace or
    manually edit the file.
            Conzul Repositories Forum
                   3rd July 2006
              Auckland New Zealand
               Skills Needed
•   Data Manipulation – savvy with
    importing and editing data.
•   Common Office or Open Office
    applications.
•   XML document editor – easy to
    learn. Do not need to understand
    XSL or Schema structures.
•   Output a single xml file: wp2005.xml
             Conzul Repositories Forum
                    3rd July 2006
               Auckland New Zealand

         Document Template
http://www.bepress.com/import-example.xml
• Set up the community and
  collection series first
• You must have the full text
  available as URL’s to upload
• Have a numbering sequence in
  place
<?xml version="1.0" encoding="UTF-8"?>
<documents xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.bepress.com/document-
import.xsd">
   <document>
    <title>Indian Patent Policy and Public Health:Implications from </title>
    <publication-date>2006-04-01</publication-date>
  <authors>
          <author xsi:type="individual">
            <email>r.aoki@auckland.ac.nz</email>
            <institution>University of Auckland</institution>
            <lname>Aoki</lname>
            <fname>Reiko </fname>
          </author>
</authors>
    <subject-areas>
          <subject-area>Economics</subject-area>
    </subject-areas>
    <keywords>
     <keyword>pharmaceutical</keyword>
    </keywords>
    <abstract><p>The introduction of pharmaceutical product patents in
India and other…………
Conzul Repositories Forum
       3rd July 2006
  Auckland New Zealand
Conzul Repositories Forum
       3rd July 2006
  Auckland New Zealand
Conzul Repositories Forum
       3rd July 2006
  Auckland New Zealand
                  Conzul Repositories Forum
                         3rd July 2006
                    Auckland New Zealand

                   Tips - Hints
•   Source existing digital collections
•   Ask for a sample load into the Digital
    Commons test site
•   Watch for encoding problems
•   Break it into chunks and load one year
•   Make sure you notify the harvesters
    your repository URL
• http://researchspace.auckland.ac.nz/cgi/oai2.cgi
        Conzul Repositories Forum
               3rd July 2006
          Auckland New Zealand

            Discussion
Some suggested topics
• Who is using Digital Commons
  Software
• What to expect from support
• Using the forums
• Types of suitable content
          Conzul Repositories Forum
                 3rd July 2006
            Auckland New Zealand

              Resources
• Location of slides
http://www.unirepositories.auckland.a
  c.nz/docs/xmlimport.pdf
• Digital Commons Forum
http://dcforum.proquest.com/eve
• Support email address
Digital.Commons@il.proquest.com

				
DOCUMENT INFO
Description: Spreadsheet Xml Editor document sample