Problem statement: When using vcs in unreal engine, files are normally locked / checkout by the person that's editing it. This become a huge problem when multiple designer / programmer are tweaking values in certain datatable in unreal engine editor.
Description: This is an unreal engine editor tool that will import data from google spread sheet into unreal engine datatable. This tool aims to solve the problem mentioned above by having values that's constantly being tweaked save in google spreadsheet instead. All the designers should only amend the values in google spreadsheet and import it when needed. Before running a new build to package the game, the designer / programmer would use this editor tool to import the amended data.
- This tool is in POC (Proof of Concept) stage
- Does not fully validate all the data from google spreadsheet api
- it showcase the flow of importing and filling datatable
- It can convert whatever type that's supported by unreal "Fill datatable" node (mostly string and numbers)
- The project linked with google spreadsheet api
- You might want to create a google cloud project in order to test this out
- Developer Select datatable to update
- The tool will execute python script
- Python script call api to get the selected spreadsheet data and convert into csv file
- The tool import converted csv file and fill the datatable
| Software | Version |
|---|---|
| Unreal Engine | 5.2.1 |
| Python | 3.9.7 |
Python default version is based on Unreal Engine Python Plugin. If you were to switch to a later Python version, check out this link
| Title | Value |
|---|---|
| MODULES_TO_INSTALL | ['pandas', 'google-api-python-client', 'google-auth-httplib2', 'google-auth-oauthlib', 'httpx'] |
| TITLES_FOR_VALUES | DATATABLE_ROW_TITLE |
| SAMPLE_SPREADSHEET_ID | YOUR_SPREADSHEET_ID |
| SAMPLE_RANGE_NAME | SPREADSHEET_TABLE_RANGE |
| PATH_TO_PYTHON | UNREAL_ENGINE_PATH_TO_PYTHON |
| PATH_TO_CSV_OUTPUT_FILE | CSV_FOLDER_IN_YOUR_PROJECT |
| CREDENTIAL_JSON | CREDENTIAL_JSON_FILE_NAME |
| TOKEN_JSON | TOKEN_JSON_FILE_NAME |
- To allow user to import selected datatable ( currently only support 1 datatable to showcase the flow )
- To support more unreal datatype E.G. softptr, blueprint class, array etc
- To do more validation to make sure data are clean before passing back to unreal engine