List of adaptations to be processed in all XLSForms Worksheet Location line or column To adapt Survey group Adapt naming to local context in language ‘location_details’ when applicable: fields, columns C, D and E - ‘District’ - ‘Township’ - ‘Village/Neighbourhood’ - column E: Translate all text from column C language’ to local language ‘label::Local ‘label::English’ column H: Translate all text from column F ‘hint::English’ language’ to local language ‘hint::Local column P: Translate all text from column N to local ‘constraint_message::English’ language’ language Choices column E: Translate all text from column C language’ to local language ‘label::Local ‘label::English’ columns B, C, D, E, F G Enter all the details of the selected geographic locations Settings column F: Translate all text from column D language’ to local language ‘label::Local column C: Set to the desired ‘default_language’ language ‘default_language’ Forms list and specific changes List of already developed XLSForms : with their corresponding reference tool when the preload of a CSV format beneficiary list is required (pulldata function) if any specific change is required to adapt the file to each operation Specific changes CSV Reference tool ODK template Work To be preload Location sheet adapted M4_2_5_2 no Survey Line 22 : Change Feedback and number of ‘phone_nb’ complaint form digits if template different from 10 M4_4_1_2 yes Survey Line 30 : Change Beneficiary master number of data, lists, reports digits if different from 10 yes None - -
List of adaptations to be processed in all XLSForms Worksheet Location line or column To adapt Survey group ‘location_details’ when applicable: - ‘District’ - ‘Township’ - ‘Village/Neighbourhood’ - Adapt naming to local context in language fields, columns C, D and E column E: ‘label::Local language’ Translate all text from column C ‘label::English’ to local language column H: ‘hint::Local language’ Translate all text from column F ‘hint::English’ to local language column P: language’ Translate all text from column N ‘constraint_message::English’ to local language Choices column E: ‘label::Local language’ Translate all text from column C ‘label::English’ to local language columns B, C, D, E, F G Enter all the details of the selected geographic locations Settings column F: ‘label::Local language’ Translate all text from column D to local language column C: ‘default_language’ Set ‘default_language’ to the desired language Forms list and specific changes List of already developed XLSForms : with their corresponding reference tool when the preload of a CSV format beneficiary list is required (pulldata function) if any specific change is required to adapt the file to each operation Reference tool ODK template CSV preload Specific changes Work sheet Location To be adapted M4_2_5_2 Feedback and complaint form template no Survey Line 22 : ‘phone_nb’ Change number of digits if different from 10 M4_4_1_2 Beneficiary master data, lists, reports yes Survey Line 30 : Change number of digits if different from 10 yes None - -