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

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

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 Reply by AndreyEver

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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

Sounds great!

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

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

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 Reply by AndreyEver (edited by AndreyEver 2022-07-05 16:45:54)

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

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 Reply by AndreyEver (edited by AndreyEver 2022-07-21 17:44:48)

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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 Reply by AndreyEver (edited by AndreyEver 2022-09-02 22:51:47)

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

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 Reply by AndreyEver (edited by AndreyEver 2022-09-08 20:12:49)

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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 Reply by AndreyEver

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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

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

13 Reply by AndreyEver

  • AndreyEver
  • Member
  • Offline
  • Registered: 2022-05-15
  • Posts: 28

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

Any chance to see additional user info fields in  "vmail.mailbox" and in iRedAdmin-Pro user profile ?

14 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

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

No plan for this shortly. Sorry.