There are times when a group of patrons from the Theatre Manager database may need to be exported and imported back into Theatre Manager in order to create a new mail list. This might be required:
Before using the import features, we suggest making a backup of the database - just in case. |
This will open the Import Data window.
For more information on the Import Data window, click here.
An Open File dialog for the user's operating system will appear.
Once the file has been selected, the column headers will appear in Step 2 of the window. Scroll through the list to ensure MKT_C_SEQ appears next to Patron # For Marketing Record and PM_SHORT_NAME appears next to Mail List Name. If a column header from the import file does not automatically match, drag the column from the left to the matching line on the right.
The MKT_C_SEQ should be listed in Step 3 next to Patron # For Marketing Record. This line should be highlighted by default.
A warning message will appear.
At the bottom of the Data Import window, a message will appear to show the import has started.
Depending on how much data is being imported, the import routine can take some time to run.
When the import is complete, a final dialog will appear.
The Patrons have now been added to the Mail List. The Mail List can be opened and reviewed for details.