Our complete set of customized site files for new dotproject customizers
February 14, 2009
Dotproject | PHP | Web Building

For all the dotProject newbies out there, this is the kind of thing I wish I'd had when I got started - it would have saved me a lot of time. I'm posting all the files for a dotproject site I manage, since it seems it may help people get started in customizing dotProject.

To find my changes, search across all the files for the phrases "ellen added" or "ellen changed" in various comments.

One note of caution! I am not an expert in php or dotproject so the fact that something has been done doesn't necessarily mean it is done in the best way, nor even that works. But these files should help to get you going. This is presented "as is" and I will not fix things for you or document things beyond what is in the articles I post here (Browse all my dotProject posts)

Ads by Google

Posted by ellen at February 14, 2009 08:31 PM

One-page Project updating

A lot of functions can be done from the projects page, including changing project status, priority, "Team" (something we added, using sys_vals), and creating a new task on a given project. Eventually I'd like to make all project editing happen from this page.

Picture 24.jpg

You may want to import our sysvals data into your database to see how we use teams, statuses, colors, etc.

-- phpMyAdmin SQL Dump
-- version
-- http://www.phpmyadmin.net
-- Host: localhost
-- Generation Time: Feb 16, 2009 at 09:52 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.4


-- Database: `complian_dprj4`

-- --------------------------------------------------------

-- Table structure for table `sysvals`

`sysval_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sysval_key_id` int(10) unsigned NOT NULL DEFAULT '0',
`sysval_title` varchar(48) NOT NULL DEFAULT '',
`sysval_value` text NOT NULL,
PRIMARY KEY (`sysval_id`)

-- Dumping data for table `sysvals`

INSERT INTO `sysvals` (`sysval_id`, `sysval_key_id`, `sysval_title`, `sysval_value`) VALUES
(1, 1, 'ProjectStatus', '0|Ready\r\n1|Nd. Resources\r\n2|Nd. Content\r\n3|In Progress\r\n4|In Review\r\n5|Complete\r\n6|Cancelled\r\n7|Templates\r\n8|Ongoing\r\n9|Hold'),
(2, 1, 'CompanyType', '1|Client'),
(3, 1, 'TaskDurationType', '1|hours\n24|days'),
(4, 1, 'EventType', '0|General\n1|Appointment\n2|Meeting\n3|All Day Event\n4|Anniversary\n5|Reminder'),
(5, 1, 'TaskStatus', '0|Active\n-1|Inactive'),
(6, 1, 'TaskType', '0|Unknown\n1|Administrative\n2|Operative'),
(7, 2, 'ProjectType', '0| All\r\n1| App Mgt - Blue\r\n2| ROI - Green\r\n3| Learn Net - White\r\n4| Edu Tech - Lilac\r\n5| Online Edu - Orange\r\n6| Office Mgmnt - Pink\r\n7| Apps Training - Purple\r\n8| Edu Programs - Yellow\r\n9| Strategic Plan - Turq'),
(8, 3, 'ProjectColors', 'Web|FFE0AE\r\nEngineering|AEFFB2\r\nHelpDesk|FFFCAE\r\nSystem Administration|FFAEAE'),
(9, 1, 'FileType', '0|Unknown\n1|Document\n2|Application'),
(10, 1, 'TaskPriority', '-1|low\n0|normal\n1|high'),
(11, 1, 'ProjectPriority', '-1|3-LOW\r\n0|2-MEDIUM\r\n1|1-HIGH\r\n2|2-UNKNOWN'),
(12, 1, 'ProjectPriorityColor', '-1|#D4E2F7\r\n0|#009999\r\n1|#EFA9A9'),
(13, 1, 'TaskLogReference', '0|Not Defined\n1|Email\n2|Helpdesk\n3|Phone Call\n4|Fax'),
(14, 1, 'TaskLogReferenceImage', '0| 1|./images/obj/email.gif 2|./modules/helpdesk/images/helpdesk.png 3|./images/obj/phone.gif 4|./images/icons/stock_print-16.png'),
(15, 1, 'BudgetCode', '0|UH 1|MedSchool 2|HMO'),
(16, 3, 'ProjectStatusColor', '0|#D4E3F7\r\n1|#D8BFD8\r\n2|#F7F7D4\r\n3|#FFFFFF\r\n4|#F7E9D4\r\n5|#E9E9E9\r\n6|#E9E9E9\r\n7|#FFFFFF\r\n8|#D5F7D4'),
(17, 1, 'ProjectRequiredFields', 'f.project_name.value.length|<3\r\nf.project_color_identifier.value.length|<3\r\nf.project_company.options[f.project_company.selectedIndex].value|<1'),
(18, 1, 'UserType', '0|Default User\r\n1|Administrator\r\n2|CEO\r\n3|Director\r\n4|Branch Manager\r\n5|Manager\r\n6|Supervisor\r\n7|Employee'),
(19, 1, 'TicketNotify', '0|admin@localhost\n1|admin@localhost\n2|admin@localhost\r\n3|admin@localhost\r\n4|admin@localhost'),
(20, 1, 'TicketPriority', '0|Low\n1|Normal\n2|High\n3|Highest\n4|911'),
(21, 1, 'TicketStatus', '0|Open\n1|Closed\n2|Deleted'),
(24, 4, 'HelpDeskPriority', '0|Not Specified\n1|Low\n2|Medium\n3|High'),
(25, 4, 'HelpDeskSeverity', '0|Not Specified\n1|No Impact\n2|Low\n3|Medium\n4|High\n5|Critical'),
(26, 4, 'HelpDeskCallType', '0|Not Specified\r\n1|Activity still in progress\r\n2|Wrong activity on plan\r\n3|Quiz didn''t score\r\n4|How to unenroll\r\n5|Unable to log in\r\n6|Delete activity from transcript\r\n7|Manager - Staff list\r\n8|Learning module or SCORM\r\n9|Other'),
(27, 4, 'HelpDeskSource', '0|Not Specified\r\n1|E-Mail\r\n2|Phone\r\n3|In Person\r\n4|Fax'),
(28, 4, 'HelpDeskOS', '0|End-User\r\n1|Manager\r\n2|Facilitator\r\n3|Other'),
(29, 4, 'HelpDeskApplic', '0|Not Applicable\r\n1|LMS\r\n2|Learning Module/Quiz'),
(30, 4, 'HelpDeskStatus', '0|Unassigned\n1|Open\n2|Closed\n3|On Hold\n4|Testing'),
(31, 4, 'HelpDeskAuditTrail', '0|Created\n1|Title\n2|Requestor Name\n3|Requestor E-mail\n4|Requestor Phone\n5|Assigned To\n6|Notify by e-mail\n7|Company\n8|Project\n9|Call Type\n10|Call Source\n11|Status\n12|Priority\n13|Severity\n14|Operating System\n15|Application\n16|Summary\n17|Deleted'),
(35, 3, 'ProjectTypeColor', '0|#CCCCCC;\r\n1|#6699cc\r\n2|#66cc99\r\n3|#FFFFFF\r\n4|#ccccff\r\n5|#ff9966\r\n6|#ff99cc\r\n7|#660099\r\n8|#ffffcc\r\n9|#009999'),
(32, 2, 'Complete?', '0|Yes\r\n1|No'),
(36, 1, 'TicketSubject', '0| Other\r\n1|activity still in progress\r\n2|wrong activity on plan\r\n3|quiz didn''t score\r\n4|how to unenroll\r\n5|unable to log in\r\n6|delete activity from transcript\r\n7|Unable to open modules or quizzes\r\n8|Facilitator access\r\n9|How to Use\r\n10|Fix Learning Activity or Portal');


Enhanced To-do list for each user

Reorder the tasks on your list: we very rarely share tasks, so each task basically has one assigned user. As a result, I was able to use a field in the main tasks table to keep track of a task-order value, so each person could order their tasks on a big list.

This should really be done with a separate table and some jquery-style drag-n-drop so you can move your tasks around in the list, but that's all for a future upgrade. This quick-and dirty-version works for small teams with minimal task sharing.

Picture 25.jpg

Help-call log based on ticket module

I modified the ticket system to create a sort of call log. We don't really need a real ticket system per se, but we do need a way to keep statistics on what kinds of requests for help come in. So I've started to work on making this a one-page module. Everything is entered and filtered on one page. A work in progress.

Picture 28.jpg

See my dotproject recipe articles for more details on what I did to the site. Browse all dotProject posts


Ads by Google


thanks for this!!!!!

have you looked at web2project??

Your 'Projects' layout is so much more along the lines of what I need to produce. Can you provide more information on how you got it to look like that? I am some what a newbie at DPJ and editing the files, but with a little much appreciated guidance I can do it.

Thank you in advance!


Ads by Google

 RSS   |   Contact Me

Ads by Google