The following tables and fields are required for LIME Insight when Lime CRM is used as a data source.
LIME Insight will always look for a table with the label User to find coworkers.
| Field | Possible Field types | Possible labels | Possible names |
|---|---|---|---|
| Name | Text | Name | name, completename |
| Inactive | YesNo | Inactive | inactive, quit |
| Signature | Nickname, Signature | signature, nickname |
If a complete name field is not found LIME Insight will try to look for a first name, last name combination.
| Field | Possible Field types | Possible labels | Possible names |
|---|---|---|---|
| First Name | Text | FirstName | firstname |
| Inactive | Text | LastName | lastname, surname |
LIME Insight will always look for a table with the label History to find activities to measure.
| Field | Possible Field types | Possible labels | Possible names |
|---|---|---|---|
| Activity | Option, TextOption | Category, Description | category, topic, subject, type, activitytype, activity |
LIME Insight will always look for a tables with the label Project and Company to find value fields, coworker fields and date fields which is what it needs to measure values.
LIME insight will look for a relation field (field type Link) to a table with the label User OR a field label ResponsibleCoworker
LIME insight will look for fields with field type Date or DateTime
LIME insight will look for fields with field type Integer or Decimal
LIME insight will look for fields with field type Option