SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA SELECT Order_ID, Assmt_ID, Status, Form_Type, Insured_HIC, Date_Admit, Certification_From, Certification_To, Pt_Agy_ID, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, Pt_DOB, Pt_Gender, Medications, ICD10, Description, ICD_Date, DME, Safety, Diet, Allergies, Functional_Limitations, Functional_Limits_Extra, Activities_Permitted, Activities_Permitted_Extra, Mental_Status, Mental_Status_Extra, Prognosis, Careplan_SN, Careplan_PT, Careplan_OT, Careplan_ST, Careplan_MSW, Careplan_HHA, Careplan_other, Goals_SN, Goals_PT, Goals_OT, Goals_ST, Goals_MSW, Goals_HHA, Goals_other, Rehabilitation_Potential, Discharge_Plan, Clinician_Signature, Render_Phys_ID, Date_Sent, Date_Received, MD_Homebound, MD_Clinical_Condition, MD_Digital_Signature, Export, filename, Date_Create, Created_by, Date_Change, Change_by FROM #Request.prefix_db_agency#.pCMS4857 Where Export = 0 AND Status = 0 //Use an absolute path for the files. ---> // theDir=GetDirectoryFromPath(GetCurrentTemplatePath()); theDir = "/var/www/cron/UploadFiles/"; thefilename = #Request.prefix_db_agency#&".xls"; theFile= theDir & thefilename; //Create two empty ColdFusion spreadsheet objects. ---> theSheet = SpreadsheetNew("pCMS4857"); SpreadsheetAddRow(theSheet, " Order_ID, Assmt_ID, Status, Form_Type, Insured_HIC, Date_Admit, Certification_From, Certification_To, Pt_Agy_ID, Agy_CCN, Pt_First, Pt_Last, Pt_Street, Pt_City, Pt_State, Pt_Zip, Pt_Phone, Agy_Name, Agy_Street, Agy_City, Agy_State, Agy_Zip, Agy_Phone, Agy_NPI, Pt_DOB, Pt_Gender, Medications, ICD10, Description, ICD_Date, DME, Safety, Diet, Allergies, Functional_Limitations, Functional_Limits_Extra, Activities_Permitted, Activities_Permitted_Extra, Mental_Status, Mental_Status_Extra, Prognosis, Careplan_SN, Careplan_PT, Careplan_OT, Careplan_ST, Careplan_MSW, Careplan_HHA, Careplan_other, Goals_SN, Goals_PT, Goals_OT, Goals_ST, Goals_MSW, Goals_HHA, Goals_other, Rehabilitation_Potential, Discharge_Plan, Clinician_Signature, Render_Phys_ID, Date_Sent, Date_Received, MD_Homebound, MD_Clinical_Condition, MD_Digital_Signature, Export, filename, Date_Create, Created_by, Date_Change, Change_by"); SpreadsheetAddRows(theSheet,GetpCMS4857); FileSetAccessMode(#theFile#, "777");

Successful: #cfftp.succeeded#