{% extends "vantage/base.html" %} {% load static vantage i18n %} {% block head %} {% endblock %} {% block content %}

{% translate "Map columns" %}

{% blocktranslate count counter=row_count %}{{ counter }} row{% plural %}{{ counter }} rows{% endblocktranslate %} · {{ encoding }} · {% blocktranslate %}delimiter {{ delimiter }}{% endblocktranslate %}

{% csrf_token %}
  1. 1 {% translate "Upload" %}
  2. 2 {% translate "Map columns" %}
  3. 3 {% translate "Preview" %}
{% if error %} {% endif %}
{% csrf_token %}

{% translate "Your columns" %}

{% blocktranslate trimmed %}Each column feeds one field, or nothing. The first values from your file are shown so you can check the guess without opening the spreadsheet again.{% endblocktranslate %}

{% for column in columns %} {% endfor %}
{% translate "Column in your file" %} {% translate "First values" %} {% translate "Field it writes" %}
{{ column.header }} {% for sample in column.samples %} {{ sample|default:"—" }} {% endfor %}

{% translate "What to do with each row" %}

{% comment %} Only unique columns are offered. Matching on something non-unique would pick an arbitrary row to overwrite, which is the worst kind of silent data loss. {% endcomment %} {% blocktranslate trimmed %}Only the primary key and unique columns can identify a record, and only if you mapped one above.{% endblocktranslate %}

{% translate "Then" %} {% for mode in modes %} {% endfor %}

{% blocktranslate trimmed %}Only the modes your permissions allow are listed. Updating needs the change permission; an upsert needs both.{% endblocktranslate %}

{% translate "Cancel" %}
{% endblock %}