Comment field expansion

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Comment field expansion

Postby dreedy » Thu May 17, 2018 4:14 pm

Our company uses the comment field to write out notes then that gets moved to our crm in the case of a special dispo. I see that the current comment field is limited to 255 character and that if i enable the note field that that is only bound by the TEXT structure of the mysql. Unfortunately, i am limited to using the comments field as the utility that moves the information over to the crm is hard coded to use that field and the rest of the lead information. Am i correct in thinking if i ALTER the comments field in the MYSQL to a VARCHAR (500) that this would enable the comments to go to 500 characters ? and would i need to expanded the agent and admin screen reference to allow the comment to be seen in one screen ? There does not seem to be a word wrap in the html code so it is one solid line.
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici |VERSION: 2.14-900a | BUILD: 231115-1636 | svn 3787 |dbschema 1702
dreedy
 
Posts: 168
Joined: Tue Nov 24, 2015 10:16 pm

Re: Comment field expansion

Postby blackbird2306 » Thu May 17, 2018 5:27 pm

Yes by increasing to VARCHAR(500) it would be possible to save longer comments. I didn't find any other place, where this field is truncated. Further I don't think you need to expand anything, but try it by yourself.
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 409
Joined: Mon Jun 23, 2014 5:31 pm

Re: Comment field expansion

Postby mflorell » Thu May 17, 2018 9:46 pm

Yes, you can change the comments to VARCHAR(500) if you want and it should not cause any problems. As for newlines, the comments field can have them, but when put into the database, they are changed to '!N', and when the lead comes up in the agent screen, they are change to newline characters(\n).
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Comment field expansion

Postby dreedy » Fri May 18, 2018 10:34 am

Thank you all i have tested this out and had to alter 2 places for the comments. vicidial_list and vicidial_comments. once i altered that to expand the store capacity to 500 char the information would go to 500 char. The line does not break though when reviewing the lead information. It is just one long string when view it in the agents screen or searching a lead.
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici |VERSION: 2.14-900a | BUILD: 231115-1636 | svn 3787 |dbschema 1702
dreedy
 
Posts: 168
Joined: Tue Nov 24, 2015 10:16 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 89 guests