DB Schema?

[sieg23]

I'm just getting started with CMSMS - excellent tool!

I'm hoping to be able to load page content from and XML file.  Am wondering whether there is a good representation of the DB schema so I can see what my options are in terms of enriching the content in the transfer, or otherwise just best utilizing the DB existing structure.

The tables appear to be well named, but if I can avoid reverse engineering assumptions, I'd rather.

thanks ~S

[tsw]

HI,

We try to avoid letting people modify the db directly. The api has functions for almost everything you need to do so we can change the db structure without affecting users code.

also next major version will have ORM between db and code so db schema isnt that important in the future.

As far as I know the schema is only in some people heads, so you might need to reverse engineer it, but as the schema is build so that it works on multiple platforms it will not look very nice

hope this helps

[sieg23]

Thanks for the info.  It certainly makes sense from a support perspective to discourage direct db manipulation.

Could you recommend any way for me to do an initial batch load of pages to a site that would then be maintained and updated via the GUI?  I suppose I could scrape out and re-use the appropriate code from the GUI modules, but if someone had already addressed this notion, I'd rather not re-invent the wheel.

'Batch-Add' or 'convert' could be a future development item that would make it easier for people to migrate from other systems.

Thanks ~S