To import questions into EASE, navigate to Manage / Question Library, first download the template file and save it to a convenient location.
- Click the 'Upload Questions' icon:
- In the pop-up window, click Template to download the .csv or .xlsx file.
- Fill out the file with all information to be imported.
- If you are using .csv, ensure the file is saved as .csv with UTF-8 encoding, or the import will not succeed.
- Questions can be imported into all audit categories that your organization may use.
- There are a few libraries' restrictions, and those restrictions mirror the setup of questions in each library.
- Each row in the file will be imported as one question with the appropriate settings. The table below is a guide for acceptable inputs in each column.
- Click browse or drag and drop to attach the file. Then click the Upload button to import the questions into the library.
ATTENTION!
When importing Questions to the library number of Tags added to the question is limited to 5.
Click here to watch the Importing Questions tutorial.
Tips:
- Do not delete or modify the header row's contents from the template.
- Save the file as a CSV UTF-8 (MS Excel 2016 and above have this option as shown below):
- If a column is Required, the value must be present in each row.
- Quotation marks are not valid and are used below for descriptive purposes only. Including them will result in an error when importing.
Columns A, C, F, S, T, and U are the bare minimum for an import.
Column Eligible value (pick one if multiple are listed) Note Template type/ Activity* The name in this field must match one of these or match a custom template type you created: "LPA" / "5S" / "Safety." Required Title Text Required for the following languages: Japanese, Chinese, Korean, Thai, and Arabic. Optional for other languages, and we will auto-generate a title. Question* Text Required Reason Text Optional Reaction Plan Text Optional Response Type* "Pass_Fail" / "Score" / "Free_Form" Required Required "Yes" / "No" Optional, if blank - then 'Yes' is selected Photo Input "Off'" / "Optional" / "Required" / "Required_Fail" Optional, if blank - then 'Optional' is selected Mitigation "Off" / "Optional" / "On" Optional defaults to 'On' for Pass/Fail and ‘Off’ for score if no value is entered under 'Minimum Passing Score.' Alternate Responsible Party "Off" / "On" Optional defaults to 'Off.' Score Integer (1-10) Required if the Response type is 'Score,' must be empty otherwise. Minimum passing score Integer (0-Score) Optional, if empty - then no pass range is defined. Must be empty if the response type is not 'Score.' tag1 Text Optional, if the tag does not currently exist, then create it. tag2 Text Optional, if the tag does not currently exist, then create it. tag3 Text Optional, if the tag does not currently exist, then create it. tag4 Text Optional, if the tag does not currently exist, then create it. tag5 Text Optional, if the tag does not currently exist, then create it. Scope Text Optional. Must be one of the scopes listed under Admin / Organization / Scopes. Allow N/A Response "Yes" / "No" Required, if blank - then 'Yes' is selected Question Comment Option "RequiredonFail" / "Required" / "Optional" Required, if blank - then 'Optional' is selected Mitigation Requires Attachment "Yes" / "No" Required, if blank - then 'No' is selected - If your Excel region has semicolons (;) as the default delimiter in CSV files, you will have to convert them to commas (,).On Windows, you can change the List separator setting in the Regional and Language Options as specified on the Office support website:
- Change the separator in a CSV text file.
- Click the Windows Start menu.
- Click Control Panel.
- Open the Regional and Language Options dialog box.
- Click the Regional Options Tab.
- Click Customize / Additional settings (Win10).
- Type a new separator in the List separator box.
- Click OK twice.
- Note: this only works if the Decimal symbol is not designated as a comma (in line with the Wikipedia citation above). If it is, Excel will not use a comma as the List separator, even if chosen. For many non-United States regions, a comma is the default Decimal symbol.
Comments
0 comments
Please sign in to leave a comment.