Body: <p>I'm moving hosts, and want to preserve a number of Mosaico templates that I've created. Mosaico had to be re-installed. It is running, but the templates are now gone. I have backups of the SQL tables. Attempts to just 'insert the rows' into civicrm_mosaico_template table have been unsuccessful. (and broke the mosaico install). So, uninstalled/reinstalled - to a clean mosaico again...</p>
  
  <p>Any suggestions on how to re-import those templates?</p>
  
  <p>Thanks!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-26T14:06:33.880Z
Comments.Text: Have you by any chance kept copies of the html source code for each template?  If you have then it would be easy to import them into new message templates in civicrm by copy and paste through the html editor for each new template by using the "Source" button
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-30T16:31:08.940Z
Comments.Text: I don't see a 'source' button in the Mosaico Editor. (I do in the 'traditional template' editor though.)
  I thought HTML was in the db in the mosaico template file, but, it's not clean. I do have html files, though they were the 'received' emails I sent to myself, so they'd need to have a bunch of cleanup so they could go out again. I'm beginning to think that is going to be my only recovery. Was hoping that it would go back into mosaico, vs std templates.
Comments.UserDisplayName: Clark Hodge
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-05-30T17:28:55.123Z
Comments.Text: I dont have the Mosaico extension installed but I've successfully compiled a Mosaico template on the Mosaico website, copied the html and saved it in a new template in Administer/Communication/Message Templates/Add Message Template/HTML Format using the Source code therein.  If you already have the HTML code for the templates you wish to import then you could perhaps go down the route I've described.  Hope this helps.
Comments.UserDisplayName: peterb
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-08T12:01:41.357Z
Comments.Text: It works the way peterb says. This means you have to design outside of CiviCRM but the procedure is quick.
Comments.UserDisplayName: Guillaume Sorel
Tags: <mosaico>
Title: Mosaico - how to 'insert' templates from a previous host?
ThreadText: # Mosaico - how to 'insert' templates from a previous host?
  
  (Asked by: username_0 on 2019-05-25)
  
  I'm moving hosts, and want to preserve a number of Mosaico templates that I've created. Mosaico had to be re-installed. It is running, but the templates are now gone. I have backups of the SQL tables. Attempts to just 'insert the rows' into civicrm\_mosaico\_template table have been unsuccessful. (and broke the mosaico install). So, uninstalled/reinstalled - to a clean mosaico again...
  
  Any suggestions on how to re-import those templates?
  
  Thanks!
  
  **Tags:** mosaico
  
  > **Comments:**
  > **username_1**: Have you by any chance kept copies of the html source code for each template?  If you have then it would be easy to import them into new message templates in civicrm by copy and paste through the html editor for each new template by using the "Source" button  
  > **username_0**: I don't see a 'source' button in the Mosaico Editor. (I do in the 'traditional template' editor though.) I thought HTML was in the db in the mosaico template file, but, it's not clean. I do have html files, though they were the 'received' emails I sent to myself, so they'd need to have a bunch of cleanup so they could go out again. I'm beginning to think that is going to be my only recovery. Was hoping that it would go back into mosaico, vs std templates.  
  > **username_1**: I dont have the Mosaico extension installed but I've successfully compiled a Mosaico template on the Mosaico website, copied the html and saved it in a new template in Administer/Communication/Message Templates/Add Message Template/HTML Format using the Source code therein.  If you already have the HTML code for the templates you wish to import then you could perhaps go down the route I've described.  Hope this helps.  
  > **username_2**: It works the way username_1 says. This means you have to design outside of CiviCRM but the procedure is quick.  
  
  ---
  
  ## 0 answers
  
  