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

[giorgis at lib.uoc.gr (Dimitrakakis Georgios)]

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.