I’m trying to streamline our asset creation workflow with a database, and am looking towards a Content Management System (CMS) to admin the thing.
What are you guys using?
Things I’m looking for:
[ul]
[li]Database listings for each asset: exporter tags used, shader settings, textures used, data archetypes, etc. We have this data, but it’s not all in one place.
[/li][li]To that end, import and collate all the assets’ XML files into database format. Maybe use XSL or somesuch to convert Programmer tags to Designer-readable English, and back out for publishing.
[/li][li]Synch with Perforce to get latest assets (middle of the night?) then update database. Perhaps update db at export time (if not too slow)?
[/li][li]Create thumbnails of Max files, TGA/PSD/DDS/etc., SWF UI elements, etc.
[/li][li]Search: Game designers can see what assets exist already for re-use, or as starting points for new assets.
[/li][li]An editable Form for each asset: designers can ask for changes, ask for new assets based on existing assets, etc. They can see all the decisions needed for each asset, and make them.
[/li][li]Approval chain when submitting changes to existing assets, or when asking for new assets. Dept heads approve, or reject with some text, automated handoff to next decider, etc.
[/li][/ul]
I know it’s a lot to ask, I’ll need to cobble together a few different tools.
Currently looking at MS InfoPath/SharePoint, but totally willing to check out other systems. Found this interesting site: CMS Critic
Basically at its heart our CMS will be a method to educate Designers (and Artists) about all the decisions that need to be made (and implemented) for each asset, and help avoid wasted work or reworking existing assets. The Wiki alone, although helpful, isn’t cutting it.
Any experience to share about similar systems would be appreciated!