The mailing list for listmasters using Sympa

[address@concealed]

Hello,

I've just been editing these values through the backend. These days I have been reading in the docs about custom attributes. If I understand this right:

Custom attributes provisioning

Custom attributes can be provided using two mutually exclusive ways:

1. manually by the user
2. extracted from an LDAP or SQL repository (see include_ldap_ca and include_sql_ca list configuration parameters).

(Source: https://sympa-community.github.io/manual/customize/custom-user-attributes.html)

It should be possible to import the custom attributes through ldap or sql.

regards,

Christoph Holtermann

Am 2021-02-05 18:11, schrieb Albert Wu:

Thank you Christoph.

 

Do you edit these fields only in the web UI, or is there a way to import data into them from an external data source or via the add multiple user UI?

 

albert

 

On 2/5/21, 1:30 AM, "address@concealed" <address@concealed> wrote:

 

Hello,

thats my script btw:

#!/bin/bash
/usr/bin/docker exec -t forum-am_db_1 bash -c "mysql --password=PASSWORD -e 'use sympa;update subscriber_table set custom_attribute_subscriber=CONCAT(\"<?xml version=\",CHAR(34 using latin1),\"1.0\",CHAR(34 using latin1),\" encoding=\",CHAR(34 using latin1),\"UTF-8\",CHAR(34 using latin1),\" ?><custom_attributes><custom_attribute id=\",CHAR(34 using latin1),\"beruf\",CHAR(34 using latin1),\"><value></value></custom_attribute><custom_attribute id=\",CHAR(34 using latin1),\"gaaed_mitglied\",CHAR(34 using latin1),\"><value></value></custom_attribute><custom_attribute id=\",CHAR(34 using latin1),\"sonstige_text\",CHAR(34 using latin1),\"><value></value></custom_attribute><custom_attribute id=\",CHAR(34 using latin1),\"zweitemail\",CHAR(34 using latin1),\"><value></value></custom_attribute></custom_attributes>\") where list_subscriber = \"mail\" and custom_attribute_subscriber IS NULL;'"

These are my custom attributes. There used to be a version of sympa where the attributes got generated. I used that as a template. If you don't have that, then it's a bit more tricky. I thought it might be something in my system config but when it happens to others it looks like a bug.

regards,

Christoph Holtermann

Am 2021-02-05 01:10, schrieb address@concealed:

Hello,

for some time the custom attributes don't appear on newly created users. As a workaroung I created a script that creates empty custom attribute values in the database for new users. Then they appear and are editable in the web interface. I am using sympa 6.2.60 now.

regards,

Christoph Holtermann

 

Am 2021-02-04 22:25, schrieb Albert Wu:

Hello,

 

I am evaluating the message personalization feature in Sympa (6.2.56) to see if we can use it to send personalized messages to the list subscribers.

 

So far, I've been able to send a personalized message containing attributes already defined in Sympa (user.email, user.gecos, etc.). I have also been able to create a custom user attribute using the Sympa user interface (under Edit List Config -> Miscellaneous).

 

 

Two questions:

 

1. Where might I find a list of all available Sympa attributes I can use in a message template? The Sympa Admin Guide doesn't seem to have an obvious listing.
2. How do I populate values for the custom attribute I've defined? I see an additional column with my custom attribute as the column heading on the subscriber list, but the attribute doesn't appear in the edit UI. More importantly, how do I populate that when adding users in bulk?

 

Thanks in advance.

 

albert

 

Albert Wu

Federation Service Manager

InCommon / Internet2 Trust & Identity