Saving CF generated Excel file 2

[toyt78]

I have an Excel file that is generated from an Access 2000 database using Cold Fusion MX on a Windows 2000 server and it works great. I am now trying to copy this Excel file into another folder once a week where I will use the CFScheduler.

Both my copy attempts are not working and just show Cold Fusion code. The one where I tried ExcelCopy.xls shows an Excel spreadsheet with Cold Fusion variables and doesnt work.


If I try this it shows Cold Fusion variables.

<cflock name="myLock" type="EXCLUSIVE" timeout="30">
	<cffile action="COPY" source="C:\myserverDirectorypath\Excel.cfm" destination="C:\inforserverDirectoryPath\ExcelCopy.xls">
</cflock>

This didnt work either:

<cflock name="myLock" type="EXCLUSIVE" timeout="30">
	<cffile action="COPY" source="C:\myserverDirectorypath\Excel.cfm" destination="C:\inforserverDirectoryPath\ExcelCopy.cfm">

</cflock>

Please advise.

 

[NorthStarDA]

maybe im confused, but if you're doing a cffile copy from a .cfm page to a .xls page, it stands to reason you would see code in the .xls page- cffile is not going to parse the .cfm file first and then copy it's results- it's just going to simply copy the file.

it looks like Excel.cfm is used to generate ExcelCopy.xls which would make sense, you would need to run excel.cfm and copy it's output as an excel file to the other directory.


=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison

 

[TruthInSatire]

Northstar is right, you can't just copy a raw CFM file and change the file name and expect to see your dynamic data. The page must be "run" not just copied.

you may want to look into cfsavecontent.

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a29.htm#wp1844410

and cffile action = "write"

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p36.htm#wp1098764

the examples are kind of crappy

basic psudo code

<cfsavecontent variable = "myStuff">
  cf code to get your data out of the database
</cfsavecontent>
<cffile action = "write" file="C:\inforserverDirectoryPath\ExcelCopy.xls" output = "#myStuff#">

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[toyt78]

Thanks, it now works.

I also created a page with the <cfschedule> tag to download this file once a week at 09:40 AM. I assume I have this correct?

<CFSCHEDULE action="UPDATE" interval="weekly" task="mytaskname" operation="HTTPRequest" startdate="8/30/05" starttime="9:40 AM" url="[URL unfurl="true"]http://theserverhere/directory/theExcelPage.cfm">[/URL]

 

[NorthStarDA]

do you not have access to the cf admin? it's easier to schedule a task that way, i only would use cfschedule in cases where i needed to allow end-users to create a scheduled task. at any rate, if you created a page with cfschedule on it, as long as you are aware that you would only need to run that page once to create the task, you should be ok.


=========================================
I have not failed. I've just found 10,000 ways that won't work.
Thomas A. Edison