[TYPO3] Content migration from legacy cms (EZ Publish)

[Valery Romanchev]

Hi Amiran

I do migration on one large site with 3500 news items and 200 pages.
I put news and categories table in the typo3 database, then write some 
SQL, to migrate categories and news

I add some fields to tt_news table for more easy migration and make 
short field to be with Rich Text Editor (by simple typo3 extension).

INSERT INTO tt_news (`uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, 
`title`, `datetime`, `short`, `bodytext`, `w_id`, `w_partition`, 
`w_catalog`, `w_sort`)
SELECT `id` , 101, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(`date`), 1, 
`caption` , UNIX_TIMESTAMP(`date`), `short_text` , `full_text` , `id` , 
`partition` , `catalog`, `sort`
FROM `w_article`
WHERE `catalog` = 0 AND partition = 14;


Then I write some SQL to clean up HTML code

UPDATE tt_news SET bodytext=REPLACE (bodytext, "<?xml:namespace prefix = 
st1 />", "");

UPDATE tt_news SET short=REPLACE (short, "&nbsp;", " ");

UPDATE tt_news SET bodytext=REPLACE (bodytext, "<st1:PersonName>", "");
UPDATE tt_news SET bodytext=REPLACE (bodytext, "</st1:PersonName>", "");

UPDATE tt_news SET bodytext=REPLACE (bodytext, "<st1:personname>", "");
UPDATE tt_news SET bodytext=REPLACE (bodytext, "</st1:personname>", "");

All this was for news.

I migrate pages by hand (copy/paste), because 200 pages is not so much 
and structure of pages is difficult to do migration by script

Regards,
Valery Romanchev
www.typo3lab.com