Importing error messages

Summary

In the article we will review all the errors you may face during the Import process. Also we'll describe the circumstances of their appearance, solutions and workarounds for them.

Message	Doesn't allow to run import until the issue is fixed.
Message	Allows to run import. Inconsistent data won't be imported though.
Explanation	More details on why the message appears.

Errors

'Cannot upload the file' errors

Message: Filetype <FILE_EXTENSION> is not allowed. File uploader supports XLSX, XLS, CSV.
Explanation:Save your data as a file of one of the supported types (formats) and try again.

Message: Incorrect URL provided.
Explanation:When you are trying to import from a Google Sheet document, double check if the link you've provided is right.

Message: No access to the document.
Explanation:Oomnitza can not get access to the Google Sheets document because of its permissions settings. You should change the permissions in the G-Suite to make it available to read for 3rd-parties.

Message: Spreadsheet does not contain importable data.
Explanation:Thespreadsheet contains values for only the first line (column names) or no values at all.

Message: Cannot upload the file: the number of columns must not exceed 100. Please reduce the number of columns.
Explanation:Make sure that your data source meets this limit described in the message.

Message: Cannot upload the file: the number of rows must not exceed 20 000. Please reduce the number of rows.
Explanation:Make sure that your data source meets the limit described in the message.

Message: All column headers should be filled. Column <#> header is empty.
Explanation:Oomnitza requires the first row of the sheet to be the row containing the headers of the table. The headers cells can not be empty as they stand for Oomnitza attributes of the object.

Message: Cannot upload the file: column headers should contain unique values.
Explanation:As soon as headers are names of object attributes they should be unique. Just make sure that there are no duplicates among the values in the headers row.

Message: <File/Sheet> contains more than one populated tab, only the first tab will be imported.
Explanation:In fact it's not an error but a warning. It shows up if your file or sheet has multiple tabs (sheets, pages). If you see this you can proceed with import.

Validation errors

Message: Primary identifier value is not populated.
Explanation:May happen if your Import Preference is 'Update' and there is at least one missing value in the spreadsheet column that is mapped on the Oomnitza 'Primary identifier' field.

Message: The value of mandatory field <FIELD NAME> is not populated.
Explanation:Happens if there is at least one missing value in the spreadsheet column that is mapped on any Oomnitza mandatory field.

Message: The <FIELD NAME> value belongs to the related field which depends on the attribute <ANOTHER_FIELD NAME>, and <ANOTHER_FIELD NAME> is not populated.
Explanation:Oomnitza allows you to configure the visibility of a field (dependent) depending on the value of another field or fields (main). This error tells that the dependent field is mapped but main the main field (which value defines whether to show the dependent field or keep hidden) is not.

Message: The <FIELD NAME> value belongs to the related field which depends on the specific set of values from Oomnitza attribute <ANOTHER_FIELD NAME>, and the value <VALUE> is out from this set.
Explanation: Oomnitza allows you to configure the visibility of a field (dependent) depending on the value of another field or fields (main). This error tells that the value of the main field from the spreadsheet does not match the value list of the main field in Oomnitza.

Message: User <VALUE> set for <FIELD NAME> is not found.
Explanation:Your Import Preference is 'Update' and the user from the spreadsheet does not exist in Oomnitza.

Message: Location <VALUE> set for <FIELD NAME> is not found.
Explanation: Your Import Preference is 'Update' and the location from the spreadsheet does not exist in Oomnitza.

Message: Field <FIELD NAME> is not filled in. This is a mandatory field.
Explanation:Role value in the spreadsheet is missing

Message: Role <VALUE> set for <FIELD NAME> is not found.
Explanation:Role value from your spreadsheet does not exist in Oomnitza

Message: Role value of user <USERNAME> is not allowed to be changed.
Explanation: You are trying to update the role you belong to in Oomnitza which is not allowed to do. You can change your role (or ask admins) and try again or update the spreadsheet so as not to be affected by the potential changes.

Message: You do not have permissions to update user role.
Explanation: You are trying to import users and map the Role Oomnitza field without having permissions to update user roles in Oomnitza. You should either ask admins to extend your permissions or ignore (not use for mapping) the restricted field.

Message: Field <FIELD NAME> is not filled in. This is a mandatory field.
Explanation:Oomnitza finds empty cells in the spreadsheet column that was mapped on the Oomnitza mandatory field.

Message: Username <VALUE> set for <FIELD NAME> is not found.
Explanation: Username value from your spreadsheet does not exist in Oomnitza

Message: Username value should be from 2 to 128 characters long and contain only allowable symbols: a-z, A-Z, 0-9 and "-", "_", "+", ".", "@", " ' ".
Explanation:The value that supposed to be set for the Username field does not meet at least one of the limitations.

Message: Username value is forbidden to be changed.
Explanation:It is not allowed to change the Username field value.

Message: Email <VALUE> set for <FIELD NAME> is not found.
Explanation: Your Import Preference is 'Update' and the user's email from the spreadsheet does not exist in Oomnitza.

Message: There is more than one <OBJECT> with unique field <FIELD NAME> equal to <VALUE>.
Explanation: Either your spreadsheet has duplicates among values in the column mapped on the Oomnitza unique field or a column from your spreadsheet is mapped to a unique Oomnitza field and contains a value for that already exists in Oomnitza.

Message: <FIELD NAME> value should be no longer than <NUMBER> characters.
Explanation: The limitation on the maximum value length is not met and the value in the spreadsheet contains more characters than Oomnitza supports for the mapped field.

Message: <FIELD NAME> value contains invalid characters.
Explanation: The value in the spreadsheet contains UTF-8 symbols which is not allowed in Oomnitza.

Message: <FIELD NAME> <VALUE> does not match existing values.
Explanation: This error happens when the attribute in Oomnitza is represented by a dropdown field type and the value from the source spreadsheet does not match any values existing in Oomnitza for this dropdown. So you have to either update your spreadsheet with valid values or add the required value in Oomnitza (fields customization feature).

Message: Invalid <FIELD NAME> value.
Explanation:The value in the spreadsheet contains invalid characters.

Message: <FIELD NAME> value is not populated.
Explanation: Appears if a spreadsheet column mapped on any Oomnitza 'checkbox'-type field contains empty values. You should use one of the next values for 'checkbox' fields: true, yes, y, 1 (for setting it as 'checked'); false, no, n, 0 (for setting it as 'not checked').

Message: Longitude value should be within the range from -180 to +180.
Explanation:The longitude value in the spreadsheet is out of the allowed range.

Message: Invalid longitude value in <FIELD NAME>.
Explanation:The longitude value in the spreadsheet contains invalid characters.

Message: Latitude value should be within the range from -85 to +85.
Explanation:The latitude value in the spreadsheet is out of the allowed range.

Message: Invalid latitude value in <FIELD NAME>.
Explanation:The latitude value in the spreadsheet contains invalid characters.