Prepare guidance for a rejected import file

A draft row-level import diagnosis with safe correction examples citing schema rules.

Choose one of three approaches. The steps for that option appear below.

Choose an option above. On a phone, swipe the tabs left or right to see all options →

Gemini: extracts the failures and drafts, you check

Gemini builds the failure worksheet, then drafts the diagnosis. You check the worksheet first, then the draft.

  1. You

    Collect the case material

  2. Gemini

    Compare rows with schema

  3. You

    Check the worksheet

  4. Gemini

    Draft the diagnosis

  5. You

    Check the draft

  1. Have ready: file sample, import schema, error text

    Use: You

    A file sample (not live customer data), the approved import schema and the validation error text.

    Check

    Check your organisation's rules before uploading case material to any tool; this record does not establish that upload is permitted. Never paste credentials or full payment details.

  2. Compare each failed row with the schema rules

    Use: Gemini

    Add the case material to Gemini and ask for a worksheet listing each failed row with field, value, broken rule and rule reference.

    Details

    What to paste into the tool

    Task: Evidence worksheet: one row per failed row with field, value, violated schema rule and rule reference. For each failed row, list the field, the value as given, the schema rule it breaks and the rule reference. If the schema or error text does not explain the failure write not stated. Do not invent missing values. Do not run code, send anything or change any record.

  3. Check the worksheet against the originals

    Use: You

    Compare every worksheet row with the original material; correct rows and fill gaps with not stated.

    Check

    Check claims, values, chronology and rule applicability against the originals for this case: Date formats and required identifiers fail validation. Do not fill missing or contradictory facts by inference.

  4. Draft the diagnosis and corrections

    Use: Gemini

    Give the corrected worksheet to Gemini and ask for a row-level diagnosis and correction examples, each citing a schema rule, without importing or overwriting.

    Details

    What to paste into the tool

    Task: Draft row-level diagnosis and correction examples that each cite a schema rule. Using only the corrected worksheet and the approved import schema, draft a row-level diagnosis and one correction example per failed row, each citing its schema rule. Where data is missing write not stated. Do not import, overwrite or invent data. Do not run code, send anything or change any record.

  5. Check the draft and share as draft only

    Use: You

    Mark open questions and hand the draft to its owner as a draft only.

    Check

    Check every proposed correction cites a schema rule and no missing data is invented. Check recipient scope and required authority before later use; the draft is not approval. Preparation only.

Before you paste into any AI tool, remove any confidential information. Put it back at the end.

Tools in this workflow

Final check

Every extracted claim is compared with the original material by a person before use.

Gaps and conflicts stay marked UNKNOWN; none are filled by inference.

The named reviewer confirms the evidence and the draft; completion is preparation only.

Check your organisation's data-handling rules before uploading case material to any tool.

Check the result against your original inputs. Approve it before sharing or acting.

Share this page