I have a client who uploads an excel spreadsheet daily (FTP), which is her datasource to her CFMX website.
Unfortunately, the file gets uploaded then locks up so that she cannot upload the next day, nor can the file be deleted w/o contacting technical support to delete (Windows servers). I suspect the client is attempting to upload while she has the spreadsheet OPEN, which is turns hozes up the files permissions and locks. Is there a way to 1) Check to see if the file is open or in use or 2) require the file to be closed before she uploads. Can this be done in CF? Suggestions, comments, ideas... All are most welcome. I am considering either writing a script that performs the uploads for her or writing a script that will suck her excel spreadsheet into a MySQL database (ugh). If we can keep it simple though, and just get a good, consistent upload of the xls file, that would be ideal. Tx, DG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
