This might be a stupid question, but I could really use some help. This
http://www.devtrench.com/first-impressions-of-xpdo-wordpress-to-modx-migration-tool/ got me to an XML representation of the tables in a WordPress database. It works, every post became a resource, but defining the relationships was one of the things left as an exercise for the reader.
I went and read this:
http://svn.modxcms.com/docs/display/xPDO20/Defining+Relationships and looked at this:
http://codex.wordpress.org/Database_Description#Database_Diagram, initially thinking it would be fairly straight forward. It probably is, but not to me.
How do you describe the relationships between posts, terms, taxonomy_relationship, and taxonomy_term using xPDO’s xml?
I want to preserve the taxonomy (ultimately including the functionality it offers), since if I can’t figure that out there are projects where I’d prefer to use MODx but would have to use WordPress or Drupal.
All of this needs to be preserved using TVs, probably two of them, and I think will require a custom table to do what the term_relationships table does. My short-term goal, if I can figure out how to get this stuff defined and then manage to get it into a format MODx understands, is to always have a list of associated tags (and one or more categories that exhibit the same behavior), each of which is a link to a listing of all resources associated with that tag. In theory, if I can get to that point I should be able to do more sophisticated views, as in Drupal, and create queries that depend on multiple tags, other TV values, user input, and even the template used by the resource from which a snippet is called.
But before I can do any of that, I need to translate the data and relationships from WordPress to MODx. To do that I need a better grasp of what this page is saying:
http://svn.modxcms.com/docs/display/xPDO20/Defining+Relationships Specifically, how to describe the relationships between tables.
Can anyone help? Attached is the XML without the relationships.
