The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
Binary file transfer |
Post Reply |
Author | |
pierre
Beta Tester Joined: May 17 2006 Location: United States Status: Offline Points: 55 |
Post Options
Thanks(0)
Posted: September 26 2008 at 4:07am |
Is there any way to use FT or FTD to transfer a binary file located on the D3 server's local file system (in windows) to my local workstation? The transfer actually works but the file received is altered somehow and the binary is no longer good.
The scenario is as follows: I have a master XL sheet with macros in it. It is stored on the D3 server in windows. I want to send that file to my local workstation. The transfer works but the transferred file is not useable because the binary gets altered during the transfer. I did set FT/FTD to binary. Thanks |
|
PSchellenbach
Admin Group Moderator Joined: December 15 2003 Location: United States Status: Offline Points: 2150 |
Post Options
Thanks(0)
|
Hi Pierre -
D3 is the problem here. While AccuTerm's Kermit utility is binary-clean, D3 is not. I think that when Kermit READs the item from the local file system it converts CHAR(10) in the source file to CHAR(254), and probably discards any CHAR(13) in the source file. This generally corrupts the binary data. Even if you disable the conversion, I don't think D3 BASIC will allow CHAR(255) in string variables, so it still won't work. What you are trying to do is possible in Universe or QM, and maybe other platforms, but just not possible in D3 or mvBase. Thanks, Pete |
|
Stefano
Newbie Joined: October 24 2005 Location: Italy Status: Offline Points: 15 |
Post Options
Thanks(0)
|
The job can be accomplished in two steps, without using FT/FTD, but it requires a shared folder on server.
Suppose C:\Temp is shared, and accessible by your PC, on D3/Windows server (D3server) The skeleton is: Step 1: DATA '(NT_BIN:C:/Temp sheet.xls' EXECUTE 'COPY pickfile binaryitem (O' Step 2 cmnd='Copy \\D3server\C\Temp\fileneme C:\Localfolder\sheet.xls' CRT CHAR(27):CHAR(2):">":cmnd:CHAR(13): Please make filename unique (eg: appending the term line number) I understand I don't directly answer to Your question and this method is not appliable to all scenarios. Stefano |
|
pierre
Beta Tester Joined: May 17 2006 Location: United States Status: Offline Points: 55 |
Post Options
Thanks(0)
|
You're right that did not answer my question but I appreciate the help.
In my citualtion, I do not have access to the local DB drive and cannot create a map drive. To solve my problem I'd have to use ftp. Any one out there can suggest an ftp solution I can use within accuterm? maybe using VBA! Thanks |
|
TonyG
Beta Tester Joined: February 04 2004 Location: United States Status: Offline Points: 127 |
Post Options
Thanks(0)
|
Pierre, the source code for AccuTerm transfers is on your system. You should be able to modify it to read from NT_BIN:filename.
As far as FTP, I have had a lot of success with cURL. Another way to do this is to BASE64-encode the file on your system, transfer, then decode it on the target system. HTH |
|
Tony Gravagno Nebula Research & Development
TG@ Nebula-RnD . com http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms https://www.linkedin.com/groups/64935 |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |