Alo ExportXls: plugin per Wordpress per generare file XLS dal db
Pubblicato mercoledì 28 ottobre 2009 in WordpressPubblico un plugin per Wordpress che serve per generare file XLS (MS Excel / OpenOffice Calc) a partire dal database del blog.
Per maggiori informazioni vi rimando alla pagina sul sito Worpress.org.
Attenzione! A causa di altri impegni non ci sarà ulteriore sviluppo del plugin.
Caratteristiche
- può scegliere quale tabella esportare (articoli, utenti, link, commenti)
- nel caso di articoli e utenti può esportare anche i relativi meta
Screenshot
» Schermata dell’amministrazione di ExportXls
Download
» Scarica Alo ExportXls (dal sito Wordpress.org)
This plugin for Wordpress lets you to generate XLS files (MS Excel / OpenOffice Calc) from WP database’s tables. For more info please visit its page on Wordpress.org.
Warning! Due to more relevant commitments this plugin will not be further developed.
Features
- you can select the table to export (users, posts, comments, links)
- ‘posts’ and ‘users’ choises can include meta data too
Screenshot
» View of ExportXls’s administration
Download
» Download Alo ExportXls (from Wordpress.org)
invio in corso...
Any way your plugin could support unique fields added by “Cimy User Extra Fields”? This could allow users to register a mailing address and the users to be exported for mailmerge. OR content could be exported for an opt in email list with a check box designating the opt in.
Thanks
Do you talk about sending emails using easymail, isn’it? Now, you don’t need to export addresses with exportxls and then import in easymail. In easymail panel you can select “All registered users” to send mail to your blog users: easymail sends to addresses registered by users at signup.
Hey – great plugin – just what I needed!
Except – I get an error when trying to open the xls export of comments… anyone else got that?
I get an error when trying to open export files using excel 2007. any ideas?
Hi nommo, I have no idea about the comments’ exportation error, on my WPs it seems working, I’ll do tests.
Hi luncan, maybe are you using WP on a windows server/system? This first release is designed for *nix system and that could be the reason of your problem. If your WP is on a windows server/system, you have to modify the path of the exportation file. Open the file ‘alo-exportxls_action.php’ and modify the line 65 with a windows path: instead of “xlsfile://tmp/wp_export.xls” try something like “xlsfile://C:/wp_export.xls” or “xlsfile://C:/temp/wp_export.xls” (see your file system if on local installation, or see/ask you hosting provider if on line). In the next release I’ll add an option to customise this path.
Hi Alo,
All the other exports are fine – just the comments I have trouble with.
It exports “wp_export.xls” saves to my PC, it seems to have data in it (305k) but when I try to open in Excel 2002 SP3 – it gives an error “Unable to read file”.
Let me know if you need any help?
Cheers
I’ve released a new version, 0.1.1. Simply added the option page to setup the exportation’s target directory. I hope it can help.
Hi Alo,
Thanks for the nice plugin.
I have a problem with the export of posts.
everything else works.
I have over 20000 posts and the export does nothing.
If I hit send then it loads a white page.
is a memory problem?
you have a solution?
Many thanks for your time
Many greetings
tommy
Hey Alo
I tested everything again. it is a memory problem.
would help you to download a selection by category.
how do you find it?
kind regards
tommy
Hi Tommy, at the moment you might try to increase memory limit and max execution time (in apache httpd.conf, or in WP wp-config.php with WP_MEMORY_LIMIT and php ini_set(‘memory_limit’) ini_set(‘max_execution_time’)).
Then, in future I’ll add a selection by category.
Many thanks for the test and for the suggestion.
Alo
Ciao, come posso esportare un’altra tabella qualsiasi?
Ciao Mario, attualmente con il plugin è possibile esportare solo quelle tabelle indicate. Per altre esportazioni puoi usare PhpMyAdmin che di solito è installato sul server del sito e accessibile dal pannello di controllo fornito dal provider. Altrimenti puoi usare plugin come ‘WP-phpMyAdmin’ o ‘Portable phpMyAdmin’ che ti permettono di usare PhpMyAdmin direttamante nell’amministrazione di WP.
Ciao,
ho installato il plugin e settato la dir per l’esportazione, compresi i permessi di lettura/scrittura.
Continua però a permanere l’errore “Error during process. Have you setted up the file exportation path? Go to Settings > Alo Export Xls.”
Cosa può essere?
Ciao, il problema più comune è il percorso errato. Se il percorso che hai inserito è corretto allora non saprei cosa suggerirti…
Hello i have this error… can you help me please
Warning: fopen(xlsfile://var/www/vhosts/tmp/wp_export.xls) [function.fopen]: failed to open stream: "xlsstream::stream_open" call failed in /homepages/29/d323086019/htdocs/wp-content/plugins/alo-exportxls/alo-exportxls_action.php on line 66Warning: Cannot modify header information - headers already sent by (output started at /homepages/29/d323086019/htdocs/wp-content/plugins/alo-exportxls/alo-exportxls_action.php:66) in /homepages/29/d323086019/htdocs/wp-includes/pluggable.php on line 868
Thank You
Can you help me with this plugin in WP 2.9.2??
I do need this plug in…
I can pay for your help
Hi Berlin, I tested this plugin on WP 2.9.2, and it worked. I’ll make more tests in next days. In the meantime, you can try deactivating all other plugins. And make a double check the exportation path, of course.