UNIX for Advanced & Expert Users

Hello - My requirement is like this...

I have flat file which is sitting in windows server... My shell script is running in unix box. Shell script loads the flat file into oracle through sqlloader. So script needs to pickup the flat file from windows box.

I need to refer windows location in shell script... How can i do this. Any help is highly appreciated....

Will have to either:

Have the flat file in a FTP directory on the windows server

Or

Configure samba to connect to a shared directory on the windows server and mount it on the linux/unix box to read the flat file.

Thank you Ikon.

I believe, samba needs to be installed in unix box and configure the windows directory..

After installing samba, i have another requests. Basically two things i need to do.

1. This question is already asked in this thread.. Login to unix and ftping files from windows to unix.

2. Login to unix, Can i also move the files from unix box to windows directory?

Please let me know.

Also it would be helpful if you could provide any link to configure smaba...

Thanks and highly appreciated your answers and responds.

From windows, you can run ftp. I do this all the time. I open a cmd window, type ftp, and then I have an ftp client very much like the unix ftp client. There are dozen of other ftp clients for windows. The windows server has IIS (I think its called) that includes an FTP server. I have heard that a limited version of IIS comes with XP Professional and you can install it and then run FTP, but only for a very few connections at a time. But both Windows and Unix must be configured to run FTP. Lots of people do not run FTP anymore. If it's not running and you can't change that, this won't work. I don't think you can run the IIS FTP server on XP Home. But in general, either system can FTP the other.

Perderabo, I think, you misunderstood my question. I need to login in unix and ftp files from windows to unix folder and ftp files from unix to windows folder. So i can login only in unix. I do not have permission to login in windows server. My shell scripts sits in unix server and interact with windows... Hope you understand now...

As Ikon suggested, i can go for samba tool.. Please let me know your thoughts...

You can't use ftp if you have no account. Depending on the way that the windows system is set up, you may have trouble with samba as well. It is rare that an unauthenticated user can read and write files to any system.

Take a look at facetwin. I think this might help.

Alternatively, you could approach this another way. What if you "export" a directory on the UNIX server to make it visible to Windows?

Then you can mount the UNIX directory as a Networked drive on the Windows Server.

Then write the flat file (a report or export file from excel or database?) or have the System Administrator write the flat file to this mounted directory.

On the UNIX side, this folder is now available to your database!


Steve