Question from a developer:
It is possible to import a file with all the catalog data into PlayFab? Like a CSV or an Excel Spreadsheet?
Question from a developer:
It is possible to import a file with all the catalog data into PlayFab? Like a CSV or an Excel Spreadsheet?
Yes! In fact, one of the developers using PlayFab - Rich Joslin - created a tool that allows you to import data directly, using Google Sheets. You can access it in Rich's GitHub, here:
Hey Brendan,
It appears that Google Sheets link doesn't work anymore. Is importing from Google Sheets still a capability?
Thanks,
Adam
Since it's really Rich's work, I've updated the pointer to his GitHub repo for this.
It seems the code used for this is depreciated, is there any alternatives for this?
Hey Brendan,
Thank you for the info, the tool is very simple and super useful (I've already expanded it with what I needed).
One question: it is possible to upload the json file to just add new items instead that completely overwrite all?
Thx
Well, the "upload JSON" is really intended for the workflow of downloading the catalog and editing it for re-upload, but you can also use UpdateCatalogItems. That API adds the items submitted to the catalog in question. For convenience, you could use it via Postman using our Collection from GitHub.
And, of course, you can quickly add items to the catalog by duplicating other items in the catalog using the Game Manager, then modifying the elements you need to for the specific item you're adding.
If you feel an "Upload JSON Additive" would be a useful option in the Game Manager, feel free to add it to the Feature Requests forum, so that others can vote on how useful it would be to them - voting there helps us be aware of which things we've heard about would be of benefit to the largest percentage of our community! :)
Just a comment on this: If you upload a JSON document that isn't formatted the same as the catalog, then nothing happens. No error message or anything. There should be some information like in Brendan's post above that mentions the intended workflow.
For me, I assumed "Upload JSON" would replace the catalog entirely, which is also different from Brendan's suggestion of an "Upload JSON Additive". I think there are use cases for all 3 of these methods.
3 People are following this question.