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)

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/

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