Skip to Content.
Sympa Menu

en - [en@sympa] What subscriber fields can be synced with SQL data source?

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Gadi Vivier <address@concealed>
  • To: address@concealed
  • Subject: [en@sympa] What subscriber fields can be synced with SQL data source?
  • Date: Wed, 16 Nov 2022 00:38:46 +0000

Hi

Can a "SQL query" data source sync any other fields apart from the subscribers' email address (user_subscriber) and name (comment_subscriber)?

I have a list that successfully gets its subscribers' name and email address from a remote database.

REMOTE_DB.table
+-----------------------+--------+-------------+
| email | name | digest |
+-----------------------+--------+-------------+
| address@concealed | Gadi | mail |
| address@concealed | Mickey | mail |
| address@concealed | Donald | digestplain |


For the SQL query inclusion I am using:

"SELECT email AS user_subscriber, name AS comment_subscriber, digest AS reception_subscriber FROM remotedb.table".

The Sympa list syncs the subscriber_table with email (user_subscriber) and name (comment_subscriber) okay, but not the digest field (reception_subscriber).

SYMPA_DB.subscriber_table
+-----------------------+-----------------------+----------------------+
| user_subscriber | comment_subscriber | reception_subscriber |
+-----------------------+-----------------------+----------------------+
| address@concealed | Gadi | mail |
| address@concealed | Mickey | mail |
| address@concealed | Donald | mail |


Is it possible to get that digest field (reception_subscriber) to sync?

Thanks
Gadi


  • [en@sympa] What subscriber fields can be synced with SQL data source?, Gadi Vivier, 11/16/2022

Archive powered by MHonArc 2.6.19+.

Top of Page