Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Shell script file movement to a Mail Box server using ftp commands


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Shell script file movement to a Mail Box server using ftp commands

Hi All,

I have a current Process that runs "windows script " for the file movement that needs to changed to a "DataStage Process (Using shell script )"

Source :Text file is getting generated as part of Datastage Jobs processes and resides in a shared drive (Unix server)

Target :ftp hostname "xxx.yyy.com " folder "ABC" is a mailbox location

Current Process :

Currently It is using following windows script to move the file

Code:
open xxx.yyy.com 
user name 
password 
prompt 
put "\\psoft8\output\FILE.TXT"%ABC%FILE 
quit

Can you please help me with FTP command OR syntax used for this file movement.

Thank you
# 2  
\\psoft8 looks like a samba (SMB) windows file share. In order to open that file on UNIX you have to install samba. So, something is missing. You can ftp from windows to UNIX, no problem.

So instead of showing us a code fragment that is of very little help:

1. Is this from windows to UNIX?
<your answer here>
2. Can it (the ftp part at least) run on Windows or does the script have to live on UNIX?
<another answer please>
3. Can the UNIX box see \\psoft (or whatever its name is on UNIX, maybe /psoft8) now? <yes or no>
# 3  
@Jim ..Thanks for the reply sorry for the confusion.

[\\psoft8]this is the windows server and Is OBSELTE NOW .. the proposed process is to place the file from unix server to Mail box location ftp server .

Responses :
1. Is this from windows to UNIX?
No ..this is from unix server to mail box location (ftp host)
2. Can it (the ftp part at least) run on Windows or does the script have to live on UNIX?
Script has to be reside on UNIX server ..Script has to be executed from DataStage Execute command Activity stage ..This stage takes the "FTP.sh " and Properties for the script.
3. Can the UNIX box see \\psoft (or whatever its name is on UNIX, maybe /psoft8 ) now? <yes or no>
No ..\\psoft is OBSELTE now

This is basic script I wrote to get the file from that mail box server

Code:
#!/usr/bin/bash 
#------------------------------------------------------------------------------------ 
# Name        : FTP.sh                                 
#---------------------------------------------------------------------------------------------------------------------------# 
HOST= 'xxx.yyy.com' 
user ='aaaa' 
password='bbbb' 

ftp xxx.yyy.com 
user $user $password 
get 00123456789 
quit 
END_SCRIPT 
Exit 0

Findings from Windows command prompt :

Code:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\X>ftp xxx.yyy.com
Connected to xxx.yyy.com.
220 Enterprise FTP server (Version 1.0.0 Nov. 5, 1996)
User (edi.cat.com:(none)): aaaa
331 Password required for aaaa
Password:
230-User logged in, proceed.
        Current Default Relationship - Recv: aaaa uuuu: *BINARY
        Get option: multiple
230
ftp> dir
200 Port command successful.
150 Opening ASCII mode data connection for transfer
Mailbox ID          St  APRZ           SYRF           Service Refs. #
abc                    N   SMAR          file123             00123
abc                    N   SMAR          file456             00456
226 Transfer Complete.
ftp: 2319 bytes received in 0.04Seconds 52.70Kbytes/sec.
ftp> get SMAR
200 Port command successful.
150 Opening ASCII mode data connection for transfer
226- 30 documents are received
226 Transfer complete.
ftp: 28687325 bytes received in 35.06Seconds 818.17Kbytes/sec.
ftp> lcd
Local directory now C:\Users\X.
ftp> get file321
200 Port command successful.
226- 0 documents are received
226 Transfer complete.
ftp> get 00123
200 Port command successful.
150 Opening ASCII mode data connection for transfer
226 Transfer complete.
ftp: 962245 bytes received in 0.31Seconds 3144.59Kbytes/sec.
ftp>

Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
ftp file starting with particular name on Windows box to Unix box using shell script
vijayb4u83
Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the...... Shell Programming and Scripting
2
Shell Programming and Scripting
Shell script for FTP a file from one server to another server
mahantysk
Hi Can any one help me for script. I need a script and this script has to execute daily to move the files. FTP from one server to another server EX: Sep 10 06:24 abc.txt Sep 11 06.56 abc.txt Sep 12 08.23 abc.txt these files are located at a/b/c/e/f in 123 server and copy...... Shell Programming and Scripting
0
Shell Programming and Scripting
FTP Unix Box to Windows Shell Script
Jose Miguel
Hello All, Could someone help me out with this? I want to incorporate this into an existing script so the output of a SAS job can be ftp'd from our UNIX box to a directory on a drive in Windows environment. Can this be done with no extra third party software? We currently use Putty for copy...... Shell Programming and Scripting
2
Shell Programming and Scripting
concurrency issue while Accessing Mail Box from shell script
Sumit_Fundoo
Hi Bros, I am in a serious trouble with concurrency issue while using mailx. I have a shell script which reads all the emails of a unix user account and create a copy (another mbox for processing and archive purpose). This script works fine for 99.99% of the time but sometime it start creating...... UNIX for Advanced & Expert Users
2
UNIX for Advanced & Expert Users
how to move a file from one server to another server using FTP in shell script?
forevercalz
I have a file --> file1.txt i need to copy this file to another server using FTP....the 2 servers are server1 and server2..may i know how to write a script that can do this? thanks in advance! Im a newbie to this...... Shell Programming and Scripting
4
Shell Programming and Scripting

Featured Tech Videos