EPrints Technical Mailing List Archive

Message: #02861

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Export Eprints in Excel format

At least for me it would be easier to wright a PHP script that gets the data from the database (this is what I have started.) but I need to know on which tables to find the necessary information. Is there a database diagramm somewhere? 

Best,

G.


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)

--

Ian Stuart.
Developer: ORI, RJ-Broker, and OpenDepot.org
Bibliographics and Multimedia Service Delivery team,
EDINA,
The University of Edinburgh.

http://edina.ac.uk/

This email was sent via the University of Edinburgh.

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: http://www.eprints.org/tech.php/
*** EPrints community wiki: http://wiki.eprints.org/
*** EPrints developers Forum: http://forum.eprints.org/



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.