Content truncated when sending email from grid

[jrmplus]

Hi
I have a grid with a number of fields which I use to compose an email using a button in the grid.
One of the fields occassionally has a lot of text/html which then gets truncated for some unknown reason.
The text is showing ok in the Mysql database, but even when displayed in a text area field, it still is truncated. This is the case when trying to email the content.

This particular field is made by group_concat in mysql which needed increased as the default length was 1024k. It seems to be something in alpha.

The content of the email is composed using an xbasic function so even if the content displayed in the grid in the textarea field, it still truncates in the email.

Any ideas?

Thanks

[Sarah Mitchell]

Re: Content truncated when sending email from grid

How are you sending the email? Are you using Action Javascript? An xbasic method?

[GGandhi]

Re: Content truncated when sending email from grid

This particular field is made by group_concat in mysql which needed increased as the default length was 1024k. It seems to be something in alpha.

would you please explain this, you have opted to increase the length of field(s), instead of using longer field like text, you have concatenated.
when you use text field in mysql as far as i know alpha does not truncate that field.
additionally, i repeat the same question sarah has raised.
how are you sending the email?
if you send email using xbasic, you can easily add those fields to the message. good to take a look at the documentation or any messages on the board relating to sending email.

[jrmplus]

Re: Content truncated when sending email from grid

I have a job table and a job_details table (one-to-many relationship)

The job details table contains the names of all employees on that job.

I have created a mysql view which group_concatenates all the employee names by job_id.

The purpose is to send the client a list of employee names for each job.

I have a grid which is a list of jobs which has a button for emailing (I use the standard javascript function). I also have an xbasic function that returns the group_concat field which then is included in the email content using {ExecuteFunction:email_report} where email_report is the name of the xbasic funtion.

This has been working really well and the only issue is when the job is quite large (eg lots of employee names, etc) this data gets truncated in the email.

In the mysql view, the data is all there as expected.

Also - with reference to not using a text field, this would require updating this field each time the job_details table is updated. Using group_concat function is much more convenient as it is simply bringing together information which is already there.

Another reason why I think is is an Alpha issue is that if I display the view in a grid, and have the group_concat field displayed in a textarea control, it also truncates in the same way as the email.

Thanks

[GGandhi]

Re: Content truncated when sending email from grid

I have a job table and a job_details table (one-to-many relationship)

The job details table contains the names of all employees on that job.

I have created a mysql view which group_concatenates all the employee names by job_id.

The purpose is to send the client a list of employee names for each job.

okay i understand now.
what you want to do is to put all the employees involved in the job to a single field and then refer to that field in the email as single entity.
would it be difficult for you to create a report using the data available in the header and the detail tables then attach the report as pdf to the person?

(it may be possible to pull the names ( or ids ) of the employees from the detail section and add that to email, haven't followed that route. but with alpha i am sure there is a way to do that way too.)

[GGandhi]

Re: Content truncated when sending email from grid

here is something to think about..
since the job table and the job_detail tables are linked, you can call the mysql data matching the job_table_id in the job_detail_table foreign key and the resultset will contain all the records that matches the job table id.
then it is a matter of joining the values of the employee names in human readable style and add that to the email.
this will be done in the xbasic code.

[jrmplus]

Re: Content truncated when sending email from grid

It seems that the problem was in the way I had configured the group_concat_max_len variable in mysql.

I had used something like set sesson ... instead of:

SET @@group_concat_max_len=15000;

The length of the concat field is now increased to 15k which is more than sufficient for what we need.

I'm not sure what the exact syntax should be for changing the variable, but perhaps initially using session keyword was the reason why in the mysql viewer the text was all there, but when accessed via alpha it was still truncated.

Its working well now. Something simple after all!!

Thanks

[aburningflame]

Re: Content truncated when sending email from grid

Using the session keyword would make the setting change for only that connection (e.g. the mysql viewer). Which is why you were seeing the truncation in Alpha.
Not using the session keyword makes the change to the entire server which is why it then worked.


I feel like you may lose the setting if your mysql service restarts and I would recommend setting this value in your actual mysql.ini file so that upon reboots it does not change.
You can find the particular ini you are using by right clicking the MySQL Service (in services) and clicking Properties and then looking at the --defaults-file switch in the Path to Executable section.

You can add the group_concat_max_len=15000 to the [mysqld] section, stop the MySQL service, start the MySQL Service and you can run the following sql to verify
SHOW VARIABLES LIKE '%group_concat%'

SHOW VARIABLES is really useful to review settings / determine if changes worked etc.