SpitFire Help Desk :: Names Not Showing on SpitFire Agent Software

Knowledgebase Home

Search the Knowledgebase

Browse by Category

Knowledgebase Home > 03. SpitFire Predictive - SPD > SpitFire Predictive Pro

Names Not Showing on SpitFire Agent Software

Contents

Intro

Concat First and Last Name

Fixing Names in Existing Lists

Introduction

The most common reason why names do not show up on the SpitFire Agent software when you are positive that you have imported the names, is because of the way the data was imported with ListMaker. There is a setting in the Import ASCII window labeled Concat First and Last name and this must be checked when importing a list where the first and last names are in different fields.

Concat First and Last Name

First, lets take a look at where that setting is located in the Import ASCII window of ListMaker.

At the bottom is the Concat first and last name check-box. Check this, any time you are importing a list where the first and last name are in separate fields.
If it is not checked, the names will be imported into the separate first and last name fields but will not show up on the SpitFire Agent screen because that screen only has a combined name field.

You can also open the list in ListMaker to see the names. In the screen shots below, we have 2 examples; the first list was imported incorrectly.

Here you can see the first and last names showing in their respective fields but not combined in the Name field. The Name field is what will receive the first and last names when you check the Concat first and last name box, in the ASCII Import window. And it is this field that will be displayed on the SpitFire Agent software. See the example below:

A call has been transferred but the Name field is blank.

In this next example, the same list has been imported correctly with the Concat first and last name box checked.

And the result is that the name will now be displayed in the Name field of the SpitFire Agent software:

Fixing Names In Existing Lists

If you have already dialed several calls on the affected list and would like to fix the names instead of reimporting the list, this can be done with MySQL Query Browser.
This is not something that can be done in ListMaker but with MySQL Query Browser, you will have access to any list you need to fix.

Warning: Improper use of MySQL Query Browser can lead to data loss so please follow the instructions below carefully.

1. Start by opening MySQL Query Browser, which should be loaded on the Dialer or Database Server. Click on Start-->Programs-->MySQL-->MySQL Query Browser.

2. On the Query Browser window that comes up, you will need to type in the MySQL Server connection information.

Typically this will be:

Server Host: localhost
Username: root
Password: password
Default Schema: [blank]

3. Click OK to continue to the Query Browser window. Click on the Scrollbar, on the right-hand side, to find the list you want to fix.

4. Double-Click on the list name to select it.

5. Now you can type in the query to fix this list.
The query is: update clients set name = concat(firstname, ' ', lastname)
This must be typed or copied and pasted into the Query field at the top of the screen.

6. Next, click the Execute button, in the top right-hand corner of the screen to execute the query. Larger lists may take a minute or two but the results of the query will be displayed in the bottom, left-hand corner of the window.

In this case, there were 4 records in the list, so there are "4 rows affected". Those records will now have the first and last name combined into the Name field.