wiki:VisualBasicTracConnectorIntegration

Version 13 (modified by Chris.Nelson@…, 4 years ago) (diff)

Refix my fix to a typo

This VBA class module is MS-Office connector via XML-RPC.

Description

There are following samples.

  1. MS-Excel Ticket editor
  2. MS-Project connector.

Bugs/Feature Requests

Existing bugs and feature requests for VisualBasicTracConnectorIntegration are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

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

Example

MS-Excel Ticket editor

  1. fill setting sheet
  1. Create sheets that are same name as project names
  1. Push "Import tickets" button
  1. Edit imported tickets' fields
  1. Add new tickets
  1. Push "Check modified fields" button
  1. Confirm the edited fields' background color are changed.
  1. Push "Update" button
  1. According to the browser, modified tickets' fields are changed

MS-Project connector

  1. Add custom fields.
type name MS-Project's field
customdue_assign Start required
customdue_closeFinish required
customcompletePercentComplete required
customblocking(dependency) add blocking ticket
standardsummary name
standardowner resource
standardmilestone (dependency) Add preceding task for the milestone
standardversion (dependency) Add preceding task for the mversion
customsummary_ticket(summary task) Optional, for TracDependencyPlugin
customdepencencies(dependency) Optional, for TracDependencyPlugin
custombaseline_startBaselineStart Optional
custombaseline_finishBaselineFinish Optional
  1. create tickets.
  2. Open TracProject.mpp
  1. Create blank mpp file.
  1. (Activate created mpp file.) It might be activated.
  2. Push "Import" button
  1. input settings for your environment, then push "Validation" button
  1. If connection is valid, then enable "Import" button. Push this button

Recent Changes

[7838] by okazaki on 2010-04-11 20:10:50
refs #6929
[7837] by okazaki on 2010-04-11 18:10:21
refs #6961
[7836] by okazaki on 2010-04-11 17:17:18
refs #6958
Validation list length limitation is added to selectable fields.

Author/Contributors

Author: okazaki
Contributors:

Attachments (19)

Download all attachments as: .zip