Hi Renata
I agree with Allen; you will be able to find some existing tools that
can be found in various locations on the web but you will need to mix it
with some custom development. We have carried out a few conversions and
have found that there is never an out-of-the-box solution due to the
idiosyncrasies of the source data.
We converted about 25,000 records for the Royal Naval Museum who had
data in CSV. The procedures we took;
- Converted the CSV to Excel XML,
- Developed a crosswalk for Excel XML to Dublin Core. The crosswalk
script built the Dublin Core metadata and assets into a package which
DSpace could easily ingest,
- Used the DSpace command line import tool to import the DC assets into
DSpace.
We open sourced the crosswalk scripts which you are welcome to use; it
is available at http://www.sourceforge.net/projects/dcmetatoolkit. The
scripts are rudimentary but they will hopefully assist you.
Cheers
Hayden
On 25/05/10 11:36, Allen Lam wrote:
Hi Renata,
It seems you are missing one important step before batch import: to
rewrite your csv file into xml files in dublin core format.
There are existing tools to generate the needed xml files from some
sources.
These tools sometimes are called converters, transformers, crosswalks,
or csv2dc, etc. Do some searching.
As the tools are pre-built, they may or may not fully meet your
requirement.
If in-house programmers are available writing a custom-made one is not
too difficult, and gives perfect results.
Also remember that the xml files and other associated files needs to
be put in suitable folders in a rigidly defined structure. Consult the
dspace manual about this requirement.
Regards,
Allen Lam.
HKU Hub Administrator, http://hub.hku.hk
On 2010-05-25 8:24 AM, Renata Dyer wrote:
Dear dspace-tech list;
I am new to the dspace world and need some basic help.
This is what I am trying to do:
I have exported over a 1000 records from the library management
system into a csv format and would like to batch import these records
(no attachments here) into the dspace.
I found some documents on the wiki but I seem to miss the initial
starting point.
I have created the collection and the fields that will match the
fields in my csv file.
Then after creating a collection I go to the Import metadata and
select the file to load it - but I got the error message:
*An unknown error has occurred*
I just have a feeling that I am missing the crucial step; do I need
to have a separate plug-in installed?
We are on Dspace 1.6.0.
Sorry for asking a stupid question but I thought this would be a very
time-consuming investigation for me while being an easy answer for an
expert.
If anyone has done something similar I would appreciate if you could
share your procedures.
Many thanks,
*Renata Dyer*
Manager, Systems and Electronic Services
High Court of Australia Library <http://www.hcourt.gov.au/library.html>
Canberra, ACT 2604
ph: 02 6270 6916
------------------------------------------------------------------------------
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
------------------------------------------------------------------------------
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
Hayden Young
Managing Director
Wijiti Pty Ltd
p. +61 (0) 8 6102 1198
m. +61 (0) 405 520 778
e. haydenyo...@wijiti.com
w. www.wijiti.com
vcard. www.wijiti.com/vcard/haydenyoung.vcf
NOTICE
This e-mail and any attachments are intended for the addressee(s) only and may
be confidential. They may contain legally privileged or copyright material. You
should not read, copy, use or disclose them without authorization. If you are
not the intended recipient please contact the sender as soon as possible by
return e-mail and then please delete both messages. This notice should not be
removed.
------------------------------------------------------------------------------
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech