Re: Wildcard characters in filepath?
Is there some way I can use cfhttp to access the files listed on the web page and download them? No, in order to use CFFTP, you need some FTP account on the aimed server. I click on the link and it takes me to a page in the browser that lists the files I need. Ok, then you do have the name of the files, and you can get them by HTTP, not FTP. Then you can extract the file names from the page, and get them using CFHTTP. Of course, extracting the file names from the page can be done for free if you a fluent in regExp, (this is to save Bobby some comments;-) You can also get them more easily if RegExp is not your cup of tea using CF_REextract, see http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| 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:311850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
Thanks for the tips, Claude! -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, August 31, 2008 9:42 AM To: CF-Talk Subject: Re: Wildcard characters in filepath? Is there some way I can use cfhttp to access the files listed on the web page and download them? No, in order to use CFFTP, you need some FTP account on the aimed server. I click on the link and it takes me to a page in the browser that lists the files I need. Ok, then you do have the name of the files, and you can get them by HTTP, not FTP. Then you can extract the file names from the page, and get them using CFHTTP. Of course, extracting the file names from the page can be done for free if you a fluent in regExp, (this is to save Bobby some comments;-) You can also get them more easily if RegExp is not your cup of tea using CF_REextract, see http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm ~| 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:311856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
Have you tried: /2008_0830_??/ ? That's how you would do it at the command line in windows anyway. Dave -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 10:56 AM To: CF-Talk Subject: Wildcard characters in filepath? How can I use wildcard characters in a file path? Is it possible? I have a data vendor that makes data available for download using file paths that use as part of the path, .../2008_0830_103028/ In other words the paths are auto-generated and include the year, date, hour/minute/second, in the file path. I want to just specify the year and date in the path and use .../2008_0830_xx/... so I can automate the data processing. I could use contains, I guess, but I'd rather specify the path using variable characters. How can I do this? Rick ~| 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:311837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard characters in filepath?
How can I use wildcard characters in a file path? In a file path for what ? If it is for an HTTP request, the answer is no. If it is for CFFILE, it is still no. Using wild cards could mean that several files could be returned, and both HTTP and CFFILE can deal with only one file at a time. However, you could use CFDIRECTORY action=list with a filter to get the name of the file. ~| 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:311838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
The question would really just apply to files. I would be automating a daily download from a specific directory to which I have access. The files would follow this format: II20080830_033219_ACR.log Everything but the hour/minute/second part is consistent each day: II20080830_xx_ACR.log The x's are where I need variable characters since that's the exact hour/minute/second the file is created. But thinking about your comments about using cfdirectory, would I be able to access the directory the files are in each day, get a list, and download them via ftp each day? Can cfdirectory read a remote directory and provide a list of files? I glanced around the docs and google but didn't see an answer, so thought it'd just be quicker to ask than research all day. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 1:08 PM To: CF-Talk Subject: Re: Wildcard characters in filepath? How can I use wildcard characters in a file path? In a file path for what ? If it is for an HTTP request, the answer is no. If it is for CFFILE, it is still no. Using wild cards could mean that several files could be returned, and both HTTP and CFFILE can deal with only one file at a time. However, you could use CFDIRECTORY action=list with a filter to get the name of the file. ~| 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:311839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
The files would follow this format: II20080830_033219_ACR.log If you're downloading via FTP then you can get a list of the remote files, then loop through the resulting query object to look for the files you want. From the filenames it looks like you're downloading images from MLXchange. I'm in the midst of updating all our MLS code here as well so I can feel your pain. -Justin Scott ~| 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:311840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
I think, at least as far as remote access to ftp sites are concerned (which is part of my issue), I see in the docs that I can use listdir in cfftp to get the files in a directory, so that solves the download side. And I read in this blog: http://www.bennadel.com/index.cfm?dax=blog:1221.view can a pipe can be used to provide multiple filters to do this: cfdirectory action=list directory=#ExpandPath( './' )# listinfo=name filter=anna.*|ben.* name=qFile / And a ? can be used to designate single-characters wild cards. Thoughts on this? Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 1:54 PM To: CF-Talk Subject: RE: Wildcard characters in filepath? The question would really just apply to files. I would be automating a daily download from a specific directory to which I have access. The files would follow this format: II20080830_033219_ACR.log Everything but the hour/minute/second part is consistent each day: II20080830_xx_ACR.log The x's are where I need variable characters since that's the exact hour/minute/second the file is created. But thinking about your comments about using cfdirectory, would I be able to access the directory the files are in each day, get a list, and download them via ftp each day? Can cfdirectory read a remote directory and provide a list of files? I glanced around the docs and google but didn't see an answer, so thought it'd just be quicker to ask than research all day. Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 1:08 PM To: CF-Talk Subject: Re: Wildcard characters in filepath? How can I use wildcard characters in a file path? In a file path for what ? If it is for an HTTP request, the answer is no. If it is for CFFILE, it is still no. Using wild cards could mean that several files could be returned, and both HTTP and CFFILE can deal with only one file at a time. However, you could use CFDIRECTORY action=list with a filter to get the name of the file. ~| 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:311841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Wildcard characters in filepath?
That's exactly what I'm doing, Justin. And I'm trying to integrate data from two different data providers with very different db schemas and will probably have to add a third provider who yet another different db schema to the mix. Trying to get all this data in every day, parse it, then get it into my local database, then uploaded to my production server is a big pain. I'm able to almost completely automate the process with one vendor, but the other one is the one that's causing all the problems and has me searching for wildcard methods, etc. You're right about the cfftp function. I do use that with one and I'm trying to get the other one to give me direct access via ftp instead of having to click links on their site to get to the data folders. If I can get direct access via ftp I can use the listdir feature of cfftp to create that list of filenames and bypass having to use wildcards at all. Thanks for the tip! Rick -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 2:04 PM To: CF-Talk Subject: RE: Wildcard characters in filepath? The files would follow this format: II20080830_033219_ACR.log If you're downloading via FTP then you can get a list of the remote files, then loop through the resulting query object to look for the files you want. From the filenames it looks like you're downloading images from MLXchange. I'm in the midst of updating all our MLS code here as well so I can feel your pain. -Justin Scott ~| 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:311842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wildcard characters in filepath?
The question would really just apply to files. Well, it DOES depend on how you want and can finally get the file. Is the file on YOUR server, or somewhere else. Is the file accessible through HTTP, FTP ? If the file is not on your server, surely you cannot use CFdirectory. If you only have HTTP access, you can only get all files names, no filter, provided the server allows directory browsing. If you have an FTP access, then you can get the list of all files, no filter either. When you have all files names, you can loop on them and find the one that meets your criterion using so regExp. ~| 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:311843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wildcard characters in filepath?
using so regExp. I mean *some* regExp. ~| 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:311844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Wildcard characters in filepath?
Gotcha... I wonder if cfhttp can help with this situation. I've never used cfhttp for anything and only know what I just read in the docs, but I'm still not clear on what I can do with it. The way one of my data vendors works is like this: They send me an email every morning with a link to my directory of files for the day. I click on the link and it takes me to a page in the browser that lists the files I need. I've started using FF 3 to download the files because Windows Explorer's ftp capability just wasn't able to get the job done. I've tried getting into the site via ftp, but can't. Is there some way I can use cfhttp to access the files listed on the web page and download them? -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, August 30, 2008 3:56 PM To: CF-Talk Subject: Re: Wildcard characters in filepath? using so regExp. I mean *some* regExp. ~| 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:311845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4