Version 5 (modified by 15 years ago) (diff) | ,
---|
This VBA class module is MS-Office connector via XML-RPC.
Description
There are following samples.
- MS-Excel Ticket editor
- 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 [download:visualbasictracconnectorintegration here].
Source
You can check out VisualBasicTracConnectorIntegration from here using Subversion, or browse the source with Trac.
Example
MS-Excel Ticket editor
- fill setting sheet
- Create sheets that are same name as project names
- Push "Import tickets" button
- Edit imported tickets' fields
- Add new tickets
- Push "Check modified fields" button
- Confirm the edited fields' background color are changed.
- Push "Update" button
- According to the WEB browser, modified tickets' fields are changed
MS-Project connector
- 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 blicking 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 depencencies (dependency) Optional, for TracDependencyPlugin custom baseline_start BaselineStart Optional custom baseline_finish BaselineFinish Optional
- Push "Import" button
- input settings for your environment, then push "Validation" button
- If connection is valid, then enable "Import" button. Push this button
Recent Changes
Author/Contributors
Author: okazaki
Contributors:
Attachments (19)
- prj01.png (116.6 KB) - added by 15 years ago.
- prj00.png (74.7 KB) - added by 15 years ago.
- VBAExcel01.png (49.5 KB) - added by 15 years ago.
- VBAExcel02.png (46.6 KB) - added by 15 years ago.
- VBAExcel03.png (49.7 KB) - added by 15 years ago.
- VBAExcel04.png (50.2 KB) - added by 15 years ago.
- VBAExcel05.png (51.8 KB) - added by 15 years ago.
- VBAExcel06.png (49.7 KB) - added by 15 years ago.
- VBAExcel07.png (52.8 KB) - added by 15 years ago.
- VBAExcel08.png (52.8 KB) - added by 15 years ago.
- VBAExcel09.png (48.8 KB) - added by 15 years ago.
- VBAPrj01.png (44.7 KB) - added by 15 years ago.
- VBAPrj02.png (6.0 KB) - added by 15 years ago.
- VBAPrj03.png (6.0 KB) - added by 15 years ago.
- VBAPrj04.png (58.7 KB) - added by 15 years ago.
- VBAPrj001.png (249.0 KB) - added by 15 years ago.
- VBAPrj002.png (295.4 KB) - added by 15 years ago.
- VBAPrj003.png (224.1 KB) - added by 15 years ago.
- VBAPrj004.png (223.7 KB) - added by 15 years ago.
Download all attachments as: .zip