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,
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.
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
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 🙂
Thanks James, we will try right away. I really appreciate your help.
The topic ‘Renaming template and keep ACF data?’ is closed to new replies.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.