Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: insuractive
I think the real culprit here is Jakarta POI. I'm calling the Jakarta POI Java package from CF in order to process the excel file and convert the data into a CF query. My best guess is that the java object causes some sort of file locking which prevents me from renaming or moving the file using <cffile>. I've created a cleanup routine that I can run after my files have processed that allows me to go back in and rename the files at a later date.
I tried adding the <cfcontent> tag in various places like BKBK suggested, but I did not see a significant change in the results. I'm inclined to agree with Adam and it probably wouldn't have much effect in this particular case since I am not displaying the Excel file, but converting the data into a CF variable.
Thanks for everyone's help on this one. If I notice anything else with this implementation, I'll be sure to note it in this thread.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied