EASQLToCSVEmail

This document was generated using Claude.ai

Overview

Executes a SQL query, exports results to CSV format, and emails the CSV file as an attachment. Uses Tempo templates for dynamic content generation including attachment names, email subjects, and body text.

When This Action Runs

Manual execution for generating and emailing data exports, reports, or data extracts to specified recipients with CSV attachments.

How It Works

  1. Executes SQL query - Runs the provided SQL query against the database
  2. Generates CSV content - Converts query results to CSV format with specified delimiter and headers
  3. Creates temporary file - Saves CSV content to a temporary file with dynamic naming
  4. Renders email content - Uses Tempo templates to generate subject and body text
  5. Sends email - Creates and queues email with CSV attachment for delivery

Parameters

Parameter 1: SQL Statement (Required) - SQL query to execute and export

Example Query:

select code,creationDate [creationDate#ddMMyyy HH:mm:ss] from Employee

Parameter 2: Delimiter (Required) - CSV field delimiter (e.g., , or ; or |)

Parameter 3: Attachment Name Tempo (Required) - Dynamic filename template using Tempo syntax

Parameter 4: Headers Line (Optional) - CSV column headers (uses SQL column names if empty)

Parameter 5: Send To Emails (Optional) - Comma-separated recipient email addresses

Parameter 6: Subject Tempo (Required) - Email subject template using Tempo syntax

Parameter 7: Body Tempo (Required) - Email body template using Tempo syntax

Parameter 8: Preferred Sender ID (Optional) - Sender configuration ID

Database Tables Affected

  • Query Target Tables - Reads from tables specified in the SQL query
  • PendingTask - Creates email task for delivery queue
  • Temporary Files - Creates temporary CSV files for attachment

Important Warnings

⚠️ SQL Query Requirements

  • Query must be valid SQL and return data suitable for CSV export
  • Large result sets may cause performance issues and large file attachments
  • Use proper WHERE conditions to limit result size when appropriate

⚠️ Email and File Handling

  • Temporary files are created on server file system
  • Large CSV files may exceed email attachment size limits
  • Email delivery depends on mail server configuration and availability

⚠️ Tempo Template Requirements

  • All Tempo templates must be valid and use correct syntax
  • Template variables must reference available entity properties
  • Invalid templates may cause email generation to fail

⚠️ Security Considerations

  • SQL query has full database access permissions
  • Email addresses are not validated before sending
  • CSV files may contain sensitive data - consider recipient permissions

⚠️ Performance Impact

  • Large queries may impact database performance
  • CSV generation and file operations consume server resources
  • Email queue processing may be delayed for large attachments

Module: core

Full Class Name: com.namasoft.infor.domainbase.util.actions.EASQLToCSVEmail

Related Actions: