Load events data

Available for an ArcGIS organization licensed with the Indoors extension.

After loading floor plans to your Indoors geodatabase, you can manually load events data.

Ensure that your events table contains a location attribute UNIT_ID that matches the Unit's UNIT_ID where the event is taking place. The events may come from a class schedule, Microsoft Exchange Server, a conference agenda, a spreadsheet, or another business system or live service. To load event data, you need to combine a spreadsheet or table of events with the Units feature class and output a 3D point of the joined location and event information.

Note:

Event date and time must be stored in UTC.

  1. Load your tabular events data into a table in the Indoors geodatabase.

    For example, you can use the Excel To Table tool.

    Note:

    Ensure that your events table contains a location attribute UNIT_ID that matches the PointsOfInterest feature class's UNIT_ID attribute. These will be used to join the unit and location details to each event.

  2. Add the POINT_X and POINT_Y fields to the PointsOfInterest feature class with the Add XY Coordinates geoprocessing tool.

    The feature class should contain your Places + Things unit points.

  3. Join the PointsOfInterest feature class to your imported events table.
    1. Right-click the events table and click Joins and Relates, and then click Add Join.
    2. Choose the location field of your events table for the Input Join Field parameter.
    3. Choose the PointsOfInterest feature class for the Join Table parameter.
    4. Choose the UNIT_ID field for the Output Join Field parameter.
  4. Run the Make XY Event Layer geoprocessing tool on the joined table.
    Tip:

    Use the POINT_X, POINT_Y, and ELEVATION_RELATIVE (Z) attributes.

  5. Run the Copy Features geoprocessing tool to create a temporary point feature class.
  6. Use the Append geoprocessing tool to load the 3D points into the Events feature class.
    Tip:

    Use the Schema Type Field Map option to match the attributes of input points to the target dataset.

Related topics