There are probably better ways to do this, but in case it helps any... You'll have to add a reference to the Windows Script Host Object Model if you use this code:
'Get the lab PDF report files using FTP
Dim objShell As WshShell
Set objShell = New WshShell
objShell.Run "cmd.exe /c ftp -s:c:\mrsa\scripts\ftpin-prod.txt >
c:\mrsa\scripts\ftpout.txt", 0, True
The file ftpin-prod.txt contains the redirected input to the ftp command:
open yourhost or IP
username
password
binary
prompt
lcd c:\local
cd /external
mget *.pdf
mdelete *.pdf
close
quit
David Garcia
Senior Programmer/Analyst
Washington Hospital Healthcare System
2000 Mowry Avenue
Fremont, CA 94538
(510) 745-6477 || (510) 797-1111 x4760
[email protected]<mailto:[email protected]>
From: [email protected] [mailto:[email protected]]
Sent: Thursday, July 11, 2013 6:10 AM
To: [email protected]
Subject: RE:[talkbws] Using Boston Workstation to FTP or receive files via FTP
The customer center has a few examples in the Script Center that might work for
you:
http://www.bostonsoftwaresystems.com/Customers/Boston-Workstation/Script-Center/Utilities/Messaging/FTP
Also, you might want to take a look at your server. We upload our claims to an
sftp, and after working with a support rep, we found out that the GetFTP
function won't work with an SSH protocol. Our solution for that was using the
windows connection to connect with an ftp client (specifically FileZilla), and
downloading the files that way.
Hope it helps!
Paul-Michael Fernandez
Analyst, Data & System Solutions
SALUD Healthcare Solutions
T 765.637.2411
F 765.637.2401
C 765.532.6601
SaludSolutions.US
CONFIDENTIALITY NOTICE: This e-mail message, including all attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. If you are not the intended recipient, you may NOT use,
disclose, copy, or disseminate this information. Please contact the sender by
reply e-mail immediately and destroy all copies of the original message
including all attachments. Your cooperation is greatly appreciated.
From: [email protected]<mailto:[email protected]> [mailto:[email protected]]
Sent: Thursday, July 11, 2013 7:34 AM
To: [email protected]<mailto:[email protected]>
Subject: [talkbws] Using Boston Workstation to FTP or receive files via FTP
I wanted to see if anyone has used the code to send or receive files via FTP in
Boston Workstation that they are willing to share. I have tried several things
and cannot get it to work. Any information would be appreciated.
Thanks,
[SMRC_CenterLogo_PMS294]
Angela Canady MBA/MHA
IS - Financial Systems Manager
Phone: 910-596-5439
Email: [email protected]<mailto:[email protected]>
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you are not the intended recipient you are notified that disclosing, copying,
distributing, or taking any action in reliance on the contents of this
information is strictly prohibited. If you have received this email in error
please notify the sender and delete the email. Please note that any views or
opinions presented in this email are solely those of the author and do not
necessarily represent those of Sampson Regional Medical Center. Finally, the
recipient should check this email and any attachments for the presence of
viruses. Sampson Regional Medical Center accepts no liability for any damage
caused by any virus transmitted by this email. If you have further questions or
issues, you may contact Sampson Regional Medical Center at 910-592-8511.
--
Scanned by MailScanner<http://www.mailscanner.info/>
--- To post a message to this list, send mail to:
[email protected]<mailto:[email protected]> You are currently subscribed as:
[email protected]<mailto:[email protected]> Unsubscribe
in the customer center on our website:
http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx
--- To post a message to this list, send mail to:
[email protected]<mailto:[email protected]> You are currently subscribed as:
[email protected]<mailto:[email protected]> Unsubscribe in the
customer center on our website:
http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx
--- To post a message to this list, send mail to: [email protected] You are
currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonsoftwaresystems.com/Customers/ListServe.aspx<<inline: image001.gif>>
<<inline: image002.jpg>>
