[EP-tech] Re: Export Eprints in Excel format
Ian.Stuart at ed.ac.uk
Wed Apr 9 09:08:03 BST 2014
On 09/04/14 08:34, Dimitrakakis Georgios wrote:
> Dear all,
> is it possible to extract the EPrints in an Excel format where each
> field is on a different column?
> For example I would like something like the following:
> Title| Authors | Journal | Publisher | Year | Pages |
> where each one of the fields is on different column.
> I have tried to get it from the database using a custom script but
> unfortunately all information is not stored in one table (unless I
> have missed something).
> If someone could point me out where to get (on which tables) the
> afforementioned data I would be grateful!
What you need to do is write an exporter
In essence, what you do is write a variation on
~~~/perl_lib/EPrints/Plugin/Export/BibTeX.pm (or ~~~~/DC.pm, or Text.pm)
but creates a .csv file (or a tab-separated file)
Either build the lines up by hand, or use something like Text::CSV::Easy
(Sorry, there's no easy read-written solution for you)
Developer: ORI, RJ-Broker, and OpenDepot.org
Bibliographics and Multimedia Service Delivery team,
The University of Edinburgh.
This email was sent via the University of Edinburgh.
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
More information about the Eprints-tech