Home  >   Forum Home  >  ExpressionEngine Community Forums  >  "How to"  >  Thread
   
 
Do I export tables?
 
Ryan Downie
Posted: 27 June 2009 04:21 AM   [ Ignore ]  
Lab Assistant
Avatar
RankRank
Total Posts:  176
Joined  05-19-2008

Hello,

Sorry must not have been clear in my last post as none answered it =(.

What I have done is created a new site for a client and they have an existing website. I have created new weblogs and custom fields that are different form the main site.

What I am trying to do is to get the content form the old site (posts, comments and categories) and put it on the new site.

What is the best way of doing this?

 Signature 

I design, I blog, and I Twitter

Profile
 
 
Ryan Downie
Posted: 28 June 2009 04:40 AM   [ Ignore ]   [ # 1 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  176
Joined  05-19-2008

bump

 Signature 

I design, I blog, and I Twitter

Profile
 
 
Andrew Weaver
Posted: 28 June 2009 07:38 AM   [ Ignore ]   [ # 2 ]  
Lab Assistant
RankRank
Total Posts:  188
Joined  12-21-2005

If you have entries in both databases (old site and new site) then you might have trouble just merging the data.

Try exporting the old data into MT Export format and importing it into the new site.

Wiki entry for exporting data: http://expressionengine.com/wiki/Export_Entries/

 Signature 

Andrew Weaver — brandnewbox.co.uk


Member of EE Professional Network · More plugins, extensions and modules · Documentation

Profile
 
 
Erik Reagan
Posted: 28 June 2009 08:08 AM   [ Ignore ]   [ # 3 ]  
Research Assistant
Avatar
RankRankRank
Total Posts:  605
Joined  03-24-2009

Try looking at XMLGrab/FeedGrab/CSVGrab. I have used XML grab twice to import site data into an EE site and it worked very well. If you can get the client’s “old” site into an XML format, you can use this plugin to import into EE. It’s the best solution I have found for something like this.

http://www.brandnewbox.co.uk/products/details/xmlgrab/

 Signature 

-Erik Reagan
on Twitter @ErikReagan

ER Developer Toolbar - a beautiful bridge between your site’s front-end and control panel.
Redirect Helper Lite - need help creating redirects for your EE site? Here’s your solution!

Profile
 
 
Ryan Downie
Posted: 28 June 2009 10:30 AM   [ Ignore ]   [ # 4 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  176
Joined  05-19-2008

Hi Andrew,

I have gone through and done that export and import and it worked a little, the only problem now is that the comments and images didn’t come over on the import. Is there a way of doing this too.

Thanks for your help

 Signature 

I design, I blog, and I Twitter

Profile
 
 
Andrew Weaver
Posted: 28 June 2009 01:20 PM   [ Ignore ]   [ # 5 ]  
Lab Assistant
RankRank
Total Posts:  188
Joined  12-21-2005

Hi Ryan,

The MT Import facility should allow you to import comments at the same time. The first step of the wiki article should have set that up.

You’ll need to manually copy the image files from one server to the other. If you need to use extra custom fields there are some instructions here:

http://expressionengine.com/docs/cp/admin/utilities/movabletype_import_utility.html

Hope that is some help…

Andrew

 Signature 

Andrew Weaver — brandnewbox.co.uk


Member of EE Professional Network · More plugins, extensions and modules · Documentation

Profile
 
 
Ryan Downie
Posted: 28 June 2009 03:51 PM   [ Ignore ]   [ # 6 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  176
Joined  05-19-2008

ok it seems not to be working when I save the code as displayed on the http://expressionengine.com/wiki/Export_Entries/ page.

I have done this for step one;

<?php

global $IN;
$IN->QSTR = '{embed:the_entry_id}'

?>

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

And this for step two;

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

I am getting somethings to export but no excerpt and quite a few posts are missing the body.

Example of code;

AUTHOR: Todd Rhoades
TITLE: Official Summer Hiatus&#8230;
STATUS: Publish
ALLOW COMMENTS: 2
CONVERT BREAKS: br

DATE: 06/16/2009 07:10:00 AM
-----
BODY:

-----
EXTENDED BODY:

-----
<?php

global $IN;
$IN->QSTR = '9159'

?>


--------

And the clients site is http://mondaymorninginsight.com/index.php so you can see the first post has the content there.

 Signature 

I design, I blog, and I Twitter

Profile
 
 
Ryan Downie
Posted: 29 June 2009 03:15 PM   [ Ignore ]   [ # 7 ]  
Lab Assistant
Avatar
RankRank
Total Posts:  176
Joined  05-19-2008

still no joy on this =(

 Signature 

I design, I blog, and I Twitter

Profile
 
 
   
 
 
‹‹ Prev_entry next_entry and conditionals      custom icon within weblog tag? ››
Post Marker Legend
New Topic New posts Hot Topic Hot Topic with new posts New Poll New Poll Moved Topic Moved Topic Sticky Topic Sticky topic
Old Topic No new posts Hot Old Topic Hot Topic with no new posts Old Poll Old Poll Closed Topic Closed Topic Announcement Announcements
Theme
Change Theme
Visitor Statistics
The most visitors ever was 1743, on December 02, 2009 02:47 PM
Total Registered Members: 115027 Total Logged-in Users: 123
Total Topics: 122462 Total Anonymous Users: 54
Total Replies: 647374 Total Guests: 479
Total Posts: 769836    
Members ( View Memberlist )
Newest Members:  Sunil Shenoy,  David Barrett (Contrast),  vasishta,  Aracne editrice S.r.l.,  Richard Feliciano,  The Ocean Agency,  terence35cameron,  Larry.Zhao,  MKLogicPlus22Gary,  denada777
Active Members:    .jb,  3000,  a38d,  Adam Dorsey,  adamwiggall,  adlur,  aesthetica,  Andrew Macpherson,  artsengine,  At the Gates,  Atenua,  atiosis,  Bennobo,  bluedreamer,  bmiller,  bouch,  burkeb03,  cc000001,  Chris Clarke,  Compass360,  Crucial,  Daniel H,  davidandlila,  Davide Bonetta,  designerhandbags,  Doug E,  dstechroom,  dubsak,  dxagency,  Dylan Smith/ContextDesign,  eefalcon,  ewn,  expocom,  fccinter,  fensterbaby,  ForestPark,  Frank Spilker,  fusioee,  Georgi Veznev,  gesturestudio,  gomacro,  Greg Aker,  grrramps,  guru24,  Gwarrior,  hearsay,  iamnick,  impdesigns,  ITWY,  Jacob Fentress,  Jason Ferrell,  Jay F,  Jörg Gudehus,  jducka1,  jeffkoncz,  jmorin,  John Morton,  JohnD,  kalweb,  Kevin Evans,  Komra Moriko,  Kurt Deutscher,  lebisol,  lifetreecreative,  lincolnpixel,  Linkshark,  log cabin,  Lyle Anderson,  magicmirror3,  Mario Rodríguez,  Mark Bowen,  Mark Croxton,  Marker Maker,  Matthew Ellis,  MH_Jez,  Michael Byström,  mjfr226,  neostructuralist,  Nevin Lyne,  nevsie,  Nico Smit,  Noah Kuhn,  Oliver Nielsen,  pab514,  Panchesco,  ParisJC,  Pascal Kriete,  PipSpratt,  PoP.Life,  qbrands,  registry,  Renman,  Response1,  rippe,  roj,  running with scissors,  russlipton,  Ryan Faubion,  Sean McDevitt,  seansciarrone,  shinka,  slapshotw,  smartpill,  smidoid,  spacewalk,  sseremeth,  stef25,  stephenslater,  Steven Grant,  Tactile Design Group,  timprint,  Tomaz B.,  tsiger,  tvruwink,  vobtoavi,  X-Team
Powered By ExpressionEngine
ExpressionEngine Discussion Forum - Version 2.1.1 (20081028)
Script Executed in 0.4804 seconds
Atom Feed   RSS 2.0