• last updated 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
A variety of changes that add up to making outlook synchronization work

with PostgreSQL (at all) and Oracle (better).

1. Changed calendar to read SystemTimezone rather than hardwire it to

US/Eastern.

2. Made calendar depend on acs-lang since that's where the param lives.

3. Fixed the query on the acs-lang page that lets you set the timezone

(used the Oracle-ism UNIQUE rather than the standard DISTINCT)

4. Saw that the test stuff doesn't work and got rid of the links on the

index page - people can live without testing it for this release (we

should fix it for 4.7)

5. Fixed timezone__local_to_utc so it works with calendar, though it's

very whacky (shifted so the timezone'd date part is the UTC date, would

be much much better to use timestamp without timezone but PG doesn't

accept that syntax for function returns and we're not ready to drop

PG 7.2 support yet so I can't take advantage of the timestamp/timestamptz

type names, sigh)

    • -7
    • +7
    ./tcl/calendar-outlook-procs-postgresql.xql
  1. … 4 more files in changeset.
Using new form builder maxlength instead. Also made description optional.

setting maxlength to 255 for name of calendar item text field, fixing bug 322

Added Sloan "+" graphic for adding an item

Migrated over changes to move some GIF resources into a common subdirectory

in the subsite package, so anyone who can read the main site can read

the images (previously you had to grant read privs to "/doc" explicitly

to get the graphics stored by acs-datetime to show up.

    • -31
    • +89
    ./tcl/calendar-display-procs.tcl
  1. … 38 more files in changeset.
Changed &lt to the datetime arrows like we use everywhere else 'cause

they're cute!

  1. … 1 more file in changeset.
Jarkko Laine's calendar bug fixes ...

  1. … 2 more files in changeset.
committing the latest translations from the dotLRN translation server

    • -1
    • +1
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.es_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.fi_FI.ISO-8859-15.xml
    • -0
    • +130
    ./catalog/calendar.gl_ES.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.it_IT.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.nl_NL.ISO-8859-1.xml
    • -2
    • +3
    ./catalog/calendar.no_NO.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.pl_PL.ISO-8859-2.xml
    • -8
    • +8
    ./catalog/calendar.pt_BR.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.ru_RU.windows-1251.xml
    • -1
    • +1
    ./catalog/calendar.sh_HR.ISO-8859-5.xml
    • -1
    • +1
    ./catalog/calendar.sv_SE.ISO-8859-1.xml
  1. … 420 more files in changeset.
I just added Jarkko Laine's bugfix for #303 and related bad input bugs. CVS

updated the other files and for some reason seems to think they're needed

again

Removed extra </if> tag.

Fixed bug #76: Day summary throws an error when you have multiple personal calendars. Now we only look for your personal calendar among the calendars displayed in your portlet (problem exposed in dotLRN).

Reverting to the previous version 1.3, since oracle doesn't have an interval data type

Reverting to the previous version 1.11, since oracle doesn't have an interval data type

    • -1
    • +1
    ./tcl/calendar-display-procs-oracle.xql
More PG 7.3 changes ...

    • -3
    • +3
    ./tcl/calendar-display-procs-postgresql.xql
  1. … 2 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

    • -15
    • +15
    ./sql/postgresql/calendar-create.sql
    • -1
    • +1
    ./tcl/calendar-display-procs-oracle.xql
    • -1
    • +1
    ./tcl/calendar-display-procs-postgresql.xql
  1. … 44 more files in changeset.
Committing the latest translation work from the dotlrn translation server. Many thanks to all the volunteer translators.

    • -1
    • +1
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -2
    • +68
    ./catalog/calendar.de_DE.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -9
    • +113
    ./catalog/calendar.es_ES.ISO-8859-1.xml
    • -1
    • +96
    ./catalog/calendar.fi_FI.ISO-8859-15.xml
    • -1
    • +1
    ./catalog/calendar.it_IT.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.nl_NL.ISO-8859-1.xml
    • -0
    • +129
    ./catalog/calendar.no_NO.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/calendar.pl_PL.ISO-8859-2.xml
    • -1
    • +11
    ./catalog/calendar.pt_BR.ISO-8859-1.xml
    • -2
    • +2
    ./catalog/calendar.ru_RU.windows-1251.xml
    • -1
    • +1
    ./catalog/calendar.sh_HR.ISO-8859-5.xml
    • -1
    • +1
    ./catalog/calendar.sv_SE.ISO-8859-1.xml
  1. … 123 more files in changeset.
Swapped e.name and a.name in cal::item::get query to show event name instead of activity name.

I18N: committing all the message catalog files from the dotLRN translation server. Kudos to all our translators for this contribution.

    • -0
    • +17
    ./catalog/calendar.TH_TH.TIS-620.xml
    • -54
    • +54
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -0
    • +64
    ./catalog/calendar.de_DE.ISO-8859-1.xml
    • -55
    • +55
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -0
    • +26
    ./catalog/calendar.es_ES.ISO-8859-1.xml
    • -0
    • +35
    ./catalog/calendar.fi_FI.ISO-8859-15.xml
    • -0
    • +39
    ./catalog/calendar.it_IT.ISO-8859-1.xml
    • -0
    • +130
    ./catalog/calendar.nl_NL.ISO-8859-1.xml
    • -0
    • +130
    ./catalog/calendar.pl_PL.ISO-8859-2.xml
    • -0
    • +120
    ./catalog/calendar.pt_BR.ISO-8859-1.xml
    • -0
    • +110
    ./catalog/calendar.ru_RU.windows-1251.xml
    • -0
    • +121
    ./catalog/calendar.sh_HR.ISO-8859-5.xml
    • -0
    • +12
    ./catalog/calendar.sv_SE.ISO-8859-1.xml
  1. … 322 more files in changeset.
Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

  1. … 76 more files in changeset.
removing temporary log statements

adding package version information to message catalog files

    • -1
    • +1
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -1
    • +1
    ./catalog/calendar.en_US.ISO-8859-1.xml
  1. … 41 more files in changeset.
Outlook sync was broken because of a changed column name

sync info files with package data and correct provides identifiers

  1. … 36 more files in changeset.
I18NL: localizing the display of dates and time using the lc_time_fmt proc from acs-lang, removing key ADD from catalog file as it's not used

    • -1
    • +0
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -1
    • +0
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -7
    • +6
    ./tcl/calendar-display-procs-oracle.xql
merge from oacs-4-6

    • -48
    • +0
    ./tcl/cal-item-procs-postgresql.xql
    • -21
    • +0
    ./tcl/calendar-procs-postgresql.xql
  1. … 118 more files in changeset.
Removed a couple &nbsp;'s between day number and plus

Made the add item template display a small + sign instead, and gave it a title tag

  1. … 1 more file in changeset.
Date/time/number localization

    • -56
    • +11
    ./tcl/calendar-display-procs-oracle.xql
    • -52
    • +8
    ./tcl/calendar-display-procs-postgresql.xql
    • -84
    • +17
    ./tcl/calendar-display-procs.tcl
  1. … 72 more files in changeset.
I18N: making the calendar package use the message catalog

    • -0
    • +131
    ./catalog/calendar.da_DK.ISO-8859-1.xml
    • -0
    • +137
    ./catalog/calendar.en_US.ISO-8859-1.xml
    • -19
    • +18
    ./www/cal-item-create-recurrence.adp
    • -12
    • +13
    ./www/cal-item-delete-confirm.adp
  1. … 9 more files in changeset.
-fixed create calendar if user does not have personal private calendar

-added query file for above query

-fixed redirect user to login if necessary