Restrictions

The Copernica software is equipped with a couple of safety systems to prevent that invalid data ends up in the database and to prevent that you accidentally send out a mailing to a wrong address list. The database restrictions feature allows you to create rules to filter input data to prevent that invalid are inserted into the database. With database intentions you can prevent that a database or selection is wrongly used to send out a mailing. These systems can be found in the profile management section the Marketing Suite.

Database intentions

After creating a new database or selection you have to specifically enable mailing for it. This is a security measure to prevent you from emailing the wrong list, for exampling sending mailings out to your whole database when some have unsubscribed. With the intention settings dialog you can enable mailing for your database or selection. You can allow fax, sms and email separately for each list.

Database restrictions

The database restriction form inside the "edit database fields" dialog can be used to add rules to a database or collection. When someone tries to add or edit a profile (either via the application or a webform), the submitted data is first matched with these restriction rules. If the data does not match the restriction settings an error message will be shown and the form will not be submitted. These restrictions may include a minimum age, or may enforce users needing unique usernames. There is also the option "block doubles" which prevents fields being stored twice to help you keep your database clean.

Restrictions apply only to new additions and edits to the database. Existing profiles will keep their existing values, but will have to satisfy your restrictions on their next edit. You can also choose to remove the existing data with the "Edit multiple profiles" function.

Regular expressions

Regular expressions (often abbreviated to regex) are very powerful patterns to validate texts. You can use them to add restrictions for data entering your database. Regular expressions can do things like "check whether the value begins with a capital", "the telephone number must contain exact 10 digits" or "the sentence must have two comma's and a single capital Q". You can make these as complicated as you want.

The following regex can be used to check whether a value is a dutch postal code, which contains four digits and two letters (for example 1244XK):

**/^[1-9][0-9]{3}[a-z|A-Z]{2}$/**

Regex is fairly standard and a lot more information can be found on the internet about it.

More information

To add restrictions you need a database with some fields. If you don't have those yet you can find out how to create them in the articles below.