Increase character limit in Department field

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , , , , , ,

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 03/26/2014 at 10:37 am #283406
    Daniel Francis
    Participant

    I love the plugin, and have purchased this C-Map template and will no doubt buy more to increase the functionality of the directory, but I’ve hit a wall! I am using the department field as an introductory bio of a company for users to scan and read when entering this section to quickly find a company they could be interested in, before choosing to read more by clicking on the ‘Show Bio’ link.

    From what I can see the limit on the characters in this field is 253. I have managed to get it aligned to the left as opposed to the right, and have had a good look through all of the CSS and PHP files but cannot find where to change it. I just need to increase the limit on the number of characters in this field now.

    Can you help me in this please?!

    03/26/2014 at 11:33 am #283415
    Steven Zahm
    Keymaster

    @ Daniel

    Sorry, but that can not be increase … that is the max number of character supported by the database when the table is created that stores the Connections data.

    You can try using phpMyAdmin or similar tool to change the column type of this field to one which can store larger number of characters.

    03/26/2014 at 11:38 am #283416
    Daniel Francis
    Participant

    I also want to change how the title for Work Phone appears. When I have chosen for it to be listed as an organisation, they wouldn’t list their phone number as Work Phone and Fax number as Work Fax. It would be something like ‘Phone number’, ‘Main Switchboard’, or simply ‘Tel’. The options at the moment only really cater for an individual or a family not an organisation.

    How can I change this please?!

    03/26/2014 at 11:45 am #283418
    Daniel Francis
    Participant

    I have just checked the MySQL database for Connections and specifically the Department column and I cannot find any limitation on the number of characters that can be entered?!

    03/26/2014 at 12:21 pm #283437
    Daniel Francis
    Participant

    I did a bit of digging and found this simple bit of code which did it!

    alter table people modify name VARCHAR(35) ;

    I modified it to:

    alter table wp_connections modify department VARCHAR(1000) ;

    So now all I need to do is be able to change the word from ‘Work Phone’ and ‘Work Fax’ to something that relates to a business and not an individual or member of public.

    Thanks for your help so far.

    :-)

    03/26/2014 at 12:48 pm #283446
    Steven Zahm
    Keymaster

    @ Daniel

    Install the Say What? plugin.

    It’ll add a new Text Changes menu item. Click Add New, enter the string exactly as shown in Connections, enter connections [notice the lack of capitalization, that's important!] as the domain and then enter your new text.

    The great thing about using this plugin is that it will be update safe and you can use it on any other plugin that has been properly internationalized.

    Here’s an example; for Original string you would enter Work Phone and for New string you would enter Phone or any other string of your choosing.

    Hope that helps.

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)

You cannot reply to this support topic. Please open your own support topic.