Produits Entr'ouvert » Authentic 2

        'csv_importable': False,

table.main.left {

	padding-left: 1rem;

}

table.main.left td,

table.main.left th {

	text-align: left;

}

  <div class="section">

    <h3>{% trans "Imports" %}</h3>

    <table class="main left">

      <thead>

        <tr>

          <th>{% trans "Filename" %}</th>

          <th>{% trans "Creation date" %}</th>

          <th>{% trans "By" %}</th>

          <th>{% trans "Rows" %}</th>

          <th></th>

        </tr>

      </thead>

      <tbody>

        {% for import in imports %}

          <tr data-uuid="{{ import.uuid }}">

            <td><a href="{% url "a2-manager-users-import" uuid=import.uuid %}">{{ import.filename }}</a></td>

            <td>{{ import.created }}</td>

            <td>{{ import.user }}</td>

            <td>{{ import.rows_count }}</td>

            <td><form method="post">{% csrf_token %}<button name="delete" value="{{ import.uuid }}">{% trans "Delete" %}</button></form></td>

          </tr>

        {% endfor %}

      </tbody>

    </table>

  </div>

  <div class="section">

    <h3>{% trans "Help" %}</h3>

    <p>

      {% blocktrans trimmed %}

        The first line of your CSV file must be a header <a href="#help-attributes">mapping columns to user's attributes identifier</a>.

        Each user attribute name can be followed by <a href="#help-flags">flags</a> separated by spaces.

        You can also import an <a href="#help-external-identifier">external identifier</a> to prevent creating duplicates when doing multiple import from the same source.

      {% endblocktrans %}

    </p>

    <h4 id="help-attributes">{% trans "Attributes" %}</h4>

    <table class="main left">

      <thead>

        <tr>

          <th>{% trans "Label" %}</th>

          <th>{% trans "Identifier" %}</th>

        </tr>

      </thead>

      <tbody>

        {% for column in help_columns %}

          <tr>

            <td>{{ column.label }}</td>

            <td><var>{{ column.name }}</var></td>

          </tr>

        {% endfor %}

      </tbody>

    </table>

    <h4 id="help-flags">{% trans "Flags" %}</h4>

    <p>{% blocktrans trimmed %}Each column can receive flags after its name, separated by spaces. Each modifier can be prefixed by <var>no-</var> to set its value to false.{% endblocktrans %}</p>

    <table class="main left">

      <thead>

        <tr>

          <th>{% trans "Flag" %}</th>

          <th>{% trans "Meaning" %}</th>

          <th>{% trans "Default value" %}</th>

        </tr>

      </thead>

      <tbody>

        <tr>

          <td>key</td>

          <td>

            {% blocktrans trimmed %}

            The column is an import key, it is used to match the row with an existing user. Only one column can be an import key.

            {% endblocktrans %}

          </td>

          <td>{% trans "False" %}</td>

        </tr>

        <tr>

          <td>create</td>

          <td>

            {% blocktrans trimmed %}

            Values will be used when creating a new user.

            {% endblocktrans %}

          </td>

          <td>{% trans "True" %}</td>

        </tr>

        <tr>

          <td>update</td>

          <td>

            {% blocktrans trimmed %}

            Values will be used when updating an existing user.

            {% endblocktrans %}

          </td>

          <td>{% trans "True" %}</td>

        </tr>

        <tr>

          <td>unique</td>

          <td>

            {% blocktrans trimmed %}

            Values must be unique in the target organizational unit.

            {% endblocktrans %}

          </td>

          <td>{% trans "False" %} {% blocktrans trimmed %}

            (default is True for the <var>email</var> and <var>username</var> columns if they are configured to be unique in the target organizational unit)

            {% endblocktrans %}

          </td>

        </tr>

        <tr>

          <td>globally-unique</td>

          <td>

            {% blocktrans trimmed %}

            Values must be unique among all users.

            {% endblocktrans %}

          </td>

          <td>{% trans "False" %} {% blocktrans trimmed %}

            (default is True for the <var>email</var> and <var>username</var> columns if they are configured to be globally unique)

            {% endblocktrans %}</td>

        </tr>

        <tr>

          <td>verified</td>

          <td>

            {% blocktrans trimmed %}

            Values are verified.

            {% endblocktrans %}

          </td>

          <td>{% trans "False" %} {% blocktrans %}(default is True for the <var>email</var> column){% endblocktrans %}</td>

        </tr>

      </tbody>

    </table>

    <h4 id="help-external-identifier">{% trans "External identifier" %}</h4>

    <p>

      {% blocktrans trimmed %}

        You can also use two special columns <var>_source_name</var> and

        <var>_source_id</var>. <var>_source_name</var> must be the name of the

        source directory from which the users are exported, it must not

        change between imports. <var>_source_id</var> is the unique identifier

        from the source directory from which the users are extracted, it must

        not change between imports and should never be reused for different

        users. <var>_source_id</var> is automatically the key column, and you

        cannot use another key column.

      {% endblocktrans %}

    </p>

    <h4>{% trans "Examples" %}</h4>

    <p>Importing first and last name of users keyed by email</p>

    <blockquote>

      <pre>"email key",first_name,last_name

john.doe@example.com,John,Doe

</pre>

    </blockquote>

    <p>Importing verified first and last name of users keyed by email</p>

    <blockquote>

      <pre>"email key","first_name verified","last_name verified"

john.doe@example.com,John,Doe

</pre>

    </blockquote>

    <p>Importing email, family_reference, first and last name of users from application <var>app1</var>, ensuring family_reference is unique.</p>

    <blockquote>

      <pre>_source_name,_source_id,email,"family_reference unique",first_name,last_name

app1,1,john.doe@example.com,1234,John,Doe

</pre>

    </blockquote>

  </div>

import base64

User = get_user_model()

        help_columns = []

        field_columns = ['username', 'email', 'first_name', 'last_name']

        key = 'username'

        if not has_show_username():

            field_columns.remove('username')

            key = 'email'

        for field_column in field_columns:

            field = User._meta.get_field(field_column)

            if Attribute.objects.filter(name=field.name).exists():

                continue

            help_columns.append({

                'label': field.verbose_name,

                'name': field.name,

                'key': field.name == key,

            })

        for attribute in Attribute.objects.all():

            kind = attribute.get_kind()

            if not kind.get('csv_importable', True):

                continue

            help_columns.append({

                'label': attribute.label,

                'name': attribute.name,

                'key': attribute.name == key,

            })

        ctx['help_columns'] = help_columns

        example_data = u','.join(column['name'] + (' key' if column['key'] else '') for column in help_columns) + '\n'

        example_url = 'data:text/csv;base64,%s' % base64.b64encode(example_data.encode('utf-8'))

        ctx['form'].fields['import_file'].help_text = format_html(

            _('{0}. {1} <a download="{3}" href="{2}">{3}</a>'),

            ctx['form'].fields['import_file'].help_text,

            _('ex.:'),

            example_url,

            _('users.csv'))