Multilingual Datatables

Subscribing

#2 seems to be a good start

Translations can be found at http://www.datatables.net/plug-ins/i18n.
As text files, they can be added like this in datatables.module:

$datatable_options['oLanguage']['sUrl'] = "path_to_the_file/nl_NL.txt";

Easy to add this as an option field. Switching according to language would be a possible next step.

Here's my quick and dirty hack (added to template_preprocess_datatables_view, line 287):

  global $language_content;
  global $theme;
  $theme_path = drupal_get_path('theme', $theme);
  $language_file_path = base_path() . $theme_path . DIRECTORY_SEPARATOR . 'datatables' . DIRECTORY_SEPARATOR . 'languages' . DIRECTORY_SEPARATOR . $language_content->language . '.txt';

  if(file_exists($_SERVER['DOCUMENT_ROOT'] . $language_file_path)) {
      $datatable_options['oLanguage'] = array(
          'sUrl' => $language_file_path
      );
  }

Now i can place the language-files (de.txt, es.txt...) to [my-theme-path]/datatables/languages/

It would be nice to see a generic solution builtin to datatables.module. Perhaps with possibillity to translate datatables from drupals string translation interface.

I found another solution without touching the source code of the module. Using the "drupal_add_js function"

drupal_add_js(array('datatables' => array('#datatable-1' => array ('oLanguage' => array('sSearch' => t('Search'))  ))), 'setting');

This overwrite the JS generated by the datatables module.

Also will be possible specify the translation file:

$language_file_path = base_path() . drupal_get_path('theme', $theme) . DIRECTORY_SEPARATOR . 'datatables' . DIRECTORY_SEPARATOR . 'languages' . DIRECTORY_SEPARATOR . $language_content->language . '.txt';

drupal_add_js(array('datatables' => array('#datatable-1' => array ('oLanguage' => array('sUrl' => $language_file_path)  ))), 'setting');

I think it's a good solution while waiting for an official update that supports natively translations.

Moreover,
in the JavaScript: datatables/js/datatables.js
some text are not translatable, like "Show Details" or "Hide Details".
Please use the Drupal.t() function:
$(this).html(Drupal.t('Show Details'));

I've created a patch which follows the #2, since I think it's the most proper way to make the internationalization in Drupal way. Please review the patch so that it can be committed to next release.

Looks good pc-wurm! Any reason why you didn't set the translations of some of the entries? I think it's save to pass through t() event though they have tokens that will be interpolated by DataTables.js (as long as the translator doesn't translate the tokens)

Oh, it is not the complete patch. Here is the complete one. Maybe I shouldn't create patches just before going to bed, sorry :D

Looks good, thanks pc-wurm!

Thanks for the reviewing, I've committed and pushed the patch to dev.

Congrats on your first commit pc-wurm!

Thanks duellj :)

Sorry, but you forgot to implement the fix from my comment in #8.

@dnsnoeck, please review the following patch to the latest dev. I just made the changes you proposed, I don't have the time to test now. I'd be glad if you would review and test it.

Applied this patch and it works like a charm. Thanks!

The proper way without any hacks it to add this code to you JS file

jQuery.extend( true, jQuery.fn.dataTable.defaults, {
  "oLanguage" : {
    sProcessing:     "Przetwarzanie...",
    sSearch:         "Szukaj:",
    sLengthMenu:     "Pokaż _MENU_ pozycji",
    sInfo:           "Pozycje od _START_ do _END_ z _TOTAL_ łącznie",
    sInfoEmpty:      "Pozycji 0 z 0 dostępnych",
    sInfoFiltered:   "(filtrowanie spośród _MAX_ dostępnych pozycji)",
    sInfoPostFix:    "",
    sLoadingRecords: "Wczytywanie...",
    sZeroRecords:    "Nie znaleziono pasujących pozycji",
    sEmptyTable:     "Brak danych",
    oPaginate: {
      sFirst:      "Pierwsza",
      sPrevious:   "Poprzednia",
      sNext:       "Następna",
      sLast:       "Ostatnia"
    },
    oAria: {
      sSortAscending: ": aktywuj, by posortować kolumnę rosnąco",
      sSortDescending: ": aktywuj, by posortować kolumnę malejąco"
    }
  }
} );

Code above amends DataTables defaults https://datatables.net/examples/advanced_init/defaults.html

You can find all localisations on page https://datatables.net/plug-ins/i18n/

The issue still exists when using theme function in code attached patch is the fix

Fixed the patch from #25 to apply correctly on any path setup.