We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 17429
    • 18 Posts
    I’m wondering if it is straight forward to create pages using only SQL commands. I have a ton of blog posts from my old blog (which was WordPress based), and I’d like to avoid a lot of copying-and-pasting. If possible, I’d like to just create a big file of SQL statements like "INSERT INTO site_content VALUES (id, type, contentType, pagetitle, ..., privatemgr, content_dispo, hidemenu)". It looks like this would work, but I do not know if I would need to update any other tables in addition to site_contents.

    So I guess my question is, "Is it really that easy?"

    Thanks
      • 27376
      • 576 Posts
      If you’re not using document permissions then yes all you have to do is add rows in to the [tt][prefix]site_content[/tt] table.

      I imagine you won’t be using document permissions if you’re just creating a blog with one manager user.
        • 18126
        • 87 Posts
        I found a couple of scripts by using the search:
        http://modxcms.com/forums/index.php/topic,3656.0.html
        http://modxcms.com/forums/index.php/topic,4216.0.html

        Not sure if those work with the current version, but probably help you to get started.