The mailing list for listmasters using Sympa

[Marten Mattisen <address@concealed>]

The issue with that is the fact that everything after e-mail address is GECOS, which means that everything would be included in the Name field in Sympa and mess up personalized messages.

[% user.gecos %] would include all the extra information, which I would actually like to have in custom attribute fields. Maybe I could find the piece of code that defines fields in multiple add and add that after third space is custom_attribute_1/phone and after fourth space custom_attribute_2/address or something along those lines?

---

From: address@concealed
To: address@concealed
Subject: RE: [sympa-users] Allowing SQL query inclusion for list owners
Date: Wed, 17 Jun 2015 18:56:15 +0000

Sympa can import data from the UI or remote resources (file,ldap,etc…)  You just need to put the data into the form of:

 

Email address<sp>GECOS

 

e.g.

address@concealed Terry McLaren phone, other info, etc.

 

The trick is one entry per line and anything after the email is considered the GECOS so you have to manage the format.  You can cut and paste up to 500 entries via the web Admin > Manage Subscribers > Add a user:  (Multiple add) button

 

 

From: Marten Mattisen [mailto:address@concealed]
Sent: Wednesday, June 17, 2015 1:35 PM
To: McLaren, Terrence M
Subject: Re: [sympa-users] Allowing SQL query inclusion for list owners

 

Hi, sorry if I was causing a bit of confusion, but the functionality I am looking for is adding multiple list members (with multiple add or any of the ohter methods) with their additional information (a personal comment, phone number and the kind) without having to manually fill the information per subscriber. Let’s say I have a spreadsheet with mail addresses, names and phone numbers, I’d create a custom user attribute for phone number and would like to add all the subscribers with their phone numbers. Currently I haven’t found a way to do it without clicking on each and every subscriber and copy-pasting the relevant information.

 

From: McLaren, Terrence M
Sent: ‎Wednesday‎, ‎June‎ ‎17‎, ‎2015 ‎8‎:‎51‎ ‎PM
To: Marten Mattisen

 

Hi Martin – the include_file option refers to a path to a local file on the Sympa server and requires an admin to maintain the file.   We’ve discouraged this approach because it reduces list owner’s independence.    Those that use remote resources typically prefer:    

 

1)      The Remote file inclusion (include_remote_file) allows the list owner to maintain their own list on their own web server.   A couple of our Colleges generate membership lists from a local MSQL and publish the file daily to a password protected location on their web server.  Then Sympa pulls the file on an list owner defined time interval which is defined using the “Inclusions timeout (ttl)” and “Inclusions timeout for message distribution (distribution _ttl)” found at the bottom  data sources setup page.

2)      Or LDAP query inclusion (include_ldap_query) to query Active Directory.

 

Details about the various ways list owners can maintain the subscribers list are described at:  https://wiki.cites.illinois.edu/wiki/display/maillists/List+Owners+How-to+FAQ

 

Hope this helps,

 

-Terry McLaren

 

From: address@concealed [mailto:address@concealed] On Behalf Of Marten Mattisen
Sent: Wednesday, June 17, 2015 1:49 AM
To: address@concealed
Subject: RE: [sympa-users] Allowing SQL query inclusion for list owners

 

Thank you very much. Guess I didn't find the right words to search.

Got another one - 

include_file

include_file path_to_file

The file should contain one email address per line with an optional user description, separated from the email address by spaces (lines beginning with a '#' are ignored).

Sample included file:

  ## Data for Sympa member import

  address@concealed  John Smith - math department

  address@concealed  Sarah Hanrahan - physics department

I tested it out and the optional user description shows up in the "Name" field. Is this intended or is there something I am missing? Reason I am asking is that I am attempting to add a custom attribute, but also keep the simplicity of multiple add (some of my owners would like to use multiple add or similar simple solution to populate fields with other relevant information they have on the subscribers without copy-pasting it line by line to each subscriber's custom field from their personal Excel sheets/text files and whatnot).

 

Thanks again,

Marten

 

PS: Sorry if the next question should be a new thread, I am not totally familiar with general practices on technical mailing lists.

---

From: address@concealed
To: address@concealed
Date: Tue, 16 Jun 2015 15:07:47 +0000
Subject: RE: [sympa-users] Allowing SQL query inclusion for list owners

Marten – Attached is an example edit_list.conf I rewrote to follow the settings on Web interface.  I found it to me more intuitive when setting up which fields the owners see and can read or write via the web UI.  In general, we’ve decided to give read-write to appropriate config options to the “privileged_owner” and read only  to “owners”  unless the param is related to member management issues, then they get read-write.

 

Hope this helps,

 

-Terry McLaren

From: address@concealed [mailto:address@concealed] On Behalf Of David Verdin
Sent: Tuesday, June 16, 2015 6:22 AM
To: address@concealed
Subject: Re: [sympa-users] Allowing SQL query inclusion for list owners

 

Of course: https://www.sympa.org/manual/list-creation#list_editing

Le 16/06/15 13:18, Marten Mattisen a écrit :

Hi, 

 

I've run into a bit of a pickle. Logging in as an owner of a list, I can do LDAP related data source inclusion, but not SQL query inclusion, but when I am using my listadmin account, I get all the data source options. Is there a way of enabling all of the options for all list owners?

 

Thanks in advance,

Marten

 

--
A bug in Sympa? Quick! To the bug tracker!

David Verdin Études et projets applicatifs
Tél : +33 2 23 23 69 71 Fax : +33 2 23 23 71 21   www.renater.fr	RENATER 263 Avenue du Gal Leclerc 35042 Rennes Cedex