lee mcdermott Posted June 9, 2017 Share Posted June 9, 2017 Hi, We still seem to have an issue where emails are being sent from an email template which uses the custom field variable to populate the email and the data is not being populated. I know the last update was meant to fix this and I thought it had as the couple of forms I checked seemed to be working. But have just found this one not working still? any ideas thanks lee Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott we need more information to investigate this... I assume the email was sent by BP associated to a request. Do you have a request reference example? Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor hi victor yes. example Ch00006265 - using email template email_cabmembers_emergency_change CH00006299 - using email template email_Teamleaders_Normal_change Both are change requests but one email is generated during the BP when an emergency change is logged. The other is generated during BP if a normal change is logged. BP process is "RFC" Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott it is not the same issue, but behavior is the same... so the defect you mentioned is fixed... this one here is caused by something else... Now, I can see why the template did not populate the variables, the custom field values are simply empty in the database... so the issue (somehow) occurred during mapping process in ProCap... I'll keep looking... Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott so, the reason why the custom fields failed to populate is because the number of characters for the information (text) in one of the fields (h_custom_e) was greater than the max. number of characters allowed for the field (255). Looking at both examples you mentioned, the "Description" information/question, in both scenarios, is over 300 characters... The only solution I can think of would be to limit the number of characters during input for "Description" to 255.... and perhaps any other text field where this might happen... Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor Ah thanks victor. - so if these fields fail because they have a maximum number of characters allowed - i assume they all fail even if the majority of the fields have less than the 255 allowed? Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor how do you limit the input field to 255 characters? Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott if one fails, they all fail .. that's being "h_custom_..." fields. You can limit the number of characters in input using REGEX validation.... You could use these REGEX functions: ^(.|[\r\n]){0,255}$ or ^[\S\s]{0,255}$ Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor thanks victor - i will try these. I will need to amend my form I think as they will at times need to input more than 255 characters - but also I need the email to be generated with the relevant information. I will have a think on the best way to do this. Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott maybe split up the description in more than one field? I know, I'm not making this easy, just trying to see what would work... Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor yes I will try that - thanks for the help. Can I just clarify for my understanding - the custom field in the Database can only hold 255 characters ? - or the email side of things when using a custom field can only contain 255 characters? as one of those changes for the description field has 302 characters or 359 including spaces. Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 8 minutes ago, lee mcdermott said: the custom field in the Database can only hold 255 characters @lee mcdermott this ^ Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor so how come in the call the field has more than 255 characters in it? does it store it in one place as part of the call (with more than 255 characters)but then also populate the custom_ field with the same data but limited to 255 characters? Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott 7 minutes ago, lee mcdermott said: does it store it in one place as part of the call (with more than 255 characters)but then also populate the custom_ field with the same data but limited to 255 characters? Something like this, yes. "h_custom_..." fields in requests table and field in questions, are two separate entities... The "Questions" section of a request is using the info stored in "h_itsm_questions" table. Here you can store more than 255 because for each question/answer you have a separate record. The mapping to custom fields in requests table, the fields you can add in the "Details" section of a request, will be done on "h_custom_..." fields in requests table. Here you have the 255 character limit. Because all data in custom fields will be stored in one record, teh record for the request. And you can't make these fields to hold large amount of text, the performance impact would be unbearable.. There is a change in the backlog to redesign this functionality to allow custom fields to hold more than current limit. Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor Ok thats great thanks. What I am now thinking I might do is remove these 2 fields from the form (as these are the only 2)that would ever contain more than 255 characters and add back into the prog capture the request details to capture summary and description. I assume the description field will hold more than 255 characters and should work if I include the description field on the email template? Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott yes, the description of the request itself can hold more than 255... (up to 65535 or whatever the limit is for the TEXT type fields) Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor is the a limit on the summary field as this seems to be a single line text rather than a multi line text field? Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott sorry, forgot to mention. Being a single line text field, it has a limit of 255 or 275 characters. Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor great thanks Link to comment Share on other sites More sharing options...
lee mcdermott Posted June 9, 2017 Author Share Posted June 9, 2017 @Victor i didn't realise that that entity viewer existed - that will prove most useful - especially when trying to do reports. Link to comment Share on other sites More sharing options...
Victor Posted June 9, 2017 Share Posted June 9, 2017 @lee mcdermott Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now