Automate file transfer from Windows to Unix

up vote
4
down vote

favorite

I have the following situation: users update csv/txt files on daily basis on Windows. I use those flat files as input for my Oracle scripts which is on Unix. I need a script/method of transferring those flat files from Windows to Unix.

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

What kind of access do you have on the Unix machine? Shell (SSH), FTP, anything else?
– ddeimeke
May 3 '12 at 11:53

Don't use ftp, it makes username/password travel the network in clear text. Scp is easiest to script alternative, sftp isn't too bad either. Check Bruce's answer.
– jippie
May 3 '12 at 18:09

WinSCP.exe is a useful tool, as well as using PuTTy.exe (like @BruceEdiger mentioned)
– Kevdog777
Jun 10 '16 at 9:49

add a comment |

up vote
4
down vote

favorite

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

What kind of access do you have on the Unix machine? Shell (SSH), FTP, anything else?
– ddeimeke
May 3 '12 at 11:53

Don't use ftp, it makes username/password travel the network in clear text. Scp is easiest to script alternative, sftp isn't too bad either. Check Bruce's answer.
– jippie
May 3 '12 at 18:09

WinSCP.exe is a useful tool, as well as using PuTTy.exe (like @BruceEdiger mentioned)
– Kevdog777
Jun 10 '16 at 9:49

add a comment |

up vote
4
down vote

favorite

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

shell-script windows ftp file-copy

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

edited Nov 17 at 1:18

Rui F Ribeiro

38.2k1475123

asked May 3 '12 at 10:15

user18355

21112

asked May 3 '12 at 10:15

user18355

21112

asked May 3 '12 at 10:15

user18355

21112

What kind of access do you have on the Unix machine? Shell (SSH), FTP, anything else?
– ddeimeke
May 3 '12 at 11:53

Don't use ftp, it makes username/password travel the network in clear text. Scp is easiest to script alternative, sftp isn't too bad either. Check Bruce's answer.
– jippie
May 3 '12 at 18:09

WinSCP.exe is a useful tool, as well as using PuTTy.exe (like @BruceEdiger mentioned)
– Kevdog777
Jun 10 '16 at 9:49

add a comment |

What kind of access do you have on the Unix machine? Shell (SSH), FTP, anything else?
– ddeimeke
May 3 '12 at 11:53

Don't use ftp, it makes username/password travel the network in clear text. Scp is easiest to script alternative, sftp isn't too bad either. Check Bruce's answer.
– jippie
May 3 '12 at 18:09

WinSCP.exe is a useful tool, as well as using PuTTy.exe (like @BruceEdiger mentioned)
– Kevdog777
Jun 10 '16 at 9:49

What kind of access do you have on the Unix machine? Shell (SSH), FTP, anything else?
– ddeimeke
May 3 '12 at 11:53

Don't use ftp, it makes username/password travel the network in clear text. Scp is easiest to script alternative, sftp isn't too bad either. Check Bruce's answer.
– jippie
May 3 '12 at 18:09

WinSCP.exe is a useful tool, as well as using PuTTy.exe (like @BruceEdiger mentioned)
– Kevdog777
Jun 10 '16 at 9:49

add a comment |

2 Answers
2

active

oldest

votes

up vote
7
down vote

You could use the SCP program that comes with famed terminal emulator PuTTY: pscp.exe

If you create public/private key files, pscp.exe should have the ability to just do something like:

pscp *.csv *.txt username@unixhost:whatever/subdirectory/

from inside a .bat file.

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

add a comment |

up vote
2
down vote

You have several options available. Choose one that you are most comfortable with. One potential would be to set up an SMB/CIFS share on the Unix host.

In a script from each Windows workstation, mount the SMB/CIFS share with the net command.

net use \computernamesharename /persistent:no

After completion of the copy or move of the file to the SMB/CIFS share, you could optionally remove the share from the Windows workstation.

net use \computernamesharename /delete

You can get full options of the net command by running net help use. Here is a good unofficial guide to configuring Samba.

answered May 3 '12 at 13:27

George M

8,94623247

add a comment |

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f37811%2fautomate-file-transfer-from-windows-to-unix%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
7
down vote

You could use the SCP program that comes with famed terminal emulator PuTTY: pscp.exe

If you create public/private key files, pscp.exe should have the ability to just do something like:

pscp *.csv *.txt username@unixhost:whatever/subdirectory/

from inside a .bat file.

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

add a comment |

up vote
7
down vote

You could use the SCP program that comes with famed terminal emulator PuTTY: pscp.exe

If you create public/private key files, pscp.exe should have the ability to just do something like:

pscp *.csv *.txt username@unixhost:whatever/subdirectory/

from inside a .bat file.

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

add a comment |

up vote
7
down vote

You could use the SCP program that comes with famed terminal emulator PuTTY: pscp.exe

If you create public/private key files, pscp.exe should have the ability to just do something like:

pscp *.csv *.txt username@unixhost:whatever/subdirectory/

from inside a .bat file.

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

You could use the SCP program that comes with famed terminal emulator PuTTY: pscp.exe

If you create public/private key files, pscp.exe should have the ability to just do something like:

pscp *.csv *.txt username@unixhost:whatever/subdirectory/

from inside a .bat file.

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

answered May 3 '12 at 12:51

Bruce Ediger

34.4k565119

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

add a comment |

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

A cmd file would give him the extended syntax on windows. psftp is another option with putty.
– Nils
May 3 '12 at 20:28

add a comment |

up vote
2
down vote

You have several options available. Choose one that you are most comfortable with. One potential would be to set up an SMB/CIFS share on the Unix host.

In a script from each Windows workstation, mount the SMB/CIFS share with the net command.

net use \computernamesharename /persistent:no

After completion of the copy or move of the file to the SMB/CIFS share, you could optionally remove the share from the Windows workstation.

net use \computernamesharename /delete

You can get full options of the net command by running net help use. Here is a good unofficial guide to configuring Samba.

answered May 3 '12 at 13:27

George M

8,94623247

add a comment |

up vote
2
down vote

You have several options available. Choose one that you are most comfortable with. One potential would be to set up an SMB/CIFS share on the Unix host.

In a script from each Windows workstation, mount the SMB/CIFS share with the net command.

net use \computernamesharename /persistent:no

After completion of the copy or move of the file to the SMB/CIFS share, you could optionally remove the share from the Windows workstation.

net use \computernamesharename /delete

You can get full options of the net command by running net help use. Here is a good unofficial guide to configuring Samba.

answered May 3 '12 at 13:27

George M

8,94623247

add a comment |

up vote
2
down vote

You have several options available. Choose one that you are most comfortable with. One potential would be to set up an SMB/CIFS share on the Unix host.

In a script from each Windows workstation, mount the SMB/CIFS share with the net command.

net use \computernamesharename /persistent:no

After completion of the copy or move of the file to the SMB/CIFS share, you could optionally remove the share from the Windows workstation.

net use \computernamesharename /delete

You can get full options of the net command by running net help use. Here is a good unofficial guide to configuring Samba.

answered May 3 '12 at 13:27

George M

8,94623247

You have several options available. Choose one that you are most comfortable with. One potential would be to set up an SMB/CIFS share on the Unix host.

In a script from each Windows workstation, mount the SMB/CIFS share with the net command.

net use \computernamesharename /persistent:no

After completion of the copy or move of the file to the SMB/CIFS share, you could optionally remove the share from the Windows workstation.

net use \computernamesharename /delete

You can get full options of the net command by running net help use. Here is a good unofficial guide to configuring Samba.

answered May 3 '12 at 13:27

George M

8,94623247

answered May 3 '12 at 13:27

George M

8,94623247

answered May 3 '12 at 13:27

George M

8,94623247

answered May 3 '12 at 13:27

George M

8,94623247

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

搜尋此網誌

mjhjmtu