CSV SFTP Connector
The CSV SFTP Connector enables flexible data exchange using custom CSV (Comma-Separated Values) formats, ideal for organizations with specific data structure requirements or legacy systems that work best with tabular data.
Overview
Section titled “Overview”Perfect for businesses that need:
- Custom data formats tailored to existing ERP systems
- Spreadsheet-compatible files for manual processing
- Flexible field mapping to match internal data structures
- Simple integration with minimal technical overhead
Technical Specifications
Section titled “Technical Specifications”| Specification | Details |
|---|---|
| Data Format | RFC 4180-compliant CSV |
| Character Encoding | UTF-8 |
| Field Delimiter | Comma (,) |
| Text Qualifier | Double quote (") |
| Line Terminator | CRLF (\r\n) |
Supported Message Types
Section titled “Supported Message Types”The CSV connector supports all core business documents:
- Orders - Purchase orders and order updates
- Order Responses - Supplier confirmations and modifications
- Despatch Advice - Shipment notifications with tracking details
- Receipt Advice - Goods receipt confirmations from buyers
Custom Implementation
Section titled “Custom Implementation”Each CSV implementation is custom-designed to match your specific:
- Field requirements and naming conventions
- Data validation rules and formats
- Business logic and workflow needs
- Integration with existing systems
Connection Details
Section titled “Connection Details”- Transport Protocol: SFTP (SSH File Transfer Protocol)
- Server Location: Tradecloud-hosted secure SFTP server
- Client Requirements: SFTP client software and outbound internet access
- Security: Encryption for all file transfers
Availability
Section titled “Availability”The CSV SFTP Connector is available through our partner Supplydrive, who provides:
- Custom CSV format design and mapping
- Implementation and testing support
- Ongoing maintenance and support
- Integration expertise and best practices
Getting Started
Section titled “Getting Started”- Assess Requirements - Identify your CSV format needs and data structure
- Contact Partner - Reach out to Supplydrive for custom implementation
- Design Format - Collaborate on CSV field mapping and validation rules
- Test Integration - Validate data flow in acceptance environment
- Go Live - Deploy to production with monitoring and support