Shell Programming and Scripting

I am sorry if i frustrate you at the repeated questions.

Then don't use one. I was just trying to be complete.
I am reallly not sure. because we are very new to this FTP server. They just provided me a GUI tool (FTP server's flat files stores in the main folder under main object) to login to it with the User ID and PW and then i can see it. I wants now to ask you that plz suggest me that how i can find the remote path to put in SSH code?

Do you actually need a remote path? Can you just sftp into username@server then MGET *.xls? Have you actually tried? Try just typing it into a terminal and see what happens.

I tried it long time ago, it was saying that EXPECT is not installed in your system. also, as you said "no expect madness required", that is the reason i wants to switch it to "SSH"
So, i wants to check with you finally the below code is a complete code that you are suggesting me to compile and execute? or does it need any changes if i did wrong specifics?. I am only looking for the code at the moment that can push the file from FTP server (Windows OS) to Application server (Linux OS - /usr/sap/NXA/COMM/interface/FICO/)
_____________________________________________________________
sftp FICO@share.dteenergy.com <<EOF
cd /usr/sap/NXA/COMM/interface/FICO/
lcd /usr/sap/NXA/COMM/interface/FICO/ (local path)
mget GET_FILE*
EOF
_____________________________________________________________

I have absolutely no idea what you tried, but whatever it is, it's not what I suggested.

Code:

sftp username@host <<EOF
mget GET_FILE*
EOF

Type it into your shell.

Does it work or not?

you can stop putting expect junk back into it, then It's a shell script. There's no compile, just execute. I have no idea if it needs changes. That depends on what files are where and where you are when you login and where you want to store the files. There's no way for me to do everything for you. You're going to have to start trying things, and start reading instead of copypasting. It'll help to do things in parts, instead of trying everything at once. Get your sftp working first, if that doesn't go then the rest is pointless.

Your sftp server being Windows could make it tougher to use keys though. Depending on what it is, it might still be possible, but copying the keys might not work the same way. try ssh-copy-id first though and if it works, it works.

As i mentioned, i am very new to this subject. if possible, please provide me the code otherwise, let us pass it to the other users if somebody wants to help me.
I am a SAP guy. not a Linux. I am trying to move the flat file from FTP server (It is on Windows O.S) to Application server (Linux O.S - This i know the path to where it should get). Infact, i dont have a access to execute a single commands or entire script at linux level. for that i again have to write a ABAP program to execute that script. So plz help if you can. Thank you so much.

It'd be nice to have known that you don't have shell access days ago...

I'm not stopping other users from contributing. I presume they're not because they lack the same information I and perhaps you do.

I can't give you a canned script for all the reasons I mentioned before. These reasons apply to other folks as well I think, they're not psychic either.

I have no idea how they expect you to write a UNIX script without shell access. It's going to be a monumental task to troubleshoot it and/or install the xls converter without it.

Are you sure you don't have access? You think you'd need shell access to run shell scripts. Try logging in with putty, same username/password as your windows ABAP thing is using to connect to the linux server.

It'd be nice to have known that you don't have shell access days ago...
Yes you will get to know in going forward that once you get a chance to work on three tier architecture.

I'm not stopping other users from contributing. I presume they're not because they lack the same information I and perhaps you do.
Thanks for not going to stop other users from contributing. I don think so. I hope everybody is not here for needing the information. sometimes others may come up with the updated information as they might have already faced the same kind of problems and solved it by theirselves and the same can be passed to us.

I can't give you a canned script for all the reasons I mentioned before. These reasons apply to other folks as well I think, they're not psychic either.
No problem. I can understand the reason why you cannot give and what kind of psychic you are.. I dont think that other folks as well, may be let us wait and watch the game. in worst cases, if that doesnt happen then i will recommend my PM to call a shell script developer who has worked in multiple environments.

I still beleive this forum that we have very good experts like DgPicket and etc. Hope this will get resolved.


I have no idea how they expect you to write a UNIX script without shell access. It's going to be a monumental task to troubleshoot it and/or install the xls converter without it.
As far as i presume that you have a good experience in your subject but that wont be enough to contribute in forums atleast before commenting against others questions. let us wait and watch the game if somebody come up with the solution or i may post the answer too after a while.

Are you sure you don't have access? Try logging in with putty, same username/password as your windows ABAP thing is using to connect to the linux server.
Yes i am sure that we dont have a access to execute the commnd wise/scriptwise at unix level. i have a option in SAP that i can develop a own command like telnet (Ex to test the single commands and need to write a ABAP program to execute the entire script.

The reason there is an sftp command is to support old FTP scripts (and those so old they cannot learn a new command?). For new work, scp seems much simpler and more powerful.

If you use relative paths in sftp, you can use the same relative paths in scp.

Thank you DGPicket for the reply. I should not ask you the same question again and again but should be becuase since i am a fresher with this shell script, and not aware of much, is it possible for you to send me the SCP code(practical code)? it would be highly appreciated.