Inbound E-Mails: Monitor Folders - including Sub-Folders

[tobias]

Hi there,

First of all, thanks for providing such a great piece of software, much appreciated.

As for my question, I'm trying to load a certain IMAP folder including all sub-folders.

Is there a way to set a wildcard in ordert to load e-mails from any sub-folder?
OR do I have to select every single of my 50 sub-folders?

Attached, please find a screenshot of my current approach, which didn't work out but should explain what I need.

Thanks for your help.

- Tobias

[yuri]

Hi Tobias

I think it's not possible to use wildcard, but I',m not sure.

[tobias]

Now that's really bad news, since it seems that one cannot select more than ~ 10 sub-folders

[yuri]

Why you can't? It is cut because not insufficient max length of the field id database?

You can increase
application/Espo/Resources/metadata/entityDefs/InboundEmail.json

Add "maxLength": 500
to "monitoredFolders"
It should look like

        "monitoredFolders": {
            "type": "varchar",
            "required": true,
            "default": "INBOX",
            "view": "views/inbound-email/fields/folders",
            "maxLength": 500
        }, 

Rebuild database.

[tobias]

Yes, this did the trick. I also had to change EmailAccount.json the same way in order to allow more folders to be monitored.

The downside: I can no longer show or create Group Email Accounts.

Here's the error code as logged in the console:

[Error] Bad server response: 
    (anonymous function)
    dispatch (espo.min.js:3:14470)
    handle (espo.min.js:3:11257)
    trigger (espo.min.js:3:13581)
    x (espo.min.js:4:9071)
    (anonymous function) (espo.min.js:4:14722)

[Error] Server side error 200: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `inbound_email` ORDER BY  DESC LIMIT 0, 20' at line 1
    (anonymous function)
    dispatch (espo.min.js:3:14470)
    handle (espo.min.js:3:11257)
    trigger (espo.min.js:3:13581)
    x (espo.min.js:4:9071)
    (anonymous function) (espo.min.js:4:14722)

Or is this some other issue?

[yuri]

Check whether JSON files you changed are valid JSON.

[tobias]

Thanks for the hint, all good now. Great support, keep up the good work.