Messages

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 / Re: Same bug / error remains in 3.0.5

« on: March 05, 2015, 06:51:30 am »

Just to inform you ...

This bug still consists in 3.1.1

 

3

Feng Office 3 / Re: 3.0.5 German translation

« on: February 18, 2015, 07:01:42 am »

Aaahh !!!
Thx

 

4

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
 

5

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.
 

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
 

6

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
 

7

Feng Office 2 / Re: 2.7.1.1 poor search function / search results

« on: October 29, 2014, 01:07:50 pm »

If you left the prefix as og_ may be the upgrade was not done correctly.

I'll check the completeness of fo_ tables by comparing the generated fo_ tables against an empty new 2.7.1.1 database.

On the other hand, have you tried the advanced search?

Yes.
Same results.

cheers,
Plotz

btw. it might help to have a complete list of prcessed queries (mysql syntax) during the upgrade from 1.7.5 to 2.7.1.1 or a list of all tables in a fresh 2.7.1.1 installation.

8

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?

9

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.

10

Deutsch / Re: Serverumzug und Zugriff auf die alte Datenbank

« on: November 07, 2013, 08:06:28 am »

/cache/autoloader.php löschen.

Schon klappt das.

 

11

Deutsch / Re: Official translation to German

« on: August 19, 2012, 08:41:11 am »

... die letzte aktuelle Übersetzungsversion ist auf jeden Fall erst mal Nr. 15 (URL siehe vorherige Beiträge - für FengOffice 1.7.5). In den FengOffice-Paketen ist oft eine sehr alte Version enthalten.

Wird schon an einer aktuelleren Version gearbeitet ?

Ja, Theo und ich arbeiten bereits daran ...

Irgendwie siehts so aus als wäre die deutsche Übersetzung einer Version 2.x klinisch tot und der Patient Fengoffice läge im Sterben.

 

12

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.

 

addendum: sorry for bad english.

SUMS  =  TOTALS

 

13

How To's / Calendar grid and snap units change from 30 minutes to 15 minutes possible ?

« on: April 02, 2010, 09:37:34 am »

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

If yes (I strongly suppose ): where?

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

Thanks in advance !!!