Working with the List Manager
Overview
The List Manager offers a graphical way to work with distribution lists without having to manipulate CSV (comma separated value) files.
Resizing columns
Columns can be resized in the List Manager just like in a spreadsheet program. To resize a column you can either click and drag the column header to a new width or you can double click a column header edge to automatically resize it to the size of the largest cell in that column.
Moving columns
You can drag and drop columns to a new order. This is very useful in making sure that the first column contains the destination
MSISDN number for each row. To drag and drop a column to a new location, click on the column header and drag it where you want it to go.
Adding rows
New rows can be typed into the blank row at the bottom of the data table.
Deleting rows
Rows can be deleted by selecting the entire row by clicking on the row you want to delete, then clicking on the small black arrow directly to the left of the row to select it. Finally press
del or backspace to delete the row.
Resizing rows
Rows can be resized to be taller or shorter in the same way as columns. To resize a row, click on its top or bottom border and drag the border out to a new size. To automatically size a row, double click the top or bottom border.
Sorting by a particular column
You can sort the contains of your table by clicking on the column header you want to sort by. By default this will sort the column in ascending order. To sort in descending order simply click the column header again. A small arrow in the column header will indicate whether the column is sorting in ascending or descending order.
Changing the number of columns
You can add or remove columns (up to a maximum of 6 and down to a minimum of 1) by changing the value of the 'Number of columns' box. Columns are always removed from the right and always added to the right.
Deleting a column
You can delete a column by moving that column to the rightmost position in the table and then decreasing the number of columns in the table by 1 (see 'Changing the number of columns').
Changing the header for each column
By default columns are named 'Column1', 'Column2' and so on. You can change the column headers by putting the column name you want to use in the first (topmost) row and then checking the 'First Row Contains Header' box.
If you already have customised column headers, you can uncheck the 'First Row Contains Header' box to revert to the standard column names. The customised column headers will appear as the first (topmost) row to be edited or deleted. You can restore them by checking the 'First Row Contains Header' box again.
Setting whether the first row contains data or a column header
You can set whether the first row in your table contains data or the headers for the columns by checking the 'First Row Contains Header' box.
Importing Excel and CSV documents
The List Manager can import Microsoft Excel 97, 2000, XP and 2003 xls files and CSV (comma separated value) files.
For more information, please consult these articles:
