WordPress.org

1. John Luetke
   Member
   Posted 2 years ago #

   If you are tech-savvy, or want to save yourself a bit of work, follow the directions below to save yourself a few headaches when converting your CP Archive to and .xls spreadsheet:

   1. Grab a copy of the VIM text editor
   2. Type :set ff=dos
   3. Open your CP archive file with it
   4. Type :%s/""/\"/g
   5. Type :%s/\n\n/<\/p><p>/g

   :set ff=dos tells VIM to read files in DOS format (This is how CP gave them to you).

   :%s/""/\"/g will replace all double quotes with the HTML code for a quote.

   :%s/\n\n/<\/p><p>/g will replace all line breaks (places where "Enter" was pressed) with the HTML code for a paragraph.

   Once all these steps are complete, you will have a nicely formatted CSV file, with each line being a separate article.

   If you are familiar with Regular Expressions (those snippets of code mentioned above), you can use them to pick out any other spacing or new line anomalies that might be in your export file.

   http://wordpress.org/extend/plugins/cp-import/

2. John Luetke
   Member
   Posted 2 years ago #

   This tip is no longer relevant with the release of CP Import 1.5

Topic Closed

This topic has been closed to new replies.