Renaming template and keep ACF data?

• ndh611

• June 30, 2015 at 3:06 pm

Hello,

I’m tackling a project where WordPress standards are highly valued and I MUST change templates’ file names following WordPress standards.

This will result in loosing ACF data.

I’m wondering if there is some sorts of SQL that can help me update the template name.

Following this article, I can update template name for all pages: http://wordpress.stackexchange.com/questions/57568/how-to-rename-a-template-file

UPDATE wp_postmeta SET meta_value = ‘new-filename.php’ WHERE meta_value = ‘old-filename.php’;

But not ACF…

Many thanks,

• James

• June 30, 2015 at 5:28 pm

Hi @ndh611

Actually, you will not lose any ACF data should you rename your template files.

Hmm… May be you can elaborate further on your field setup so that I can be able to assist.

• ndh611

• June 30, 2015 at 5:51 pm

Sorry I did not make it clear.

For example I have field group FG-A, setup for Page Template page-a.php
I need to change page template name to page-awesome.php

After changing that, in Custom Fields tab, field group FG-A does not apply for this template anymore, so I gotta do that manually again, and even go to check pages (with template page-awsome.php) to see if this still works.

Is there any kinda SQL query to fix this all at once, instead of manually doing this for every single field group (which this website has a lot)

For pages, this is what we did:
UPDATE wp_postmeta SET meta_value = ‘page-awesome.php’ WHERE meta_value = ‘page-a.php’;

But this did not solve ACF thing above 🙂

Thanks

• James

• June 30, 2015 at 6:21 pm

Hi @ndh611

Thanks you for the clarification. ACF saves the field group settings in wp_posts table in the DB. So should you wish to do a DB query to update the template, this should work:

UPDATE wp_posts SET post_content = REPLACE( post_content , 'page-a.php', 'page-awesome.php' ) WHERE post_type = 'acf-field-group'

Give this a try and let me know if your issue gets resolved 🙂

• ndh611

• June 30, 2015 at 6:28 pm

Thanks James, we will try right away. I really appreciate your help.