Frequently Asked Questions (FAQs)
- End User FAQ - Attempts to address the most commonly asked questions regarding DSpace (from a user perspective)
- TechnicalFAQ - Attempts to address the most commonly asked technical or installation questions regarding DSpace
- Additional resources for common questions:
Repository Planning
- The following documents are useful in planning a repository. All are written by Mary R.Barton et al copyright 2004-2005 (RM).
- SUNScholar/Practical Guidelines for Starting an Institutional Repository. Produced by Stellenbosch University Library, this guide provides step-by-step information to help academic institutions in developing countries start an institutional repository.
- Lessons learned building an Institutional Repository with DSpace
Installing DSpace
Customizing DSpace
- Past Training Materials & Workshops:
- General Tips:
- How-To Guides has a list of all wiki pages which provide "how-to" hints for changing/customizing your DSpace install.
- Build Cookbook has examples of adding your local changes to a DSpace distribution.
- Additional training in spanish: Curso de capacitación en repositorios y DSpace by SeDiCi, Universidad de la Plata, Argentina
Developing with DSpace
Documentation for New DSpace Administrators
DSpace Oracle to PostgreSQL migration
The following procedure is only one example of migration done from Version 6.3 to Version 7.2.
It has been made using Ora2pg: https://ora2pg.darold.net/documentation.html
- Install PERL: http://strawberryperl.com/
- Download Ora2Pg: https://sourceforge.net/projects/ora2pg/
- Unzip and access the file from the command line
- Install Ora2Pg :
perl Makefile.PL
gmake && gmake install
- ora2pg files will be installed in Strawberry directory
- C:\Strawberry\perl\site\bin
- C:\ora2pg
Note : Do not use another path for Ora2Pg, otherwise configuration will not be made correctly in Strawberry Perl.
- Rename file « C:\ora2pg\ora2pg_conf.dist » en « ora2pg.conf »
- Modify variable ORACLE_HOME to point to Oracle client
- Modify string connexion to Oracle DB :
- User/Password
- ORACLE_DSN, ORACLE_USER, ORACLE_PWD
- TYPE = TABLE,SEQUENCE,INSERT
- UUID_FUNCTION = gen_random_uuid
- STOP_ON_ERROR = 0
- FKEY_DEFERRABLE = 1
- DEFER_FKEY = 1
- MODIFY_TYPE
bitstream:size_bytes:bigint,checksum_history:check_id:bigint,checksum_history:checksum_expected:varchar,checksum_history:checksum_calculated:varchar,checksum_history:result:varchar,checksum_results:result_code:varchar,checksum_results:result_description:varchar,harvested_collection:oai_source:varchar,harvested_collection:oai_set_id:varchar,harvested_collection:harvest_message:varchar,harvested_collection:metadata_config_id:varchar,harvested_collection:harvest_start_time:timestamp with time zone,harvested_collection:last_harvested:timestamp with time zone,harvested_item:last_harvested:timestamp with time zone,harvested_item:oai_id:varchar,item:last_modified:timestamp with time zone,metadatavalue:text_lang:varchar(24),most_recent_checksum:expected_checksum:varchar,most_recent_checksum:current_checksum:varchar,most_recent_checksum:checksum_algorithm:varchar,most_recent_checksum:result:varchar,resourcepolicy:start_date:date,resourcepolicy:end_date:date,webapp:url:varchar,webapp:isui:integer - REPLACE_AS_BOOLEAN NUMBER:1 CHAR:1
- DATA_TYPE NUMBER(*\,0):integer,VARCHAR2(2000):text
- SCHEMA DSPACE
Data migration procedure :
- Open command line and move to following directory:
C:\Strawberry\perl\site\bin. - Execute command line ora2pg to launch migration script from Oracle to SQL files for PostgresSQL objects creation.
- Create a database on PostgreSQL server
- Use extension « pgcrypto »