@extends('layouts.app') @section('title', 'Import Target · QA Dashboard') @section('content')

Import Target

Set each project's Quarter Targets. Pick the quarter, then upload the BA target sheet as CSV (in Google Sheets: File → Download → CSV), paste Jira links, or do both in one go.

@if (session('status'))
{{ session('status') }}
@endif @if ($errors->any())
{{ $errors->first() }}
@endif @foreach ($projects as $name => $p)

{{ $name }} @if ($p['total']){{ $p['total'] }} stories imported@endif

@csrf
Quarter
Target sheet (CSV)
Jira links
@if (!empty($p['by_quarter'])) @endif

A CSV replaces that quarter's target list (your confirmed matches carry over); Jira links are added to it. Rows with a Jira key auto-link, keyless rows are title-matched for you to confirm.

@if (!empty($p['by_quarter']))
Imported quarters
@foreach ($p['by_quarter'] as $q => $c)
{{ $q }} · {{ $c }} stories Open
@endforeach
@endif
@endforeach

Expected CSV columns: a story/title column (e.g. Module, Story, Target story) and, where available, a Jira key column (Jira, Key, Issue).

@endsection