Skip to main content

Prepare your CSV file for importing multiple profiles

Use the company_profiles.csv template for importing company profiles and the individual_profiles.csv template for importing individual profiles.

The first row of the templates contain column headers for standard profile fields and the custom fields that are defined in your institution. Each subsequent row corresponds to one profile in Passfort. Each CSV file can contain up to 1000 profiles.

You can prepare your own CSV file to import profiles but it must include required columns. The required columns in the CSV file depend on whether you use a Company profiles CSV file or an Individual profiles CSV file. The column headers you use in your file must match the name of the headers used in the templates as Passfort needs these headers to recognize the data.

CSV files must use UTF-8 encoding. This allows Passfort to accept special characters in data. If an alternative encoding was used to create your CSV file, save the file again and select UTF-8 from the encoding options.

If you have a value that contains a comma, surround the entire value with double quotes to avoid clashes with the use of commas as separators. For example, if the company name is Forexo, Pro LLC, then you must enter "Forexo, Pro LLC" in the CSV file. The double quotes won't appear in the profile in Passfort.

Separate values in multi-select custom fields with ; and ensure no spaces appear before or after the semicolon. For example, enter CAN;IRL;JPN if you want to include Canada, Ireland, and Japan in a custom field where multiple countries can be selected.

By default, most spreadsheet programs will automatically remove leading zeros in a cell. For example, a field containing 03304 is automatically converted to 3304. To retain the leading zeros in the fields, set the formatting of columns where leading zeros occur to text.

Company profiles CSV file

The company_profiles.csv template contains the following column headers related to organization profiles:

Column header

Description

Sample data

Product alias

*Required

The alternative name for the product when making calls to the API.

See Aliases for products, tasks, and checks for more details.

forexo_pro

Country of incorporation

*Required

The country in which the company is incorporated.

The country must be provided as an ISO3 code.

DEU

Company name

*Required

The legal name of the company.

Forexo Pro Limited

Company number

*Required

The company’s registration number.

You can enter the BVD ID in this field if and only if Bureau van Dijk Orbis is configured as the data provider for your Company data check.

09565115

State of incorporation

Optional

The state, province, or territory of the address.

The format follows the state code of the ISO-3166-2 standard.

Note that a UK county should not go here.

TX

Email address

Optional

The contact email address for the company.

alex@forexoproteam.com

Phone number

Optional

A contact phone number for the company. You can include the country code, which can be added with + or 00.

+44 20 7777 1000

Website

Optional

The URL of the company's website.

www.forexopro.com

Incorporation date

Optional

The company's date of incorporation.

Enter the exact date in YYYY-MM-DD format.

1933-05-20

Entity type

Optional

The ownership structure used by the company.

Enter ASSOCIATION, COMPANY, PARTNERSHIP, SOLE_PROPRIETORSHIP, TRUST, or OTHER.

COMPANY

Company shares type

Optional

Whether the company is publicly or privately traded.

Enter Publicly-traded or Private.

Private

Company liability type

Optional

The kind of liability the company's members are exposed to.

Enter Limited or Non-limited.

Limited

Customer reference

Optional

The reference number of the company.

FOREXO2901

Legal Entity Identifier (LEI)

Optional

The company’s LEI.

984500F46A6AFD68DD59

Country

Optional

The country of the address.

The country must be provided as an ISO3 code.

GBR

Building number

Optional

The building number of the company's address.

1A

Building name

Optional

The name of the building.

Tower

Flat number

Optional

The subaddress within the building. Typically this is a flat number.

3-2

Street

Optional

The street name and number of the company's address.

38 Crown Street

Town

Optional

The postal town or district of the address.

Ealing

City

Optional

The city name of the company's address.

Boston

Postal code

Optional

The postal code or zip code of the address.

90210

County

Optional

The county of the address.

Note that a US state or a Canadian province or territory should not go here.

Middlesex

State

Optional

The state, province, or territory of the address.

The format follows the state code of the ISO-3166-2 standard.

Note that a UK county should not go here.

ON

Type of address

Optional

The address type.

Enter registered_address, branch_address, head_office_address, contact_address, or trading_address.

registered_address

Euro VAT Identification number

Optional

The company's Euro Value Added Tax (VAT) identification number.

BE09933399XX

VAT Identification number

Optional

The company's VAT tax identification number.

8760047464

EIN Identification number

Optional

The company's Employer Identification Number (EIN).

12-3456789

BvD ID

Optional

Description

GB00280357

Custom field name

Optional

Additional information about the profile that can't be captured through Passfort's standard fields.

Values for custom fields must be in the format defined for each custom field when they were set up. For example, a date field must be in YYYY-MM-DD format. See Custom field content types for more examples.

2008-09-30

TRUE

-25000

Individual profiles CSV file

The individuals_profiles.csv template contains the following column headers related to individual profiles.

Column header

Description

Sample data

Product alias

*Required

The alternative name for the product when making calls to the API.

forexo_pro

First name(s)

*Required

The individual’s first and, if applicable, middle names.

Alex

Surname

*Required

The individual’s last name.

Wheeler

Date of birth

Optional

The individual’s date of birth.

Date format must be YYYY, YYYY-MM, or YYYY-MM-DD.

1975-04-19

Gender

Optional

The individual's gender.

Enter M or F. Leave blank for non-binary genders.

M

Email address

Optional

The individual’s email address.

alex@forexo.com

Phone number

Optional

The individual’s phone number. This must include the country code, which can be added with + or 00.

+44 158 296 777

Customer reference

Optional

The individual's customer reference.

WHEEL750419

Nationality

Optional

The individual’s country of nationality.

The country must be provided as an ISO3 code.

AUS

Country

Optional

The country of the address.

The country must be provided as an ISO3 code.

GBR

Building number

Optional

The building number of the individual's address.

A

Building name

Optional

The name of the building.

Tower

Flat number

Optional

The subaddress within the building. Typically this is a flat number.

3-2

Street

Optional

The street name and number of the individual's address.

38 Crown Street

Town

Optional

The postal town or district of the address.

Ealing

City

Optional

The city name of the individual's address.

Boston

Postal code

Optional

The postal code or zip code of the address.

90210

County

Optional

The county of the address.

Note that a US state or a Canadian province or territory should not go here.

Middlesex

State

Optional

The state, province, or territory of the address.

The format follows the state code of the ISO-3166-2 standard.

Note that a UK county should not go here.

TX

Custom field name

Optional

Additional information about the profile that can't be captured through Passfort's standard fields.

Must be in the format defined for each custom field when they were set up. For example, a date field must be in YYYY-MM-DD format. See Custom field content types for more examples.

2008-11-24

TRUE

-2500

Additional information