Mandatory Fields For Member Imports

Link: https://support.brilliantdirectories.com/support/solutions/articles/5000568062

If there are any issues during the import process, it may be caused by one of the following mandatory fields missing.


Name or Company (name, company)

Field Variable: name, company 


Include either the "name" or "company" fields. It is also possible to include both. 


Name: Combines the first and last name. 

Company: Company name


Listing Type (listing_type)

Field Variable: listing_type


Company: Will display the company name in search results

Individual: Displays the individual's name in search results (commonly used for medical or professional directories).


Country Code (country_code)

Field Variable: country_code


Two-letter country codes are assigned to each listing. Although only the country_code is strictly required, omitting the zip_code and city fields prevents accurate geo-coding, resulting in an incomplete user experience.


Profession Name (profession_name)

Field Variable: profession_name


Top-level categories associated with each member. This is the minimum required to have members import and display properly.



Subscription & Billing Fields 

The following fields are optional for standard member imports. However, when importing existing subscription information, both fields must be provided together. 


Subscription Start Date

Field Variable: subscription_start_date

Defines the subscription start date for an imported member on a paid membership plan. This field must be provided together with billing_cycle.


Accepted date formats:

  • YYYY-MM-DD (example: 2024-06-15) 
  • YYYYMMDD (example: 20240615) 
  • The website's configured date format (e.g. MM/DD/YYYY or DD/MM/YYYY)


The subscription start date cannot be more than one billing cycle in the past or more than 10 years in the future.


Billing Cycle 

Field Variable: billing_cycle

Defines the billing cycle for the imported member's subscription. This field must be provided together with subscription_start_date. The corresponding billing amount configured in the selected Membership Plan must be greater than 0.





Available billing cycles depend on the billing options and prices configured for the selected Membership Plan. The corresponding billing amount for the selected cycle must be greater than 0. For example, if the billing cycle is Monthly, the plan's monthly amount must be greater than 0.