 |
Online Documentation & Community |
Contents
- General
- FAQ
- @@ Configuration FAQ
- About FAQ's
- Architecture FAQ
- Bug Tracker FAQ
- Developer FAQ
- Filestorage FAQ
- Finance FAQ
- General FAQ
- Installation FAQ
- Localization FAQ
- Maintenance FAQ
- One Time Passwords FAQ
- Project Mgmt FAQ
- Reporting FAQ
- Rollout FAQ
- Software as a Service (SaaS) FAQ
- Translation FAQ
- Workflow FAQ
- ]project-open[ Wiki FAQ
- Partner Network
- About Partners - Complete list
- Access-Business Solutions S.A.
- Ad Axem
- Cogito
- Cosmo Commerce Corp.
- EFEXCON AG
- Elego
- Gongolabs
- IcoText LLC
- Konsultex
- Leinhäuser Solutions
- Localization to Russian
- Nuvento
- Odin Consultores
- Pentamino GmbH
- Qabiria
- SPIR-IT
- Sesmic Technologies
- Spazio IT - Soluzioni Informatiche
- Stoquart
- Thiqah
- Venkat Mangudi Consulting Pvt Ltd
- Webbudget
- Wizentis
- Zensar
- cognovís
- Material for ]po[ Partner
- Business Processes supported
- @Processes
- CKM Collaboration
- CKM Knowledge Management
- CKM Project E-Room Communication
- CRM Campaign Mgmt
- CRM Customer File Maintenance
- CRM Price List Maintenance
- CRM Sales Forecasting
- FI Accounting Process
- FI Accounts Payable
- FI Accounts Receivable
- FI Controlling
- FI Cost Accounting
- FI Credit Control
- FI Managing Project Expenses
- FI Project Invoicing
- FI Timesheet Invoicing
- FI Work in Progress Calculation
- HR Absence Management
- HR Employee Maintenance
- HR Freelance Management
- HR Project Staffing
- HR Recruiting
- HR Skill Maintenance
- ITSM Account Management
- ITSM Change Management
- ITSM Configuration Management
- ITSM Incident Management
- ITSM Problem Management
- ITSM Release Management
- ITSM Service Level Management
- PD Idea Generation
- PM Capacity Planning
- PM Earned Value Management
- PM Project Approval
- PM Project Planning
- PM Project Portfolio Mgmt
- PM Project Resource Planning
- PM Project Tracking & Monitoring
- PM Timesheet Management
- PMA Provider Auction, RFQ & RFP
- PMA Provider Maintenance
- SM Service Management
- ]po[ Modules
- ]po[ Packages
- @Packages
- Introduction to ]po[ Petri-Net Workflows
- OpenACS API Browser
- OpenACS Bug Tracker
- OpenACS Calendar
- OpenACS Diagram
- OpenACS Documentation
- OpenACS XML-RPC Package
- OpenACS XoWiki
- ]po[ ASUS Client
- ]po[ ASUS Client2
- ]po[ Active Directory LDAP
- ]po[ BB4 Big Brother Integration
- ]po[ Baselines
- ]po[ Batch Importer
- ]po[ CVS Integration
- ]po[ CVS Integration Package
- ]po[ Calendar
- ]po[ Chat
- ]po[ Contacts/CRM Package
- ]po[ Core
- ]po[ Data Warehouse Light
- ]po[ DynField
- ]po[ Earned Value Management
- ]po[ Exchange Rates
- ]po[ Expenses Workflow
- ]po[ Filestorage
- ]po[ Finance Core
- ]po[ Finance Cost Center Permissions
- ]po[ Finance Expenses
- ]po[ Finance Invoices / Quotes / Provider Bills
- ]po[ Finance Payments
- ]po[ Financial Planning
- ]po[ Forum
- ]po[ Forum
- ]po[ Freelance
- ]po[ Freelance RFQ
- ]po[ Full-Text File Search
- ]po[ Full-Text Search Engine
- ]po[ Funambol Integration
- ]po[ Gantt Project
- ]po[ Helpdesk
- ]po[ Human Resources
- ]po[ ITSM Bug Tracker
- ]po[ ITSM Configuration Mgmt
- ]po[ ITSM Nagios Integration
- ]po[ ITSM Release Management
- ]po[ Idea Management
- ]po[ Intranet File Storage with AJAX support
- ]po[ Invoice Templates
- ]po[ Mail Import
- ]po[ Material Master
- ]po[ Milestone
- ]po[ Notes
- ]po[ One Time Passwords (OTP)
- ]po[ OpenLDAP Driver
- ]po[ Petri-Net Workflow Integration
- ]po[ Portfolio Management
- ]po[ REST Interface
- ]po[ REST Interface - Creating Objects
- ]po[ RSS Reader
- ]po[ Reporting Core
- ]po[ Reporting Dashboard
- ]po[ Reporting Data-Warehouse
- ]po[ Reporting Finance
- ]po[ Reporting Indicators
- ]po[ Reporting OOoo ("PowerPoint")
- ]po[ Reporting Translation
- ]po[ Reporting Tutorial
- ]po[ Resource Management
- ]po[ Risk Management
- ]po[ SCRUM Support
- ]po[ SLA Management
- ]po[ SOAP::Lite Server
- ]po[ Sencha Libraries
- ]po[ Sharepoint Integration
- ]po[ Simple Survey
- ]po[ System Configurator
- ]po[ Timesheet Approval Workflow
- ]po[ Timesheet Invoices
- ]po[ Timesheet Management
- ]po[ Timesheet Tasks
- ]po[ TinyTM Integration
- ]po[ Translation Freelance
- ]po[ Translation Project Wizard
- ]po[ Translation Quality
- ]po[ UBL Interface
- ]po[ Wiki Interface
- ]po[ XML-RPC Interface
- ]po[ XoWiki
- ]project-open[ Audit
- ]project-open[ XML-RPC Package
- ]po[ Pages & Portlets
- About Pages & Portlets
- Admin @Home Page
- Admin API Doc
- Admin Backup and Restore
- Admin Cache Flush
- Admin Cache Status
- Admin Categories
- Admin Cost Center Permissions
- Admin Cost Centers
- Admin Developer Home
- Admin DynFields
- Admin DynViews
- Admin Exchange Rates
- Admin Interactive Shell
- Admin LDAP Authentication
- Admin Localization Home
- Admin Materials
- Admin Menu Permissions
- Admin Package Manager
- Admin Parameters
- Admin Portlet Components
- Admin Restart Server
- Admin SQL Profiling
- Admin Simple Surveys Permissions
- Admin Site Map
- Admin SysConfig Wizard
- Admin User Exits
- Admin User Matrix
- Admin User Profiles
- Admin Workflow
- Categories
- Earned Value Portlet
- Intranet Timesheet Tasks
- PM Capacity Planning
- PM Resource Planning
- Projects Main Page
- ]po[ Templates
- Portlets
- Business Intelligence
- Indicators
- Reports
- @Reports
- Finance Cube
- Finance Expenses
- Finance Income Statement
- Finance Project Hierarchy
- Finance Projects and their Documents
- Finance VAT Report
- Financial Documents and their Projects
- Monthly Financial Summary
- Object Audit Cube
- Price Cube
- Project
- Project Manager Productivity
- Simple Surveys
- Simple Surveys Cube
- Timesheet Cube
- Timesheet Customer/Project
- Timesheet Finance
- Timesheet Productivity
- Timesheet Productivity (Calendar View)
- Timesheet Weekly View
- Translation Tasks
- User Contact Information
- User Tutorials
- About Tutorials
- Consulting
- FI Financial Controlling Sample Case
- FI Financial Controlling Tutorial
- FI Managing Project Expenses
- FI Project Invoicing
- FI Setting Sales Prices
- Finance User
- Forum User
- GEN Generic User Guide
- GEN Printing from browser
- GEN User Filestorage
- GEN User Management
- GEN Wiki
- HR Absence Workflow
- HR Managing Vacation / Vacation Balance
- HR Setting Bank Holidays
- PM Capacity Planning
- PM Gantt and Timesheet
- PM Project Approval
- PM Project Invoicing & Timesheet Guide
- PM Project Planning
- PM Resource Planning
- PM Timesheet Management
- Project Manager
- TR Translation Freelance Guide
- TR Translation Guide
- TR Translation WorkFlow Guide
- TR Use and set up of the ]po[ Customer Portal
- TR Using Wordcounts
- Configuration Tutorials
- @@ Configuration FAQ
- @Configuration Overview
- FI Financial Document Configuration
- FI List of Placeholder variables for templates
- Filestorage Integration
- GEN Configuration Wizard
- GEN GUI Configuration
- GEN Home Page Configuration
- GEN Internal Company Configuration
- GEN Language, Date, and Currency
- GEN Multi-Company Configuration
- GEN Permissions Configuration
- GEN Permissions Model/Access Rights
- GEN User Profile Configuration
- GEN User Profile Permissions / Privileges
- HR Configuration Absence Workflow
- System Administration
- "Find" Benchmark
- AOLserver Startup Benchmark
- Dynamic Fields
- Installation, Maintenance & Updates
- Database Configuration
- Installing the ]po[ Customer Portal
- LdapAD and the ]project-open[ intranet
- Operations and Maintenance Guide [deprecated]
- Pound Root Jail & HTTPS Configuration
- Unix Advanced Installation Guide
- Unix Advanced Maintenance Guide
- Unix Simplified Installation Guide [deprecated]
- Updates for ]project-open[ 3.x
- Installers
- Mail System
- Other
- Developer Corner
- About
- Benchmarks
- CVS Updates & Versions
- Contributing Patches
- Developer FAQ
- Developers Guide: GUI
- GEN User Profile Permissions / Privileges
- OpenACS High Level Tutorial
- Reporting a bug
- The Need for A Different Approach to DB extendibility
- Tutorials
- Patterns & Practices
- Workflow
- Introduction & Concepts
- Building WFs in ]po[ - Tutorials
- REST Interface
- Released Versions
- Data-Model
- @Data-Model Overview
- Architecture
- Data Model
- Data Model Cookbook
- Data-Model Intro
- Project Permissions
- Database Tables
- @Tables Overview
- OpenACS Bug-Tracker Tables
- OpenACS Calendar Tables
- OpenACS Content Rep Tables
- OpenACS Localization Tables
- OpenACS Mail Tables
- OpenACS Notifications Table
- OpenACS Object Tables
- OpenACS Other Tables
- OpenACS Package Mgr Tables
- OpenACS Permission Tables
- OpenACS Relationship Tables
- OpenACS Service Contract Tables
- OpenACS Status Engine Tables
- OpenACS Users & Groups
- ]po[ Core GUI Tables
- ]po[ Core Objects Tables
- ]po[ DynField Tables
- ]po[ Filestorage Tables
- ]po[ Financial Tables
- ]po[ Forum Tables
- ]po[ Full-Text Search Tables
- ]po[ Gantt & Timesheet Tables
- ]po[ Helpdesk & ITSM Tables
- ]po[ Reporting Tables
- ]po[ Simple Survey Tables
- ]po[ Skill & Freelance Tables
- ]po[ Translation Tables
- ]po[ Workflow Tables
- PL/SQL API
- Object Types
- @Object Types
- ACS Event
- Gantt Project
- OpenACS Attribute
- OpenACS Calendar
- OpenACS Calendar Item
- OpenACS Group
- OpenACS Object
- OpenACS Object Type
- OpenACS Package
- OpenACS Party
- OpenACS Permission
- OpenACS Person
- OpenACS Privilege
- OpenACS Relationship
- OpenACS User
- ]po[ Business Object
- ]po[ Category
- ]po[ Company
- ]po[ Component Plugin
- ]po[ Cost Center
- ]po[ Cost Item
- ]po[ DynField Attribute
- ]po[ DynView
- ]po[ Employee
- ]po[ Expense Bundle
- ]po[ Expense Item
- ]po[ Financial Document
- ]po[ Financial Document Item
- ]po[ Forum Topic
- ]po[ Hour
- ]po[ Indicator
- ]po[ Material
- ]po[ Menu
- ]po[ Office
- ]po[ Payment
- ]po[ Profile
- ]po[ Project
- ]po[ Ticket
- ]po[ Ticket-Ticket Rel
- ]po[ Timesheet Invoice
- ]po[ Timesheet Price
- ]po[ Timesheet Task
- Categories
- @Categories
- Intranet Absence Status
- Intranet Absence Type
- Intranet Annual Revenue
- Intranet Company Status
- Intranet Company Type
- Intranet Conf Item Status
- Intranet Conf Item Type
- Intranet Cost Center Status
- Intranet Cost Center Type
- Intranet Cost Status
- Intranet Cost Template
- Intranet Cost Type
- Intranet DynField Storage Type
- Intranet Employee Pipeline State
- Intranet Expense Payment Type
- Intranet Experience Level
- Intranet Freelance RFQ Type
- Intranet Freelance Skill Type
- Intranet Invoice Payment Method
- Intranet Job Title
- Intranet LOC Tool
- Intranet Office Status
- Intranet Office Type
- Intranet Operating Systems
- Intranet Organization Size
- Intranet Partner Status
- Intranet Payment Type
- Intranet Prior Experience
- Intranet Project On Track Status
- Intranet Project Status
- Intranet Project Type
- Intranet Qualification Process
- Intranet Release Status
- Intranet Report Status
- Intranet Report Type
- Intranet Service Catalog
- Intranet Skill Type
- Intranet Skin
- Intranet Ticket Action
- Intranet Ticket Class
- Intranet Ticket Priority
- Intranet Ticket Type
- Intranet Timesheet Task Status
- Intranet Topic Status
- Intranet Topic Type
- Intranet Translation Language
- Intranet Translation Memory Tool
- Intranet Translation Memory Tools
- Intranet Translation Quality Type
- Intranet Translation Subject Area
- Intranet Translation Task Status
- Intranet UoM
- Intranet User Type
- Glossary
- Languages & Localization
- Systems Integration
- About Software Integration
- CVS Integration
- Currency and Exchange Rates
- Data Migration
- File Server Integration
- Filestorage Integration
- Funambol Integration
- LDAP Integration
- MS-Project Integration
- Microsoft Active Directory
- Nagios Integration
- Navision Integration
- OCS Inventory NG Integration
- ODBC Generic Integration
- OpenOffice Integration
- OpenProj/Gantt Project integration
- SAP FI Integration
- SourceForge Bug-Tracker Integration
- Subversion Integration
- TSearch2 Full-Text Search Integration
- TaskJuggler Integration
- Types of Application Integration
- XML-RPC Generic Integration
- Extension Requests
- About Extension Requests
- CRM: Advanced Customer Relationship Management
- FI: Administration of Consulting & Service Rates
- FI: Extensions Cost Accounting - Accounts, Management of Overhead Costs, Cash Flow Report
- FI: Recurring Invoices
- ITSM: Service Contract Management
- PM/FI: Pending Invoice Units
- PM: Advanced Financial Project Planning
- PM: Getting things done (GTD)
- PM: Improvements HTML Forum
- PM: Improving Resource Planning Report
- PM: Mail integration
- PM: Resource-constrained Project Scheduling
- PM: Utility Analysis
- TR: Customer Portal for Translation Companies
- Extension Requests - COMPLETED
|
5 registered users in last 24 hours OpenACS Users & Groups PL/SQL APIFor reference please see the users & groups data model.
Shortcut Functions for Users
|
| Function | Returns | Arguments | Description |
|---|---|---|---|
| [im_dept_from_user_id] | varchar | integer | |
| [im_email_from_user_id] | varchar | integer | Shortcut function returning a user's first_names, last_name. |
| [im_profiles_from_user_id] | varchar | integer | Shortcut function returning a string with a comma separated list of all profiles of a user. |
| [im_initials_from_user_id] | varchar | integer | Shortcut function returning the user's intials. |
Profiles PL/SQL API
Profiles are a ]po[ sub-type of group.
| Function | Returns | Arguments | Description |
|---|---|---|---|
| [im_profile__delete] | integer | integer | Destructor |
| [im_profile__name] | varchar | integer | Name Function |
| [im_profile__new] | integer | integer, varchar, timestamptz, integer, varchar, integer, varchar, varchar, varchar, varchar, varchar | Constructor |
| [im_profile__new] | integer | varchar, varchar | Shortcut constructor |
| [im_profile_add_user] | integer | varchar, integer | Adding a profile to a user. This function is not save, because profile membership is cached in the TCL API. |
Parties PL/SQL API
Parties are a super-type of persons and groups.
| Function | Returns | Arguments | Description |
|---|---|---|---|
| [party__delete] | integer | integer | Destructor |
| [party__email] | varchar | integer | Shortcut function to return the party's email field. |
| [party__name] | varchar | integer | Name function |
| [party__new] | integer | integer, varchar, timestamptz, integer, varchar, varchar, varchar, integer | Constructor |
The following functions allows to add/remove users to a party:
| Function | Returns | Arguments | Description |
|---|---|---|---|
| [party_approved_member__add] | integer | integer, integer, integer, varchar | |
| [party_approved_member__add_one] | integer | integer, integer, integer | |
| [party_approved_member__remove] | integer | integer, integer, integer, varchar | |
| [party_approved_member__remove_one] | integer | integer, integer, integer |
Persons PL/SQL API
Persons represent natural persons.
| Function | Returns | Arguments | Description |
|---|---|---|---|
| [person__delete] | integer | integer | Destructor |
| [person__first_names] | varchar | integer | Shortcut function to return the first_names field of a person. |
| [person__last_name] | varchar | integer | Shortcut function to return the last_name field of a person. |
| [person__new] | integer | integer, varchar, timestamptz, integer, varchar, varchar, varchar, varchar, varchar, integer | Constructor |
