How Can ListManager Use My Data?
ListManager uses a single members table which contains the email addresses and other information it needs about the people to send messages to. You may already have data about your list members in your own SQL database, and you'd like to use this data when sending out mail using ListManager. There are a number of ways of having ListManager use this data, depending on how your database is set up and how you'd like it to work. Here are some suggestions:
1. Add columns with pertinent member information to your ListManager Members_ table, and import your members with this additional information. Use triggers to keep the data between your other tables and the ListManager Members_ table in synch.
2. Import your members into the ListManager Members_ table, and use the UserID_ field to refer to the primary key used by your other table. You may then create advanced subsets which join to that other table based on the UserID_ field.
3. Import your members into the ListManager Members_ table, and create a lookup table which matches the ListManager Members_.MemberID_ field with the primary key of the table which contains the additional data you need for your mailings. You may then create advanced subsets which join to that other table based on the UserID_ field.
4. Instead of using the default ListManager Members_ table, have ListManager use the table which contains your member information as its members table. This is known as using a foreign members table. Using a foreign member table is a feature of ListManager Pro or Enterprise, and is unavailable for standard ListManager. Contact your account representative at sales@lyris.com if you'd like to upgrade to ListManager Pro or Enterprise. Note that the foreign members table must be in the same SQL server as the rest of your ListManager tables.
5. Make a copy of your data table, and use it as a foreign members table as in 4 above. Continue to use your data table as you used to, but keep it in synch with your ListManager table by using triggers.
More
Connecting to Your Database with lmcfg.txt
Using a Foreign Members Table with Oracle or PostgreSQL
|
|