Import profile attributes via FTP

Use this workflow to update profile attributes for existing users in bulk. Define the attributes in Netmera first, prepare a delimited text file, and upload it to the dedicated Profile folder.

Step 1: Create the profile attributes

Create every profile attribute that the import file will update. The attribute names in the file must exactly match the attribute names in the panel.

For example, create a membershipTier profile attribute before importing membershipTier values.

Learn more about Profile Attributes.

Step 2: Prepare the FTP folder

Ask your DevOps team to create a Profile folder under your application’s FTP path. Upload profile-attribute imports only to this folder.

Step 3: Create the import file

Create a plain-text .txt file. Each row represents one user record. Use the tilde (~) character as the delimiter.

The fields must appear in this order:

1. extID — required user identifier.

2. email — optional.

3. deviceToken — optional.

4. msisdn — optional phone number.

5. One or more profile attributes to update.

For example:

Exid~~~email~deviceToken~msisdn~profileattribute
ExtId1~~~email1~deviceToken1~+905XXXXXXXXX~membershipTier1
ExtId2~~~email2~deviceToken2~+905XXXXXXXXX~membershipTier2
ExtId3~~~email3~deviceToken3~+905XXXXXXXXX~membershipTier3

The header identifies each column. Each following row supplies values for one user. Empty optional fields still require their delimiter so later values remain in the correct column.

Use profile attribute names that exactly match the attributes created in the panel. Create missing attributes before uploading the file.

Step 4: Format phone numbers

When you include msisdn, use the international E.164 format. Start the number with +.

For example, use +905XXXXXXXXX.

Step 5: Upload the file

1. Give the file a unique name with a date and time.

2. Upload the .txt file to the Profile folder.

3. Wait for processing to complete.

For example, use profile-attributes-20260810-0900.txt. Unique filenames prevent a new upload from being confused with a previous file.

When Netmera processes the file successfully, it disappears from the folder.

Step 6: Plan large uploads

Split large imports into smaller files before uploading them. This is recommended for updates affecting more than 300,000 profiles.

Upload files during business hours. Nighttime processing jobs can affect processing.

FTP Profile Attribute.txt

128B

Open

Importing FTP Profile Attribute