Migrate PDF template from 1 database to another database of Suitecrm

I have 2 instances of Suitecrm installed, 1 is 8.1.2, the other is 8.2.4. Something went wrong with 8.1.2, and I’d like to use 8.2.4 moving forward. I’ve already created pdf templates in old instance. Can I migrate template within phpmysql? Or how?

I’ve never done it but I suspect you could copy of the rows from the various tables. I’d suspect there would be a table for the template and another table for the content of the template. Again, never done it , but I think that would work. You’d find the row in the pdf template table and it must have either a field to relate to the content table or by the ID, then you have to find the matching record in the content table. You could export the row from both tables from one DB and import it into your new DB. Give it a shot, but make sure you have a full backup just in case.

Had a look at the DB looks like there is only one table and the contents of each PDFtemplate are stored as a row in: aos_pdf_templates. I’d be surprised if it didn’t work that you just copy the row from one DB to another. Again, I’ve never tried it.

It works perfectly well.

Thanks to both of you. Indeed, I was able to copy it without problems :smiley:

1 Like