Hotfix/import file

Fixes #263 (closed) Fixes #262 (closed)

smash/import_file.py

@@ -178,6 +178,19 @@ language_table = {
     'FIN': 'Finnish'
 }
 
+locale_table = {
+    'Luxembourgish': ('lb_LU', 'LU'),
+    'Lithuanian': ('lt_LT', 'LT'),
+    'Italian': ('it_IT', 'IT'),
+    'French': ('fr_FR', 'FR'),
+    'German': ('de_DE', 'DE'),
+    'English': ('en_GB', 'GB'),
+    'Portuguese': ('pt_PT', 'PT'),
+    'Arabic': ('ar_sa', None),
+    'Spanish': ('es_ES', 'ES') ,
+    'Finnish': ('fi_FI', 'FI')
+}
+
 language_translation_table = {
     # deletions
     ord(u')'): None,
@@ -308,14 +321,15 @@ def parse_row(index, row, visit_columns, appointmentTypes, voucher_types):
     languages = []
     for language in row['LANGUAGES']:
         lang, created = Language.objects.get_or_create(
-            name=language)
+            name=language, locale=locale_table.get(language,(None, None))[0])
         languages.append(lang)
         if created:
             logging.warn('New Language added: {}'.format(language))
         lang.save()
 
     for language in row['PREFERED WRITEN LANGUAGE'][:1]:
-        pref_lang, created = Language.objects.get_or_create(name=language)
+        pref_lang, created = Language.objects.get_or_create(name=language
+            ,locale=locale_table.get(language,(None, None))[0])
         if created:
             logging.warn(
                 'New Language (from Prefered) added: {}'.format(language))