...
Error messagecode | BeskrivningDescription | LösningSolution | |||||
Record exists | The item already exists in the base and will not be imported. | Can be deleted from the spreadsheet or just left as it is. It is not taken into account when importing. | |||||
Reference Mismatch | Reference to an item that does not exist. For example asset type. | If a check box is available in the relevant column heading (Create missing reference), tick this. Then the validation in this column disappears and the referenced element is automatically created during import. | |||||
Validation error | This usually comes because the text string is longer than the number of characters allowed. The tooltip above the validated cell shows e.g. varchar (40), which means the maximum number of characters allowed = 40 | Reduce the length of the text string in the Excel sheet and reload it. | |||||
Mandatory | Mandatory field | Validates on the setup under Admin> Required fields. Turn off the requirement or enter a value | Mandatory | Obligatoriskt fält. | |||
Single Quote not allowed | Single quote ( ' ) är inte tillåtet vid importnot allowed | Remove Ta bort ( ' ) i importfilin the import file | |||||
Wrong Date Format | Fel datumformat i den importerade filen | Wrong date format in the import file. | Change date format. It is recommended to convert dates in the import template to text using the formula = TEXT (A1; "dd.mm.yyyy") In the example above, a date in cell A1 is formatted as a date.Ändra datumformatet i den importerade filen | ||||
Value <= Previous Value | Validation on reading counter count. Specified counter level is lower than last registered. | Check meter readings on this machine and adjust in the import template if necessary. | |||||
Date < Previous Date | Validation on entry of date for counter reading. Indicates that the stated date is lower than the last registered date. | Check meter readings on this machine and adjust in the import template if necessary. | |||||
Wrong Time Format | Fel datumformat i den importerade filen | Incorrect time format in import file. | Times must be in the form 08:00Ändra datumformatet i den importerade filen | ||||
Missing Parent | Objektimport – Överliggande objektreferens saknas | Asset import – Missing parent asset reference. | Enter a valid parent asset no. in the asset structure. Refers, as a rule, to column A, Parent noAnge ett giltigt överliggande objektnr. i objektstrukturen. Referera, som regel, till kolumn A, Parent Nr. | ||||
Parent Error | |||||||
1 or 0 | Visas om fältet är annat än blankt, 0 eller 1. | Requires 0 or 1 as value. Blank cell will be perceived as 0. | Delete value in the field or set in value 1 or 0Ta bort värdet i fältet eller ange värde 1 eller 0. | ||||
Duplicate Value | |||||||
Number Already In Use. Please Use Unique Numbers! | Det kan inte vara mer än ett av dessa nummer i databasen. Nummer existerar redan i databasen. Gäller t.ex. för AO-nr., objektnr. osv. | Ange ett unikt nummer | Reservation Exists | Reference Not Unique | Numbers already exist in the database. Applies to e.g. for WO no, asset no etc. | Enter a unique number | |
Reservation Exists | When importing rental reservations, this indicates that a reservation exists for the specified period of time | Adjust reservation dates. | |||||
Reference Not Unique | This indicates that a given reference is not unambiguous. | Check the datebase for duplicate for the current referance. | |||||
Number Already In Use | A number field with requirements for uniqueness already exists in the database. | Change the number. | |||||
Item Already Connected | When importing items, you will get this error if you have specified a link to an asset that already has a connected item. | Remove existing item link to current asset. | Number Already In Use | Item Already Connected |