CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Help with editing civicrm mailing report page
Pages: [1]

Author Topic: Help with editing civicrm mailing report page  (Read 479 times)

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Help with editing civicrm mailing report page
May 24, 2012, 09:00:02 am
Not too sure what section of the forums to ask this;

All our past mailings have been created (oddly) using underscores instead of spaces in the mailing name. Initially, this wasn't a problem. However, since we now have mailings with names of over 60 characters in length, the underscores are forcing the table view to be too wide.

I know I could run some SQL on the field and do a find-and-replace I am wary that this may break the database. First question: Will replacing all instances of underscore(_) with a space ( ) in the mailing name field break CiviCRM?

Trying to work around the above, is there a way to alter/replace the underscore using code in the tpl files themselves?
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Help with editing civicrm mailing report page
May 24, 2012, 12:08:35 pm
1. Before making changes to your MySQL database, always back it up first
2. It should not be a problem to replace _ in that field with space
3. You could edit the tpl file using the {truncate} function to shorten the mailing names
Try CiviTeacher: the online video tutorial CiviCRM learning library.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Help with editing civicrm mailing report page

This forum was archived on 2017-11-26.