System information
Note: call record must reach a completition question to be valid in quota calculations
4.9.6. Presentations
Used to store the different presentation locations. When a client is invited, the operator will select a presentation for them.
Presentation can be selected dynamically in MAgent by setting the sql condition in the script form.
It can be done by tree way:
1. leaving empty
In this case the following query will be run: select top 150 id,Name,startdate,remainusers,comment from tb_ccpresentations with(nolock) where > getdate() and
campaignid = :assignedcampaign order by startdate, name
2. using only the sql clause
for example: name like ‘%hotel%’
the default clause is:
startdate > getdate() and campaignid = :assignedcampaign
3. using a complete sql.
In this case the “id” and a “displaytext” field must be returned.
Example:
select id, name+’ ‘+comment as displaytext from tb_ccpresentations where name like ‘%hotel%’
The usual keywords can be embedded in the sql scripts. See chapter Keywords
.
4.9.7. Checklist
Can be used in presentations to print the list of invited users.
Status texts can be configured in tb_ccstatus. To be compatible with other version, change the texts to correspond with the original without changing the
statusid.
The “Print Invitations” button will print all invitations in the selected campaign/checklist whose status indicated that it was not printed prior.
4.9.8. Clients
The client (phone number) database.
Clients can be assigned and/or reassigned to campaigns with the ease of this form.
You can search across client by a lot of condition presented on this form.
By selecting the “Last Status” filer, the users can be searched by the reason code in the last campaign
By selecting the “Any Status” filer, the users can be searched by the reason code in any campaign
Importing client database can be done from external csv or dbf files. These files must have the following fields:
CSV file columns (must be in this order):
-Name (string)
-Landline phone number (string)
-Mobile phone nuber (string)
-Zipcode (short string)










