massively rename many posts of a discussion

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Harrison76
Registered User
Posts: 56
Joined: Wed Jul 12, 2017 7:25 am

massively rename many posts of a discussion

Post by Harrison76 » Thu Feb 14, 2019 2:31 pm

Bye, everybody,
I often have to rename a discussion, but when it contains so many posts it takes a long time to rename them all: there is a way to rename them in bulk, so that by editing the first one you change all the others but putting "re:" in front?
Thank you

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51760
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: massively rename many posts of a discussion

Post by Brf » Thu Feb 14, 2019 2:39 pm

You mean you want to change the Subject line in all of the Posts in a Topic?

Harrison76
Registered User
Posts: 56
Joined: Wed Jul 12, 2017 7:25 am

Re: massively rename many posts of a discussion

Post by Harrison76 » Thu Feb 14, 2019 2:56 pm

exactly! except that when you have topics of 15 pages, or 150 messages, it becomes a very long operation...

User avatar
canonknipser
Registered User
Posts: 2016
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: massively rename many posts of a discussion

Post by canonknipser » Thu Feb 14, 2019 3:00 pm

You can check this extension: https://www.phpbb.com/customise/db/exte ... m_replies/
It will not rename the reply titles, but suppress them.
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

User avatar
warmweer
Registered User
Posts: 2337
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: massively rename many posts of a discussion

Post by warmweer » Thu Feb 14, 2019 3:03 pm

Harrison76 wrote:
Thu Feb 14, 2019 2:31 pm
I often have to rename a discussion, but when it contains so many posts it takes a long time to rename them all: there is a way to rename them in bulk, so that by editing the first one you change all the others but putting "re:" in front?
Change 1 post-title (by putting "re:" in front ... BTW "re: " may look nicer (space after the ":").
Then look up that post in phpMyAdmin to see how it was changed, take note of the changes, and then apply that change to selected posts.
If you're not fluent enough with SQL you could use an ODBC connector to do that in OpenOffice, LibreOffice (or even Access).
My board's not broken, it just went peculiar

Harrison76
Registered User
Posts: 56
Joined: Wed Jul 12, 2017 7:25 am

Re: massively rename many posts of a discussion

Post by Harrison76 » Thu Feb 14, 2019 3:11 pm

Change 1 post-title (by putting "re:" in front ... BTW "re: " may look nicer (space after the ":").
Then look up that post in phpMyAdmin to see how it was changed, take note of the changes, and then apply that change to selected posts.
If you're not fluent enough with SQL you could use an ODBC connector to do that in OpenOffice, LibreOffice (or even Access).

witvisser
Registered User
Posts: 62
Joined: Wed Nov 25, 2009 9:08 am

Re: massively rename many posts of a discussion

Post by witvisser » Thu Feb 14, 2019 3:11 pm

You can do that with this extension: https://www.phpbb.com/customise/db/exte ... _subjects/

Harrison76
Registered User
Posts: 56
Joined: Wed Jul 12, 2017 7:25 am

Re: massively rename many posts of a discussion

Post by Harrison76 » Thu Feb 14, 2019 3:19 pm

great, this looks even better then: I'll try it now. Thank you

Harrison76
Registered User
Posts: 56
Joined: Wed Jul 12, 2017 7:25 am

Re: massively rename many posts of a discussion

Post by Harrison76 » Thu Feb 14, 2019 3:47 pm

thanks guys, you saved me a lot of time: I just updated in one click a discussion that had 290 posts :-)
Thank you

Post Reply

Return to “[3.2.x] Support Forum”