Validate a DATEV EXTF file
validate_datev_extfValidate DATEV EXTF CSV files before import or after rejection. Get line, field, and plain-language explanations for issues like decimal commas, leading zeros, account length, encoding, and header errors.
Instructions
Check a DATEV-Format (EXTF) CSV file, e.g. EXTF_Buchungsstapel.csv or a Debitoren/Kreditoren export, before importing it into DATEV or after DATEV rejected it. Returns every problem with line, field and a plain-language explanation in German or English: dot instead of comma in amounts, missing leading zeros in Belegdatum, BU-Schlüssel on automatic accounts, account length, encoding, header errors and more. Pass a file path (preferred, the encoding is checked too) or the file content.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| lang | No | Language of the messages: de (default) or en. | de |
| path | No | Path to the CSV file on this machine. Relative paths resolve against the server's working directory. | |
| content | No | The file content as text, if there's no file. The encoding can't be checked this way. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| errors | Yes | ||
| header | No | ||
| category | No | buchungsstapel, debkred or other | |
| encoding | Yes | ||
| findings | Yes | ||
| warnings | Yes | ||
| truncated | Yes | ||
| disclaimer | Yes | ||
| countsByCode | Yes |