Timesheet doesn't show [User] column

Jian 2012-03-02 23:39:43 UTC #1

Hi, All,

I’m testing eGroupware 1.8.002.20111111 on CentOS 6.2. We have been
using v1.6 for a while so I migrate the mysql database from the current
v1.6.003 to this new installed v1.8.002.

There were some problem after the upgrade. I managed to solved some of
them and it seems works fine now. But when I login as admin user and
clicked the “Timesheet” icon on the top, in the display, there is no
"User" column any more. On our v1.6, this column is located in between
the “Duration” and “Actions”. Also on the v1.6 I can use the "User"
pull-down manual to filter the user.

On the new v1.8.002, there is a tiny icon (shape like a window) which I
can pull down to select which columns to show. But enable and disable
the “User” make no difference. The “User” just disappeared.

How can I bring the “User” column back? Please help.

Thanks in advance.

–
Jian Gao

–

Jian 2012-03-03 00:36:17 UTC #2

More information:

When I upgrade the eGw, I had to drop the timesheet app (this aslo drop
the ts_timesheet table.) and reinstall v1.8. After reinstall the
timesheet app, I restored the ts_timesheet table.

Jian

Hi, All,

I’m testing eGroupware 1.8.002.20111111 on CentOS 6.2. We have been
using v1.6 for a while so I migrate the mysql database from the
current v1.6.003 to this new installed v1.8.002.

There were some problem after the upgrade. I managed to solved some of
them and it seems works fine now. But when I login as admin user and
clicked the “Timesheet” icon on the top, in the display, there is no
"User" column any more. On our v1.6, this column is located in between
the “Duration” and “Actions”. Also on the v1.6 I can use the "User"
pull-down manual to filter the user.

On the new v1.8.002, there is a tiny icon (shape like a window) which
I can pull down to select which columns to show. But enable and
disable the “User” make no difference. The “User” just disappeared.

How can I bring the “User” column back? Please help.

Thanks in advance.

–
Jian Gao

Virtualization& Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

–

Ralf_Becker_Stylite 2012-03-03 09:05:15 UTC #3

More information:

When I upgrade the eGw, I had to drop the timesheet app (this aslo drop
the ts_timesheet table.) and reinstall v1.8. After reinstall the
timesheet app, I restored the ts_timesheet table.

That leaves you without the necessary schema changes of the 1.6 -> 1.8
update! It’s an integer column egw_timesheet.ts_status and an index on it.

Hi, All,

I’m testing eGroupware 1.8.002.20111111 on CentOS 6.2. We have been
using v1.6 for a while so I migrate the mysql database from the
current v1.6.003 to this new installed v1.8.002.

There were some problem after the upgrade. I managed to solved some of
them and it seems works fine now. But when I login as admin user and
clicked the “Timesheet” icon on the top, in the display, there is no
"User" column any more. On our v1.6, this column is located in between
the “Duration” and “Actions”. Also on the v1.6 I can use the "User"
pull-down manual to filter the user.

On the new v1.8.002, there is a tiny icon (shape like a window) which
I can pull down to select which columns to show. But enable and
disable the “User” make no difference. The “User” just disappeared.

How can I bring the “User” column back? Please help.

Are you sure you have the rights to view other users timesheets. If you
have not rights for any other user but yourself, the column will not show.

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

Commerzbank BLZ 55040022 | Account 218111300
IBAN DE33 5504 0022 0218 1113 00 | BIC COBADEFFXXX
VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

Jian 2012-03-05 19:31:05 UTC #4

More information:

When I upgrade the eGw, I had to drop the timesheet app (this aslo drop
the ts_timesheet table.) and reinstall v1.8. After reinstall the
timesheet app, I restored the ts_timesheet table.
That leaves you without the necessary schema changes of the 1.6 -> 1.8
update! It’s an integer column egw_timesheet.ts_status and an index on it.

Hi, All,

I’m testing eGroupware 1.8.002.20111111 on CentOS 6.2. We have been
using v1.6 for a while so I migrate the mysql database from the
current v1.6.003 to this new installed v1.8.002.

There were some problem after the upgrade. I managed to solved some of
them and it seems works fine now. But when I login as admin user and
clicked the “Timesheet” icon on the top, in the display, there is no
"User" column any more. On our v1.6, this column is located in between
the “Duration” and “Actions”. Also on the v1.6 I can use the "User"
pull-down manual to filter the user.

On the new v1.8.002, there is a tiny icon (shape like a window) which
I can pull down to select which columns to show. But enable and
disable the “User” make no difference. The “User” just disappeared.

How can I bring the “User” column back? Please help.
Are you sure you have the rights to view other users timesheets. If you
have not rights for any other user but yourself, the column will not show.

Ralf

Thank you Ralf for the reply.

I checked the egw_timesheet table and it has ts_status(int11) field.

And the I am the admin user. I can login and click the “Admin” icon and
configure anything.

What should I look into? ACL?..

Jian Gao

–

Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

Jian 2012-03-06 01:05:37 UTC #5

More information:

When I upgrade the eGw, I had to drop the timesheet app (this aslo drop
the ts_timesheet table.) and reinstall v1.8. After reinstall the
timesheet app, I restored the ts_timesheet table.
That leaves you without the necessary schema changes of the 1.6 -> 1.8
update! It’s an integer column egw_timesheet.ts_status and an index on it.

Hi, All,

I’m testing eGroupware 1.8.002.20111111 on CentOS 6.2. We have been
using v1.6 for a while so I migrate the mysql database from the
current v1.6.003 to this new installed v1.8.002.

There were some problem after the upgrade. I managed to solved some of
them and it seems works fine now. But when I login as admin user and
clicked the “Timesheet” icon on the top, in the display, there is no
"User" column any more. On our v1.6, this column is located in between
the “Duration” and “Actions”. Also on the v1.6 I can use the "User"
pull-down manual to filter the user.

On the new v1.8.002, there is a tiny icon (shape like a window) which
I can pull down to select which columns to show. But enable and
disable the “User” make no difference. The “User” just disappeared.

How can I bring the “User” column back? Please help.
Are you sure you have the rights to view other users timesheets. If you
have not rights for any other user but yourself, the column will not show.

Ralf

OK, I got it fixed after few hours research. All I did is restore the
egw_acl from our current db.

Thanks a lot for the hint, Ralf.

Cheers,

Jian

–

Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users