Title: Content Transfer/Organization Last modified: May 4, 2019 --- # Content Transfer/Organization * [ttafflinger](https://wordpress.org/support/users/ttafflinger/) * (@ttafflinger) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/) * I am taking over development of the site familytreecounseling.com. My client has an old site he is running in parallel to host content that has not yet transferred over at . I’m fairly new to WordPress and need some direction on how best to transfer and organize the content. From what I’ve been able to learn so far it seems the way to organize it would be to have an ARTICLES page with introductory information and then a page for each category of articles (Abandonment Issues, About Marriage Counseling, etc.). Then all the articles in each category would be on one page and use article titles as links to anchors to the article farther down the page. I considered a page for each article but there are over 300 of them and it didn’t “feel” right to have 300 pages. The main menu would be ARTICLES with submenu items of article categories pointing to the article category pages. * The other issue is transferring the content. The old site runs on a custom CMS built on PHP and MySQL. The new site is on godaddy. Is it possible to export content from the old site to insert into the database on godaddy using PHPMyAdmin or should I just accept that it needs to be an article by article copy and paste? * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcontent-transfer-organization%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 6 replies - 1 through 6 (of 6 total) * [Joy](https://wordpress.org/support/users/joyously/) * (@joyously) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11496753) * I would make the old Articles into posts. Posts have categories. Categories can have a description. But don’t make a page for each category. Just put them in the menu or in the sidebar with the Categories widget. You don’t need an Articles page unless you just want to call it that, but designate it as your Posts page in Settings > Reading. * Export the old database to a CSV file. There are several plugins that will import from CSV. Edit it as a spreadsheet and name the columns the way whatever plugin you use needs them to be for importing. Make sure to include the category in the CSV. * Edit: 300 articles is not that big. A few months ago, I did one that had 7200 static HTML pages. At least you already have a database. - This reply was modified 7 years ago by [Joy](https://wordpress.org/support/users/joyously/). Reason: added comment * [Kyle Pott](https://wordpress.org/support/users/kylepott/) * (@kylepott) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11496781) * Hello! * The technique you described would certainly work – so you’re starting from a good conceptual way of thinking about it. Let me offer a few suggestions that would help you take advantage of the strengths of WordPress. WordPress is incredibly flexible and you can use plugins to assist with your migration. * **Exporting/Importing** Since your current site has a similar architecture ( PHP, MySQL) to WordPress, it is very possible to write a script that could export content from your current platform into WordPress. I would avoid the manual copy/ paste routine at all costs. You can either do this directly through phpmyadmin as you’ve suggested, through a custom PHP page, or through a variety of other scripting techniques. I suggest making a copy of your current MySQL database tables so that you are working from a copy rather than the master, just to be safe. Alternatively, you might be able to scan the WordPress universe to find a plugin that would allow you to define the schema of your current site and do the export automatically for you. Sorry I don’t have a specific plugin to recommend. * Here is a link to the database schema for WordPress which describes how the back- end is organized for a standard installation. Focus on the wp_posts table which I believe is where you’ll do most of your work. [https://codex.wordpress.org/Database_Description](https://codex.wordpress.org/Database_Description) * **Site Design** I would recommend importing each of your current pages as a WordPress “post” with the appropriately denoted category or tag. * Then the header menu of each page of your site would be the major categories or tags. By organizing your site this way you can avoid the manual work of using anchors. When you click on the menu the posts will all automatically appear and be sorted from newest to oldest. WordPress has an option for you to customize how many posts appear on the page and whether you want the whole post to appear or just the opening few paragraphs with a “read more” link. * I would rely on WordPress for menu design and content organization – it’s what WordPress does best – and it would get you out of the hassle of manually organizing the content. The menu, posts, and categories/tags are all native to WordPress and very easy to configure through the wp-admin portal once you have your posts imported. * Good luck with your project, it is very doable. I would be happy to answer any more specific questions you may have. Best wishes! * Kyle - This reply was modified 7 years ago by [Kyle Pott](https://wordpress.org/support/users/kylepott/). * Thread Starter [ttafflinger](https://wordpress.org/support/users/ttafflinger/) * (@ttafflinger) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11498326) * Thank you for your suggestions! A previous developer, who is not available for consultation, had already transferred over some articles as posts and I had already played around with assigning a category to one of them to get it to be accessible via the menu. The article has a permalink specified of managing-abandonment-issues- through-recovery-chapter-one and so is available at [http://familytreecounseling.com/managing-abandonment-issues-through-recovery-chapter-one/](http://familytreecounseling.com/managing-abandonment-issues-through-recovery-chapter-one/). I have an Articles category to which I assigned it and then added that category to the menu. That menu item is ARTICLESCATEGORY to differentiate it from the ARTICLESPAGE menu item that is a page I had been experimenting with. So what I thought would happen is the post of the article would display via the ARTICLESCATEGORY menu item but that isn’t happening. What am I missing? I’m much more comfortable with coding than I am the abstraction offered by a CMS so thank you in advance for your patience. * [Kyle Pott](https://wordpress.org/support/users/kylepott/) * (@kylepott) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11498486) * Exactly what you described should be happening. However, when I click your ARTICLESCATEGORY menu item I get a blank index.php page instead of the WordPress page listing all of the posts with the ARTICLES category. * I think the issue is your life-changing-articles static page and your life-changing- articles category have the same slug. For debugging purposes, try changing the slug on your static page to life-changing-article-static-page and then check to see if your menu item behaves the way you want it to. * Here’s the issue you may be having. * [https://wordpress.stackexchange.com/questions/32561/using-same-slug-name-for-a-page-and-category](https://wordpress.stackexchange.com/questions/32561/using-same-slug-name-for-a-page-and-category) * [Kyle Pott](https://wordpress.org/support/users/kylepott/) * (@kylepott) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11505016) * I can tell that changing the slugs didn’t work for you and I’m sorry about that. You may have a plugin/theme conflict. I can see you have Yoast installed and others have noted a similar issue in the past in that sub-forum about category pages not showing up. There is a suggested fix over there that you could try. * [https://wordpress.org/support/topic/links-to-categories-produce-blank-pages/](https://wordpress.org/support/topic/links-to-categories-produce-blank-pages/) * Before you do that though, you may want disable all plugins in WordPress, to see if the /category/life-changing-articles/ page loads as you’d expect. * Sorry about all this! * Kyle * Thread Starter [ttafflinger](https://wordpress.org/support/users/ttafflinger/) * (@ttafflinger) * [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11505031) * Oh my gosh! Don’t be sorry! That you would take it upon yourself to follow up and offer more suggestions is so appreciated. Thank you! Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Content Transfer/Organization’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 6 replies * 3 participants * Last reply from: [ttafflinger](https://wordpress.org/support/users/ttafflinger/) * Last activity: [7 years ago](https://wordpress.org/support/topic/content-transfer-organization/#post-11505031) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics