All columns to be imported must be formatted as text in the Excel sheet. If this is not done, you risk that data will not be imported into 24SevenOffice.
|NoteCategoryId||System categories on the note. Variables are Note, Phone, Meeting, Sales, Invoice, Other and Email|
|NoteCompanyId||ID or name of existing company in 24SevenOffice that you want the note to be associated with|
|NoteContactId||ID on existing contact you want the note to be attached to|
|NoteDateRegistered||Date of registration of the note. Format: day of year (31.01.2008)|
|NoteDescription||Comment in the note|
|NoteOwner||The owner of the note must be an existing user of 24SevenOffice, otherwise it will be set to the user who imports the data. Must be in the format first name + last name or employee id|
|Note Private||Defines whether the note should be private to the owner of the note. The field is then set to "private".|
|NoteProjectId||ID of existing project to which the note is to be linked|
|Note Title||Title of the note|
When importing files that contain notes larger than 255 characters, a note that is over 255 characters must be in the first row (under the heading).
Otherwise, the database will limit the field to nvarchar (255), and large notes will be cut to 255 characters.