Prev: CFPRINT Dropping Images
Next: CFImage Fonts
From: CFmonger on 13 Jun 2008 17:10
Hello;
I am trying to set up a cfschedule for part of my app. It has a number of
different function, so I am trying to build them one at a time.

The first part I am trying to do it to get an export to excel to function
automatically on a weekly basis, I have been writting the code, and setting it
for like 5 min after I post it to see if it works, and it isn't posting a file
to the directory I am specifying.

This is my code:

<cfschedule action = "run"
task = "spreadsheet"
startDate = "6/13/08"
startTime = "4:15 PM"
interval = "weekly"
resolveURL = "no"
publish = "Yes"
file = "report.xls"
path = "c:\websites\4npp8b\admin\trac\excel"
requestTimeOut = "600">

<cfsetting enablecfoutputonly="yes">

<cfquery NAME="tracking" datasource="#APPLICATION.dataSource#">
SELECT ID, REMOTE_ADDR, HTTP_USER_AGENT, TRACK_DATE, PATH_INFO
FROM tracking
ORDER BY ID
</cfquery>

<cfset tabChar = chr(9)>
<cfset newLine = chr(13) & chr(10)>

<cfcontent TYPE="application/msexcel"
file="c:\websites\4npp8b\admin\trac\excel">
<cfheader name="content-disposition" value="attachment;filename=report.xls">

<cfoutput>REMOTE ADDRESS#tabChar#Browser#tabChar#Date#tabChar#Entry
Page#newLine#</cfoutput>

<cfloop query="tracking">

<cfoutput>#REMOTE_ADDR##tabChar##HTTP_USER_AGENT##tabChar##TRACK_DATE##tabChar##
PATH_INFO##newLine#</cfoutput>
</cfloop>
</cfschedule>

I know the excel code works, I tried it off a link before I tried to automate
it, then added the file feature to the cfcontent tag.

I believe this is the way it is supposed to be done, I have been reading it
from cfdocs. What am I doing wrong? Any idea? Can anyone help me fix this?

Thank you


 | 
Pages: 1
Prev: CFPRINT Dropping Images
Next: CFImage Fonts