This thread is a discussion for the wiki article: Export Entries
   
 
Export Entries
Posted: 07 February 2010 05:12 PM   [ Ignore ]  
Lab Assistant
Avatar
RankRank
Total Posts:  116
Joined  10-02-2002

In EE v2.0.1pb01, I’ve modified the code on this page to get it working on my Beta build.

The index template within the export template group became:

{exp:channel:entries channel="default_site" limit="999" rdf="off"}
TITLE
{title}
AUTHOR
{author}
DATE
{entry_date format='%m/%d/%Y %h:%i:%s %A'}
STATUS
publish
ALLOW COMMENTS
0
CONVERT BREAKS
0
{categories}CATEGORY
{category_name}{/categories}
-----
BODY
{body} 
-----
EXTENDED BODY
{extended}
-----
{embed="export/comments" the_entry_id="{entry_id}"
--------
{/exp:channel:entries} 

In the comments template within the same export template group, I used the following, but I did not enable PHP in the template since there is no PHP in the updated code.

{exp:comment:entries channel="default_site" entry_id="{embed:the_entry_id}" sort="asc"}COMMENT
AUTHOR{name}
URL
{url}
DATE
{comment_date format="%m/%d/%Y %h:%i:%s %A"}
{comment} 
----- {/exp:comment:entries} 

I followed the same steps outlined mentioned in the original instructions beyond that, ie viewing the index page and viewing source and saving that.

Note: I’ve updated the above code since the original submission. In my initial attempt to import my entries, it failed. I looked through the original spec for the Movable Type Export and there were some inconsistent values in the previous code. Even after using the above code, I did a find and replace to remove some extra line returns. I successfully imported roughly 150 entries using it.

 Signature 

———-
work: jmx2.com
blog: SuperGeekery
twitter: johnmorton
email: .(JavaScript must be enabled to view this email address)

Profile
 
 
Posted: 24 August 2010 03:08 AM   [ Ignore ]   [ # 1 ]  
Lab Assistant
RankRank
Total Posts:  199
Joined  04-28-2010

I’m probably missing something but after doing this how do you IMPORT the MT-formatted data?  grin

 Signature 

http://digitalformula.net/
@digitalformula
ExpressionEngine 2.2.1 build 20110705

Profile
 
 
Posted: 24 August 2010 04:02 AM   [ Ignore ]   [ # 2 ]  
Chancellor's Fellow
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  33338
Joined  05-15-2004

There is a tool for that in EE 1.6.9. No importer exists yet for EE 2.

Profile
MSG
 
 
Posted: 24 August 2010 08:09 PM   [ Ignore ]   [ # 3 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  116
Joined  10-02-2002

How I imported was to install 1.6.8, which was the current version at the time, then import my data then do the upgrade to EE 2. My import didn’t end up working perfectly for my comments. Entries with multiple comments ended up having a single comment that contained the data for all the comments on posts. I decided that was good enough for what I was doing since at least the data was preserved.

 Signature 

———-
work: jmx2.com
blog: SuperGeekery
twitter: johnmorton
email: .(JavaScript must be enabled to view this email address)

Profile
 
 
Posted: 15 November 2011 03:26 PM   [ Ignore ]   [ # 4 ]  
Summer Student
Total Posts:  1
Joined  04-17-2011

Just used this to export from ExpressionEngine v1.6.8 to MoveableType and then into WordPress 3.2.1 using the MoveableType import plugin. Thank you - thank you - thank you. The wife (it’s her blog) and I are very happy about the smooth transition.

Tips & lessons learned:
1) L14N and I18N - had to do search&replace; in the exported file for scandinavian letters into html codes. Like Å into Å, ½ into ½ etc.

2) We wanted the category “oldblog” for all 477 imported posts, set this in the script with:

CATEGORYoldblog 

rather than editing the output ...

3) Go through the output after references to the old site:
3a) www.oldsite.com/expressionengine/index.php - we removed these smile
3b) www.oldsite.com/expressionengine/images/smileys/* - we ftp’ed them to www.newsite.com/oldblog/smileys/*
3c) www.oldsite.com/expressionengine/images/uploads* - we ftp’ed them to
www.newsite.com/oldblog/uploads/*

Profile