importing to ee2 using datagrab

EngineSummit 2010

1Importing to EE via DataGrab

Importing to EE2 viaDataGrab

EngineSummit 2010

2Importing to EE via DataGrab

Old School WayMT ExpOrT FOrMaT

MT IMpOrT UTIlITy

EngineSummit 2010

5Importing to EE via DataGrab

New School WayaNDrEW WEaVEr’S DaTaGraBhTTp://BraNDNEWBOx.cO.Uk/prODUcTS/DETaIlS/DaTaGraB

cOMMErcIal aDD-ON: £20.00

EngineSummit 2010

6Importing to EE via DataGrab

Features:IMpOrT DaTa VIa rSS/aTOM, cSV & xMl

Map DaTa ValUES TO a chaNNEl’S cUSTOM FIElDS

aSSIGN ENTrIES TO aN aUThOr

aSSIGN caTEGOrIES TO INDIVIDUal ENTrIES

cOMMENT IMpOrT!!!

EngineSummit 2010

7Importing to EE via DataGrab

you need:a lITTlE phpMyaDMIN ExpOrTING kNOW-hOW

UNDErSTaNDING OF rSS, xMl, Or cSV

FaMIlIarITy WITh EE2 INTErFacE

FaMIlIarITy WITh EE2 TEMplaTES & TaGS

EngineSummit 2010

8Importing to EE via DataGrab

EE1 to EE2rSS cONTENT TypE

EngineSummit 2010

9Importing to EE via DataGrab

...

{exp:weblog:entries weblog="{master_weblog_name}" limit="999" rdf="off" dynamic_start="on" disable="member_data|trackbacks"} <item> <title>{exp:xml_encode}{title}{/exp:xml_encode}</title> <link>{exp:xml_encode}{title_permalink="weblog/"}{/exp:xml_en-code}</link> <description>{exp:xml_encode}{body}{/exp:xml_encode}</descrip-tion> <dc:subject>{exp:xml_encode}{categories backspace="1"}{catego-ry_name}, {/categories}{/exp:xml_encode}</dc:subject> <content:encoded><![CDATA[{body}]]></content:encoded> <dc:date>{gmt_entry_date format="%Y-%m-%dT%H:%i:%s%Q"}</dc:date> </item>{/exp:weblog:entries} ...

rSS Template within EE1

EngineSummit 2010

10Importing to EE via DataGrab

<content:encoded><![CDATA[{body}]]></content:encoded>

allow hTMl or Not allow...?

...depends on final EE2 content field type

EngineSummit 2010

11Importing to EE via DataGrab

{title} = default title field{body} = body (textarea or wygwam or whatever){gmt_entry_date format="%Y-%m-%dT%H:%i:%s%Q"} = proper entry date

create channel & custom fields within EE2 that correspond to original

EngineSummit 2010

12Importing to EE via DataGrab

create proper templates, setup site, etc.

Import Types

Settings

http://domain.com/rss/

EngineSummit 2010

17Importing to EE via DataGrab

That's it!

EngineSummit 2010

18Importing to EE via DataGrab

Wordpress to EE2 EntriesxMl cONTENT TypE

Wp's native export tool

EngineSummit 2010

20Importing to EE via DataGrab

<item><title>Title Content</title><link>http://yourdomain.com/?p=2</link><pubDate>Tue, 04 Nov 2003 02:42:17 +0000</pubDate><dc:creator><![CDATA[Ana]]></dc:creator>

<category><![CDATA[Uncategorized]]></category>

<category domain="category" nicename="uncategorized"><![CDATA[Uncategorized]]></category>

<guid isPermaLink="false">http://yourdomain.com/?p=2</guid><description></description><content:encoded><![CDATA[Blog post content, blah blah blah]]></content:encoded><excerpt:encoded><![CDATA[]]></excerpt:encoded><wp:post_id>2</wp:post_id><wp:post_date>2003-11-03 18:42:17</wp:post_date><wp:post_date_gmt>2003-11-04 02:42:17</wp:post_date_gmt><wp:comment_status>open</wp:comment_status><wp:ping_status>open</wp:ping_status><wp:post_name>this-is-the-url-title</wp:post_name><wp:status>draft</wp:status><wp:post_parent>0</wp:post_parent><wp:menu_order>0</wp:menu_order><wp:post_type>post</wp:post_type><wp:post_password></wp:post_password><wp:is_sticky>0</wp:is_sticky><wp:comment><wp:comment_id>2</wp:comment_id><wp:comment_author><![CDATA[ Comment Person's Name ]]></wp:comment_author><wp:comment_author_email>comment_author@gmail.com</wp:comment_author_email><wp:comment_author_url>http://commentersdomain.com/</wp:comment_author_url><wp:comment_author_IP>24.65.75.137</wp:comment_author_IP><wp:comment_date>2003-11-03 11:51:36</wp:comment_date><wp:comment_date_gmt>0000-00-00 00:00:00</wp:comment_date_gmt><wp:comment_content><![CDATA[ This is sample comment content ]]></wp:comment_content><wp:comment_approved>1</wp:comment_approved><wp:comment_type></wp:comment_type><wp:comment_parent>0</wp:comment_parent><wp:comment_user_id>0</wp:comment_user_id></wp:comment></item>

path = Tags that lead to main repeating entryremember NOT to have trailing slash

comments!

... currently for xMl entries only

EngineSummit 2010

23Importing to EE via DataGrab

That's it!

EngineSummit 2010

24Importing to EE via DataGrab

Gallery Module to channels

creates an exp_gallery_entries.csv fileupload this somewhere accessible by a browser on your server

EngineSummit 2010

26Importing to EE via DataGrab

"2";"1";"1";"3";"0";;;"filenameofsorts";".jpg";"Title of Image";"Description of what's happening aka the caption.";;;;;;;"1481";"1252";"89";"75";"355";"300";"o";"1191974040";"2010-09-25 07:53:24";"n";"0";"0";"0";"183"

EngineSummit 2010

27Importing to EE via DataGrab

create a new channel called “Gallery.” create a new custom field group called “Gallery custom Fields.”

ThE cUSTOM FIElDS yOU NEED TO crEaTE arE:

gallery-old-filename – Text field (select no formatting)gallery-image – File fieldgallery-description – Textarea field (select no formatting)

EngineSummit 2010

28Importing to EE via DataGrab

{exp:channel:entries channel="gallery" limit="10" paginate="bottom" disable="member_data|categories|trackbacks"}

<div class="thumb">{if gallery-old-filename}{exp:imgsizer:size src="/gallery/{gallery-old-filename}.jpg" width="100" height="75"}<a href="{permalink='gallery/'}"><img src="{sized}" width="{width}" height="{height}" title="{title}" /></a>{/exp:imgsizer:size}{if:else}{exp:imgsizer:size src="{gallery-image}" width="100" height="75"}<a href="{permalink='gallery/'}"><img src="{sized}" width="{width}" height="{height}" title="{title}" /></a>{/exp:imgsizer:size}{/if}<h3>{title}</h3></div>

{paginate}<p class="paginate"><span class="pagecount">Page {current_page} of {total_pages} pages</span> {pagina-tion_links}</p>{/paginate}{/exp:channel:entries}

Thumbnail/Index Template

EngineSummit 2010

29Importing to EE via DataGrab

{exp:channel:entries channel="gallery" limit="1" disable="member_data|categories|pagination|trackbacks"}{if gallery-old-filename}<img src="/gallery/{gallery-old-filename}.jpg" width="{width}" height="{height}" title="{title}" />{if:else}<img src="{gallery-image}" width="{width}" height="{height}" title="{title}" />{/if}<h3>{title}</h3>

{if gallery-description}<p>{gallery-description}</p>{/if}{/exp:channel:entries}

Individual Image Template

cSV configuration Screen

EngineSummit 2010

32Importing to EE via DataGrab

Questions?