基于Hyperion FDMEE环境的Windows至Linux文件传输批处理脚本咨询

Hey there, let's break down your two questions step by step with practical, actionable solutions:

In Windows CMD, you have several secure, reliable options based on SSH protocol for cross-system file transfers. Here are the most common approaches:

• PSCP (Part of the PuTTY Toolkit)
  First, install the PuTTY toolkit on your Windows machine. Then use these commands in CMD:

  # Basic password-based authentication
  pscp C:\local\path\your_file.txt linux_username@linux_server_ip:/remote/target/path/
  
  # Key-based authentication (more secure, no plaintext password)
  pscp -i C:\path\to\your_private_key.ppk C:\local\path\your_file.txt linux_username@linux_server_ip:/remote/target/path/
  

• Built-in SFTP Command (Windows 10/11+)
  Modern Windows systems include an SFTP client by default—no extra installation needed. You can run it interactively or automate it in a batch file:

  # Batch file automation
  @echo off
  echo put C:\local\path\your_file.txt /remote/target/path/ | sftp linux_username@linux_server_ip
  

  For passwordless automation, set up SSH key authentication by adding your Windows public key to the Linux server's ~/.ssh/authorized_keys file.

• WinSCP Command-Line Version
  If you already use WinSCP's GUI, its command-line tool winscp.com is great for batch scripts:

  # Password-based (not recommended for production, only testing)
  winscp.com /command "open sftp://linux_username:your_password@linux_server_ip/" "put C:\local\path\your_file.txt /remote/target/path/" "exit"
  
  # Key-based authentication
  winscp.com /command "open sftp://linux_username@linux_server_ip/ -privatekey=C:\path\to\your_key.ppk" "put C:\local\path\your_file.txt /remote/target/path/" "exit"
  

Hyperion FDMEE's Jython environment can call external system commands to run the transfer tools above. Below are tailored solutions for your use case:

Solution 1: Jython Script Calling PSCP #

Ideal for key-authenticated setups (more secure):

import subprocess

# Configure your parameters (can dynamically fetch via FDMEE context, e.g., fdmAPI.getRuntimeContext())
local_file_path = "C:\\FDMEE\\Outbox\\exported_data.txt"
remote_user = "linux_user"
remote_server = "10.0.0.5"
remote_target_path = "/opt/fdmee/incoming/"
private_key_path = "C:\\FDMEE\\Security\\fdmee_ssh_key.ppk"
pscp_exe_path = "C:\\Program Files\\PuTTY\\pscp.exe"

# Build PSCP command array (avoids space escape issues)
command = [
    pscp_exe_path,
    "-i", private_key_path,
    "-batch",  # Batch mode, no interactive prompts
    local_file_path,
    f"{remote_user}@{remote_server}:{remote_target_path}"
]

try:
    # Execute command and capture output
    result = subprocess.run(command, check=True, capture_output=True, text=True)
    # Log success to FDMEE
    fdmAPI.logInfo(f"File transfer succeeded! PSCP output: {result.stdout}")
except subprocess.CalledProcessError as e:
    error_msg = f"File transfer failed: {e.stderr}"
    fdmAPI.logError(error_msg)
    raise Exception(error_msg)  # Trigger FDMEE process error
except FileNotFoundError:
    error_msg = f"PSCP tool not found. Check path: {pscp_exe_path}"
    fdmAPI.logError(error_msg)
    raise Exception(error_msg)

Solution 2: Jython Script Calling WinSCP Command-Line #

Great if WinSCP is your preferred tool:

import subprocess

# Configure parameters
local_file = "C:\\FDMEE\\Outbox\\data_file.csv"
remote_sftp_url = "sftp://linux_user@10.0.0.5/opt/fdmee/incoming/"
winscp_exe = "C:\\Program Files (x86)\\WinSCP\\winscp.com"
private_key = "C:\\FDMEE\\Security\\win_scp_key.ppk"

# Build WinSCP command
command = [
    winscp_exe,
    "/command",
    f'open "{remote_sftp_url}" -privatekey="{private_key}" -batch',
    f'put "{local_file}"',
    "exit"
]

try:
    subprocess.run(command, check=True, capture_output=True, text=True)
    fdmAPI.logInfo(f"File {local_file} successfully transferred to remote server")
except subprocess.CalledProcessError as e:
    fdmAPI.logError(f"WinSCP transfer failed: {e.stderr}")
    raise

Critical Notes for FDMEE Integration #

• Permissions: Ensure the FDMEE service account (Windows service account) has access to local files, can execute PSCP/WinSCP, and the Linux server allows SSH connections for the specified user.
• Key Security: Never hardcode passwords in scripts. Always use SSH key authentication—deploy your public key to the Linux server's ~/.ssh/authorized_keys file.
• FDMEE Workflow Integration: Attach this script to a custom event (e.g., After Export) to trigger transfers automatically after data exports.
• Test First: Manually run the CMD commands to confirm transfers work before integrating into Jython—this simplifies troubleshooting in FDMEE.

内容的提问来源于stack exchange，提问作者raman9840