|
Author
|
Message
|
|
Anthony M.
|
Wednesday 24 September 2008 3:10:35 am
Hello, i have listed some datas in the backoffice, and i want to make an export csv ou xls of these datas... i have created a new template with this code :
<html>
<head>
<meta http-equiv="Content-Type" content="application/vnd.ms-excel">
</head>
</html>
{def $pages = fetch( 'content', 'tree', hash( 'parent_node_id', '147', 'sort_by', array( 'modified', false() ) ) )}
{foreach $pages as $item}
{$item.name};{$item.object.modified|l10n( shortdatetime )}\n
{/foreach}
but it doesn't work...
is it possible to make this ? can i modify the header in a template ? thanks a lot for your help
Anthony
|
|
Jorge estévez
|
Wednesday 24 September 2008 4:29:13 am
Hi! I recommend you stick to something similar to the pagelayout used for the printed version of the page that comes with ez "print_pagelayout.tpl". I am working in a similar problem exporting (saving somehow) the content of the information of the basket to an excel format, the only problem is that I have to have images, but images are not constrain into a cell (everybody seems to say the same), so it's getting a little difficult to solve this issue.
Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com
|
|
Anthony M.
|
Wednesday 24 September 2008 5:14:18 am
i call my page like this : "http://mysite.com/site_admin/layout/set/excel/" and the page is "excel_pagelayout.tpl"
but the problem is the header...
in php i can specify the header like this :
<meta http-equiv="Content-Type" content="application/vnd.ms-excel">
but in the template, i can't do that...
Anthony
|
|
Nicolas Lescure
|
Wednesday 24 September 2008 12:42:23 pm
Hi, I can see this in the layout.ini :
# Consists of groups which are the layout name
# A layout group can have the followin variables
# - PageLayout - Uses a different pagelayout for this page
# - ContentType - Sets 'Content-Type' for layout module output
# example: ContentType=text/xml
So, you shoud try this :
[excel]
PageLayout=excel_pagelayout.tpl
ContentType=application/vnd.ms-excel
|
|
Anthony M.
|
Thursday 25 September 2008 12:36:13 am
thank you very much, it works fine !! ;-)
Anthony
|
|
Jorge estévez
|
Wednesday 01 October 2008 6:15:50 am
Glad you solved your problem, You can find mime (Multipurpose Internet Mail Extensions) types here: http://www.w3schools.com/media/media_mimeref.asp Check it out...
Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com
|
|
SEBBANE Alexandre
|
Tuesday 09 December 2008 10:25:51 am
hello , i didnot succeed : my template is ok :
<html>
<body>
<table>
<tr>
<td>Nom-Prénom</td>
<td>Entité</td>
<td>Téléphone</td>
<td>E-mail</td>
</tr>
<tr>
<td>Name1</td>
<td>entity</td>
<td>phone1</td>
<td>mail1</td>
</tr> <tr>
<td>Name11</td>
<td>entity1</td>
<td>phone11</td>
<td>mail11</td>
</tr>
</table>
</body>
</html>
my lyout is just :
{$module_result.content}
<!--<!--DEBUG_REPORT-->-->
my layout.ini is
[xls]
ContentType=application/vnd.ms-excel
PageLayout=xls_pagelayout.tpl
please help me i didn't see what it is wrong thanks
Paris, France
|
|
Nicolas Lescure
|
Tuesday 09 December 2008 11:26:23 am
Did you try this ?
<meta http-equiv="Content-Type" content="application/vnd.ms-excel">
Which url do you use to call your page ?
|
|
Piotrek Karaś
|
Tuesday 09 December 2008 2:12:36 pm
I don't know what 'ou' means, but I've successfully used this library:
http://www.phpexcel.net (PHPExcel)
This is much better than just trying to force headers...
Good luck,
Piotrek
--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu
|
