12

Does anyone know any modules that can be used to import/export cms pages (and blocks) in CE?

The scenario I am looking at now is:

  • users (content editors) create pages/blocks with content on a staging website (cloned after live site, different db, different servers)
  • after the pages are being validated, the users create the pages again on the live site (copy-pasting)

Some things to take into consideration:

  • it shoudn't keep a reference to the store views by IDs, rather use the store view code
  • duplicate pages on import should be identified by url key and store views
15

On the last Hackathon we developed a module which will help you to achieve this:

https://github.com/magento-hackathon/firegento-contentsync

It will store the content in a json file, which can be synced to another server (already integrated are git and svn support). It still uses the store views by ID, but pull requests are strongly appreciated. ;)

  • Can you please, provide a Wiki page for this module. This looks quite awesome. Thank you very much :D – Thang Pham Sep 4 '14 at 8:50
  • Buddy, Question is How to Import some CMS pages from ONE magento site to ANOTHER, this is waste of time as it syncs thru GIT,SVN. Please answer the question anked. – Pratik Oct 8 '15 at 10:19
  • Currently this extension is abandoned. – Sergey Jan 13 '16 at 10:32
6

You can do export/import cms pages/static blocks easily via SSH.

  1. Export:

    mysqldump -u [username] -p[password] [database] cms_page cms_page_store cms_block cms_block_store | grep INSERT | sed 's/INSERT INTO/REPLACE INTO/' > cms-export.sql
    

    Note: Don’t forget to add prefix to cms_* tables if you have prefixed your tables.

  2. Import:

    mysql -u [username] -p[password] [database] < cms-export.sql
    

[ Make sure to backup your database before any import operation ]

REF: http://www.blog.magepsycho.com/export-import-cms-pages-static-blocks-via-ssh/

  • 1
    this assumes that live is not changed in the meantime... everything gets overwritten. – FlorinelChis Feb 12 '13 at 11:18
  • It will not export the static content, which is not in DB and only in files. – Kostanos Sep 2 '13 at 17:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.