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 |
*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. | 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 | A unique identifier issued by Bureau van Dijk Orbis. | GB00280357 |
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-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 |
*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 |