---
title: Hexagon CAD Export Script
description: Extracting the necessary data from your CAD is a key first step in sending your CAD data to Clear/Voyager AI
---

[Skip to content](https://help-legacy.corti.ai/migration/hexagon-cad-export-script#main-content)

English

Show submenu for translations

![Orb\_logotype\_horizontal\_white.png\]](https://help-legacy.corti.ai/hs-fs/hubfs/Orb_logotype_horizontal_white.png?height=40&name=Orb_logotype_horizontal_white.png)

- [Default HubSpot Blog](https://3997889.hs-sites.com/blog)

Open main navigation

Close main navigation

- [Default HubSpot Blog](https://3997889.hs-sites.com/blog)
- English
  
  Show submenu for translations
- [Go to corti.ai](https://corti.ai/)

[Go to corti.ai](https://corti.ai/)

 Welcome to Corti's Help Center

- There are no suggestions because the search field is empty.

1. [Help Center](https://help-legacy.corti.ai/migration?hsLang=en)
2. [New to Corti?](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en)
3. [Implementing Clear/Voyager AI - CAD Integration](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en#implementing-clear-voyager-ai-cad-integration)

# Hexagon CAD Export Script

## Extracting the necessary data from your CAD is a key first step in sending your CAD data to Clear/Voyager AI

Corti customers will begin by using an export from their CAD system to identify and share the CAD records of in scope calls. This is often done with a SQL query, but default exports may also work.

 

For Corti's Clear/Voyager AI solution, Corti looks for the following data from the CAD for each call:

| **File Type** | **Key Data Points** |
| --- | --- |
| **.csv** | **Incident ID** - or other unique Identifier **Call Start Time** **Workstation ID** - Identifier to pair to channel from Call Recorder **Call Taker ID** **Protocol ID** - Chief complaint, etc. - this is how the incident protocol will be displayed within Corti |

 

Corti has worked with customers that use Hexagon CAD systems and have used the following script to high degree of success in the past. As all organizations may opt to configure their systems slightly different, this may require modifications to extract the appropriate data points for your organization. The below script can be used in a daily run to extract CAD data for the previous day's activity:

 

```
SELECT 	agency_event.cdts as EventCreatedTime,	agency_event.num_1 as Event_Number,	agency_event.tycod as Protocol_ID,	event_type.eng as protocol_Descr,	agency_event.cpers as Calltaker_ID,	CONCAT(persl.fname,' ',persl.lname) as Calltaker_Name,	agency_event.cterm as ComputerNameFROM agency_eventJOIN event_type ON agency_event.tycod=event_type.tycodJOIN persl ON agency_event.cpers=persl.empidWHERE	(agency_event.cdts >= DATEADD(day, -1, CONVERT(date, GETDATE())) AND agency_event.cdts < DATEADD(day, -0, CONVERT(date, GETDATE())))
```

 

- [New to Corti?](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en#main-content)

    - [Technical Set-Up](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en#technical-set-up)
    - [Implementing Clear/Voyager AI - Call Recorder Integration](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en#implementing-clear-voyager-ai-call-recorder-integration)
    - [Implementing Clear/Voyager AI - CAD Integration](https://help-legacy.corti.ai/migration/new-to-corti?hsLang=en#implementing-clear-voyager-ai-cad-integration)
- [How To's](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#main-content)

    - [Clear/Voyager AI Videos](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#clear-voyager-ai-videos)
    - [Clear/Voyager AI - Explore - Articles](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#clear-voyager-ai-explore-articles)
    - [Clear/Voyager AI - Call Review - Articles](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#clear-voyager-ai-call-review-articles)
    - [Clear/Voyager AI - Call Search - Articles](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#clear-voyager-ai-call-search-articles)
    - [Engage - Protocol Editor Videos](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#engage-protocol-editor-videos)
    - [Engage - Protocol Editor Articles](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#engage-protocol-editor-articles)
    - [Admin - Articles](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#admin-articles)
    - [Clear/Reviews](https://help-legacy.corti.ai/migration/how-tos?hsLang=en#clear-reviews)
- [User Guide](https://help-legacy.corti.ai/migration/user-guide?hsLang=en#main-content)

    - [Engage](https://help-legacy.corti.ai/migration/user-guide?hsLang=en#engage)
    - [Clear](https://help-legacy.corti.ai/migration/user-guide?hsLang=en#clear)
    - [General Platform](https://help-legacy.corti.ai/migration/user-guide?hsLang=en#general-platform)
    - [Deep Dive Repository](https://help-legacy.corti.ai/migration/user-guide?hsLang=en#deep-dive-repository)
- [What's new?](https://help-legacy.corti.ai/migration/whats-new?hsLang=en#main-content)

    - [Release Notes 2024](https://help-legacy.corti.ai/migration/whats-new?hsLang=en#release-notes-2024)
    - [Release notes 2023](https://help-legacy.corti.ai/migration/whats-new?hsLang=en#release-notes-2023)
- [Corti Co-Pilot](https://help-legacy.corti.ai/migration/corti-co-pilot?hsLang=en)

- [Default HubSpot Blog](https://3997889.hs-sites.com/blog)

[![](https://help-legacy.corti.ai/hs-fs/hubfs/Corti%20Logo-1.png?width=617&height=200&name=Corti%20Logo-1.png)](https://help-legacy.corti.ai/?hsLang=en)

Can't find what you need? Reach out through https://corti.zendesk.com/hc/en-us

Copyright © 2026, Corti