1. Preparation

Create four fields in the « A2ind_individu » FileMaker database—using the specific names and order required for automatic processing by the « MailSubscribers 4.0.3 » plugin on SPIP :

1. email
2. nom
3. lang
4. statut

These fields are populated via conditional calculations with the values ​​from :

1. a5courriel
2. indNP
3. Langue
4. « valide »

After selecting the contacts, export these 4 fields to .xls format to ensure the headers appear in the first row ; name the export file—for example, « rubrique gdds multi » (« multi » for multilingual).

2. Formatting with OpenOffice

1. Open the .xls file
2. Select the .csv format
3. Save the file with a prefix added to the original name to distinguish it from the previous version.

3. Processing in SPIP

a) Creating a mailing list

Name it, for example, « rubrique gdds multi »

Add segments for each language used in the destination section (for the GDDS group, these are FR, DE, IT, EN)

Import the .csv file

1. Preview to check the layout of the 4 columns : email, nom, lang, statut
2. Import
3. Link this contact list to the « rubrique gdds multi » mailing list—the contacts will automatically be sorted into their respective language segments.

   

b) Creating a newsletter

using the « Newsletters 3.3.0 » plugin :

1. name it « rubrique gdds multi » and
2. add the suffix for the language of use (e.g., « DE »),
3. set the frequency,
4. select the language,
5. select the site section from which the newsletter will draw announcements for new articles published during the chosen period (articles announced will be those with a timestamp later than the newsletter’s timestamp—if necessary, change the article status to « proposed » and then « publish »),
6. select the mailing list for recipients : in this case, choose the « DE » segment within « rubrique gdds multi »,
7. save.

Finally, regarding articles intended for the "<rubrique gdds multi" section

After ensuring that the translations—along with the necessary multilingual tags—have been entered into the article’s Title and Tooltip fields, simply create translations starting from the French version and then translate the body text into each respective language.

PS : The mailing list has 26 recipients as of October 1, 2096, at 17:34.