Importing Users from Another Service
In this article, we'll walk you through the process of importing one of your existing lists of users into Appreciation Engine.
Before starting, note that you need a CSV file with a specific set of columns that include specific data about the users. You can reference the required formatting from our User Import Table Format article.
Step 1: Contact AE Support
At this time, Appreciation Engine needs to give you access to a private FTP address before you can successfully import users from other services.
Before you start Step 2, we recommend that you reach out to the AE support team so they can set up an FTP drop site for you.
Step 2: Prepare the Import Files
First, we will include your properly formatted
users.csv inside of a
.zip file. Name the
.zip file using your preferred label for a campaign or user segment.
- Name the user import file users.csv.
- Check that the contents of users.csv follows the format specified in the User Import Table Format article.
- Create a
.zipfile with the
- Give the
.zipfile a meaningful name that corresponds with your campaign or user segment. For example,
The label that you give your
.zip file will be converted to an
importCode. This means you can filter all of your users and find the ones from this specific import in the future.
Note that any spaces or underscores in your label will be converted to dots. If your
.zip was named
Spiderman Fans.zip , the corresponding
importCode would be
Step 3: Import Users Using SFTP
We strongly recommend using the encrypted SFTP protocol over FTP for the security of your user data.
Each of your import groups and sources will have their own FTP site. You will need to make sure that you are uploading the correct
.zip file to the correct FTP site.
Step 4: Monitor the Upload Process
Once a zip file is uploaded to the ftp site, AE will begin to process the import. First, the
.zip file will be uncompressed to an import folder.
The name of the new folder will be the name of your
.zip file, but with any spaces converted into underscores. For example, if your
.zip file was named
Spiderman Fans.zip the new folder will be named
Here's some more information about the upload process:
- Users are imported line by line at around 25 users per minute.
- An import counter file will count the users as they are processed for import. You may need to refresh the view in your FTP client or reconnect to check the status.
- Users will appear in Appreciation Engine while they are being processed.
- If there is an error while importing a specific user, it will be appended to the error log.
- Once the import is complete, the processing text will be replaced with "done".
Once an import is complete, you can look inside the import folder for the error log, named
You can view the error log in any text editor or spreadsheet application. Using a spreadsheet application like Microsoft Excel will present the error log with cleaner, distinct columns for the timestamp, the error, and the specific error message.
For user-specific errors, the unique identifier for the user will be included.
Step 5: Upload Corrected Data (Optional)
After reviewing and correcting any problems with a specific user's data, you can repeat Steps 3 and 4 by re-uploading the files. Alternatively, you can create new files that contain just the problematic data.
If there are only a few errors during your initial upload, it would be much faster to create a new file.
If you do choose to create new files, be sure to name the files with the same name that you used initially. Doing this will ensure that your new upload uses the same
importCode as before.