Jump to:

23376 Posts in 18176 Topics by 2867 members

General Questions

SilverStripe Forums » General Questions » Big migration from Joomla

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 620 Views
  • CB
    Avatar
    Community Member
    3 Posts

    Big migration from Joomla Link to this post

    Hi,

    I'm trying to migrate a joomla site to silverstripe, but I have a few problems/questions.

    The joomla site has around 7000 pages in content table. I was trying to migrate these to SiteTree table with sql , using this map:

    SS          Joomla
    ID          ID
    ClassName      "Page" -> value page to all itens
    Created         created
    LastEdited      modified
    URLSegment      ID -> using ID to avoid spaces
    title          title
    MenuTitle       "null" -> value page to all itens
    content         CONCAT(introtext,fulltext)
    MetaTitle       title
    MetaDescription   metadesc
    MetaKeywords      metakey
    ExtraMeta      "null" -> value page to all itens
    ShowInMenus      "0" -> value page to all itens
    ShowInSearch      "1" -> value page to all itens
    HomepageForDomain   "null" -> value page to all itens
    ProvideComments      "null" -> value page to all itens
    Sort          "100" -> value page to all itens
    HasBrokenFile      "0" -> value page to all itens
    HasBrokenLink      "0" -> value page to all itens
    Status         "Unpublished" -> value page to all itens
    ReportClass      "null" -> value page to all itens
    CanViewType      "Inherit" -> value page to all itens
    CanEditType      "Inherit" -> value page to all itens
    ToDo          "null" -> value page to all itens
    Version         "1" -> value page to all itens
    ParentID       "6" -> value page to all itens

    The sql statement does the work without errors and all the data goes to SiteTree

    After this I try to log in in admin interface and nothing happens.

    Question 1 - How can I activate logging in SS?
    Question 2 - Is the SiteTree table the only one with page information?
    Question 3 - Can the admin interface handle 7000 pages?

    Thanks
    Carlos
    (sorry for the bad english)

  • martimiz
    Avatar
    Forum Moderator
    1067 Posts

    Re: Big migration from Joomla Link to this post

    Hi,

    I never tried this, but maybe the following can help some.

    1. if you had a working login earlier, it should still be there, so maybe something else is wrong. You can always set a default admin/password in your /mysite/_config.php. Security::setDefaultAdmin('userOrEmail','password');

    2. The basic SiteTree lives in the SiteTree table. Once published, the record will also live in the SiteTree_Live table. SiteTree_versions will store earlier versions of a page. I haven't checked the validity of all your fieldvalues - I suppose you first did a fresh install, and checked existing page records?

    3. OK, I've never built a site with over a couple hundred pages, but people on the forums have done it, so it should be possible. But I'm not sure about giving all pages the ParentID 6 - 6999 children of a Page with ID=6? I'm not sure the CMS SiteTree can handle that within reasonable time... Does that page 6 exist? I'd suggest trying this with a test database (say 3 pages) first...

    You might even want to think about not using 7000 actual pages, but use DataObjects instead. Read this:

    http://www.ssbits.com/tutorials/2010/dataobjects-as-pages-part-1-keeping-it-simple/

  • Willr
    Avatar
    Forum Moderator
    5489 Posts

    Re: Big migration from Joomla Link to this post

    > Question 1 - How can I activate logging in SS?

    http://api.silverstripe.org/2.4/sapphire/dev/SS_Log.html

    > Question 2 - Is the SiteTree table the only one with page information?

    If you're creating pages with custom fields or custom page types then you need to worry about the 'Page' table and 'YourCustomPage' table.

    > Question 3 - Can the admin interface handle 7000 pages?

    Depends how you structure it, 7000 under 1 parent page (e.g blog) then no, it won't handle it. 50 pages under 70 parents under 2 parents, then it should handle it for MySQL. PostgreSQL based SiteTree's are a little less scalable.

    620 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.