Contact person: Business Client

Phone:Show

Email:Show

Location: Wolverhampton, United Kingdom

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I have an Excel workbook that already holds everything I need to log new Jira issues—issue descriptions, user details, and project metadata—each clearly separated by column headers. What I need from you is a concise PowerShell script (plus a clean template sheet, if you prefer) that will read those columns, map them to the relevant Jira fields, and create tickets automatically through the Jira REST API.

The script must:
• Locate data strictly by the existing column headers, not by fixed cell ranges.
• Pass the Priority level and Assignee from the sheet into the new issue payload.
• Authenticate with Jira in a secure, easily configurable way (API token, basic auth, or OAuth—whichever you recommend for simplicity).
• Return the created issue keys to the sheet (or a log file) so I can confirm each ticket was opened successfully.
• Handle basic errors gracefully—missing required fields, invalid assignee, network failure—and flag the row for review rather than halting execution.

Please include clear comments in the code and a brief “read-me” style note so I can adjust column names or Jira field mappings later without digging through the entire script. If you prefer any specific PowerShell module (e.g., [login to view URL]), let me know; otherwise, use native Invoke-RestMethod calls.

Deliverables:
1. PowerShell (.ps1) script ready to run.
2. Sample or updated Excel template showing the exact column layout.
3. Short setup guide covering prerequisites and how to trigger the job.

I’m happy to test in my environment as soon as you provide a working draft." (client-provided description)