Transcript

00:04 hey everyone i wanted to do a video for
00:06 you guys to show you
00:08 how you can
00:10 export
00:12 a wordpress blog
00:14 and still be able to use the images that
00:18 it has in it
00:19 and
00:20 use it for
00:22 a total cms blog
00:24 now
00:25 the utility that that joe has provided
00:28 to us allows us to
00:30 take an existing blog
00:32 and export it to a csv file
00:36 and unfortunately
00:38 with that
00:39 we can't export images that are
00:42 associated with the blog
00:44 natively i guess and
00:46 so
00:47 there is a little work around that you
00:50 can do with an existing blog
00:52 and then a solution
00:55 for moving forward with a new blog
00:58 so
00:59 i'm going to show you guys this is a
01:03 friend's website
01:05 and they have
01:07 a blog up here
01:16 so here's their blog
01:17 okay
01:18 so each one of these images is
01:20 associated with one of the posts and
01:22 they do repeat you know some of the
01:24 images do repeat
01:25 and this is actually in wordpress okay
01:27 so i'm going to show you how to do this
01:29 from a wordpress site and
01:32 put it into a foundation 6 site
01:35 and i'll be using my my case on project
01:37 file to show you guys this okay so i'm
01:41 already logged in to the wordpress
01:43 backend
01:45 so i'm going to go to there now
01:50 alright so this is wordpress if you
01:53 aren't familiar with it
01:55 alright so there is a plugin for
01:58 wordpress that you're going to need it's
02:00 called all export it's free
02:04 and it does a pretty decent job
02:06 so i'm going to go ahead and click on
02:09 new export
02:12 and choose the post type i'm going to do
02:14 posts
02:17 okay
02:18 so then you can customize it um do
02:21 whatever i'm just going to customize
02:23 just so you can you know
02:25 make sure everything is going to come
02:27 through okay so
02:28 it's it by default it only does three
02:31 uh columns and so i'm gonna do at all
02:34 because i don't know what really
02:37 the the ones that i need are going to be
02:39 so i'm just going to add all and i'm
02:41 going to say continue
02:47 and confirm and run
02:52 and what this is going to do is
02:54 generate a csv that will download
03:02 so i'm going to go ahead and open this
03:04 csv file
03:09 all right it's
03:11 so here is all the information that
03:15 that we got from
03:17 the wordpress all right
03:19 make this a little bit bigger okay now
03:21 that's a lot of information right
03:24 so how do you find
03:26 the columns that you're going to need
03:28 you know what are you going to need to
03:30 do the import into total cms
03:32 well joe has very kindly provided for us
03:35 a utility
03:37 and if you open up your ftp client of
03:39 choice i'm using transmit here
03:43 you
03:44 open it up go to rw common folder
03:48 and then plugins
03:51 stacks
03:54 and then
03:58 i believe it's total cms
04:03 and then you have total import
04:06 okay so again that path is
04:08 rw common
04:10 plug-in stacks
04:12 total cms and total import so okay what
04:16 i'm going to do is i'm going to right
04:18 click on this say copy url just so i
04:21 have it
04:22 and i'm going to do a new tab
04:28 and paste that in there
04:30 all right so
04:31 this is the utility and this is going to
04:34 be the same
04:35 for
04:36 any total cms
04:39 or
04:39 foundation 6 and total cms website it's
04:42 going to be the rw you know whatever
04:44 your url is
04:46 rwb common plugin stacks total cms total
04:48 import
04:50 so we need a little bit of information
04:52 here we're going to need the total cms
04:54 license key
04:55 the blog id
04:57 which will be blog in our case and the
04:59 csv for the imp for the import
05:02 but
05:03 joe has also been
05:05 kind and provided for us a sample
05:09 which is what we're going to use to
05:11 fill in our
05:13 our import file
05:15 so i'm going to open this up
05:19 all right now you see that you have all
05:22 the all the columns are basically
05:25 the different
05:26 child stacks within a blog so permalink
05:29 timestamp title summary on and on and on
05:31 right
05:32 so this is how we will be able to
05:36 know what we need to fill in and the key
05:38 thing here is going to be the media for
05:40 us to get those images and i'll show you
05:43 in a bit how or why
05:45 but for right now i'm just going to
05:46 delete the existing content
05:50 and i'm going to go ahead and
05:55 let's see
05:57 i'm going to look over here so permalink
05:59 definitely need the permalink you know
06:00 we want to make sure everything is
06:02 going to be matchy matchy so
06:04 the site permalink
06:06 for the wordpress
06:08 is here and it has you know
06:11 the existing website the folder it's in
06:14 and then here's the permalink it's going
06:16 to be this right here
06:18 now i can go through and you know
06:20 do
06:21 you know a little bit of
06:23 um
06:25 you know find and replace and all that
06:27 fun stuff but another cool thing at
06:30 least it's kind of cool in my opinion um
06:33 is in the export
06:36 you also get what's called i think it's
06:39 the slug okay so here's the slug
06:44 column i'm going to expand that out a
06:45 bit so
06:46 here we have the
06:49 the permalink without all the fun stuff
06:51 so i'm going to just
06:54 click this guy
06:55 option click
06:57 the first
06:58 row because i don't need it i'm sorry
07:00 command click the first row because i
07:01 don't need it
07:02 copy
07:05 come over here and
07:07 paste
07:09 okay so here is our first
07:13 first hurdle down we got the permalink
07:15 right
07:17 okay
07:18 time stamp
07:20 it's good to have the timestamp you know
07:21 if you want to make sure that your
07:23 your blogs are
07:24 you know show up on the same
07:27 month and day and everything so i'm
07:29 gonna do the same thing here
07:31 click
07:32 command click the first row
07:35 copy
07:37 paste
07:39 okay
07:41 so i got my my dates in here i'm going
07:44 to go ahead and do the rest
07:46 and
07:47 you know come back but what i'm going to
07:49 do now is show you the media once i'm
07:51 just going to do it just for for good
07:53 measure okay so in this export we also
07:56 have the image url
07:58 okay
08:00 which is
08:02 a very fun long
08:04 thing
08:05 okay
08:06 it's going to be
08:07 the url
08:09 forward slash wp-content which is
08:11 wordpress content uploads and then the
08:14 subfolders that you know those images
08:16 are in
08:17 so i'm going to go ahead and
08:20 command-click the first line see
08:24 and then come over here and paste there
08:26 we go
08:28 all right make sure i didn't paste it
08:29 twice okay
08:32 so
08:34 obviously
08:35 if we're
08:37 going to be moving to
08:39 let's say that you have a dev site that
08:40 you're working on you know like for me
08:42 this this one is
08:44 owensrecoveryscience.com
08:46 my dev site would probably be
08:48 ors dot
08:50 you know
08:51 graphicgato.com or whatever because it's
08:53 a dev site but i want to make sure that
08:55 you know i can still see the images
08:57 or let's say that you know the the
08:59 company has changed their name you know
09:01 it's not owens recovery science it's
09:03 we have reallycoolstuff.com and you know
09:06 you want to make sure that the images
09:08 still show up so
09:10 what you can do is do a find and replace
09:14 so if it was me
09:15 i know that my images i've already
09:17 actually uploaded the image folder this
09:19 this uploads you know blah blah blah
09:22 folder into transmit
09:24 and so for me
09:27 it is going to be i created an images
09:29 folder
09:30 and then i have uploads and here they
09:31 all are okay so i just downloaded
09:34 this folder from the existing wordpress
09:37 site and it uploaded it into my server
09:41 so how do i get that to match up well
09:45 i'm just going to
09:47 come over here
09:48 and since i know that uploads is the
09:50 last or the the first folder that i
09:52 created
09:53 i'm gonna just
09:55 come over here and delete
09:58 or i'm gonna say i'm gonna find all this
10:00 here i'll just do the whole thing
10:04 i'm going to copy that
10:06 i'm going to do a command f
10:10 and make sure i have the replace on
10:13 i'm going to say i'm going to find this
10:16 okay
10:17 and what i'm going to do is i'm going to
10:18 replace it
10:20 with
10:25 kson.weaverbasesite.com
10:31 forward slash
10:33 images forward slash
10:38 okay
10:39 so
10:41 the existing one is owns recovery
10:43 science dot com forward slash wp dash
10:46 contents
10:48 let me just do that make sure it's
10:51 all the same
10:52 and i'm replacing it with mine and
10:54 instead of wp content i have images
10:57 because beyond this beyond this is going
10:59 to be
11:01 the uploads folder
11:03 like you have here so uploads
11:05 alright so i'm going to say replace all
11:09 all done made 176 replacements
11:12 close all right so now we have
11:15 the correct folder
11:17 or file path
11:19 for
11:20 each of these images okay so i'm gonna
11:22 go ahead and do the rest and i will be
11:23 back okay
11:25 okay so
11:26 i have now just copied in all the
11:29 information that i want to bring over
11:32 just for this example okay
11:34 so i have
11:36 permalink
11:37 timestamp
11:38 i have the title
11:40 and then i left summary blank because on
11:43 the existing one
11:45 the existing website
11:58 they don't have a summary okay so i'm
12:00 just trying to make it match up
12:02 for this example
12:06 i have the content for the blog
12:10 and i know this has html tags in it um
12:12 that's okay
12:14 i took i brought over the categories
12:16 just so you know you can see that it
12:17 does bring over categories and then the
12:19 media file which is going to be the
12:21 image okay
12:23 okay so i'm going to save this
12:26 and then we're going to go back over to
12:28 safari we're going to go up to
12:31 the total import
12:32 i'm going to paste in my key
12:35 blog id
12:36 i'm going to choose the file
12:40 so import
12:42 okay upload
12:45 and then i'm going now just just so we
12:47 can see what we don't have yet
12:50 so
12:51 i'm going to go to
12:53 case on i'm going to go down to
12:56 blog post
12:58 and right now i only have two blog posts
12:59 okay
13:00 post one post two nothing in drafts
13:03 nothing in archive that's all i have
13:05 and even over here on the preview page
13:07 which i know this is
13:09 i have all the total cms macros turned
13:12 off so
13:14 all it's showing is these two blog posts
13:16 now i'm gonna
13:18 come over to the importer
13:21 and paste in my license key
13:24 the blog id
13:27 the blog id i'm going to
13:29 set the
13:31 csv for upload to be the total import
13:34 file that we just made which is again
13:37 this guy
13:38 okay with all the correct
13:40 column
13:41 headers
13:42 and say import csv
13:47 all right so
13:49 it has imported
13:52 all of these
13:54 so when i come back over here
13:56 and i reload
14:00 boom it's got all my
14:03 all my blog entries all right
14:05 now don't worry about the image not
14:07 showing up i'll show you what how that's
14:09 going to work let me refresh this guy
14:12 okay
14:13 so
14:14 i only have this set to show
14:16 however what's it nine ten ten blog
14:18 posts right now
14:20 but you notice there's no image right so
14:23 okay how do we fix that
14:25 so i'm gonna go into rapidweaver
14:27 and i have my
14:29 blog
14:30 list page open
14:32 and i have my my image stack
14:35 in my from my blog list image stack here
14:38 so clearly if there's no image to show
14:40 then it won't show anything
14:42 but what i'm going to do is put in a
14:44 layout rule
14:46 okay
14:47 now this layout rule is going to be
14:50 if
14:51 there's
14:52 no content in the image stack okay so
14:55 like the image you haven't dragged and
14:57 dropped an image into the image well
15:00 um
15:01 it's going to show something so i have
15:03 no content
15:05 and i'm going to say for image
15:08 okay
15:09 and then i'm going to come over here and
15:12 find the picture stack
15:18 okay and then for warehouse i'm going to
15:21 image set link to
15:30 media
15:36 okay
15:38 and so now that takes care of it you
15:40 know this this makes it so that
15:43 if
15:44 the image is missing
15:46 then it will use
15:48 the media
15:50 macro to put in the path for that image
15:53 okay
15:55 now
15:55 let's say that i have
15:57 an image okay that i i've actually
16:00 dragged and dropped an image in because
16:01 it's it's a new blog post you know
16:03 moving forward
16:04 so i'm going to do another layout rule
16:11 okay and this one
16:12 this one is going to be has content
16:15 image
16:17 okay
16:18 and i'm going to take this image and
16:20 drag it into here
16:22 so now i have two layout rules
16:25 that i'm going to be working with
16:29 okay
16:30 and so let's go ahead and preview this
16:34 post okay
16:37 it's not working now why is it not
16:39 working
16:40 i think i do know why it's not working
16:44 and i was right i misspelled
16:47 i misbuilt my own website so that's a
16:50 fairly easy fix we'll just take
16:53 this
16:56 okay
16:59 i'll do
17:00 find and replace
17:04 and i'm going to put
17:07 case on weaver base
17:09 steyr for some reason like
17:12 that's a fun one so i'm going to do site
17:15 okay weaver base site
17:18 this is the beauty of
17:19 find replace
17:22 actually
17:24 i need to do this sorry
17:26 steyr
17:28 and replace it with
17:30 site okay so
17:33 replace all
17:35 okay close now unfortunately but you
17:38 know it's not a big deal
17:40 we're going to need to
17:42 re-upload
17:44 that that
17:45 file so this is a good example of you
17:47 know oops i need to fix something so you
17:50 can come over here
17:52 paste in your
17:53 license key blog id
17:56 you know choose your file and then say
17:58 import
17:59 and the cool thing is it will overwrite
18:02 whatever information you have okay so
18:05 now that we have
18:06 fixed the
18:08 the website path error
18:10 we can go back to
18:12 rapidweaver
18:14 and
18:15 what i've done is in the background just
18:18 you know while everything was
18:20 working
18:21 i
18:22 added a layout
18:24 stack and then put the two layout rules
18:27 inside of it and for the picture stack
18:31 i did center image fill container
18:33 and then
18:34 this layout i made it 300 pixels high
18:37 okay so pretty basic stuff just just to
18:40 you know make things a little bit better
18:42 okay and so now now that we've fixed the
18:45 fun little error if i preview
18:49 you see now we have the images show up
18:51 okay now clearly i have to go through
18:53 and fix you know heights and
18:57 text sizes and things like that but
19:00 we now have
19:01 our blog with the blog images now you're
19:04 going to notice that some of these don't
19:05 show up and why is that for some silly
19:08 reason
19:09 if i come in here like in this
19:11 top one up here
19:13 it's
19:16 it has
19:17 this
19:19 fun
19:23 thing right here where it's like a pipe
19:25 symbol
19:27 plus you know
19:29 the the url as well so i'm going to
19:32 delete that
19:33 and hit save and this is just you know
19:36 unfortunate
19:37 little cleanup stuff that we have to do
19:40 because it came from a wordpress site
19:42 so if i scroll down
19:45 ah here
19:46 nope that's just a
19:47 skinny thing
19:49 all right
19:52 so i'm just going to scroll down
19:55 and see if there are any others
20:01 yeah like this one right here
20:04 so i'm going to come over here do the
20:06 delete everything after the pipe and
20:08 i'll just go through and clean all this
20:10 up
20:11 and come back
20:13 okay i think i got them all so what i'm
20:15 gonna do is come back over to the
20:17 importer
20:18 if you hit the back button it will keep
20:20 your license your blog id and the thing
20:23 so i'm just going to hit import csv it's
20:26 going to work its magic come over here
20:28 reload
20:29 the page and those broken image
20:32 urls are back or
20:35 are fixed
20:36 so now
20:38 i have the original
20:41 blog image okay
20:43 from the wordpress site and moving
20:46 forward
20:47 all i have to do now is
20:49 drag and drop an image into
20:51 that
20:52 image well in the in the blog form and
20:55 you're good to go but another kind of
20:57 interesting thing is
20:58 you know you still have the media
21:00 field in the blog form so
21:03 you could essentially
21:05 instead of having your client or you
21:07 drag in an image you could just have
21:09 them paste in a url to that image so you
21:14 have options now
21:16 so now obviously you know if
21:20 if you have it set up with the layout
21:22 rule you know here that means that on
21:25 the actual blog post page
21:27 you're going to have to set it up there
21:29 as well another another layout rule so
21:31 you're going to say you know
21:32 if
21:33 image is empty then use the media macro
21:36 and and vice versa okay
21:38 so hope this helped you guys
21:41 i look forward to seeing you guys on the
21:43 friday hangouts and in the community bye"}]