Windows CSV AI Rewriter
Budget: $30 – $250 AUD
I need a small Windows-friendly utility—either a compiled .exe or a well-packaged script—that I can schedule with Task Scheduler. When it runs, it should:
• Read a local INI file (plain-text, single header section) that supplies three keys:
INFILE, OUTFILE and RULE.
Example:
[Settings]
INFILE=C:\TEXTIN\Description1.csv
OUTFILE=C:\TEXTOUT\Description2.csv
RULE=Rewrite text removing any html codes and removing any blank lines
• Open the source CSV, which always contains exactly two columns: <ProductCode> and <Description> (≈100 rows, English only).
• For each row, send the Description to a large-language-model service—OpenAI GPT-4-Turbo or another platform you consider cost-effective and stable—to apply the RULE in plain English and return a cleaned, rewritten Description capped at 1000 characters.
• Write a new CSV to the path in OUTFILE, preserving the original ProductCode and appending the AI-generated Description as the second column.
• Log any runtime problems—missing files, bad CSV structure, API failures—to a separate timestamped .log file in the same folder as the executable.
Primary acceptance criteria
1. Runs unattended under Windows 10/11 from Task Scheduler.
2. Consumes the INI exactly as described.
3. Produces the expected OUTFILE with no extra columns or reordered rows.
4. Graceful error handling with detailed log output.
5. Clear setup notes, including API sign-up steps and estimated token costs for the recommended AI provider.
Feel free to build in Python, PowerShell or C#—whichever lets me run the task without installing heavyweight dependencies. A simple README and a sample INI/CSV pair are all I need to get started.
• Read a local INI file (plain-text, single header section) that supplies three keys:
INFILE, OUTFILE and RULE.
Example:
[Settings]
INFILE=C:\TEXTIN\Description1.csv
OUTFILE=C:\TEXTOUT\Description2.csv
RULE=Rewrite text removing any html codes and removing any blank lines
• Open the source CSV, which always contains exactly two columns: <ProductCode> and <Description> (≈100 rows, English only).
• For each row, send the Description to a large-language-model service—OpenAI GPT-4-Turbo or another platform you consider cost-effective and stable—to apply the RULE in plain English and return a cleaned, rewritten Description capped at 1000 characters.
• Write a new CSV to the path in OUTFILE, preserving the original ProductCode and appending the AI-generated Description as the second column.
• Log any runtime problems—missing files, bad CSV structure, API failures—to a separate timestamped .log file in the same folder as the executable.
Primary acceptance criteria
1. Runs unattended under Windows 10/11 from Task Scheduler.
2. Consumes the INI exactly as described.
3. Produces the expected OUTFILE with no extra columns or reordered rows.
4. Graceful error handling with detailed log output.
5. Clear setup notes, including API sign-up steps and estimated token costs for the recommended AI provider.
Feel free to build in Python, PowerShell or C#—whichever lets me run the task without installing heavyweight dependencies. A simple README and a sample INI/CSV pair are all I need to get started.
Related categories:
Python
Data Processing
C# Programming
Software Development
Scripting
Automation
API Integration
OpenAI