Go back to working and paste it on the next line then. Okay, under our categories, the next free line, we paste that in. So WP post sections are not sure what that is for but we do not need it, it is optional. First, what we need is the body, and then the title, and then the title in the post, then the categories, and then the link itself, the image L, that is called actually, squeezes that back a little bit. The last one is the post data, which is there somewhere. Okay, so first thing we need is the body, which is the actual text of the description. So, we go back to our master file, and we are looking for, just want to cross a bit, product description. So what I want to do is hide the whole of that column, again, it is 400 out here, grab that, copy it, go back to working, paste it underneath, so we now have a description. Then we need a title, which is going to be the name of the product, so again, we got back to the list, we get a product name and we scroll down to the bottom and copy that, go back to working, paste it in under the WP title.
Now, you can use the same thing for this, which is the title in the body. Basically, the last thing I am going to do is put this product name in the post itself as well as in the title. Just know how many is doing that, it is an extra copy of the key word. Then the category which is a repeat of the category that we had here. So again, we go back, we find product cast grease, we highlight the whole lots. It takes just a second or two, as you can see. If you had 70,000 to 80,000 in there, it is going to take a bit longer to do this but then you need to redo the work once and you end up with the lot of post for your blog. Set categories, we then need the WP link, which is the product here. So again, highlight that, and to the bottom, we skip to that, and again, just paste that in, then we are going to go for the image here as well. So the image here is the next one along, probably could have grabbed both columns that would not go for this bit in mind, was not thinking there. So copy that, go back to working and paste it under the image here, and we are actually missing a bit at the end, and what went on there, where have I put that.
Here we go, I missed one of them. Be careful; make sure you grab all the data from this master file. So I am going to copy that bit, get back to my working and paste that in this last column here. Now, this is the date to publish and then the period between each post, okay. So the first one, we leave as blank, the second one, you are going to decide how many minutes later, I believe Neo went for something like five minutes, I think five minutes is a bit short, so I am going to go for 56, and you actually have to type in minutes, okay. And then the next one will be another 56 minutes, so two 56 is or 112. And then again, we got a 168 and my math is right here, okay. Now, you not going to have to go through and do that for all of them, providing you do in multiple of 56. You can grab the first three, and when this changes to a cross here, you can grab it and run down and you can see that there is a little box there with a number of minutes that is changing as I get into the bottom and when we get there, there we go. We got 30,520 minutes, and it does that automatically for you, which is a bit of time saver.
That is our data file saved or not saved yet, that is formatted. Now, the working one is actually, what we are going to use, so I should actually called that excess. What I am going to do is rename this as; I will just call it AD wifeed. Now, I said earlier in the last word at the start of this video that we wanted that one at the start, it is not. It is this one that we needed at the start because this is our actual file that we are going to use; this is what we are going to feed into the data, into the plug in itself to get a post done. So we need to make sure that is the first one on this list, because, what we are now going to do is choose the save it, we are going to save it as a CSV file.
If we save this as a text file, it would not work. If we save this as an XLS file, it would not work. So, we need to look on the list and find CSV, delimited file. That is the file that we want and I will again quit. Now, the name of the blog I am going to use and I will click on save now, it is going to come out with the a warning, just say that the file type that I have chosen ICSV does not support work books, stumbling over my worst day. That is basically saying it would not save all of this. What it will do is only save the first one, which is why we need the important one at the start. So we okay that, we are going to say okay. So as the saying, there is other data in there that will be lost; it should not actually using the data, its formatting, which we are happy with, because we are saving as a CSV file. So on my voice is going; this is why I would only keep my video short. Okay, so we have saved that file, that is our master file. If we go back to the directory, we now hove to access addict, which is my blog name.csv, which is the file that we are going to use in the next video, when we are actually going to import that into the plug in and get it posting to the blog.
That is how you actually format the datafeed into a suitable format for your blog to get it posting. This video is on blogtactics.com on the video’s page, thanks very much.
Transcription by:
Scribe4you Transcription Services