Anyone using Opacus Outlook Plugin Lite V3?

English Language - Forum SuiteCRM Outlook Plugin
1

I am using Opacus Outlook Plugin Lite V3 to archive my emails from Outlook 2013 to SuiteCRM 7.7.9.

It is working well for Cases, Bugs and Projects modules. That is, archived emails are shown up under the History subpanel of each module.

However, it does not work for Contracts module. What I mean is that, in Opacus Outlook Plugin, I can find the contract that I want to archive the email to. It even says that the email is archived successfully. However, over at SuiteCRM, it’s empty in the History subpanel of the contract.

This is what is being shown in the log.

Wed Jan 18 16:10:20 2017 [120268][1][FATAL] Error running count query for ProjectTask List:  Query Failed:  SELECT count(*) c FROM project_task   LEFT JOIN  users jt0 ON project_task.modified_user_id=jt0.id AND jt0.deleted=0
 AND jt0.deleted=0  LEFT JOIN  users jt1 ON project_task.created_by=jt1.id AND jt1.deleted=0
 AND jt1.deleted=0  LEFT JOIN  project project ON project_task.project_id=project.id AND project.deleted=0
 AND project.deleted=0  LEFT JOIN  users jt3 ON project_task.assigned_user_id=jt3.id AND jt3.deleted=0
 AND jt3.deleted=0 where ((projecttask.name LIKE 'imc%')) AND project_task.deleted=0: MySQL error 1054: Unknown column 'projecttask.name' in 'where clause'

As you can see, it is weird that Project Task module shows up in the log! I am wondering who is causing the problem, Opacus Outlook Plugin or SuiteCRM?

2

We have same error in the log file. Have you able to figure out the issue? :melting_face:

3

No longer using it because it cannot work with SuiteCRM 8

4

Ohh okay, do you use any other tool to archive your emails to SuiteCRM v8? :thinking:

5

Currently not using any tools.

6

I’ve actually done it with n8n.
Archiving with custom logic :slight_smile: works very well in multiple projects.

7

:nerd_face: do you have video about it on your YT channel?

Also, do we need n8n on HTTPS to integrate with SuiteCRM ?

8

More or less.

It’s starting with the IMAP node.
I’m using this one for way more features than the standard one: https://www.npmjs.com/package/n8n-nodes-imap

Then it’s the search for the right lead / contact:

And afterwards just create the mail record:

Depending on what you’d like to relate, you’d need to create relationships as well:

One specific thing to point out:
SuiteCRM is using its own hashing logic for the Mail ID. So you’d either need to rebuilt it or simply store the original Mail ID in the DB to avoid duplicates.

As for HTTPS:
More or less - the modern browsers don’t want to accept HTTPS anymore and it’s free and easy via letsencrypt. Chrome will make it default this year:

So technically it works without SSL encryption - but it’s multiple steps backwards / the wrong way to go. :slight_smile:

1 Like