Page 2 - Import files to UNIX folder

You can use either CFFILE or CFFTP. Either one will transfer one file at a time. So that means that if you want to transfer multiple files, then you must read them in using CFDIRECTORY, loop over that result set, and then use CFFILE or CFFTP one at a time to copy the files to the UNIX box.

Once you have all the files that are currently on the NT box moved to the UNIX box, then you will also have to write some code that takes all newly uploaded files from your form and copy them over to the UNIX box. Again this can be done with either CFFILE or CFFTP. There is no other easy way to do this, but if you want another way you could start looking at the Java API classes that handle files or FTP.

ok..right now i already succesful transfer all .cfm files to the directory in UNIX server...i use cfftp to do this...now i have to view the file that located in the database in UNIX when i click 'view document' button in my system...my system is located in NT server...unfortunately i cant view the file...the page cannot be found...what the right source code for me to view document that located in database in UNIX through my system?i'm using coldfusion...

This still isn't making any sense to me. You have the content stored in a database on the UNIX box? What database? Oracle? MySQL?

And the whole thing about not being able to view the source code doesn't make any sense either. You're on the NT box but you want to view source from the file that's on the UNIX box? If that's the case have you shared the UNIX directory? Created a virtual directory on the NT box so the web server can use the UNIX directory? And what does this have to do with a database on the UNIX box?

To be honest, I'm getting the impression that you're trying to do more than your skill level will support. Maybe you need to step back and try to do some of this one step at a time instead of leaping all the way to separate servers, FTP sites, and databases...

let me explain a little bit more...in my system(DOCUMENT MANAGEMENT SYSTEM), i upload file (such as minutesmeeting.doc) using the form....then, that files (minutesmeeting.doc) will be copied automatically to the folder in UNIX....that one i already successfull done...then i want to search that files(minutesmeeting.doc) through the system using search form...i'm not want to view the source code...all i want to do is to view back the document(minutesmeeting.doc) that stored in UNIX folder through the search form in my system....my system is located in NT server...but the document (minutesmeeting.doc) is stored in UNIX folder...so how?one more thing, i use oracle database...

Well nothing in that post had anything to do with Oracle, so I'm just going to leave that off. If you want CF to be able to read the file from the UNIX box, you'll need to share a folder on the UNIX box and then use CFFILE from the CF box to read the file using the shared directory path. The security account that CF server is running under must have access rights to the shared folder.

If you want the user to be able to get to the file directly through their browser (and avoid the need to use CFFILE), then you'll not only need to share the folder on the UNIX box but you'll need to make it web-accessible, meaning that your web server must have a virtual directory pointing to the shared directory path. The security account for web anonymous users must have access rights to the shared folder.

I can't make it much more straightforward than that.

ok..i want the users can view the file directly from the UNIX box through their browser...i search everywhere on how to create a virtual directory between NT and UNIX but i'm getting confuse because there's a lot of article about it..can u tell me how to create virtual and shared directory between NT and UNIX so that i can access file from UNIX box?..one more , what is the difference between shared and virtual directory...do u have a link to any article or tutorial to fix this problem?if i have to create shared and virtual directory, where should i create them?

You'll have to make a shared directory on the UNIX box...you are telling the OS that you want network users to be able to read from the folder. I have no idea how to do this on UNIX as I don't use UNIX at all.

On the NT box, within IIS you will right click on the web site and choose "Create New Virtual Dirctory", give it a directory alias name (this is the folder name users will have in their URLs), and then point it to the network path to the shared folder that is set up on the UNIX box. So if you made the name of the alias "mydocuments", user's would get to it like "http://mysite.com/mydocuments/".

You might want to ask about UNIX shares in the UNIX forums.