HOW TO: Add a New APN to UniTrac

PURPOSE

If the necessary APN setting for configuring a device is not present within the drop-down box in UniTrac, a new setting can be added manually.

PROCESS

Identify the New APN Settings

The first step in adding a new APN is to identify the correct settings to use for the new carrier that you are attempting to configure. The best route for this is to do a simple Google search for “<carrier> APN settings”. The key values are APN, User name, and password.

Update the UniTrac Database

The UniTrac database must be updated in two places to enable the new APN settings.

UniTrac.dbo.APN

Populate the correct values for the new APN into this sample SQL update statement and run it in SQL Server Management Studio on the UniTrac database server.

USE Unitrac

INSERT INTO APN (name, apnName, apnUser, apnPwd)

VALUES ('Setting_Name','NewAPN','APN_User_Name','APN_Password')

In this scenario,'Setting_Name' is the name of the APN that the user will see in the drop-down menu. The remaining values should be populated from the information discovered for the specific APN. If the carrier does not specify a username and password, the SQL statement should be updated to remove the text between the single quotes, being sure to leave the single quotes in place so a blank value is inserted into the database.

UniTrac.dbo.UnitAttributeEnums

This table contains data used in many areas of UniTrac. First, find the rows that appear to be current APN values. The exact ID will vary from UniTrac to UniTrac. In this example, the APN values have a kUnitAttribute value of 16.

To insert the new APN, first choose where in list the APN will be displayed. The default is to list the APNs alphabetically. For this example, let’s insert “NewAPN” between KOREUSC2 and ROGERSATT. We accomplish this by choosing a value for the nOrder column between 45 and 50. The SQL statement would look like this:

USE Unitrac

INSERT INTO UnitAttributeEnums (kUnitAttribute, nOrder, bDeleted, szName, szValue)

VALUES (16, 47, 0, 'NewAPN', 'NewAPN')

When running this on your own UniTrac server, be sure to update the kUnitAttribute number and nOrder number to properly match your environment’s configuration.

That concludes the necessary configuration. Refresh the UniTrac admin UI to see the new APN listed.