Data Transfer
Data Transfer (formerly Task Manager) is where you move data in and out of VisuaLeaf. Every export, import and database-to-database migration is created, scheduled and tracked here — along with syncs, backups and recurring maintenance tasks. Instead of a plain list, you get a live board with progress bars, throughput sparklines, a run history timeline, and drill-in log panes for every job.
Opening Data Transfer
- Left activity bar — click the checklist icon. It sits in the tool group, after Visual Schema (ERD) and Schema Manager.
- Command Palette — press Ctrl+K (⌘+K on Mac) and type "Data Transfer".
- Right-click — right-click a database in the sidebar and choose Data Transfer.
If you hid the icon from the left bar, Data Transfer is still available from the Command Palette. See Left activity bar to bring it back.
Quick Start
Create your first scheduled task:
- Open Data Transfer from the left activity bar (or search "Data Transfer" in the Command Palette).
- Click + New Task on a folder (use Create Folder first if you have none) to add a task, then + Add Job to configure what it does.
- Pick a task type (Export, Import, Sync, Backup, Rolling Compact, Migration, or a custom shell script).
- Configure source, destination, transformations, and options — each field previews live results as you fill it in.
- Set the schedule (one-time, cron expression like
0 2 * * *, or event trigger).
- Save, then tick Set schedule... or click Run All. The task shows a live status chip on the board.
Visual Board Overview
Data Transfer has three tabs along the top — Tasks, Monitor, and History. The Tasks tab is where you build and run your automation:
- Header actions — Getting Started, Check Connections, Create Folder, Import, and Export All.
- Search and filters — search tasks and jobs by name, and filter by Scheduled, Status, and Type.
- Folders — group related tasks (for example "Nightly exports"). Each folder shows its task count and has its own + New Task and Import buttons, plus expand/collapse and sorting controls. Star a folder to keep it at the top.
- Task rows — each task shows its name, a Set schedule... checkbox, an Async option, a status chip with the last run time and duration (for example "Completed"), and buttons to expand, pop out, move to a folder, export, or delete.
- Jobs — a task holds one or more jobs. Use + Add Job to add another, and Run All to run every job in the task; a progress bar and a count of finished jobs sit next to it.
Live progress & throughput
Running jobs stream progress live, so the board updates without refreshing. The Monitor tab gives you the whole picture in one place:
- Capacity bar — how much of the execution capacity is in use, slots in use (for example "0/2"), queued work, an estimated time to clear the queue, and how many tasks are scheduled.
- Running Executions — everything executing right now, with its progress.
- Pending Executions — work waiting for a free slot.
- Scheduled Tasks — upcoming runs, filterable by status, type, and name, with a Timeline View.
- Configure and Cleanup — set how many executions may run at once, and clear out finished entries.
Run history timeline
The History tab summarises every past run. Cards across the top show total tasks, total executions, successful, failed and cancelled runs, and the overall success rate. Below them, filter by status, type, period (for example "Last 7 Days"), or task name, and read two charts: Executions Over Time (total, success, with errors, failed, cancelled per day) and Success Rate Trend. The task list underneath is grouped by day and shows each task's last execution, status, duration, total runs, and success rate. Use Clear All to reset the history.
Pop-out tasks
Any task can be popped out into its own OS window, so you can keep watching a long-running export while you continue working in the main VisuaLeaf workspace. Two ways to pop out:
- From the card menu — click the “ Pop Out” icon on any task card.
- From a running task — while a task is executing, drag its progress bar off the main window; it becomes a floating monitor window.
The popped-out window has its own compact layout — progress bar, throughput sparkline, ETA, current step, and a cancel button — and stays connected to the same SSE stream as the main board. Close the window at any time; the task keeps running in the background. Multiple tasks can be popped out simultaneously so you can arrange a “job monitor wall” alongside your primary workspace.
Pop-out windows respect the theme (light / dark) and remember their last position and size per task.
Migrating to another database
To copy a database, collection or table straight into another database, right-click it in the sidebar and choose Migrate to Another Database…. It's available on MongoDB databases and collections, and on SQL databases and tables, next to Export Data and Import Data.
The export wizard opens with your selection already filled in as the source and Database already chosen as the target type, so you only need to pick the target connection and database name. You can pick an existing database or type a new name.
- Cross-engine moves — the target connection doesn't have to match the source. Pick a SQL connection to move MongoDB data into SQL, or the other way round. See SQL Migration for how documents and tables are mapped.
- Prefer a file? Switch Target Type back to a file format at any time — the rest of the wizard works the same as a regular export.
- Run now or later — click Export Now to start straight away, or Save as Job to keep it in Data Transfer, where you can schedule it and follow its progress on the Monitor tab.
Task Types
Data Transfer supports various automation tasks for different data operations.
Export Tasks
Automatically export data from MongoDB collections to files.
| Export Option |
Description |
JSON |
Export to JSON format with optional pretty printing |
CSV |
Export to CSV with configurable delimiters and headers |
BSON |
Export in native MongoDB BSON format for backups |
SQL |
Export as SQL INSERT statements for migration |
Import Tasks
Schedule automated data imports from files or external sources.
- File Import: Import from JSON, CSV, or BSON files
- Field Mapping: Map source fields to destination fields
- Data Transformation: Apply transformations during import
- Upsert Mode: Update existing documents or insert new ones
Scheduling
Configure when and how often tasks should run.
Schedule Options
| Option |
Description |
One-Time |
Run once at a specific date and time |
Hourly |
Run every hour at a specific minute |
Daily |
Run once per day at a specific time |
Weekly |
Run on specific days of the week |
Monthly |
Run on specific days of the month |
Cron |
Custom cron expression for advanced scheduling |
Timezone Support
Tasks can be scheduled in any timezone. Data Transfer displays all times in your local timezone and handles daylight saving time automatically.
Task Monitoring
Monitor running tasks and view execution history.
Monitoring Features
- Real-Time Progress: Live progress bars and document counts
- Execution History: View past runs with start/end times and results
- Error Logs: Detailed error messages for failed tasks
- Statistics: Documents processed, skipped, and failed counts
- Duration Tracking: Execution time for performance analysis
Task Status
| Status |
Description |
Scheduled |
Task is waiting for its next scheduled run |
Running |
Task is currently executing |
Completed |
Task finished successfully |
Failed |
Task encountered an error |
Paused |
Task is temporarily disabled |
Task Actions
Manage tasks with various control actions.
- Run Now: Execute the task immediately, regardless of schedule
- Pause: Temporarily stop scheduled runs
- Resume: Reactivate a paused task
- Edit: Modify task configuration
- Clone: Create a copy of the task with new settings
- Delete: Remove the task permanently
- View History: See all past executions
Notifications
Get notified about task execution results.
Notification Options
- On Success: Notify when task completes successfully
- On Failure: Notify when task encounters an error
- On Warning: Notify when task completes with warnings
- Email Notifications: Send results to email addresses
- In-App Notifications: Desktop notifications in VisuaLeaf
Apply transformations to data during export, import, or sync operations.
- Field Mapping: Rename or restructure fields
- Data Type Conversion: Convert between types (string to date, etc.)
- Filtering: Include/exclude documents based on conditions
- Custom JavaScript: Write custom transformation functions
- Aggregation Pipeline: Apply aggregation stages before export
Task Settings
Configure task behavior and performance options.
| Setting |
Description |
Default |
Batch Size |
Number of documents to process per batch |
1000 |
Retry Count |
Number of retry attempts on failure |
3 |
Timeout |
Maximum execution time before timeout |
30 minutes |
Concurrent Tasks |
Maximum tasks that can run simultaneously |
2 |
Keep History |
Number of execution records to retain |
100 |
Pro Tips
- Test First: Run tasks manually before scheduling to verify configuration.
- Use Incremental Sync: For large datasets, incremental sync is much faster than full sync.
- Schedule Off-Peak: Schedule heavy tasks during off-peak hours to reduce database load.
- Monitor First Runs: Watch the first few scheduled runs to ensure they complete as expected.
- Set Up Notifications: Enable failure notifications to catch issues quickly.
- Use Transformations: Clean and transform data during migration to avoid manual post-processing.