Dashboard
Overview of your CSV workflow system
Download URL:—
S3 Bucket:—
SMTP Server:
—
Sender Email:
—
Notification Email:
—
IMAP Server:
—
Listener Email:
—
Status Timeout:
—
Run Workflow
Execute the CSV download, verify, and upload process
Waiting for import status email...
Expected around --:--
Monitoring for 10 minutes total
📥 Review Failed Import File
The CSV file failed to import. You can view and download it to review and fix the issues.
Error Details:
Schedule Workflow
Set up automatic execution times
Select specific days or leave unchecked for every day
No scheduled times
Run workflow repeatedly at regular intervals
No interval schedules
Execution History
View past workflow executions
Settings
Configure workflow behavior
Download CSV file from the configured URL
Validate CSV structure and content
Upload verified CSV to AWS S3 bucket
Remove rows with crop_name_variety_id > 5 (keep only 1-5)
Remove exact duplicate rows where all columns match
Remove duplicate latitude/longitude coordinates - SECOND check, only 1 record per coordinate
Remove coordinates within detection perimeter radius of existing coordinates
Remove rows with blank unique_village_info_id
Validate Region/Department/Subprefecture/Locality against master data (invalid rows saved to error_rows.csv)
Validate shape column format (lat long 0.0 0.0; ...) - invalid rows saved to error_rows.csv
Validate latitude/longitude values exist and are within valid ranges (-90 to 90, -180 to 180) - invalid rows saved to error_rows.csv
Automatically number duplicate blocknames sequentially (e.g., Farm-1, Farm-2, Farm-3) - Runs last before upload
Note: Changes are saved automatically and will persist across restarts.
URL to download CSV files from
Name of the S3 bucket for uploads
Full S3 URL: s3://not-configured
Your AWS access key for S3 uploads
Your AWS secret key (kept secure)
⚠ Security Note: Credentials are stored securely on the server and never transmitted to the browser after saving.
ℹ Required IAM Permissions:
The IAM user must have the following permissions for the S3 bucket:
s3:PutObject- Upload files to the buckets3:GetObject- Read files from the bucket (optional)s3:ListBucket- List bucket contents (optional)
If you get "AccessDenied" errors, contact your AWS administrator to add these permissions to your IAM user policy.
SMTP server address for sending emails
Port number (465 for SSL, 587 for TLS)
Email address to send notifications from
Password or app-specific password for sender email
Default email address to receive notifications
Choose when to send email notifications for scheduled tasks
IMAP server address for checking emails
Port number (typically 993 for SSL)
Email account to monitor for status notifications
Password or app-specific password for listener email
Filter status emails from this sender (optional)
Maximum time to wait for status email
ℹ Note: Email monitoring checks for import status notifications after CSV files are uploaded to S3.
Enter the column names that must be present in uploaded CSV files. Leave empty to skip header validation.
⚠ Warning: CSV files missing any required headers will fail verification and won't be processed.
Menu
App navigation and options