Description

The guide describes how export/import system works and common concepts, applicable to all formats

Video guide

Jobs and data sources

There are 2 different entities under Export/Import tab- jobs and data sources

1. Data sources defines where data is stored. Each format has its own set of parameters for data source.
2. Jobs reference data sources and defines which data is transferred. Several jobs can reference the same data source

Step-by-step guide

We use Excel for this example, but all other formats work the same way

Step 1: Create Excel Datasource

Open BGDatabase window Window->BGDatabase

Select Export/import tab, then Data sources tab, press plus icon, set Datasource type to excel and click on Add button

Choose xls/xlsx file location.

Step 2: Create Export/Import job

Select Export/Import tab, then Jobs tab, press plus icon, set Job type to excel and click on Add button

Select xls datasource, created in step 1. Include tables/fields you wish to update to merge settings

Step 3: Running Export/Import Task

Press Export or Import button to run the task you just created.

[Optionally] After job is finished, open Log tab to see full log of all actions performed. Pay attention to Warning messages (colored red). Every error or unexpected event happened during syncing will be colored red.

Default field value string format

We use Acute (Back quote) symbol ` to separate tokens of single value, for example Vector3.zero is 0`0`0

We use Vertical bar (Pipe) symbol | to separate values of the list, for example List<bool> is 0|1|0

Custom field value string format

Most of the fields support custom string format (except for Unity assets and relations). You can create your own class, implementing BGStringFormatter<T> interface (T is a field value type) and assign it under "M" menu as a custom string value formatter