Forums / Developer / Where to create generated files

Where to create generated files

Author Message

Jorge estévez

Thursday 11 March 2010 3:15:14 am

Hello,

I have seveal cronjobs that generate excelfiles xxx.csv

I have no clues where to create those files (somewhere at the site with read access for customers) so that customers can donwload them.

I have tryed at "var" (with 755 permissions) but when trying to "get" the file from the site it gives me an error "you have not enough permissions to access bla bla bla"

Any ideas?

thanks

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

Christian Rößler

Thursday 11 March 2010 4:11:24 am

Hy,

i think the var-directory is a good place for those 'temporary' files.
The errormessage probably comes from your .htaccess file which restricts the access to files in the var-folder except for pdfs and images.
Perhaps you should post the complete errormessage, try copy'n'paste :-)

If the error is invoked by .htaccess restrictions, edit that file. You can find it in the ezpublish main directory.
Find the following lines and add your csv-files to it:

from:
<FilesMatch "(^index\.php|favicon\.ico|index_treemenu\.php|\.(gif|jpe?g?|png|css|js|swf|html?)|var(.+)storage.pdf(.+)\.pdf)$">
to:
<FilesMatch "(^index\.php|favicon\.ico|index_treemenu\.php|\.(gif|jpe?g?|png|css|js|swf|html?)|var(.+)storage.pdf(.+)\.pdf|var(.+)\.csv)$">

from:
RewriteRule !(\.(gif|jpe?g?|png|css|js|swf|html?)|var(.+)storage.pdf(.+)\.pdf)$ index.php
to:
RewriteRule !(\.(gif|jpe?g?|png|css|js|swf|html?)|var(.+)storage.pdf(.+)\.pdf|var(.+)\.csv)$ index.php

That should do the trick. But it is untested, please verify...
Chris

Hannover, Germany
eZ-Certified http://auth.ez.no/certification/verify/395613

eZ debug

Timing: Jan 19 2025 08:54:58
Script start
Timing: Jan 19 2025 08:54:58
Module start 'content'
Timing: Jan 19 2025 08:54:59
Module end 'content'
Timing: Jan 19 2025 08:54:59
Script end

Main resources:

Total runtime1.2017 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0068 588.9531180.8359
Module start 'content' 0.00681.0450 769.7891499.7500
Module end 'content' 1.05180.1498 1,269.5391333.4766
Script end 1.2016  1,603.0156 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.3377210.0002
Check MTime0.00160.1309210.0001
Mysql Total
Database connection0.00070.060310.0007
Mysqli_queries1.122093.36931910.0059
Looping result0.00200.16571890.0000
Template Total1.172497.620.5862
Template load0.00190.158320.0010
Template processing1.170597.403520.5852
Template load and register function0.00010.010810.0001
states
state_id_array0.00140.113010.0014
state_identifier_array0.00160.130020.0008
Override
Cache load0.00160.1316280.0001
Sytem overhead
Fetch class attribute can translate value0.00120.101530.0004
Fetch class attribute name0.00110.091520.0005
XML
Image XML parsing0.00060.046430.0002
class_abstraction
Instantiating content class attribute0.00000.000620.0000
General
dbfile0.01321.0989210.0006
String conversion0.00000.000530.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
7content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezxmltags/strong.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/strong.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 18
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs