1 (edited by AndreyEver 2022-09-08 20:30:02)

Topic: Feature request: extend user profile page with additional fields

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.5.2
- Deployed with iRedMail Easy or the downloadable installer? Installer
- Linux/BSD distribution name and version: Debian 11
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes, iRedAdmin Pro
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Currently on user creation in iRedAdmin (PRO) in sogo database user's contact created with limited number of data (just two: name and email). Specifically domain (or global) address book is exported only with this data and is read only carddav address book, so this data can non be extended neither from SOSo web not iRedAdmin (PRO)

It could be very useful if admin and/or user itself would be able to define/edit these data (phone, address, company name, etc ...) on account creation or latter on.

P.S. +1 nice point to iRedAdminPro

Thanks in advance

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Stable release is out.

2

Re: Feature request: extend user profile page with additional fields

Maybe we can improve the SQL VIEW "sogo.users" (in iRedMail-1.5.2 and earlier) or "vmail.sogo_users" (in upcoming release, 1.5.3 or 1.6.0) to add more columns from "vmail.mailbox" table.

3

Re: Feature request: extend user profile page with additional fields

Sounds great!

4 (edited by AndreyEver 2022-05-17 01:25:18)

Re: Feature request: extend user profile page with additional fields

New fields we need the most (ideally on user creation in iRedAdmin PRO) to be used in SoGO web, RoundCube and Outlook address/phone books:

- company name
- department (useful for domain/global address book grouping/search)
- mobile phone number (+xxxxxxxxx) (useful for VoIP app like Zoiper etc)
- internal phone number (xxxx) (useful for VoIP app like Zoiper etc)
- social net nickname (like Telegramm @nickname)
- birthday (for the reminder in mail client)

Thanks in advance

5

Re: Feature request: extend user profile page with additional fields

iRedMail doesn't have these information in user profile.
FYI:
- https://github.com/iredmail/iRedMail/bl … mysql#L187
- https://www.sogo.nu/files/docs/SOGoInst … -using-SQL

6 (edited by AndreyEver 2022-07-05 16:45:54)

Re: Feature request: extend user profile page with additional fields

ZhangHuangbin wrote:

iRedMail doesn't have these information in user profile.
FYI:
- https://github.com/iredmail/iRedMail/bl … mysql#L187
- https://www.sogo.nu/files/docs/SOGoInst … -using-SQL

Right.
That's why it's called: feature request to extend user profile in iRedmail (add additional user info fields)
If you do so, you would be able to extend SQL VIEW to support "popular LDAP attributes"

as written in sogo manual from the link you provided:
"Other columns can exist and will actually be mapped automatically if they have the same name as popular LDAP attributes (such as givenName, sn, department, title, telephoneNumber, etc.)."

7

Re: Feature request: extend user profile page with additional fields

Would you like to give it a try? I'm happy to merge your changes. smile

8 (edited by AndreyEver 2022-07-21 17:44:48)

Re: Feature request: extend user profile page with additional fields

I wish I could....
This is why I'm posting my wishes as "feature request" and it's fully up to u to implement it or not

9 (edited by AndreyEver 2022-09-02 22:51:47)

Re: Feature request: extend user profile page with additional fields

Changing VIEW (sogo.users) to

select `vmail`.`mailbox`.`username` AS `c_uid`,
`vmail`.`mailbox`.`username` AS `c_name`,
`vmail`.`mailbox`.`password` AS `c_password`,
`vmail`.`mailbox`.`name` AS `c_cn`,
`vmail`.`mailbox`.`username` AS `mail`,
`vmail`.`mailbox`.`domain` AS `domain`,
`vmail`.`mailbox`.`enablesogowebmail` AS `c_webmail`,
`vmail`.`mailbox`.`enablesogocalendar` AS `c_calendar`,
`vmail`.`mailbox`.`enablesogoactivesync` AS `c_activesync`,
`vmail`.`mailbox`.`employeeid`  AS `telephonenumber` 
from `vmail`.`mailbox` where `vmail`.`mailbox`.`enablesogo` = 1 and `vmail`.`mailbox`.`active` = 1

gives value from EmployeeID field (in iRedAdminPro panel) to VCARD c_telephonenumber field
It is very simple to extend domain address book (in SOGO) by adding corresponding fields to iRedAdminPro panel with appropriate sogo.users SQL VIEW update

10

Re: Feature request: extend user profile page with additional fields

AndreyEver wrote:

`vmail`.`mailbox`.`employeeid`  AS `telephonenumber`

Using 'employeeid' as telephone number is not proper.
Better add new column (e.g. "telephone") in "vmail.mailbox" and use it in VIEW.

11 (edited by AndreyEver 2022-09-08 20:12:49)

Re: Feature request: extend user profile page with additional fields

ZhangHuangbin wrote:
AndreyEver wrote:

`vmail`.`mailbox`.`employeeid`  AS `telephonenumber`

Using 'employeeid' as telephone number is not proper.
Better add new column (e.g. "telephone") in "vmail.mailbox" and use it in VIEW.

Sure!!

That's why I'm requesting to add additional fields (telephone, mobilephone, department etc) to iRedAdmin-Pro user profile page with new columns (e.g. "telephone") in "vmail.mailbox" 

Currently there is only "employeeid" editbox  available for this purpose

12

Re: Feature request: extend user profile page with additional fields

Here is what I'm talking about: https://prnt.sc/pk1CrP5cTIPK