Import application data from a file

​

What are file connectors?

File connectors sync application data from apps that do not have an automated connector available, such as non-API-enabled, legacy, or homegrown on-prem apps. You can add file connectors to ConductorOne in two ways:

• Manually, by uploading a file.
• Automatically, by syncing data from an external datasource.

​

Supported file formats

Application data can be imported into ConductorOne using three different file formats:

• Comma Separated Value (.csv) files (values can be either comma- or tab-separated)
• Excel (.xlsx) files
• ConductorOne Baton (.c1z) files: these files are generated using the Baton protocol

Other file formats will not upload successfully.

​

Creating Excel and CSV files

ConductorOne allows for custom configurations in your Excel or CSV file, as each file can be dynamically mapped into different data elements in ConductorOne, such as username, email, or manager. You can use one of our templates as a starting point: Use this template if your data is organized by entitlements or permissions.### Expected data valuesConductorOne looks for the following column names to automatically understand and process the data in your uploaded file. You can give the columns in your file any names you like and manually map the data values, but if you use the column names listed below, they will be automatically understood and processed by ConductorOne without further intervention from you. For identity-focused files: For grant-focused files: Can be included in either file type: A few fields are required. Most critically, to successfully upload account information you must either include a “User ID” column in your file or map a data value in your source file to the User ID column. The other required fields are noted above.

​

Designate service and system accounts in your file

Follow this process to designate service accounts and system accounts in your file and associate these special accounts with the human user responsible for each one. These fields will map account types and account owners respectively, and this information will be reflected in the Accounts tab of the application.

​

Import last login info

To import last login data for accounts in the app, create the header “Last Login” in your CSV file. (If you use this exact header, you won’t need to map the data value.) Then, populate the column with last login dates. The following date formats are accepted:

​

Using .c1z files

Files in the ConductorOne Baton file format are supported natively for application data uploads in a non-lossy format. In other words, the .c1z file preserves all resource metadata, hierarchy, and grant structures that are discovered in an application. When uploading a .c1z file, there is no need to configure file mappings. ConductorOne understands and ingests the application data automatically.

​

Add a file connector to an app

To add file data to an application: ConductorOne will now begin ingesting the data into the ConductorOne application. To review the detected delta between files, click View logs on the connector.

​

Map data values

When you upload a custom spreadsheet, the data values in your file might not automatically be matched with ConductorOne attributes. For example, a data file that includes a column titled “Last” for a user’s last name might not automatically be understood by ConductorOne, which expects the data in that column to be titled “Last Name”. You can avoid needing to map data values by using the column headers listed in the table above. To ensure that the data in your spreadsheet maps accurately into ConductorOne’s system, map your spreadsheet’s values to those used by ConductorOne. When you set the mappings, ConductorOne automatically reprocesses the data with the changed mappings. You can see the output of the changes by viewing the log.

​

Refresh or replace file data

Periodically, you may need to refresh data in your file connector, whether to prepare for upcoming access review campaigns or simply to refresh the source of truth of accounts and permissions in ConductorOne. Doing so it as simple as replacing the current uploaded file with a more current version. To refresh application data in a file connector: That’s it! The updated data is processed and loaded into the application.