EPrints Technical Mailing List Archive

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

Message: #02885


< 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


Hey,

The export plug-in is defined as follow (bazaar.eprints.org/314/...):

	$self->{name} = "Multiline Excel";
	$self->{accept} = [ 'list/eprint' ];
	$self->{visible} = "staff";
	$self->{suffix} = ".xls";
	$self->{mimetype} = 'application/vnd.ms-excel';



So it should at least appear on a staff eprint search (Admin > Search items) ?

I forgot to say but you need to reload Apache after installing the pre-requisites.

Seb.


On 14/04/14 13:09, Dimitrakakis Georgios wrote:
Hi Sebastien!
Thanks for the very useful addon!

I have installed the pre-requisites but I don't see it anywhere....Was  
it supposed to appear at the export list by default??

Is there something else I should do? Do I have to enable it through  
the plugins.pl file as Yuri have suggested and how? Where to check for  
an error?? Apache error log doesn't show anything at all regarding this!

Best,


G.

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