Difference between revisions of "Field: Language"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Category:HelpBooks]]
+
{{Help_Files_Import_module}}
−

 
  
−
==Field: Language==
+
== Field: Language ==
−
[[Image:720.gif]]
+
 
−
* In case the above table was how our language table looked for a site, we could put in ‘2’ or ‘en-GB’ in the excel cell and the language of the user would be set to English (GB). User can mix mapping using Number (ID) and character in the same import!
+
 
−
* To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ languages you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default language and overwrite their existing language.
+
 
−
|- align="left" valign="top"
+
{| width="1189" cellspacing="0" cellpadding="2" border="0" style="border-collapse:collapse" class="tableintopic"
−
| style="border: 1px solid #010101" width="168" |
+
|-
 +
| width="168" height="0" |
 +
| width="1020" height="0" |
 +
|- valign="top" align="left"
 +
| width="1189" colspan="2" style="border:1px solid #010101;" |
 +
== Field: Language ==
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |
 +
Type
 +
 
 +
| width="1021" style="border:1px solid #010101;" |
 +
String/Number
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |
 +
General Description
 +
 
 +
| width="1021" style="border:1px solid #010101;" |
 +
The language that user used in the system. It will affect the language that is presented in the graphical user interface and many other places.
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |
 +
Import Group
 +
 
 +
| width="1021" style="border:1px solid #010101;" |
 +
User Information
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |
 +
Business Rules
 +
 
 +
| width="1021" style="border:1px solid #010101;" |
 +
*Language can be imported using both number and string. Numbers are the unique ID on the database for languages and may differ between sites. You should contact your site administrator to know what languages your site has available. The table below is therefore only an example of the languages supported in one specific site. Other sites may use different numbers to recognize languages so it is generally best to use Character which is a unique identification. <br>[[Image:720.gif]]<br>
 +
*In case the above table was how our language table looked for a site, we could put in ‘2’ or ‘en-GB’ in the excel cell and the language of the user would be set to English (GB). User can mix mapping using Number (ID) and character in the same import!  
 +
*To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ languages you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default language and overwrite their existing language.
 +
 
 +
&nbsp;
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |  
 
Auto mapping
 
Auto mapping
−
| style="border: 1px solid #010101" width="1021" |
+
 
−
In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:
+
| width="1021" style="border:1px solid #010101;" |  
 +
In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:  
  
 
UK: Language
 
UK: Language
  
 
DK: Sprog
 
DK: Sprog
−
|- align="left" valign="top"
+
 
−
| style="border: 1px solid #010101" width="168" |
+
&nbsp;
 +
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |  
 
Validation
 
Validation
−
| style="border: 1px solid #010101" width="1021" |
+
 
−
* The value imported to language (either number or character (ISO code) must exist in the table ‘language’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).
+
| width="1021" style="border:1px solid #010101;" |  
−
* If number and iso-code is mixed in one excel column, then System will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultLanguageForImportedUser’, as described in the ‘web.config’file, will be used as the language of the imported user.
+
*The value imported to language (either number or character (ISO code) must exist in the table ‘language’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).  
−
|- align="left" valign="top"
+
*If number and iso-code is mixed in one excel column, then System will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultLanguageForImportedUser’, as described in the ‘web.config’file, will be used as the language of the imported user.
−
| style="border: 1px solid #010101" width="168" |
+
 
 +
|- valign="top" align="left"
 +
| width="168" style="border:1px solid #010101;" |  
 
Notes
 
Notes
−
| style="border: 1px solid #010101" width="1021" |
+
 
−
* If the value in your excel cell is empty, the system will use the ‘DefaultLanguageForImportedUser’ setting, as described in the ‘web.config’ help file, as the language of the imported user.
+
| width="1021" style="border:1px solid #010101;" |  
−
__NOTOC__
+
*If the value in your excel cell is empty, the system will use the ‘DefaultLanguageForImportedUser’ setting, as described in the ‘web.config’ help file, as the language of the imported user.
−
<!-- imported from file: 508.htm-->
+
 
 +
|}
 +
 
 +
[[Category:Import_module]]

Latest revision as of 11:32, 16 December 2011



Field: Language

Field: Language

Type

String/Number

General Description

The language that user used in the system. It will affect the language that is presented in the graphical user interface and many other places.

Import Group

User Information

Business Rules

  • Language can be imported using both number and string. Numbers are the unique ID on the database for languages and may differ between sites. You should contact your site administrator to know what languages your site has available. The table below is therefore only an example of the languages supported in one specific site. Other sites may use different numbers to recognize languages so it is generally best to use Character which is a unique identification.
    720.gif
  • In case the above table was how our language table looked for a site, we could put in ‘2’ or ‘en-GB’ in the excel cell and the language of the user would be set to English (GB). User can mix mapping using Number (ID) and character in the same import!
  • To update this field for existing users, you must map the import using the User_Id column to show which users to update for. If you are updating existing users’ languages you are forced to update all of the users in your excel. The system will not recognize NULL as an acceptable value and instead update the existing users to get the default language and overwrite their existing language.

 

Auto mapping

In order to ensure auto mapping then the column name in the Excel must fit with the given name in import. This name is language dependent as shown:

UK: Language

DK: Sprog

 

Validation

  • The value imported to language (either number or character (ISO code) must exist in the table ‘language’ of the systems database or an error will occur. Error type: ERROR (the import job will not be allowed to be executed).
  • If number and iso-code is mixed in one excel column, then System will try to convert iso-code to id number. If some cells do not follow the chosen method they will be considered as ‘empty’ and ‘DefaultLanguageForImportedUser’, as described in the ‘web.config’file, will be used as the language of the imported user.

Notes

  • If the value in your excel cell is empty, the system will use the ‘DefaultLanguageForImportedUser’ setting, as described in the ‘web.config’ help file, as the language of the imported user.
Retrieved from "http://wiki.catglobe.com/index.php?title=Field:_Language&oldid=20963"