Skip to content

Task Creator Tool

Javapackage: com.etendoerp.copilot.toolpack

Overview

The Task Creator Tool automates the creation of tasks based on the content of a file. It supports ZIP, CSV, XLS, and XLSX formats. Each file or row extracted from the input becomes a separate task, making it ideal for bulk task creation based on structured data.

Info

To be able to include this functionality, the Copilot Extensions Bundle must be installed. To do that, follow the instructions from the marketplace: Copilot Extensions Bundle. For more information about the available versions, core compatibility and new features, visit Copilot Extensions - Release notes.

Tip

To know when is the best time to use this tool or how there are executed this tasks, check the How to create bulk tasks for Copilot guide.

This tool provides the assistant with:

  • Bulk Task Creation: Automatically generate multiple tasks from one file.
  • Multi-format Support: Works with .zip, .csv, .xls, and .xlsx.
  • Smart Defaults: Automatically detects and creates missing task types, statuses, or group IDs if not provided.
  • Parallel Execution: Creates tasks concurrently for better performance.

It is especially useful for team collaboration, project onboarding, data entry workflows, and recurring structured task setups.

Setup

The tool doesn’t require specific environment variables from the user. However, it depends on the internal Etendo configuration for token and host retrieval, using the ETENDO_TOKEN and ETENDO_HOST values internally. These values are handled securely and are never exposed to the model.

Supported File Formats

  • ZIP: A task is created for each extracted file.
  • CSV / Excel (XLS, XLSX): A task is created for each row (excluding the header), with data mapped as key-value strings.
  • Other Files: A single task is created using the full file path.

Functionality

The tool follows these main steps:

  • Input Processing

    Accepts the following parameters:

    • question: Description or request that will be used as the task base.
    • file_path: Path to the input file (ZIP, CSV, XLS, or XLSX).
    • group_id: Optional group ID. If not set, it uses the conversation ID.
    • task_type_id: Optional task type ID. If not set, it auto-creates one named "Copilot".
    • status_id: Optional status ID. Defaults to "Pending".

  • File Extraction

    Depending on the file type:

    • ZIP: Unzips and lists file paths.
    • CSV/XLS/XLSX: Reads and converts each row to a string representation.

  • Task Generation

    For each extracted item (file path or row), it generates a task with:

    • The base question + item content.
    • The associated task_type, status, group_id, and the current assistant ID.

  • Secure Token Use

    The tool retrieves the Etendo access token using ETENDO_TOKEN, ensuring sensitive values are resolved securely before execution and are not visible to the model.

  • Parallel Execution

    Tasks are created in parallel using up to 10 concurrent threads to optimize performance.

  • Final Response

    Returns:

    {
    "message": "Bulk Task creation process completed, the tasks from this batch group has the group id: <group_id>"
}

Usage Example

You have a .csv file with a list of customer feedback. Each row should become a separate task under the same group. You would input:

  • question: Review feedback
  • file_path: /path/to/feedback.csv
  • group_id: 123456789
  • task_type_id: (optional)
  • status_id: (optional)

The Task Creator Tool will process each row and generate a task with the base question + the row's data. If task type or status is not set, it creates default values.

This helps you automate large-scale task generation in just one step, saving time and avoiding manual entry.