Microsoft Places Data-Mapping Process

This article will show you how to map Microsoft Place IDs with an Archilogic floor plan model and how to export this floor plan as an IMDF-compatible ZIP file

To follow this article the requirements listed below have to be met:

The latest Microsoft PowerShell is installed on your computer.
Your Archilogic account does already exist.
Archilogic has converted your floor plan into a Microsoft Places and IMDF-ready model
Your buildings, floors, rooms, and desk pools are already set up in Microsoft Places.

This article makes use of some PowerShell commands for Microsoft Places. You can find additional information and PowerShell commands in the full Microsoft Places documentation.

Tutorial video on how to set up an Archilogic account

Tutorial video on how to map your Microsoft Exchange Data with your Archilogic floor plan model

Export Microsoft Exchange Data Dump

To start the mapping process you first need to export a Microsoft Exchange Data Dump containing the Microsoft Place IDs of the building’s floor that you want to map to the corresponding Archilogic floor plan model.

To do that you need to:

Open PowerShell
If you haven’t accessed Microsoft Places through the Power Shell before make sure to first install the necessary Microsoft Places Module by using this command (otherwise you can skip this step):
```
Install-Module -Name MicrosoftPlaces -AllowPrerelease -Force
```
Connect to Microsoft Places by using the following command:
```
Connect-MicrosoftPlaces
```
A login popup will open allowing you to sign into Microsoft Places using your existing Microsoft login credentials.
Use the following command to list your buildings. From the result pick the PlaceId of the one which you plan to map to the Archilogic floor plan model:
```
Get-PlaceV3 -Type Building | Select DisplayName, PlaceId, Type
```
Export a Microsoft Exchange Data Dump of the correct building by adjusting and using the following command:
```
Get-PlaceV3 -AncestorId XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX | export-csv "C:\...\XX.csv" -NoTypeInformation
```
- Replace XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX with the correct PlaceId of the building you wish to export (See step 3). You can learn more about setting up buildings and floors on this Microsoft page.
- Specify the exact export folder here: "C:\\...\\XX.csv"
  - Keep the quotes in the command.
  - The folder structure needs to exist before you run the command.
  - Choose a name for the file to be exported.
  - Make sure that the file ends with CSV.
- By running this command the Data Dump of your Microsoft Places building will be exported to your specified folder.
The complete command should look something like this:

Import the Microsoft Exchange Data Dump into Archilogic and export an IMDF-compatible ZIP file

To map the data within the CSV file, you must import it into the Archilogic Editor first.

Sign in to your Archilogic Dashboard: https://app.archilogic.com/login
Find the correct floor to which you wish to map Microsoft PlaceIDs
Right-click the floor and open it in the Archilogic Editor
Microsoft Places requires a floor plan to be geo referenced before it can be imported. You can geo reference your Archilogic floor plan model by following this guide.
Then open the main menu in the top left corner and select Plugins > MS Places Import.
The MS Places Import plugin will open on the left side of the window. You can now either drag and drop the previously exported CSV into the grey field or left-click the blue link to open the file browser and select the correct file on your computer.

The first time you run the MS Places Import plugin it will automatically create 2 custom attribute fields called: MS Places Directory Id. You may see 2 notifications about this popping up in the lower right corner of the window.
One of these newly created custom attributes is for the floors while the other is for the spaces. These fields will receive the Microsoft Places IDs once we continue with the mapping process.
After importing the CSV you’ll see a preview of the data. Open the first drop-down menu and select the correct building. A second drop-down menu appears asking you to select the correct floor. Be advised that the floor you’re selecting has to be the same one as the Archilogic model that is currently open in the editor.
After selecting the correct building and the correct floor, the plugin will show the rooms you created on Microsoft Places earlier.
To map the Microsoft Places room with a space on the Archilogic floor plan you have to first left-click the button with the target icon and then left-click the corresponding space on the Archilogic floor plan.
Successfully mapped spaces will be highlighted in a light blue color on the floor plan. In addition, you can also see a checkmark next to the room name in the list. If you made a mistake and want to unmap the room in the list with the space on the floor plan simply click the button with the X icon to remove the connection.
If you select the space with a left-click you will also see that the “MS Places Directory Id” custom attribute field in the right sidebar has been populated with the corresponding ID from Microsoft Places.
Repeat step 8 if you have more than one room to be mapped in the list.
Once you mapped all the rooms to the corresponding spaces on the floor plan click the blue Publish button in the top right corner to save your progress. Wait a couple of seconds until the publishing process is complete.
Now click the blue Export IMDF button in the lower-left corner of the window to export an IMDF-compatible ZIP file in which the Microsoft PlaceIDs are mapped to the correct spaces on the floor plan.

Upload the IMDF-compatible ZIP file to Microsoft Places

The last step in the process is to upload the IMDF-compatible ZIP file containing the mapped spaces to Microsoft Places:

Open the same PowerShell again.
Use the following command to upload the IMDF-compatible ZIP file to Microsoft Places:
```
New-Map -BuildingId XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX -FilePath "C:\\...\\ZIPNAME.zip”
```
1. Replace the Xs with the correct BuildingId XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX This is the same ID as above.
2. Make sure the path "C:\\...\\ZIPNAME.zip” points to the current location of the ZIP file you wish to upload.
After executing the command the floor plan gets uploaded to Microsoft Places. A user can now see where a certain room is located on a floor plan if they wish to book it.

If you need to upload several floor plans of the same building to Microsoft Places, you have to run the New-Map command once for each ZIP file.

Make sure to use the same BuildingId every time but point to a different ZIP file in the FilePath.