Supported Modules

The CSV Upload tool currently supports editing and inserting data for three of the SFV Modules:

User
Contact Preferences
Custom Data Fields

The email_address field will need to be present in every upload, as this is the link between the user and each of the modules. Please check below the fields currently supported via de CSV Upload tool for each of these.

Uploadable Fields

User Module

Required	Field Name	Data type	Input Format	Notes
x	scv_user_id	String
x	email_address	String
	mobile_number	String
	title	String
	first_name	String
	last_name	String
	full_name	String
	gender	String		Please check existing valid set of values
	birth_date	Date time	yyyy-mm-dd
	age	String
	postcode	String
	postcode_town	String
	postcode_region	String
	postcode_latitude	Numeric
	postcode_longitude	Numeric
	postcode_district	String
	postcode_area	String
	country_code	String		2 letter ISO country code
	country_name	String
	continent_name	String
	distance_to_club	Numeric
	job_title	String
	company_name	String
	originating_source	String
	originating_source_insight	String
	originating_source_tstamp	Date time	yyyy-mm-dd hh:mm:ss

Contact Preferences

Required	Field Name	Data type	Input Format	Notes
	name	String
	description	String
x	key	String		Please check existing valid preference keys
	option_id	String
	option_name	String		Please check existing valid preference options
	option_status	String
x	option_modified_at	Date time	yyyy-mm-dd hh:mm:ss

Custom Data Fields

Required	Field Name	Data type	Input Format	Notes
	favourite_club_team	String