Automate your File Sync.
Securely ingest historical transactions, offline POS records, and customer traits directly from your buckets and servers without writing complex ETL scripts.
S3
sales_2023.csv
SFTP
crm_export.csv
G
VIP_List.xlsx
SYNC
Parsing Engine
HUBXIO PLATFORM
> 1,240 Profiles Updated
> 5,092 Events Ingested
> Sync Completed successfully.
> 5,092 Events Ingested
> Sync Completed successfully.
Supported Sources
Import data from anywhere
Whether it’s an automated enterprise data lake or a manual spreadsheet, we support the protocols you already use.
Secure FTP
Connect your internal servers. We automatically scan your SFTP directories on a schedule and parse new CSV/JSON files.
Amazon S3
Direct integration with AWS. Point us to your S3 bucket, provide read-access, and we’ll handle the heavy lifting ingestion.
Google Sheets
Perfect for marketing teams. Live-sync a shared spreadsheet directly into the CDP to update VIP tiers or lead statuses.
Manual Upload
Need a quick, ad-hoc import? Drag and drop your CSV directly into our dashboard and map the columns visually.
Visual Mapper
No code schema mapping
Data rarely arrives in the perfect format. Our visual mapper allows you to bridge the gap between your raw files and the CDP’s structured schema effortlessly.
- Map any CSV column to a Standard or Custom Trait.
- Specify the Identity Key (Email, Phone, User ID).
- Automatically cast data types (String to Number/Date).
CSV FILE COLUMN
HUBXIO SCHEMA FIELD
Customer_Email
➔
Identity: Email
First Name
➔
Trait: first_name
Total_Spent
➔
Trait: lifetime_value (Number)
Purchase_Date
➔
Event Timestamp
Profiles & Behaviors Ingestion
File Sync isn’t just for static info. Choose between Identify Mode (to create users and update traits like Loyalty Tier) or Track Mode (to append historical events like Offline Store Purchases) directly from your rows.
Scheduled Cron Syncs
Set it and forget it. Configure syncs to run hourly, daily, or using custom Cron expressions.
0 2 * * *
Runs at 02:00 AM
every day.
every day.
Fault Tolerance & Validation
If a row is corrupted (e.g., invalid email format), the entire sync doesn’t fail. We skip the bad row, log the error, and continue processing the rest of your millions of records.
Total Rows: 10,000
Success: 9,998
Skipped (Invalid Email): 2
Enterprise Encryption
Security is paramount. Data imported via SFTP or AWS S3 is transferred via encrypted tunnels (SSH/TLS 1.2+). Rest assured your PII and financial records remain confidential during transit.
Ready to import your offline data?
Connect your storage bucket or upload a test CSV right now to see the mapping engine in action.