RE: How to access files on an ftp url that doesn't allow direct ftp access?
What I have to do is click on a link in my email, which takes to to an web page that uses an ftp url (ftp://datalink.interealty.com/) MLXchange certainly allow direct access to their FTP server. I wrote a routine that downloads IDX feeds daily and it's fully automated. I can't send you the full code (you know, the whole copyright and work for hire stuff) since it's owned by the client, but here are the pertinent parts (not optimized since this is just a small chunk of a vast empire of code; watch for line breaks)... cfscript // Set our variables. variables.ftp_server = datalink.interealty.com; variables.ftp_username = anonymous; variables.ftp_password = [EMAIL PROTECTED]; variables.ftp_folder = /DataLinkOutput/yourPathHere/; /cfscript !--- Get a file list from the server. --- cfftp action=open connection=datalink server=#variables.ftp_server# username=#variables.ftp_username# password=#variables.ftp_password# stoponerror=yes cfftp action=listdir connection=datalink name=remoteFiles directory=#variables.ftp_folder# stoponerror=yes cfftp action=close connection=datalink At this point you'll have a remoteFiles query which you can loop through to either download the individual files with CFFTP, or, in our case, generate an FTP script and pass it to a command-line FTP utility to handle the actual file transfers (I found that to be more stable over time with the larger files). Once downloaded, unzip, import and enjoy. For anyone else interested in the trials and tribulations of the MLS system we are talking about, I wrote a short novel about it in my blog. -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to access files on an ftp url that doesn't allow direct ftp access?
Thanks for the info, Justin! I'll work on that and try to make it work. Hopefully this will work...I hate to think that I might have to download the data manually every day! Rick -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 9:49 PM To: CF-Talk Subject: RE: How to access files on an ftp url that doesn't allow direct ftp access? What I have to do is click on a link in my email, which takes to to an web page that uses an ftp url (ftp://datalink.interealty.com/) MLXchange certainly allow direct access to their FTP server. I wrote a routine that downloads IDX feeds daily and it's fully automated. I can't send you the full code (you know, the whole copyright and work for hire stuff) since it's owned by the client, but here are the pertinent parts (not optimized since this is just a small chunk of a vast empire of code; watch for line breaks)... cfscript // Set our variables. variables.ftp_server = datalink.interealty.com; variables.ftp_username = anonymous; variables.ftp_password = [EMAIL PROTECTED]; variables.ftp_folder = /DataLinkOutput/yourPathHere/; /cfscript !--- Get a file list from the server. --- cfftp action=open connection=datalink server=#variables.ftp_server# username=#variables.ftp_username# password=#variables.ftp_password# stoponerror=yes cfftp action=listdir connection=datalink name=remoteFiles directory=#variables.ftp_folder# stoponerror=yes cfftp action=close connection=datalink At this point you'll have a remoteFiles query which you can loop through to either download the individual files with CFFTP, or, in our case, generate an FTP script and pass it to a command-line FTP utility to handle the actual file transfers (I found that to be more stable over time with the larger files). Once downloaded, unzip, import and enjoy. For anyone else interested in the trials and tribulations of the MLS system we are talking about, I wrote a short novel about it in my blog. -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312057 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to access files on an ftp url that doesn't allow direct ftp access?
I'm in! Thanks, Justin! I even managed to get in with FileZilla. I can't believe those guys were telling me a direct FTP connection wasn't possible. (It's not the first time I've gotten wrong info from them, however) Tomorrow's gonna' be a brighter day now! :o) Thanks, again! Rick -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 9:49 PM To: CF-Talk Subject: RE: How to access files on an ftp url that doesn't allow direct ftp access? What I have to do is click on a link in my email, which takes to to an web page that uses an ftp url (ftp://datalink.interealty.com/) MLXchange certainly allow direct access to their FTP server. I wrote a routine that downloads IDX feeds daily and it's fully automated. I can't send you the full code (you know, the whole copyright and work for hire stuff) since it's owned by the client, but here are the pertinent parts (not optimized since this is just a small chunk of a vast empire of code; watch for line breaks)... cfscript // Set our variables. variables.ftp_server = datalink.interealty.com; variables.ftp_username = anonymous; variables.ftp_password = [EMAIL PROTECTED]; variables.ftp_folder = /DataLinkOutput/yourPathHere/; /cfscript !--- Get a file list from the server. --- cfftp action=open connection=datalink server=#variables.ftp_server# username=#variables.ftp_username# password=#variables.ftp_password# stoponerror=yes cfftp action=listdir connection=datalink name=remoteFiles directory=#variables.ftp_folder# stoponerror=yes cfftp action=close connection=datalink At this point you'll have a remoteFiles query which you can loop through to either download the individual files with CFFTP, or, in our case, generate an FTP script and pass it to a command-line FTP utility to handle the actual file transfers (I found that to be more stable over time with the larger files). Once downloaded, unzip, import and enjoy. For anyone else interested in the trials and tribulations of the MLS system we are talking about, I wrote a short novel about it in my blog. -- Justin Scott, http://www.tlson.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312060 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
