Just an overview.
- I took all of my short-notes from http://computer.justetc.net to http://www.justetc.net/sayedblog: wordpress blog
- How? take your categories into wp_categories table. You can take all your categories from your current web-site/source/database into wordpress in this way.
- You may bring both databases under the same MySQL host/server. Will facilitate to write queries to transfer data.
- Take all your articles/contents into wp_posts table. Map right – your table fields and wp_posts table fileds. You can use insert into wp_posts…….select…..from your table . You know what I mean………
- Create articles and categories – mapping – in wp_post2cat table
- You may update wp_categories table to reflect the number of articles under that category
- In wp_posts table- guid field need to be appropriately generated. You can write a script to create guid/actually the article url – using wordpress existing functions such as get_permalink(), and write_posts() functions
- You can also create guid manually. After you transfer your data into wp database, from wp-admin window, open each article by clicking the edit button and click on the save option. GUID will be generated. Article links will work
- You can also do such for categories. Open all categories one by one using the edit option, and then click on the save option. From your blogs the categories will also work.
I know: creating another site with the same contents is not something that search engines love. What you can do, you can point your guide to your original location if you need both. For me, I wanted to link to my short-notes from linkedin.com, linkedin.com can display your blog contents/feeds in your linkedin home page – but your blog has to be in wordpress or in blog link…so you know where I am going to. Alternatively, you can write an application for linkedin that can display feeds from your type of blogs – or you can write a very customizable application that can ask for content source/type, db type, db name, table fields, password if any, and can show contents from the source. RSS feed should work – a simple way From: http://sitestree.com/?p=5215
Categories:113
Tags:
Post Data:2011-12-07 03:19:01
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>