Save job_title in column

[jlalanne]

• deleted -

[Ralf_Becker_Stylite]

Hi,

Hi dears members,

I have created a new column linked to the job_title in the admin user groups
aditor , see the image below :

http://egroupware.219119.n3.nabble.com/file/n4007544/print_function.png

I have also added this column ‘account_job_title’ in mysql database in the
table egw_accounts.

When I push the save button in the user editor it doesn’t fill the column
!!!

Where in the code php do I have to add for it works ??? I have already
modified many lines to integrate this job_title but it still doesn’t work !!
You have to add your extra column to phpgwapi/setup/tables_current.inc.php:

$phpgw_baseline = array(
…
‘egw_addressbook’ => array(
‘fd’ => array(
‘contact_id’ => array(‘type’ => ‘auto’,‘nullable’ => False),
…
‘account_job_title’ => array(‘type’ => ‘varchar’,
‘precision’ => ???)
),
…

But I would not recommend that.

Recommended way is to add a “job_title” custom field, which will be
stored in egw_addressbook_extra.
You can change our eTemplates to show that custom field in an arbitrary
position and exclude it from regular custom fields shown in an extra tab
or column.

I never have seen a so much complexe code php in my life !!

Ralf

–
Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

[jlalanne]

Thanks Mr Becker,

Great honnor to get contact with you,

When I add your line, like this:

I get this error:

Moreover, as you can note there already is this line in ‘egw_addressbook’ array:
‘contact_title’ => array(‘type’ => ‘varchar’, ‘precision’ => ‘64’, ‘comment’ => ‘jobtitle’),
it fits with the field job_title !

Don’t you think I rather have to add ‘account_job_title’ line in ‘egw_accounts’ array ? still in the same class tables_current.inc ? like this:

I have tried it too but it still doesn’t work : when I press the save button in the adressbook editor, the column ‘contact_title’ of table ‘egw_addressbook’ in my database mysql is well filled, but the ‘account_job_title’ column in egroupware remains empty.

Thanks !

[jlalanne]

Nobody can help me ?

I have not succed yet !!!

The column does NOT want to fill !!

[AlexS]

Dear jlalanne,

egroupware does not know about your new db-field. Thats why it says: Unknown column account_job_title in field list.
Normaly reinstalling the addressbook application from setup should solve your problem, but you would lose your adressbook data!

Additionaly normaly there is no need to edit the tables_current.inc.php and tables_update.inc.php files directly. This can be managed via db tools app: /index.php?menuaction=etemplate.db_tools.edit it is located in application etemplate.

As a general hint: I followed the tutorial below and learned many things about egroupware apps:

https://community.egroupware.org/index.php?wikipage=Code+Corner

Good luck!