EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #02881

< 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

Have you installed the following pre-requisites:

- Spreadsheet::WriteExcel (export)
- Spreadsheet::ParseExcel (import)

?

Seb


On 13/04/14 08:47, Dimitrakakis Georgios wrote:

I did install it from the Bazaar and it is shown under installed with
options disable and uninstall, so I guess it is enabled as well!!

But I don't seem able to find how to use it!!

There is no option like these in the Export field!!

Could you help me with that??

Best,

G.


Il 09/04/2014 10:37, Dimitrakakis Georgios ha scritto:

Yuri thx for the very useful (from what it seems) links!

Do you know where I can find setup instructions for the Bazaar package?


eprints.org? the bazaar package works the same way it works on the first
link, just unpack it and install the perl module dependencies. I think
there's an utility in eprints to install them, or maybe a control panel?

Multiline also export the fields with multiple values (autors,
creators). It is really the best option.


G.



you can use this howto to build a custom plugin:

http://wiki.eprints.org/w/Contribute:_Plugins/ExportPluginsExcel

or this (can also import from excel)

http://bazaar.eprints.org/315/

Il 09/04/2014 09:34, Dimitrakakis Georgios ha scritto:

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!

Best,

G.

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

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

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

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

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

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