Dear eGW developers,
I’m developing an accounting tool based on eGW project calendar entries
with booked resources. This tool operates separately from eGW, but uses
the eGW database. We use eGW 1.8.x.
My standard warning here is if you can find another way, do that.
By going directly to the database, you are missing out out all sorts of
nice logic handled by egw.
I hope you’ve already checked out project manager’s accounting and
budgeting, as well as exporting or merging into a document as alternative
ways of getting your data out.
My problems and questions:
- Is there some database documentation for tables and keys?
Check projectmanager/setup/tables_current.inc.php, fields are documented
there
- Currently I’m struggeling with calendar series entries, they all have
the same cal_id, but different dates. If a specific entry of a series is
modified a new calendar entry is made, with a new cal_id. Unfortunately,
the original entry is not deleted, so in my accounting tool I end up
with both entries listed. I couldn’t find a hint that those two entries
were linked to discard the older one. How do I properly deal with this
case?
See, this is what I’m talking about. Inside egw, when the event is read it
comes with a list of exceptions. If you read an event that is an
exception, you get a reference to the original.
This is generally not done in SQL, but I think egw_cal_dates has what you
need. Avoid this approach if you can.
- On the other hand, the table egw_pm_elements seems to offer all
up-to-date entries for a project, including calendar entries. Those a
separate entries containing copies of the cal_title of the calendar
entry, but missing the cal_id, which I need. I couldn’t find any key or
link to retrieve the cal_id for an egw_pm_elements entry. Where do I
find it?
I believe egw_links joins the two.
Nathan
