Subject: The mailing list for listmasters using Sympa
List archive
[en@sympa] What subscriber fields can be synced with SQL data source?
- 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+.