Skip to main content
Eptura Knowledge Center

Update or Archive Switches

  1. Last updated
  2. Save as PDF

Level: Administrator

When you are maintaining Wireup and need to update switches or archive old switches, you can use the 350 Switch Report to import the switches into the database.

Remember

  • Import Format - The imports have a Trial Import and this will let you know what rows will be ignored, updated, or archived before you import into the database. This is letting you know if the import format is set up correctly.
  • Import Switch Data - We recommend you test your Switch Import on your UAT environment first before your run it in PROD environment, because if your switch data is incorrect you can easily mess up the switches. This will only be a effective test if you UAT environment is up-to-date with your PROD environment.

If you don't have access to the Switch Import and/or unsure of how to set up the Switch Import file then send the  file to the Serraview Support Team, use the File Upload's category Other and include a comment.

Step 1. Download the Switch Import Report 

  1. Navigate to Insights > Reporting.
  2. Search for and open 350 Switch Report.
  3. Click the Launch button.

clipboard_eb0650a4a4a252f6dd2c9694dd38fd38f.png

  1. Click the Report Queue clipboard_ed4fed61c480b094082c48070bacc57bf.png icon. 
  2. Click the Switch Import to download the report.

Step 2. Open the Switch Import Report 

  1. Open the Switch Import report in Microsoft Excel.
  2. Delete the Instructions tab.
  3. Delete the Add New tab.

clipboard_e8ffb0f7f1964bd8fd5d043c39f9c964c.png

Step 3. Complete the Update tab

  1. Complete the following columns:
  • Building - The building name must be the same as Building and Floors Module.
  • Floor - The floor name must be the same as Building and Floors Module. Beware of your floor number format as 01 is different to 1, see Import Troubleshooting.
  • Additional Floors - Sometimes switches are connected to the multiple floors (e.g. levels 1,2 and 3 are managed by the same switch, which allows the floors to all be connected). If levels 1, 2 and 3 are connected the value in this column would be 2,3 and the value in the Floor column would be 1.
  • IP Address - The IP Address of the Switch e.g. 10.123.123.12.
  • Switch Name - This is the name of the switch.
  • Archive - Accepts values of true or false. True means archive and false means don't archive.
  1. Remove the rows that don't have changes.

clipboard_e37eec5100272f6661e3d2a4307388b91.png

  1. Save the Switch Import file.

Step 3. Set up the Switch Import

  1. Navigate to Admin Settings > Data Imports > Data Imports.
  2. Click Switch Import. The Switch Import screen displays.

clipboard_eb2feb9ee087b9e4aadeba32619495c2d.png

Do not use the Force Import check box unless instructed by Serraview Support.

Do not use the Archive Untouched Switches check box. 

  1. Click the Import File's Choose file button.
  2. Navigate to the file and select it.

Trial Run

We recommend that you complete a trial run of the import before you uncheck the Trial Run check box and import in the data. In this example, you can see that 3 rows will be update in the database.

clipboard_e34d868bebb4ecaa62d5262db9bcf3ce9.png

  1. Click the Run! button.

In this example the Trail Run check box is unchecked and 3 rows have been updated in the database.

clipboard_e648c170c195075332d119aea8f55c9c4.png