Exporting contacts

The Export menu produces an Excel file of the grid, or the J+S file of your members.

1. 1Exportopens the menu.
2. 2The exportsExport to Excel, and Export to JS for the J+S file.

1. 1Click Export › Export to Excel.
2. 2Set the options of the Export to Excel window, then click Execute.

1. 1EntriesAll rows exports the rows displayed in the grid, with your filters and your sort. Selected rows exports only the selected members.
2. 2DestinationLocal download saves the file in your browser's downloads. Documents area asks you for the folder, then saves the file in the Documents module.
3. 3Filenamesuggested with today's date, or with the name of the selected group. The .xlsx extension is added.
4. 4Export all columnsunticked, the file takes the columns displayed in the grid, in the same order. Ticked, it contains all the available columns.
5. 5Executeproduces the file.

The J+S export produces the file of the members for the national sports database (BDNS) of Youth+Sport.

1. 1Select the members to export: with no selection, Export to JS stays greyed out.
2. 2Click Export › Export to JS.
3. 3Read the summary, then click Download CSV.

1. 1The members exportedtheir record contains all the data J+S requires.
2. 2The members excludedeach with the fields that are missing, here the AVS number. Complete their record, then run the export again.
3. 3Download CSVsaves the file, named with today's date. The button is greyed out if no member is exported.

A member is exported if their record contains the last name, the first name, the date of birth, the gender, the AVS number, the nationality, the language, the postal code, the city and the country. The J+S number and the street are not required.