Re: [Dspace-tech] Batch import metadata help needed

2010-05-24 Thread Leonie Hayes
Hi Renata 

Normally batch metadata editing is used to modify existing records, for tidying 
up and enhancing data, however if you are using the Batch Metadata tool and 
want to add new items you do need to know a small trick!

The best way to get a skeleton csv is export a current item in your collection. 
Add new rows for each item.

In the place (first column) where you have an id number you substitute a + 
(plus) symbol and this will add a record.

Please get in touch off-line and we can send you some samples.


Leonie Hayes
Research Repositories Manager
http://www.library.auckland.ac.nz/contacts/?stid=124
http://researchspace.auckland.ac.nz  
 


--

Message: 2
Date: Tue, 25 May 2010 10:24:37 +1000
From: Renata Dyer 
Subject: [Dspace-tech] Batch import metadata help needed
To: dspace-tech@lists.sourceforge.net
Message-ID:



Content-Type: text/plain; charset="us-ascii"

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
Canberra, ACT 2604
ph: 02 6270 6916
-- next part --
An HTML attachment was scrubbed...

--

Message: 3
Date: Tue, 25 May 2010 11:36:04 +0800
From: Allen Lam 
Subject: Re: [Dspace-tech] Batch import metadata help needed
To: dspace-tech@lists.sourceforge.net
Message-ID: <4bfb45a4.2050...@gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

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


Re: [Dspace-tech] Batch import metadata help needed

2010-05-24 Thread Hayden Young
If the resulting XML is MARC XML you will still require a crosswalk 
plugin to convert the MARC to Dublin Core. More information about 
Crosswalk plugins is available at 
http://www.fedora-commons.org/confluence/display/DSPACE/CrosswalkPlugins.


Information about a marc to dc crosswalk is available at 
http://www.loc.gov/marc/marc2dc.html but I'm not sure if there is a 
plugin currently available (someone else on the list may have 
alternative information about that).


Cheers


Hayden

On 25/05/10 11:55, Renata Dyer wrote:
I forgot to mention that I have also created an xml file generated by 
the MARC to xml conversion done in MARCedit programme. I tried to 
import this too but the same error showed up.

I saved the file in My Documents folder - could that be the problem?

Renata



From: Allen Lam 
To: dspace-tech@lists.sourceforge.net
Date: 25/05/2010 01:39 PM
Subject: Re: [Dspace-tech] Batch import metadata help needed




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_ <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-t...@lists.sourceforge.net_ 
<mailto: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


--

   



___
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


Re: [Dspace-tech] Batch import metadata help needed

2010-05-24 Thread Hayden Young

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 
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


Re: [Dspace-tech] Batch import metadata help needed

2010-05-24 Thread Renata Dyer
I forgot to mention that I have also created an xml file generated by the 
MARC to xml conversion done in MARCedit programme. I tried to import this 
too but the same error showed up.
I saved the file in My Documents folder - could that be the problem?

Renata



From:   Allen Lam 
To: dspace-tech@lists.sourceforge.net
Date:   25/05/2010 01:39 PM
Subject:Re: [Dspace-tech] Batch import metadata help needed



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 
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

--

___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech


Re: [Dspace-tech] Batch import metadata help needed

2010-05-24 Thread Allen Lam

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 
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