Skip to Content.
Sympa Menu

en - Re: [sympa-users] Question regarding configuring personalized messages (ie mail merge)

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Albert Wu <address@concealed>
  • To: "address@concealed" <address@concealed>
  • Cc: "address@concealed" <address@concealed>
  • Subject: Re: [sympa-users] Question regarding configuring personalized messages (ie mail merge)
  • Date: Fri, 5 Feb 2021 17:11:35 +0000

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

 

 

 




Archive powered by MHonArc 2.6.19+.

Top of Page