Modifying your directory data offline

To make multiple or global changes that would be time-consuming in the Entry window, you may export your entries from ClickMail, modify them offline, then import them back into ClickMail. You may export in LDIF format and edit in a text editor, or use Tab-delimited format to bring the data into FileMaker and work with it there.

When re-importing tab-delimited data, be sure the field list shown when you choose Import... matches the tab-delimited file.

• If you do not include all attributes in your directory's entries when you export and import, you may delete attributes from existing entries in your directory when you reimport them. To eliminate this possibility, You can use the "Current" setting when you export, which ensures that all existing attributes are exported (Lists menu—Current Database Attributes). However, to bring this file into the FileMaker template, you must drag the fields into proper order when you import.

Here's the step-by-step procedure:

1. From the File menu, choose Export->Tab-delimited. This exports all records (except the DSE). Unless you have non-people records (such as "ou" department records), use the default setting of "Export People Only". Use the Standard attribute list (Lists menu) unless you have other attributes not on the list (in that case, try the "Current" list).
   • Here's another way to see all attributes in use: From the Database menu choose Attributes.
2. Open the Import/Data Utility in FileMaker. Click the Import button.
3. The default field list matches the "Standard" list in ClickMail. Make changes by dragging if you used Current or your own list. (Note that the little arrows must be on for each field you want to import.) When the list is correct, click "Import".
4. Modify your data as desired in FileMaker. Scripts are provided to auto-create distinguished names, common names, first names and last names.
   • If you will be reimporting back into the same datafile, you may delete entries which you are not changing (such as the subschema entry, "emailPerson").
5. Export to a new tab-delimited file. If you used a special field order when you imported, choose Export Records from the File menu to export in the same order (check the pop-up menu for "Last Order"). If you are using the standard order, click the Export button instead.
6. In ClickMail, you may either import into the current datafile or start a new file. (For example, a new file would be needed if you changed some distinguished names). To start a new file, from the File menu choose Configure, click New, name the file, click Save, enter any other settings, then click OK.
7. In ClickMail, from the File menu choose ImportTab-delimited. The last-used field order is displayed (even if you are working in a new datafile). Choose the appropriate field order and import your data.
   • If reimporting into the original datafile, each imported entry replaces its matching existing entry. ClickMail identifies matching entries by comparing the distinguished name.
8. Check your new entries by choosing Entries from the Database Menu.