How to Migrates FuneralNet Obits to WordPress Obits

 

Plugins Use

  1. Bulk Delete
  2. Really Simple CSV Importer
  3. Duplicate Remover
  4. Reset Permalink
  5. Phpmyadmin

FuneralNet Files

  1. family.xls
  2. images.zip
  3. images.xls
  4. locations.xls
  5. main.xls
  6. message.xls
  7. obit.xls

Here’s how :

  1. Convert all xls files to csv use MS Excel to do the job
  2. Import all CSV using your phpmyadmin to the database where your wordpress setup
    • Rename them according to the name of csv file
  3. Extract all the images and upload it to the images folder of your domain
  4. Extract All the column needed for the post  using the sql command below :

 
[php]
SELECT obit.id as reference_id,

CONCAT(main.fname, ‘ ‘, main.mname, ‘ ‘, main.lname) as post_title,

obit.bio as post_content,

DATE_FORMAT(main.ddate,’%Y/%m/%d %H:%i:%S’) as post_date,

CONCAT(‘http://www.yourdomain.com/images/’,image.id, ‘/’, image.iid, ‘.jpg’) as post_thumbnail,

CONCAT(‘Obituaries’) as post_category,

CONCAT(‘publish’) as post_status

CONCAT(‘post’) as post_type

FROM  `main`

LEFT JOIN obit ON ( obit.id = main.id )

LEFT JOIN image ON ( image.id = main.id)[/php]

  1. Export the output the sql above  as CSV
  2. Import the CSV using Really Simple CSV Importer
  3. Check for duplicate using Duplicate Remover
    • Delete all duplicate
  4. Extract all condolences using the SQL below

[php]
SELECT

wp_posts.ID as comment_post_ID,

message.name as comment_author,

message.email as comment_author_email,

message.date as comment_date,

message.text as comment_content

FROM `wp_posts`

LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)

LEFT JOIN message ON (condolence.book_id= wp_postmeta.meta_value)

WHERE wp_postmeta.meta_key=’reference_id'[/php]

 

  1. Export the output above
  2. Using cpanel import it to wp_comments  table
    • Post specific option
      1. comment_post_ID,comment_author,comment_author_email,comment_date,comment_content
  3. DONE