VBA class module as MS-Office connector via XML-RPC

Description

This plugin alloows you to use MS-Excel and MS-Project for ticket tracking of tickets which are logged and maintained in Trac.

There are following samples:

1. MS-Excel Ticket editor: a hot-linked connection between your Trac tickets and your custom spreadsheet.
2. MS-Project connector: a hot-linked connection between your Trac tickets and your MS-Project file.

Bugs/Feature Requests

Existing bugs and feature requests for VisualBasicTracConnectorIntegration are here.

If you have any issues, create a new ticket.

defect	2 / 10
enhancement	2 / 5
task	1 / 1

Download

Download the zipped source from here.

Source

You can check out VisualBasicTracConnectorIntegration from here using Subversion, or browse the source​ with Trac.

Installation

General instructions on installing Trac plugins can be found on the TracPlugins page.

Example

MS-Excel Ticket editor

1. Fill setting sheet

2. Create sheets that are same name as project names

3. Push "Import tickets" button

4. Edit imported tickets' fields

5. Add new tickets

6. Push "Check modified fields" button

7. Confirm the edited fields' background color are changed.

8. Push "Update" button

9. According to the browser, modified tickets' fields are changed

MS-Project connector

1. Add custom fields.

type	name	MS-Project's field
custom	due_assign	Start	required
custom	due_close	Finish	required
custom	complete	PercentComplete	required
custom	blocking	(dependency)	add blocking ticket
standard	summary	name
standard	owner	resource
standard	milestone	(dependency)	Add preceding task for the milestone
standard	version	(dependency)	Add preceding task for the mversion
custom	summary_ticket	(summary task)	Optional, for TracDependencyPlugin
custom	dependencies	(dependency)	Optional, for TracDependencyPlugin
custom	baseline_start	BaselineStart	Optional
custom	baseline_finish	BaselineFinish	Optional

2. Create tickets.
3. Open TracProject.mpp

Note: You may have to lower the macro security level in MS-Project for the connector's Import button to show up:

• Choose Tools -> Options... to display the Options dialog.
• Select the Security tab
• Click the Macro Security button
• Choose Medium or Low security

4. Create blank mpp file.

5. (Activate created mpp file.) It might be activated.
6. Push "Import" button

7. input settings for your environment, then push "Validation" button

8. If connection is valid, then enable "Import" button. Push this button

Recent Changes

7838 by okazaki on 2010-04-11 18:10:50

refs #6929

7837 by okazaki on 2010-04-11 16:10:21

refs #6961

7836 by okazaki on 2010-04-11 15:17:18

refs #6958
Validation list length limitation is added to selectable fields.

(more)

Author/Contributors

Author: okazaki
Maintainer: Yuji OKAZAKI
Contributors: