trac ticket export to gitlab csv

convert.py

#!/usr/bin/env python3

import csv
import sys

# Check if an input file is provided
if len(sys.argv) < 2:
    print("Usage: python convert_to_gitlab.py <input_csv_file>")
    sys.exit(1)

input_file = sys.argv[1]
output_file = f"{input_file}_gitlab.csv"

# Read the input CSV and write to output in GitLab format
with open(input_file, newline='', encoding='utf-8') as csvfile, open(output_file, 'w', newline='', encoding='utf-8') as outfile:
    reader = csv.DictReader(csvfile)
    writer = csv.writer(outfile)
    
    # Write the header
    writer.writerow(["title", "description"])
    
    for row in reader:
        title = row.get("Summary", "").strip()
        if title:  # Ensure title is not empty
            writer.writerow([title, title])

print(f"Conversion complete. Output saved to {output_file}")

This will take the export of a trac query csv file, and simply convert it into gitlab format to be imported. (Will only take the title and description. Nothing else.