Report Module - Conditions not working in other language than english

SuiteCRM Forum - English Language Translation and Language Packs
1

German Language Pack:
https://crowdin.com/project/suitecrmtranslations

Versions: 7.5.1.1 and 7.5.1.2

Bug: Report is not working correctly, run Report -> the Report will be empty; the same Report will deliver results with english and other languages

2

The same Issue with latest German Language Package Version 7.5.2.1:
Reports without Conditions are working correctly
Reports with Conditions (different types tested) are empty, but exact the same Report with Conditions are working with English or other Language Pack

3

Hi, can you post a screen with one set of conditions used (English!)

4

Please find enclosed the PrintScreen with the identical conditions in Report for English and exact the same for German.
English -> Report will produce entries
German -> Report will produce fully empty Report

I have tried different types of Conditions, but seems for all the same Issues.
Other Language Packs are working too e.g. the English one

5

Hello
Unfortunately the issue stll exists even with latest suitecrm and german language pack Versions - but other language packs e.g french or english are working. Has anyone any further Idea ?
thanks

6

Hi,
please post a screen from your "creation dialog), as in
Reports / Edit so I can match your:
Report module / “Module tree” / and “fields”

7

Hello Horus
first of all many thanks for your efforts in advance.

I have used all the latest today 7.7beta2 and German DE Pack 7.6.4 and I used the standard “contact” Module to make it simpler:

  1. sample_reportedit_de shows the Report Edit Page
  2. sample reportrun_de shows the Report Result - it’s empty
  3. sample reportrun_en shows exact the same Report in english - it’s not empty
    
also other languages eg. de_CH is not empty
8

Found it and it affects any language that translated AOR fileds in include file!
This is a major bug on Transifex

In you language code file xx_XX.lang.php at \include\language
see line 3315 ‘aor_sql_operator_list’ strings operator if translated are ignored on reports!
This must be solved in SuiteCRm itself as a bug

For a quick and dirty fix change the operators value to the non translated version (as in LIKE instead of EnthÀlt)
Your actual translation:


$app_list_strings['aor_sql_operator_list']['Equal_To'] = 'Gleich';
$app_list_strings['aor_sql_operator_list']['Not_Equal_To'] = 'Ungleich';
$app_list_strings['aor_sql_operator_list']['Greater_Than'] = 'Grösser als';
$app_list_strings['aor_sql_operator_list']['Less_Than'] = 'Kleiner als';
$app_list_strings['aor_sql_operator_list']['Greater_Than_or_Equal_To'] = 'Grösser oder gleich';
$app_list_strings['aor_sql_operator_list']['Less_Than_or_Equal_To'] = 'Kleiner oder Gleich';
$app_list_strings['aor_sql_operator_list']['Contains'] = 'EnthÀlt';
$app_list_strings['aor_sql_operator_list']['Starts_With'] = 'EnthÀlt';
$app_list_strings['aor_sql_operator_list']['Ends_With'] = 'EnthÀlt';
$app_list_strings['aor_condition_operator_list']['And'] = 'Und';
$app_list_strings['aor_condition_operator_list']['OR'] = 'ODER';

Change to english values


$app_list_strings['aor_sql_operator_list']['Equal_To'] = '=';
$app_list_strings['aor_sql_operator_list']['Not_Equal_To'] = '!=';
$app_list_strings['aor_sql_operator_list']['Greater_Than'] = '>';
$app_list_strings['aor_sql_operator_list']['Less_Than'] = '<';
$app_list_strings['aor_sql_operator_list']['Greater_Than_or_Equal_To'] = '>=';
$app_list_strings['aor_sql_operator_list']['Less_Than_or_Equal_To'] = '<=';
$app_list_strings['aor_sql_operator_list']['Contains'] = 'LIKE';
$app_list_strings['aor_sql_operator_list']['Starts_With'] = 'LIKE';
$app_list_strings['aor_sql_operator_list']['Ends_With'] = 'LIKE';
$app_list_strings['aor_condition_operator_list']['And'] = 'And';
$app_list_strings['aor_condition_operator_list']['OR'] = 'OR';

I didn’t check for the other values on aor strings if they are also causing the bug.

9

I’ve posted an issue on Github so others can solve it!
https://github.com/salesagility/SuiteCRM/issues/1662

1 Like
10

Hi Folks,
thank you for keeping f/oss CRM alive. As we could see, our translations for AOS some years ago did find their way into suiteCRM, very nice.

We’ve got an issue with the reports module in german language. If we try to have a condition refering to the value of a drop down list, the module is not working at all. E.g. the state of an invoice in german can be “bezahlt” it looks like the module does a comparison between the visible value of the dropdown “bezahlt” and the value in the database (payd)

When i switch to english language everything works fine, in german it does unfortunately not. Could you please check and confirm and tell me a way how to manage that?

Regards
Georg

11

This is not a translation issue but a SuiteCRM code issue:
Application was getting the translated value as an operator instead of the key part of the string.

The issue is now fixed here:
Fixed #1662 - remove aor_sql_operator_list values from language files by gymad ·
Pull Request #1901 - https://github.com/salesagility/SuiteCRM/pull/1901

As an easy temp fix, until next SuiteCRM version is released, you can change the lines from your translation on the file:
\include\language\xx_XX.lang.php

check strings near line 3310

and change to this (they will end up as non translated strings):

$app_list_strings['aor_sql_operator_list']['Equal_To'] = '=';
$app_list_strings['aor_sql_operator_list']['Not_Equal_To'] = '!=';
$app_list_strings['aor_sql_operator_list']['Greater_Than'] = '>';
$app_list_strings['aor_sql_operator_list']['Less_Than'] = '<';
$app_list_strings['aor_sql_operator_list']['Greater_Than_or_Equal_To'] = '>=';
$app_list_strings['aor_sql_operator_list']['Less_Than_or_Equal_To'] = '<=';
$app_list_strings['aor_sql_operator_list']['Contains'] = 'LIKE';
$app_list_strings['aor_sql_operator_list']['Starts_With'] = 'LIKE';
$app_list_strings['aor_sql_operator_list']['Ends_With'] = 'LIKE';

Note: this was already posted here: https://suitecrm.com/forum/international-language-support/8276-german-language-pack-reports-not-working-correct#34075

12

You can now solve this by using a fresh language pack.

  • Uninstall all your actual languages (first login as english)
  • Repair and rebuild
  • Install a fresh language pack from: https://crowdin.com/project/suitecrmtranslations
    (choose the flag for each language you need, then Download)
  • Repair and rebuild
  • Logout / Login as your language