How to Import Call History from Shoretel 14.2 to Mitel Connect Build 22.13

Importing Call History During A Shoretel to Mitel Upgrade

First a little background.  On Shoretel and Mitel systems store the call history for each extension in a SQL Lite database that is stored outside the main CDR and Config databases. The Shoretel Communicator application reads this file directly to get the history.  

What you will need to do this task:  sqlite3.exe and sqlite3.dll from the new mitel server, you can get this from anywhere really.  Plus you will need the mysql command line tool on both servers. Open a dos prompt to perform all  of these tasks.   Open a cmd.exe prompt, make a directory called \Temp to do all of your work.

First Step is to find the UserData folder:

usually is located here on both Mitel and Shoretel:  C:\Shoreline Data\UserData\<hash code>\

in mysql command line, using the Shoreware database, look for the user's DN to get the hash code folder name.  If you need help using the mysql command line, see my other shoretel related postings for the database names and passwords. Here's a hint: port 4308, database name: Shoreware, username: root

The GUI Login name is what you are looking for.

in mysql command line:  on the Shoreware database:

select DN, userDN, DNUuid, GUILoginName from DN inner join users on DN.DN = users.userDN;

...

| 8501 | 8501   | 4e22c7ff-1a7d-4c6b-a1d6-3b8035becba4 | JJohnson      |

...

Close the mysql command line for now.  for extension 8501 go to this folder: (on shoretel 14.2)

C:\Shoreline Data\UserData\4e22c7ff-1a7d-4c6b-a1d6-3b8035becba4

then copy the history.sq3 file to c:\temp to work on it.  Finally run the sqlite3.exe command on the command line prompt.

0) Edit the history database with sqlite3.exe

> sqlite3.exe history.sq3

1) Check Version Table

select * from VersionTable;

2) should return 18

3) Alter the tables add new columns

ALTER TABLE HistoryTable ADD COLUMN ListPartiesNoPrefix VARCHAR(1024);

ALTER TABLE HistoryTable ADD COLUMN RoutingSlipNoPrefix VARCHAR(2048);

4) Set the Version Number to 19

UPDATE VERSIONTABLE SET Version = 19;

5) Finally, copy the modified history.sq3 file to the new mitel server and overwrite the existing file.

Conclusion

If this post helped you in anyway, please leave me a comment below.  If you hated it, then please leave me a comment as well.  If you need assistance with your shoretel to mitel migration, please feel free to contact me anytime.