Person Export CSV Column Reference

This document describes all columns included in the Person export CSV file generated by the Profyle Card enterprise portal.

Standard Columns

Identity & Contact Information

Column Name	Description	Example
id	Unique identifier for the person	abc123xyz
prefix	Name prefix/title (translatable)	Dr., Ms., Mr.
first_name	Person’s first name (translatable)	John
last_name	Person’s last name (translatable)	Smith
email	Email address	john.smith@example.com
mobile	Mobile phone number	+1234567890

Professional Information

Column Name	Description	Example
position	Job title/position (translatable)	Senior Developer
department	Department name (translatable)	Engineering
nominals	Post-nominal letters/credentials (translatable)	PhD, MBA, CISSP
pronouns	Preferred pronouns (translatable)	she/her, they/them
bio	Biography/about text (translatable)	Experienced software engineer...

NFC Card Information

Column Name	Description	Example
nfc_card_id	First 6 characters of the assigned NFC card ID	ABC123
nfc_card_enabled	Whether the assigned NFC card is enabled	true, false

Social Media & Web Presence

Column Name	Description	Example
linked_in	LinkedIn profile URL	https://linkedin.com/in/johnsmith
twitter	Twitter/X handle or URL	@johnsmith
instagram	Instagram handle or URL	@johnsmith

Organisation & Grouping

Column Name	Description	Example
group	Name of the group the person belongs to	Sales Team, London Office
address	Custom address string (semicolon-separated) when not using Locations (below)	123 Main St;Suite 100;London;;SW1A 1AA;GB

Location Settings

Column Name	Description	Example
locations	Location display mode	disabled, group, list, custom
location_ids	Array of location IDs associated with person	"xyz123456,abc987654"

Location Modes:

• disabled – No location shown
• group – Inherit locations from group
• list – Show specific locations from location IDs
• custom – Use custom address fields

Linked Profyles Settings

Column Name	Description	Example
linked_profyles	Linked profyles display mode	disabled, group, list
linked_profyle_ids	Array of linked person IDs	"abc123def,987xyz123"

Linked Profyles Modes:

• disabled – No linked profyles shown
• group – Show all people in the same group
• list – Show specific people from linked profyle IDs

Custom Fields

Custom field columns are dynamically added based on your organization’s configuration:

Column Name Format	Description	Example
cf_<field_id>	Custom field value	cf_employee_id_a54ff, cf_office_phone_e331d

Each custom field defined in your organization settings will appear as a separate column with the prefix cf_ followed by the custom field’s unique identifier.

Metadata Columns

Timestamps

Column Name	Description	Format	Example
created_at	When the person was created	ISO 8601	2024-01-15T10:30:00.000Z
last_updated	When the person was last modified	ISO 8601	2024-03-20T14:45:30.000Z
last_profyle_view	When the person’s Profyle was last viewed	ISO 8601	2024-03-25T09:15:00.000Z

Analytics

Column Name	Description	Example
views_counter	Total number of Profyle views	142
intros_counter	Total number of introductions made	23

Notes

Translatable Fields

The following fields support multiple language translations:

• prefix
• first_name
• last_name
• pronouns
• nominals
• position
• department
• bio

The CSV export shows the English (default) version of these fields. Translations for other languages are stored separately in the database but not included in the CSV export.

Address Format

The address column contains a semicolon-separated string with the following components in order:

1. Line 1 (street address)
2. Line 2 (building/suite)
3. City
4. Region/State
5. Postcode/ZIP
6. Country (2-letter ISO code)

Example: 123 Main Street;Suite 400;New York;NY;10001;US

Array Fields

The following fields contain arrays and are exported as comma separated lists of IDs:

• location_ids
• linked_profyle_ids

Usage

This CSV export can be used for:

• Backing up person data
• Bulk editing in spreadsheet applications
• Importing into other systems
• Data analysis and reporting
• Compliance and audit purposes

Note: when importing, ensure date fields are parsed as ISO 8601 format.