xowiki pages are managed with the OpenACS Content repository. XOWIKI pages: For each page there’s an entry in cr_items projop=# \d cr_items Table “public.cr_items” Column | Type | Modifiers ——————-+————————+———————————————— item_id | integer | not null parent_id | integer | not null name | character varying(400) | not null locale | character varying(4) | live_revision [...]

Content General Information Tables and views used Time sheet Portlets Sample Queries General information When time sheet form (/intranet-timesheet2/hours/new) is send to the server, … ]po[ deletes affected time sheet entries for affected day and user and creates new ones ... ]po[ updates im_projects::reported_hours_cache Please note that ... Paramaters have in impact on values shown [...]

http://www.infoworld.com/article/08/12/02/49TC-jitterbit-talend_1.html compares TALEND with JITTERBIT

Before a user can create or view a Financial Document, a permission check is performed. As a sample we will have a closer look what is checks are performed when a user wants to create a new quote. Permission checks creation of a new quote: /intranet-invoices/new?cost_type_id=3702 1) Depending on the required permission type (read/write) a [...]

# —————————————————— # Show extension fields # —————————————————— set dynamic_fields_p 0 if {[db_table_exists im_dynfield_attributes]} { set dynamic_fields_p 1 set object_type “im_company” set form_id “company_view” template::form create $form_id -mode “display” -display_buttons {} im_dynfield::append_attributes_to_form -object_type $object_type -form_id $form_id -object_id $company_id -form_display_mode “display” }

Table “public.im_menus” Description: Contains all menu items Open questions: Table “public.im_menus” Column | Type | Modifiers —————-+————————-+——————— menu_id | integer | not null package_name | character varying(200) | not null label | character varying(200) | not null name | character varying(200) | not null url | character varying(200) | not null sort_order | integer | [...]

What are ]po[ privileges? Privileges allow a user to perform a certain operation in the system. Find more information about privileges in the po-dev-openacs-developersguide.061201a.doc or in OpenACS Permissions Tediously Explained. Sample:Setting privileges on a component -- ----------------------------------------------------- -- Add privileges for freelance_skills -- create or replace function inline_0 () returns integer as ' declare v_count [...]

Groups: CREATE TABLE groups ( group_id int4 NOT NULL, group_name varchar(1000) NOT NULL, join_policy varchar(30) NOT NULL DEFAULT ‘open’::character varying, CONSTRAINT groups_pk PRIMARY KEY (group_id), CONSTRAINT groups_group_id_fk FOREIGN KEY (group_id) REFERENCES parties (party_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT groups_join_policy_ck CHECK (join_policy::text = ‘open’::text OR join_policy::text = ‘needs approval’::text OR [...]