Table structure

This is the standard structure that the integration expects and needs to function properly, however every table and field name can be configured in the Lime CRM admin config for TRAML tracking.

If using the email function, create the limetypes tramlemail and tramlmergecode. Optional to use linkclick and emailopening.

If using sms function, create the limetype tramlsms

Limetype linkclick and linkopening

If you will be using linkclick and linkopening, check the tables here or here but instead of adding a relation to automatedflowparticipant, automatedflowparticipantaction or mailing only add a relation to the tramlemail limetype.

Lisa examples:

Limetype tramlemail

tramlemail (Automatic email sendout/Automatiskt e-postutskick)

Field name	Required	Suggested local name(en/sv)	Field type(length)
fromname	False	Sender name/Namn avsändare	Text(128)
fromemail	False	Sender email/E-post avsändare	Text(128)
recipientname	False	Recipient name/Namn mottagare	Text(128)
recipientemail	False	Recipient email/E-post mottagare	Text(128)
subject	False	Subject/Ämnesrad	Text(128)
templatename	False	Template/Mall	Text(128)
templateid	False	Template ID/Mall ID	Integer
transactionmail_id	False	Transactionmail ID/Transactionmail ID	Integer
scheduledsendtime	False	Scheduled send time/Schemalagd utskickstid	Time
sent	False	Sent/Skickad	Time
delivered	False	Delivered/Levererad	Time
sendoutstatus	False	Sendout status/Utskicksstatus	Option
errormessage	False	Error message/Felmeddelande	Text(512)
person *optional	False	Person/Person	Relation - belongs to (person)
tramlmergecode	False	Merge codes/Styrkoder	Relation - have many (tramlmergecode)
linkclick *optional	False	Link click/Länkklick	Relation - have many (linkclick)
emailopening *optional	False	Email Opened/Email öppnat	Relation - have many (emailopening)

tramlemail.sendoutstatus

Key	Suggested local name(en/sv)
empty
bounce	Bounced/Studsat
clicked	Clicked/Klickat
error	Error/Fel
open	Opened/Öppnat
sent_to_marketing	Sending/Skickas
sent	Sent/Skickad
test	Test/Test
notsent	Not sent/Inte skickad
delivered	Delivered/Levererad

Lisa example:

Limetype tramlmergecode

tramlmergecode (Merge code/Styrkod)

Field

If the length of a mergecode name or mergecode value is greater than the length of the data given to the save function, it will truncate the value to not create a commit error.

Field name	Required	Suggested local name(en/sv)	Field type(length)
mergecode	False	Marketing string/Marketing sträng	Text(256)
value	False	Value/Värde	Text(2000) - increase the length if working with long mergecodes.
tramlemail	False	Automatic email sendout/Automatiskt e-postutskick	Relation - belongs to (tramlemail)

Lisa example:

Limetype tramlsms

If using sms function, create the limetype tramlsms

tramlsms (Automatic SMS sendout/Automatiskt SMS-utskick)

Field name	Required	Suggested local name(en/sv)	Field type(length)
sendernumber	False	Phone number sender/Telefonummer avständare	Text(32)
recipientnumber	False	Phone number recipient/Telefonummer mottagare	Text(32)
text	False	Sent text/Skickad text	Text(512)
transactionsms_id	False	Transactionsms ID/Transactionsms ID	Integer
scheduledsendtime	False	Scheduled send time/Schemalagd utskickstid	Time
sent	False	Sent/Skickad	Time
person *optional	False	Person/Person	Relation - belongs to (person)
errormessage	False	Error message/Felmeddelande	Text(512)
sendoutstatus	False	Sendout status/Utskicksstatus	Option

tramlsms.sendoutstatus

Key	Suggested local name(en/sv)
empty
deliveryfailed	Delivery failed/Leveransen misslyckades
deliverysucceded	Delivery succeded/Leveransen lyckades
error	Error/Fel
sent_to_marketing	Sending/Skickas
sent	Sent/Skickad
test	Test/Test

Lisa example: