Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Plotz

Pages: [1]
1
Feng Office 3 / How are Events connected to Workspaces
« on: November 09, 2021, 08:28:11 am »
Which field (or cascade of fields) connects a fo_projects_events object to workspaces?

It is yet relatively easy to get the creators name through fo_projects_events.object_id -> fo_objects.id -> fo_contacts.object_id by running this query:
Code: [Select]
SELECT
fo_project_events.object_id,
fo_project_events.`start`,
fo_project_events.duration,
fo_project_events.description,
fo_objects.`name`,
fo_objects.created_by_id,
fo_contacts.first_name,
fo_contacts.surname
FROM
fo_project_events
LEFT JOIN
fo_objects
ON
fo_project_events.object_id = fo_objects.id
LEFT JOIN
fo_contacts
ON
fo_objects.created_by_id = fo_contacts.object_id;

But I don't succeed in building a query retrieving the workspace owners names.
Anybody can help?

I did not find out yet how events are connected to workspaces.

The database model of fengoffice is a holy mess.
(if there is any at all)

Thank you.

2
Feng Office 3 / Same bug / error remains in 3.0.5
« on: January 28, 2015, 06:32:12 am »
This bug is still not fixed:

fengoffice\public\upgrade\templates\db_migration\2_0_asado.php

in line 1156

UPDATE `fo__config_options` ...

has to be

UPDATE `fo_config_options`...

every upgrade from 1.75 (or others below 2.0) will fail without this fix.

Please fix in new pckages.
Cheers
 8)

3
Feng Office 3 / 3.0.5 German translation
« on: January 21, 2015, 11:04:53 am »
since there is a lot of untranslated stuff  in the latest versions, I read about there's a tool for the job.

Would be helpful to find this tool.

Thx.
 8)

Does really nobody know about how to work on translations / laguage files ?

For shure there must be a tool in use similar to poedit.

Thank you
 8)

4
Feng Office 3 / Same bug / error remains in 3.0.3
« on: January 20, 2015, 07:12:38 am »
There is still the same error in

fengoffice\public\upgrade\templates\db_migration\2_0_asado.php


in line 1156

UPDATE `fo__config_options` ...

has to be

UPDATE `fo_config_options`...

which pulverizes every upgrade from below.

Please correct.
Cheers
 8)

5
Feng Office 2 / 2.7.1.1 poor search function / search results
« on: October 29, 2014, 10:48:45 am »
search function in 1.7.5 had been poor (couldn't handle german Umlaut ä ö ü ...)

After upgrading to 2.7.1.1 rearch results are even worse.
E.g. search for a person: among 750 contacts in total, from 7 having the same First Name only 4 are found, some of a certain Surname are not found at all.

There is no difference wether you choose Quick Search or Full Search, wether you choose a Search Object Category or all categories.

Is there any chance to reindex the search (if there is any search index) - or what can be done to make this poor search function  find ALL matching entries???

Thx.


Note: for now I left all "og_" prefixed tables in the database. Should I send them to Nirwana?

6
Feng Office 2 / Impossible to change address of a contact in Version 2.x
« on: October 26, 2014, 10:23:38 am »
In the Change Mode of a contact you may change the stinking avatar, but simple essential address fields of a contact like city and street are missing.
You can't change the address unless you change it in fo_contacts (og_contacts) using database tools.

Poor.

In Version 1.7.5 you couldn't change a persons e-mail,  if this e-mail address was already in the database elsewhere. Simple Developer thinking fault.
This happens often, e.g. a company and a person have same emal address.

You had to use database tools as well (I use Navicat premium, but phpmyadmin would do the job).
In Version 2.x there is no more chance at all to change an existing  persons address.
You are forced to use a backdoor.

Very Poor.

Hope you get this finally fixed. Not everybody is able to use mysql backdoors to get changes done.

Thx.



7
Feature requests / Footer in report to calculate sums
« on: February 21, 2012, 07:53:41 pm »
wish having a footer in reports and the ability to calculate sums or averages.of values in report fields there.

The one and only standard report already has this ability.

 ;D

addendum: sorry for bad english.

SUMS  =  TOTALS

 ;D

8
Is it possible to change the calendar grid and snap units from 30 minutes to 15 minutes ?

If yes (I strongly suppose ;D ): where?

Maybe you just have to change some php or js scripts for that. (?)

Thanks in advance !!!

 ;D

Pages: [1]
anything