Re: (ot) SQL bulk inserts, ftps, and unicode special characters
On 4/13/2013 1:55 AM, Rick Root wrote: > It occurs to me that even If I put the data in correctly, I still have to > "deal" with it because I can't really output a utf-16 character to a web > page (or can I?).. I dunno maybe it just works. no, it will show up fine (your db driver & cf will see to that). internally sql server stores the data as UCS2, that's going to get transformed to UTF-8 (or whatever you request). just make sure the columns holding the unicode text data are "N" dataype (nvarchar, etc.) & you should be good to go. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
Thanks Paul. It occurs to me that even If I put the data in correctly, I still have to "deal" with it because I can't really output a utf-16 character to a web page (or can I?).. I dunno maybe it just works. time to play... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355395 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
On 4/11/2013 11:53 PM, Rick Root wrote: > No, it doesn't. Not really. > > http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx actually that page and a decade of my experience says it does. UTF-8 will get transformed (its designed for that) to UCS2 by the db driver. for all practical purposes, sql server does "support" utf-8 encoded text. BULK INSERT is another matter. UTF-8 was dropped from that particular tool for some reason or another (digging around it looks like maybe a bug that was supposed to be fixed in 2 months, 5 years ago). ms uses the term "Unicode Character Format" for what BULK INSERT supports but they're the only one that does. not exactly sure what's meant by it but reading thru this page: http://msdn.microsoft.com/en-us/library/ms188289.aspx the BOM mentioned there seems to indicate its UTF-16. so i think you're on the right track w/trying to get UTF-16 out of your source & using the wide char option. because its ms, i'd try to get little endian UTF-16 to be on the safe side. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
I'm gonna try to get the SAP people to send me a UTF-16 file instead (essentially the same as the link except I wouldn't have to convert it :) ) On Thu, Apr 11, 2013 at 1:03 PM, Russ Michaels wrote: > > you could try this work around. > > > http://stackoverflow.com/questions/5498033/how-to-write-utf-8-characters-using-bulk-insert-in-sql-server > > > On Thu, Apr 11, 2013 at 5:53 PM, Rick Root wrote: > > > > > On Tue, Mar 26, 2013 at 11:10 PM, Paul Hastings > >wrote: > > > > > > > > > SQL Server 2005 does not support UTF-8 apparently. > > > > > > sure it does. > > > > > > > No, it doesn't. Not really. > > > > http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx > > > > I'm loading this data from UTF-8 encoded files coming from an SAP system, > > and I'm loading them using the BULK INSERT command. > > > > Even SQL Server 2012 doesn't support UTF-8. Look at this page ( > > http://msdn.microsoft.com/en-us/library/ms188365.aspx) and find "UTF-8") > > > > Ultimately, my "workaround" here is that I found the specific garbage > > strings after loading the data and replacing them with a sql udf I wrote > > that basically does this: > > > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(163),'"') > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(165),'"') > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(214),) > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(244),'-') > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(201),'-') > > > > Rick > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
you could try this work around. http://stackoverflow.com/questions/5498033/how-to-write-utf-8-characters-using-bulk-insert-in-sql-server On Thu, Apr 11, 2013 at 5:53 PM, Rick Root wrote: > > On Tue, Mar 26, 2013 at 11:10 PM, Paul Hastings >wrote: > > > > > > SQL Server 2005 does not support UTF-8 apparently. > > > > sure it does. > > > > No, it doesn't. Not really. > > http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx > > I'm loading this data from UTF-8 encoded files coming from an SAP system, > and I'm loading them using the BULK INSERT command. > > Even SQL Server 2012 doesn't support UTF-8. Look at this page ( > http://msdn.microsoft.com/en-us/library/ms188365.aspx) and find "UTF-8") > > Ultimately, my "workaround" here is that I found the specific garbage > strings after loading the data and replacing them with a sql udf I wrote > that basically does this: > > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(163),'"') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(165),'"') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(214),) > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(244),'-') > set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(201),'-') > > Rick > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
On Tue, Mar 26, 2013 at 11:10 PM, Paul Hastings wrote: > > > SQL Server 2005 does not support UTF-8 apparently. > > sure it does. > No, it doesn't. Not really. http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx I'm loading this data from UTF-8 encoded files coming from an SAP system, and I'm loading them using the BULK INSERT command. Even SQL Server 2012 doesn't support UTF-8. Look at this page ( http://msdn.microsoft.com/en-us/library/ms188365.aspx) and find "UTF-8") Ultimately, my "workaround" here is that I found the specific garbage strings after loading the data and replacing them with a sql udf I wrote that basically does this: set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(163),'"') set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(165),'"') set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(214),) set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(244),'-') set @comment = replace(@comment,nchar(915)+nchar(199)+nchar(201),'-') Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
On 3/27/2013 3:08 AM, Rick Root wrote: > AMEX � ADR Box > > The em dash seems to come through in my text file is 3 characters when I > view it in notepad++ that's because your data is garbaged or its encoding is either missing or misidentified or i guess notepad++ doesn't understand unicode (not sure, not familiar w/it). UTF-whatever are variable width encodings of unicode. UTF encodes all of the million or so unicode code points as 1-4 bytes (8-bit). if something "bad" happens those encodings can "blow apart" & look like multiple chars. > However, when the data is loaded into SQL Server, it goes in as three > characters. unicode 915-199-71 how are you inserting the data? is the column holding this data unicode capable (for sql server it should be one of the "N" datatypes). > SQL Server 2005 does not support UTF-8 apparently. sure it does. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) SQL bulk inserts, ftps, and unicode special characters
Sorry, the em dash is 915-199-244, not 915-244-71. a unicode em dash is unicode 2015 .. I'm not sure how these numbers relate though On Tue, Mar 26, 2013 at 4:08 PM, Rick Root wrote: > > Hi all, > > I am getting some data feeds from our SAP system (god help me). Some of > the data contains unicode characters apparently like em dashes and such. > For example, take the following string: > > AMEX ADR Box > > The em dash seems to come through in my text file is 3 characters when I > view it in notepad++ > > IF I open the document in Word, it asks me for a character encoding and I > say UTF 8, and it appears to show the em dash as a single character: > > AMEX ADR (copy paste from word) > > However, when the data is loaded into SQL Server, it goes in as three > characters. unicode 915-199-71 > > In fact, it looks like pretty much all of these special characters start > with unicode 915-199 and then some other character. > > SQL Server 2005 does not support UTF-8 apparently. > > Has anyone run across this problem and implemented some kind of solution? > > My data files are fairly large (1.3GB of data in 26 files), and they are > loaded every night (full replace) > > Rick > > > -- > The beatings will continue until morale improves. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355154 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) SQL bulk inserts, ftps, and unicode special characters
Hi all, I am getting some data feeds from our SAP system (god help me). Some of the data contains unicode characters apparently like em dashes and such. For example, take the following string: AMEX ADR Box The em dash seems to come through in my text file is 3 characters when I view it in notepad++ IF I open the document in Word, it asks me for a character encoding and I say UTF 8, and it appears to show the em dash as a single character: AMEX ADR (copy paste from word) However, when the data is loaded into SQL Server, it goes in as three characters. unicode 915-199-71 In fact, it looks like pretty much all of these special characters start with unicode 915-199 and then some other character. SQL Server 2005 does not support UTF-8 apparently. Has anyone run across this problem and implemented some kind of solution? My data files are fairly large (1.3GB of data in 26 files), and they are loaded every night (full replace) Rick -- The beatings will continue until morale improves. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355153 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 CFFTP FTPS/Implicit SSL connection?
Hi All, Does anyone know if you can use cfftp in CF8 to make a FTPS/Implicit SSL connection? I can make cfftp SFTP/SSH connections just fine. My guess is Iâm connecting to a remote IIS FTP server thatâs using a SSL cert. Regards, Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FTPS
The file transaction I'm looking to do is a communication with a bank - I have no control over the file server in place on their end. It is an FTPS fileserver, not an SFTP fileserver and I need to be able to access it programmatically. If there's an existing Java object that I can wrap, that'll work just fine. I'm not about to go pay $1399 for Jscape's Java object when it isn't even a complete solution... ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FTPS
I too would still be interested in finding any code which gracefully handles FTPS transactions. The current solution I'm looking at would require me to write a BAT file for every transaction I wish to perform... ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTPS
Adrian -- Thanks much! chris. >Chris, > >I contacted Drew and gave him your email address. It's his work, so I >left it to him to give it away. > >A. > >Adrian -- I'd be really interested in this CFX with FTPS capabilities... >unfortunately the link you gave had an "X-ed" out email address. Could >you provide more information? Perhaps off-list, if necessary? > >Thanks, >chris. > >>I used Drew's CFX - while you usually just read about it's SFTP >>capabilities, there actually is a FTPS (which we use and can recommend) > >>version of it. >> >>http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Col >>d-Fusion-98733.aspx (The reference to his email address is at the end >>of the thread). >> >>Adrian ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284056 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS
Chris, I contacted Drew and gave him your email address. It's his work, so I left it to him to give it away. A. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 19 July 2007 8:17 AM To: Adrian Wagner; CF-Talk; [EMAIL PROTECTED] Subject: Re: FTPS Adrian -- I'd be really interested in this CFX with FTPS capabilities... unfortunately the link you gave had an "X-ed" out email address. Could you provide more information? Perhaps off-list, if necessary? Thanks, chris. >I used Drew's CFX - while you usually just read about it's SFTP >capabilities, there actually is a FTPS (which we use and can recommend) >version of it. > >http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Col >d-Fusion-98733.aspx (The reference to his email address is at the end >of the thread). > >Adrian ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTPS
Adrian -- I'd be really interested in this CFX with FTPS capabilities... unfortunately the link you gave had an "X-ed" out email address. Could you provide more information? Perhaps off-list, if necessary? Thanks, chris. >I used Drew's CFX - while you usually just read about it's SFTP >capabilities, there actually is a FTPS (which we use and can recommend) >version of it. > >http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Cold-Fusion-98733.aspx >(The reference to his email address is at the end of the thread). > >Adrian ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS
I think the original poster was looking for FTPS ... Not SFTP. The Jscape link in my prior post supports both, while jsch is strictly for SFTP via SSH. Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Mark Stanton [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 8:35 PM To: CF-Talk Subject: Re: FTPS Here is part of a wrapper we have written for the jsch library. The rest of the component deals with stuff that is specific to our application. hth On 7/4/07, Jim Rising <[EMAIL PROTECTED]> wrote: > Jake, > > You could probably write a CFC wrapper for this: > > http://www.jscape.com/sftp/index.html > > That's really all that sftp.cfc is... It's a wrapper for Java Secure > Channel: > > http://www.jcraft.com/jsch/ > > Jim Rising > Sr. Cold Fusion Developer > ICGLink Inc. > www.icglink.com > > > > > -Original Message- > From: Jake Pilgrim [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 11:36 AM > To: CF-Talk > Subject: FTPS > > Does anyone know of a way I can connect to an FTPS (FTP over SSL) > server using coldfusion? I have seen the sftp.cfc download out there, > but SFTP is a different protocol and this CFC doesn't seem to work. > > I would prefer a CFC/custom tag based solution, but I am able to run > cfexecute so a command line solution could potentially work. > > > > ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTPS
Here is part of a wrapper we have written for the jsch library. The rest of the component deals with stuff that is specific to our application. hth On 7/4/07, Jim Rising <[EMAIL PROTECTED]> wrote: > Jake, > > You could probably write a CFC wrapper for this: > > http://www.jscape.com/sftp/index.html > > That's really all that sftp.cfc is... It's a wrapper for Java Secure > Channel: > > http://www.jcraft.com/jsch/ > > Jim Rising > Sr. Cold Fusion Developer > ICGLink Inc. > www.icglink.com > > > > > -Original Message- > From: Jake Pilgrim [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 11:36 AM > To: CF-Talk > Subject: FTPS > > Does anyone know of a way I can connect to an FTPS (FTP over SSL) server > using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a > different protocol and this CFC doesn't seem to work. > > I would prefer a CFC/custom tag based solution, but I am able to run > cfexecute so a command line solution could potentially work. > > > > ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FTPS
I used Drew's CFX - while you usually just read about it's SFTP capabilities, there actually is a FTPS (which we use and can recommend) version of it. http://www.sagewire.org/advanced-cfml-techniques/Secure-FTP-SFTP-in-Cold -Fusion-98733.aspx (The reference to his email address is at the end of the thread). Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 4 July 2007 6:09 AM To: Adrian Wagner; CF-Talk; [EMAIL PROTECTED] Subject: RE: FTPS Jake, You could probably write a CFC wrapper for this: http://www.jscape.com/sftp/index.html That's really all that sftp.cfc is... It's a wrapper for Java Secure Channel: http://www.jcraft.com/jsch/ Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so a command line solution could potentially work. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS
Jake, You could probably write a CFC wrapper for this: http://www.jscape.com/sftp/index.html That's really all that sftp.cfc is... It's a wrapper for Java Secure Channel: http://www.jcraft.com/jsch/ Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so a command line solution could potentially work. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FTPS
Der duh der... I guess I could read the whole post... He actually said he was familiar with sftp.cfc and that it wasn't working for him. Jake... In order to use sftp.cfc ... You need to setup a SSH server like openSSH. It will not work over FTPS (SSL). Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 4:19 PM To: CF-Talk Subject: RE: FTPS > Or... You can use this: > > http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/co > ldfusion-sftp SFTP != FTPS Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FTPS
Dan G. Switzer, II wrote: >> I've seen differing support for the two protocols. Filezilla, for >> instance, support SFTP and FTPS on the client, but only supports SFTP in >> the server product. > > Actually, FileZilla Server only support FTPS on the server. :) This is the problem with having FTPS and SFTP. I know the difference and currently have Filezilla set up as an FTPS server and I still don't always type it correctly. Good thing tomorrow is a holiday. At least I hope it will be. Judah ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FTPS
>I've seen differing support for the two protocols. Filezilla, for >instance, support SFTP and FTPS on the client, but only supports SFTP in >the server product. Actually, FileZilla Server only support FTPS on the server. :) -Dan ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FTPS
> Or... You can use this: > > http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/co > ldfusion-sftp SFTP != FTPS Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS
I know that. I just figured that if the ultimate goal is secure file transfer, perhaps doing that over SSH would give him what he needs. Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 4:19 PM To: CF-Talk Subject: RE: FTPS > Or... You can use this: > > http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/co > ldfusion-sftp SFTP != FTPS Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FTPS
FTPS is not the same thing as SFTP. FTPS is ftp over SSL. It typically runs on port 990. SFTP is ftp running over SSH. It typically runs on port 22. I've seen differing support for the two protocols. Filezilla, for instance, support SFTP and FTPS on the client, but only supports SFTP in the server product. Judah Jim Rising wrote: > CF8 is going to support it native. If you can wait... And upgrade... > > Or... You can use this: > > http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/coldfusion-sftp > > Jim Rising > Sr. Cold Fusion Developer > ICGLink Inc. > www.icglink.com > > > -Original Message- > From: Jake Pilgrim [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 11:36 AM > To: CF-Talk > Subject: FTPS > > Does anyone know of a way I can connect to an FTPS (FTP over SSL) server > using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a > different protocol and this CFC doesn't seem to work. > > I would prefer a CFC/custom tag based solution, but I am able to run > cfexecute so a command line solution could potentially work. > > > > ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS
CF8 is going to support it native. If you can wait... And upgrade... Or... You can use this: http://www.socialpoints.com/blog/client/index.cfm/2006/3/25/coldfusion-sftp Jim Rising Sr. Cold Fusion Developer ICGLink Inc. www.icglink.com -Original Message- From: Jake Pilgrim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 11:36 AM To: CF-Talk Subject: FTPS Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so a command line solution could potentially work. ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FTPS
Does anyone know of a way I can connect to an FTPS (FTP over SSL) server using coldfusion? I have seen the sftp.cfc download out there, but SFTP is a different protocol and this CFC doesn't seem to work. I would prefer a CFC/custom tag based solution, but I am able to run cfexecute so a command line solution could potentially work. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: FTPS? (was RE: SFTP?)
Thanks. That fits with what I already knew. Based both my own experience and yours regarding using SFTP over FTPS, it makes me wonder why whenever there's a request for FTP servers recommendation thread that it only includes servers that use FTPS. Do most people just not use the security? I haven't seen many private vendors requiring either FTPS or SFTP whereas here it's policy. I've been looking for an easy to administer server for home, but I want secured transfers so this interest isn't just academic. --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension > -Original Message- > From: Damien McKenna [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 11, 2005 10:46 AM > To: CF-Talk > Subject: RE: FTPS? (was RE: SFTP?) > > FTPS is a file transport layer on top of SSL or TLS. There > are number of options available with it and this can cause > problems: SSL v2 or v3 or TLS, implicit connection, passive > transfers, etc. In my experience it can be quite tricky to > get the options all working correctly on both the server and > client if you have a firewall or two in the middle, I spent > quite some time this past summer trying to get a series of > servers working and ultimately gave up. One of the problems > that I see with FTPS is that there are several fall-back > options usually available (sometimes required) which drop > communications back to an unsecured channel, which defeats > the purpose. > > SFTP is a file transport layer on top of SSH, a protocol for > creating secure shell logins. It is IMHO the most secure way > of doing transfers and is easiest to use from a network > management point of view because it all runs on one port > (#22) and there are no "drop back to unsecured transfers" > capabilities. > > Whether my experiences with FTPS were actual problems or just > my lack of knowledge I can't say, I just got frustrated after > trying several server-client combinations and gave up in > favor of SSH which was pretty much install-and-go. > > FYI there are both free SSH servers (OpenSSH on > UNIX/Linux/BSD/MacOSX and FreeSSHd on Windows) and clients > (oodles on UNIX, CoreFTP on > Windows) available. > > -- > Damien McKenna - Web Developer - > [EMAIL PROTECTED] The Limu Company - > http://www.thelimucompany.com/ - 407-804-1014 #include > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
> -Original Message- > From: Kevin Graeme [mailto:[EMAIL PROTECTED] > > Related to this, can someone point me to a comparison of the two? I > understand that SFTP is SSH file transfer and FTPS is FTP > with SSL, but what are the tradeoffs between them if any? FTPS is a file transport layer on top of SSL or TLS. There are number of options available with it and this can cause problems: SSL v2 or v3 or TLS, implicit connection, passive transfers, etc. In my experience it can be quite tricky to get the options all working correctly on both the server and client if you have a firewall or two in the middle, I spent quite some time this past summer trying to get a series of servers working and ultimately gave up. One of the problems that I see with FTPS is that there are several fall-back options usually available (sometimes required) which drop communications back to an unsecured channel, which defeats the purpose. SFTP is a file transport layer on top of SSH, a protocol for creating secure shell logins. It is IMHO the most secure way of doing transfers and is easiest to use from a network management point of view because it all runs on one port (#22) and there are no "drop back to unsecured transfers" capabilities. Whether my experiences with FTPS were actual problems or just my lack of knowledge I can't say, I just got frustrated after trying several server-client combinations and gave up in favor of SSH which was pretty much install-and-go. FYI there are both free SSH servers (OpenSSH on UNIX/Linux/BSD/MacOSX and FreeSSHd on Windows) and clients (oodles on UNIX, CoreFTP on Windows) available. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
Related to this, can someone point me to a comparison of the two? I understand that SFTP is SSH file transfer and FTPS is FTP with SSL, but what are the tradeoffs between them if any? In my experience it seems that unix administrators seem inclined to use SFTP while most easy to administer FTP server packages running on Windows use FTPS. >From a practical perspective, most client tools I see use sftp, including Dreamweaver and Contribute, which makes me shy away from picking a server that uses FTPS even if it is easy to administer. --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension > -Original Message- > From: Chris Terrebonne [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 08, 2005 7:59 AM > To: CF-Talk > Subject: FTPS? (was RE: SFTP?) > > Actually, I had my acronym backwards (which apparently makes > a HUGE difference :). > I am really looking for FTPS ability (FTP over SSL). > Sorry for the confusion. Any idea where I can find a CF > resource for that protocol? > > Thanks again, > Chris ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220661 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
Thanks for the help everyone. I'll start digging through those libs and see what I can use. Thanks again, Chris >>> [EMAIL PROTECTED] 06/08/05 10:06AM >>> > Actually, I had my acronym backwards (which apparently makes > a HUGE difference :). > I am really looking for FTPS ability (FTP over SSL). > Sorry for the confusion. Any idea where I can find a CF > resource for that protocol? The library I pointed you to does FTPS as well as SFTP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
> Actually, I had my acronym backwards (which apparently makes > a HUGE difference :). > I am really looking for FTPS ability (FTP over SSL). > Sorry for the confusion. Any idea where I can find a CF > resource for that protocol? The library I pointed you to does FTPS as well as SFTP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208970 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FTPS? (was RE: SFTP?)
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=26929&forumid=4 (sorry if that wraps) --Ferg Chris Terrebonne wrote: >Actually, I had my acronym backwards (which apparently makes a HUGE difference >:). >I am really looking for FTPS ability (FTP over SSL). >Sorry for the confusion. Any idea where I can find a CF resource for that >protocol? > >Thanks again, >Chris > > > >>>>[EMAIL PROTECTED] 06/08/05 08:58AM >>> >>>> >>>> >>Can CF do secure FTP (SFTP)? >> >> > >No. > > > >>If not, is there a Java class that can be used in CF that will? >> >> > >You could try this: >http://www.jscape.com/sftp/ > >I haven't tried it myself, though. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208956 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
In that case, you could proxy the connection through stunnel. Http://www.stunnel.org Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208955 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
FTPS? (was RE: SFTP?)
Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL). Sorry for the confusion. Any idea where I can find a CF resource for that protocol? Thanks again, Chris >>> [EMAIL PROTECTED] 06/08/05 08:58AM >>> > Can CF do secure FTP (SFTP)? No. > If not, is there a Java class that can be used in CF that will? You could try this: http://www.jscape.com/sftp/ I haven't tried it myself, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54