Bulk Importer and Exporter Tool

A tool to assist with stat and achievement management

6 mins to read

You can use the Bulk Importer/Exporter Tool to manage your product's stats and achievements outside of the Developer Portal interface. The tool uses .zip archives containing CSV-formatted data, so you can view and edit your stats and achievements in a wide variety of existing programs or your own tools.

The bulk import tool only affects the definitions of your stats and achievements. It does not add, delete, or change your users' progress in any way. If you delete and recreate your stats or achievements definitions, your users' stat and achievement progression remains intact.

You can find this tool on the Developer Portal, under Games Services > Achievements. The Bulk Import/Export button exists between the Player Lookup and Create New buttons near the top.

Exporting (Step 1)

The export process creates a zip archive for download. This archive contains .csv and .png image files of all existing stats and achievements for your product.

These files adhere to the standard .csv format for easy import and export with most spreadsheet software applications. Your image files should be in standard .png format before exporting.

To start the export, simply select Export Current Achievements. The download automatically begins and creates a .zip folder wherever your downloaded content is typically stored.

You can also skip exporting by selecting Next. If you do not have a backup of your current achievements, it is not recommended to skip this step.

Importing (Step 2 and 3)

The import process follows the same file format as the export process. Your import .zip file should contain the following files in the root of the .zip file:

File NameContents
stats.csvA list of "name and type" pairs that define each stat
achievementDefinitions.csvA list of achievement names, along with the stats they reference
achievementLocalizations.csvAchievement Localization locale keys and the files names of their icons
One or more .png filesThe icons referenced in achievementDefinitions.csv

To help prepare your .zip file for import, you can download our .zip template from the Developer Portal where you would upload your .zip for import (select the Download EOS Achievements Zip Template) or click here. Either option sets off an automatic download of our sample BulkTemplate.zip folder with properly organized content.

Sample of the EOS Achievements Bulk Import template

Before beginning the import process, review the requirements for both your CSV and image files.

Once you are ready to import your files, select Choose File to Upload on Step 2 of the Bulk Import process. Confirm that you have read the notice about the import removing all existing achievements and clears all the stats for your product.

Select Next to begin a validation check for your imported content. Once complete, the backend service deletes all your existing stats and achievements, then replaces them with the ones found in the .zip file. This includes caching any icons that the new achievements use on the backend service.

The final step of the import modal displays the success of your achievements and stats import.

CSV Format Requirements

To ensure that the .csv files you upload pass the validation check, use to the data format listed below for each file type and avoid leaving any blank lines. All CSV files must be UTF-8 encoded.

stats.csv Format

The stats.csv file has two columns for each stat: the name of the stat and its aggregation type. Supported values for aggregation type are SUM, MIN, MAX, or LATEST. A sample stats.csv file follows:

name,aggregationType
numTreesChopped,SUM
lastTreesChopped,LATEST
maxTreesChopped,MAX
minTreesChopped,MIN
numAxesUsed,SUM