Robot Framework Test Case Auto-Generator for Automotive Cluster Alerts

Description

This project is a portfolio version of an industrial tool developed during my internship at Ampere Software Technology (Renault Group). It provides a Python-based generator that automatically generates Robot Framework test cases for automotive cluster alert validation.

The tool processes structured alert specifications (Excel files) and transforms them into ready-to-execute Robot Framework scripts, using a predefined and standardized validation template. This automation ensures consistency, reduces human error, and significantly accelerates test authoring for large alert datasets.

Features

• Excel-driven generation
  Reads test cases specs from input/*.xlsx and builds a Robot Framework test case in output/.

• Template-based scripts (37 steps)
  Copies TC_Template.robot and programmatically fills its 37 standard steps based on the Excel parameters.

• Rule-based applicability
  For each step, decides if it is Applicable, Not Applicable, or Not yet covered using fields like AlertTypeON/OFF, Blinking_freq, Time_out, Color, Picture, Text_ID, Reminded, and Acknowledgeable.

• Automatic keyword insertion & comments
  Replaces # Auto : placeholders with generated comments and Robot keywords (Set State, Compare Image, Sleep), explaining how each step is derived from the Excel table.

• Consistency and safety checks
  Tracks implementation of all 37 steps and prints an error if any step was not correctly processed.

Requirements

• Ubuntu 22+ (or any OS with Python 3.10+)
• Python 3.10+
• Python dependencies:
  • pandas
  • openpyxl
• Input files:
  • One Excel .xlsx file in input/
  • One Robot Framework template in template/

Installation

Install Python dependencies:

python3 -m pip install pandas openpyxl

Usage

1. Place the Excel file in input/ (e.g., input/1104265.xlsx).
2. Place the template file in template/ (e.g., template/TC_Template.robot).
3. Run the generator:

python3 ./src/tc_generator.py

The generated Robot Framework file will be created in output/ with the same base name as the Excel file.

Template conventions

When modifying the template, keep these markers intact:

• # Step step_number means #<space>Step<space>step_number<space> (e.g., # Step 1 ).
• # Auto : means #<space>Auto<space>: