usSuperOfficeCRM (new 2014-02-26)

Based on (table.column) Type Column alias Localised english name Comment
associate.name E UserName User name User name
- E Domain Domain Value comes from system variable =sv(user_import_domain);
PS! Go to system variables and make sure this setting is correct.
adr.name E Email
E-mail
 E-mail address.
contact.department E Mobile
Mobile
 Mobile / cell phone number.
contact.orgNr E Fullname
Name
 Users full name.
associate.deleted E Active Active Status of user: 1=Active, 0=Inactive / deleted.
address.zip E IsAdmin IsAdmin Is the user an administrator in SuperOffice? 1=Administrator, 0=Ordinary user.
If the user is an administrator in SuperOffice he will be an administror in SuperOffice Analyze as well.
address.city
 E
Locale
 Locale Users preferrred locale.
This will decide the locale for the user.
address.state E
Usr1t
Associate Id (Usr1t)
 Users associate_id
address.address1 E Usr2t
Primary group Id (Usr2t)
 Id of Users primary group.
contact.category_idx -> category.name E
Usr3t
Person Id (Usr3t)
 Users person_id.
contact.business_idx -> business.name E
Usr6t
Language (Usr6t)
 This will decide how multi-language strings are decoded for the user.
usergroup.name E GroupName Primary group Name of users primary group.
contact.contact_id C SecondaryGroupNames Secondary groups Comma separated list of users secondary group memberships.
ejuser.id C Usr7t Usr7t The id of the Customer service user.
Only relevant for Customer service users.
ejuser.usergroup C Usr8t Usr8t Id of Usergroup for the Customer service user.
ejuser.default_category C Usr9t Usr9t Id of the default category for the Customer service user.
sale.contact_id C Person number Person number Person number.
  C
Salutation
Salutation
Salutation (Mr. / Mrs / Ms.)
sale.contact_id C Department Department Department.
sale.contact_id C Initials Initials Initials.
sale.contact_id C Gender Gender Gender.
appointment.contact_id C Person image Person image Image of the person as stored in the superOffice database.
It is possible to set width and/or height of the images to improve appearance of output.
Go to the Properties tab and edit the inline image tag.
Use height=<pixels> to set height and width=<pixels> to limit width. Use the preview tab to see the results imediately.
appointment.contact_id C Days since last login/out Days since last login/out Nr. of days since last registered login ot logout.
PS! If the user is using the web-client there will be no trace here. If thats the case this column will be unreliable.
ticket.cust_id C Currently active Currently active 1=Active, 0=Not currently active.
PS! If the user is using the web-client there will be no trace here. If thats the case this column will be unreliable.
ticket.cust_id C Position/Title Position/Title Closed tickets.
contact.registered E Date of birth Date of birth Registered date.
contact.registered E Date of birth available Date of birth available Registered date. Used for pivoting / comparing this/last year.
contact.updated E Days until birthday (this year) Days until birthday (this year) Updated date.
contact.updated E Anniversary
Anniversary
 Updated date. Used for pivoting / comparing this/last year.
contact.number1 E Birthday Birthday number1