Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

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

Big migration from Joomla


Reply


3 Posts   712 Views

Avatar
CB

Community Member, 3 Posts

26 October 2011 at 9:26am

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)

Avatar
martimiz

Forum Moderator, 1132 Posts

28 October 2011 at 10:07am

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/

Avatar
Willr

Forum Moderator, 5513 Posts

31 October 2011 at 8:40pm

> 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.