How To Use The Device-ManageR-to-Room-Alert-Manager Import Tool

You can import from one of two different Device ManageR source folders:

1. Your Device ManageR v6.3.6 program installation folder.
   • This is the easiest option. You can use this option if your Device ManageR writes to the default  embedded H2-type database that comes with the program.
   • By default, Device ManageR’s installation folder is:
     • C:\Program Files (x86)\AVTECH Device ManageR (on 64-bit Windows computers)
     • C:\Program Files\AVTECH Device ManageR (on 32-bit Windows computers)
2. A custom folder that you put together than has just the required files from Device ManageR v6.3.6.
   • You must use this option if you configured your Device ManageR to write to an external database (MySQL, SQL Server or Postgres).
   • Please note that Room Alert Manager currently only supports its own embedded database. It does not support external databases.

For instructions for the custom folder, please see our FAQ, How to Make a Custom Device ManageR Folder for the Room Alert Manager Import Tool.

You need the following software for the import:

1. Your existing Device ManageR installation, which must be on v6.3.6 before you begin.
2. The latest version of the Device-ManageR-to-Room-Alert-Manager Import Tool.
3. The latest version of Room Alert Manager.

• Device ManageR v6.3.6
  • Available on the Legacy tab of the Downloads page.
  • Requires a Personal (or higher) level account.
• Device-ManageR-to-Room-Alert-ManageR Import Tool
  • Available in Room Alert Manager’s Installation Directory.
• Room Alert Manager
  • Available on the Downloads page.
  • Requires a Professional (or higher) level account.

• The Import Tool must be installed on the same computer as Device ManageR.
  • The Device ManageR service must be stopped when you initiate an import. This FAQ shows you how: How To Stop, Start And Restart The Device ManageR Service.
• Room Alert Manager may be installed on the same computer or a different computer on your network.
  • Room Alert Manager must be installed and running when you initiate an import.

The following items are imported:

1. From your Alerts/Tasks tab:
   • From Contacts: email addresses (including email-to-SMS addresses).
     
     • Those email addresses become “Notify” Actions in Room Alert Manager.
     • Those “Notify” Actions have the name you gave the Contact record in Device ManageR.
   • From Alerts: alerts that meet the following criteria.
     • The alert is on a sensor supported by Room Alert Manager.
     • That sensor is on a device that is supported by Room Alert Manager.
       
   • From Action/Notification Lists that are attached to the imported alerts:
     • The “Send Email to Configured Contact” action items.
     • Any “Perform the Action after X seconds” delays on those actions.
       
2. From your Settings tab:
   • These Discovery settings:
     • Discovery Scan Interval
     • Auto Discovery Timeout
     • Manual Discovery Timeout
     • Data Refresh Interval
     • Disable Auto Discovery
     • Missed Scans Before Disabling Devices
       
   • Your SMTP Email settings for Primary and Secondary Mail Servers (except the Test Email Recipient).
     
   • Your Blocked devices
     
3. From the Device Status –> Advanced Discovery Options –> Manually Add Devices via IP Address feature: your manually-discovered IP addresses.
4. From your Device ManageR database: the following information so that Room Alert Manager knows what device and sensor your imported Alerts go with:
   • The MAC address and device model that an imported alert points to
   • The sensor type, channel, and port that the imported alert points to (Example: Temperature & Humidity Sensor, Heat Index, Ext Sensor 2)

No other items are imported by the Import Tool.

1. Locate the Import Tool within Room Alert Manager’s installation directory (C:\Program Files\AVTECH Room Alert Manager\adm2ram by default).
2. Click (or double-click) on the AVTECH-ADM2RAM-import-tool-vX.X.X.exe file.
3. If the User Account Control dialog box appears, select Yes to continue.
4. The Windows Command Prompt opens to the following screen:
   

1. Answer the 6 prompts that appear. The prompts ask you these questions:
   • What folder are you importing from?
     
   • What is the path to that folder?
     
   • Is Room Alert Manager on this computer? (If not, what is the IP address or computer name of Room Alert Manager’s host computer?)
     
   • What HTTP port is Room Alert Manager using?
     
   • Enter the username of any Admin-level user in Room Alert Manager.
   • Enter password for that user.
     

2. After you enter the last answer, a summary of your choices will appear. Read it to make sure your choices are correct.
   
3. If you are satisfied with your choices, enter “y” to run the import. (If not, enter “n.” The command prompt will close. You can restart by opening the program through the Start menu.)
   
4. Once you enter “y,” the import begins and the results print onscreen. You’ll see the imported items and a confirmation message at the end.
   
5. Press the Enter key to close the screen. You are done with the Import Tool.

If you run the Import Tool again, the same Alerts and Actions will be added a second time (and a third time, a fourth time, etc). The duplicate Alerts and Actions will need to be deleted from Room Alert Manager.