Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-08 Thread Timo Aalto
Hi, Did the re-export - review csv - re-import drill - the importer stated it found no changes. The only thing left to try at the moment without hacking the database directly (Thanks for the tip, Steve!) would be 1) export to csv 2) populate the unwanted fields with some mock data 3) re-import 4)

Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-07 Thread Stuart Lewis
Hi Timo, Thanks for the update - it will be interesting to hear how your re-import goes. Since there are no spaces in the CSV (these would, I think, although I've not had time to confirm it, be translated into empty strings once they get into the database), I'm not sure what could cause this.

Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-07 Thread Steve Swinsburg
We removed some empty metadata fields today. Whilst not a recommended approach, it's pretty easy. If you look at the logs, DSpace itself does the same thing. Assuming metadata_field_id is 12345: delete from metadatavalue where metadata_field_id='12345'; delete from metadatafieldregistry where me

Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-07 Thread Timo Aalto
Hi Stuart, 2011/2/4 Stuart Lewis > Hi Timo, > > > I did some metadata gardening using the CSV bulk editor and as I uploaded > my changes I noticed that the bulk metadata importer added an empty > dc.description.abstract (with a 'fi' language identifier that is the default > for our installation

Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-04 Thread Peter Dietz
Timo, To answer the question on how to delete the field you don't want. Your best bet is to use batch metadata editing. When you import a column (dc.language.iso), with no value, then it treats that as delete that value from the metadata record. Export the metadata of the affected collection, and

Re: [Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-04 Thread Stuart Lewis
Hi Timo, > I did some metadata gardening using the CSV bulk editor and as I uploaded my > changes I noticed that the bulk metadata importer added an empty > dc.description.abstract (with a 'fi' language identifier that is the default > for our installation nowadays) into just about every record

[Dspace-tech] Any way to purge empty metadata fields? (csv bulk editor woes)

2011-02-04 Thread Timo Aalto
Hi, I did some metadata gardening using the CSV bulk editor and as I uploaded my changes I noticed that the bulk metadata importer added an empty dc.description.abstract (with a 'fi' language identifier that is the default for our installation nowadays) into just about every record I had in that cs