i have searched archives , cannot find answer question. basically, doing ftp'ing several folders , files remote server. code have create root folder, , transfer 11 files in root create of folders under root. not happening files each folder not being transferred. in addition, 11 files in root folder resent each time folder being created. attaching code comments.
<!--- open ftp connection ---> <cfftp action = "open" connection = "myconnection" username = "#getsitelist.tms_username#" password = "#getsitelist.tms_password#" server = "#getsitelist.tms_ftpaddress#" secure = "no" stoponerror = "yes"> <!--- if ftp connection has been made ---> <cfif cfftp.succeeded eq "yes"> <!--- ftp folder contents ---> <cfset foldername = listlast(#request.fileurl#, "\\")> <cfset local_path = "#request.fileurl#"> <cfset remote_path = "#foldername##getsitelist.tms_directory#"> <!--- loop through number of folders ---> <cfloop index="i" from="1" to="#numberofpages#"> <cfscript> keywordstart=getpagebreaks.tmp_pagestart[i]; if (i eq numberofpages) { keywordend=getallkeywords.recordcount; } else { keywordend=getpagebreaks.tmp_pagestart[i+1]-1; } pagekeywordstart=trim(getallkeywords.tml_keyword[keywordstart]); pagekeywordrange=pagekeywordstart & " " & trim(getallkeywords.tml_keyword[keywordend]); keyfolder=makefoldertitle(pagekeywordstart); request.thisfolder=keyfolder; create_remote_folder=keyfolder; </cfscript> <!--- add slash end of local path if necessary ---> <cfif right(local_path, 1) neq "\"> <cfset local_path = local_path & "\"> </cfif> <!--- add slash end of remote path if necessary ---> <cfif right(remote_path, 1) neq "/"> <cfset remote_path = remote_path & "/"> </cfif> <!--- ensure root folder there. ---> <cfftp action="existsdir" connection="myconnection" directory="#remote_path#/#foldername#" stoponerror = "no"> <!--- if doesn't exist create ---> <cfif cfftp.succeeded neq "yes"> <!--- create directory ---> <cfftp action="createdir" connection="myconnection" directory="#foldername#" stoponerror = "no"> </cfif> <!--- local directory contents ---> <cfdirectory directory="#local_path#" name="local_dir_contents" action="list"> <!--- check if create_remote_folder exists ---> <cfftp action="existsdir" connection="myconnection" directory="#remote_path##create_remote_folder#" stoponerror = "yes"> <cfif cfftp.succeeded neq "yes"> <cfoutput> following error occured: #cfftp.errorcode# : #cfftp.errortext# </cfoutput> </cfif> <!--- if doesn't exist create ---> <cfif cfftp.succeeded neq "yes"> <!--- create directory ---> <cfftp action="createdir" connection="myconnection" directory="#remote_path##create_remote_folder#" stoponerror = "yes"> <cfif cfftp.succeeded neq "yes"> <cfoutput> following error occured: #cfftp.errorcode# : #cfftp.errortext# </cfoutput> </cfif> </cfif> <!--- loop through contents , put file on sftp server ---> <cfloop query="local_dir_contents" startrow="1" endrow="20"> <cfif local_dir_contents.type eq "file"> <!--- put file on server ---> <cfftp action="putfile" connection="myconnection" localfile="#local_path##local_dir_contents.name#" remotefile="#remote_path##local_dir_contents.name#" stoponerror="yes"> <cfif cfftp.succeeded neq "yes"> <cfoutput> following error occured: #cfftp.errorcode# : #cfftp.errortext# </cfoutput> </cfif> <cfelse> <!--- recursively call function new directory ---> <cfset foldername = listlast(#request.fileurl#, "\\")> <cfset local_path = "#request.fileurl#"> <cfset remote_path = "#foldername##getsitelist.tms_directory#"> <cfscript> keywordstart=getpagebreaks.tmp_pagestart[i]; if (i eq numberofpages) { keywordend=getallkeywords.recordcount; } else { keywordend=getpagebreaks.tmp_pagestart[i+1]-1; } pagekeywordstart=trim(getallkeywords.tml_keyword[keywordstart]); pagekeywordrange=pagekeywordstart & " " & trim(getallkeywords.tml_keyword[keywordend]); keyfolder=makefoldertitle(pagekeywordstart); request.thisfolder=keyfolder; create_remote_folder=keyfolder; </cfscript> <cfftp action="createdir" connection="myconnection" directory="#remote_path##create_remote_folder#" stoponerror = "yes"> <cfif cfftp.succeeded neq "yes"> <cfoutput> following error occured: #cfftp.errorcode# : #cfftp.errortext# </cfoutput> </cfif> </cfif> </cfloop> </cfloop> <cfftp action="close" connection="myconnection"> thanks,
bruce
Comments
Post a Comment