Text Translations

Purpose:

To add, edit or delete Text Translations.  The Text Translations are the translations the district has entered for some text elements or Table Name/Field Name combinations.  The elements must then be coded into the various locations in the SchoolData applications.

This Element Table does not include the text that is translated.  To see this text, along with the translation use the Text Translations with Untranslated Text combination.

What you'll need:

• Table Name
• this is the name of the table the information to be translated is stored in.  If the information can be seen in the Admin, put in the name of the category where it can be seen i.e. Assessment Tests, Learning Standards, Student Learning Plan Commitments
• Field Name
• this is the name of the field in the table the information to be translated is stored in. If the information can be seen in the Admin, put in the name of the header where it can be seen i.e. Assessment Test Label, Learning Standard, Student Learning Plan Commitment
• Record Id Value
• this is the name of the Id value in the Table of the Field that will be translated. If the information can be seen in the Admin, put in the Id of the row containing the text to be translated
• Text Translation
• this is the actual translation of the English text
• Language Id
• this can be found in the Admin - Classroom Admin >> Report Card >> Text Translation Languages *note: This is NOT the Id from the Languages Element Table

Directions:

Log into the Admin at http://{YourDistirct}.schooldata.net/admin with your SchoolData.net username and password.

• navigate to the Admin category >> Report Card >> Text Translations (Assignment)
• For more information on navigating in the Admin read this article
• the information in the Element Table includes:
• Id
• Text Translations
• Table Name
• Field Name
• Text Translation Language (and Id)
• Record Id Value
• for more information on utilizing an element table read this article

Web Form:

The web form is best used for edits and one or two additions.

• type the text translation
• type the table name
• type the field name
• select the text translation language
• type the record id value
• click the 'submit' button

CSV Upload:

The .csv upload is best used for multiple changes or additions.

Directions:

1. click the table actions button at the bottom of the window
2. select 'download CSV template...' It will be named "TemplateForTable-TextTranslations-[current date].csv"
3. open the template in Excel. Leave the header row in tact
4. for each Text Translation, enter the following information row by row, starting with the second row (*note:  the file may say some fields are optional, but they are not):
   • Text Translation
   • Table Name
   • Field Name
   • Text Translation Language
   • Record Id Value
5. save the template as a csv file again
6. return to Homeroom Admin and select table actions, then upload.csv
7. select the template you modified, and optionally give the file a label
8. click Upload