Heretic Programmer(2007-05-19)

2007-05-19

＠ [Trac]VBAからチケットの操作

TracのXMLRPCプラグインとPocketXMLRPCを利用すると、VBAからチケットの操作が可能になる。例えば、チケットを取得してみよう。

set factory = CreateObject("pocketXMLRPC.Factory")
set proxy = factory.Proxy("http://127.0.0.1/trac/SampleProject/xmlrpc", "ticket.")
ticket = proxy.get(1)    'id 1のチケットをXMLRPC経由で取得
 
' チケットの各情報を取得
createDate = DateAdd("s", ticket(1), #1/1/1970#)
modifiedDate = DateAdd("s", ticket(2), #1/1/1970#)
status = ticket(3).status
summary = ticket(3).summary
...

うまくやれば、ExcelやMS Project上のスケジュールとTracのチケットを同期させることができる。

本日のツッコミ(全52件) [ツッコミを入れる]

# captain (2007-06-17 03:51)

xR5Ca6Ap86cZ9pv Diet Drug Phentermine http://christ77.power-emergency.com

# Duran Duran (2007-07-10 06:37)

sale@mp3.com

# Rihanna (2007-07-10 08:30)

sale@mp3.com

# Lionel Richie (2007-07-10 12:45)

sale@mp3.com

# Il Divo (2007-07-10 14:24)

sale@mp3.com

# Phil Collins (2007-07-10 17:46)

sale@mp3.com

# Alice Cooper (2007-07-10 19:31)

sale@mp3.com

# 50 Cent (2007-07-10 21:21)

sale@mp3.com

# Wolfgang Amadeus Mozart (2007-07-10 23:54)

sale@mp3.com

# viagra prescription (2007-07-12 23:18)

cheap@viagra.com

# viagra generic (2007-07-13 01:02)

cheap@viagra.com

# viagra discount (2007-07-13 02:54)

cheap@viagra.com

# buy cialis (2007-07-13 04:07)

cheap@cialis.com

# cheap cialis (2007-07-13 07:42)

cheap@cialis.com

# cialis generic (2007-07-13 16:54)

cheap@cialis.com

# cheap levitra (2007-07-13 23:28)

cheap@levitra.com

# generic levitra (2007-07-14 03:10)

cheap@levitra.com

# buy viagra (2007-07-14 08:57)

cheap@viagra.com

# discount viagra (2007-07-14 17:03)

cheap@viagra.com

# buy generic viagra (2007-07-15 01:03)

cheap@viagra.com

# purchase viagra (2007-07-15 02:58)

cheap@viagra.com

# order online viagra (2007-07-15 05:53)

cheap@viagra.com

# online viagra (2007-07-15 07:35)

cheap@viagra.com

# pharmacy viagra (2007-07-15 09:47)

cheap@viagra.com

# order levitra (2007-07-16 09:32)

cheap@levitra.com

# generic viagra (2007-07-16 15:36)

cheap@viagra.com

# buy cheap viagra (2007-07-17 04:37)

cheap@viagra.com

# buy viagra generic (2007-07-17 06:10)

cheap@viagra.com

# cheap viagra uk (2007-07-17 07:50)

cheap@viagra.com

# prescription viagra (2007-07-17 09:51)

cheap@viagra.com

# generic cialis (2007-07-17 17:32)

cheap@cialis.com

# cialis discount (2007-07-17 21:07)

cheap@cialis.com

# cialis cheap (2007-07-17 23:16)

cheap@cialis.com

# cialis soft (2007-07-18 00:49)

cheap@cialis.com

# cheapest cialis (2007-07-18 02:40)

cheap@cialis.com

# discount cialis (2007-07-18 04:31)

cheap@cialis.com

# buy levitra (2007-07-18 06:53)

cheap@levitra.com

# cheap viagra (2007-07-18 20:01)

cheap@viagra.com

# viagra price (2007-07-19 00:55)

cheap@viagra.com

# viagra pharmacy (2007-07-20 19:27)

cheap@viagra.com

# viagra cheap (2007-07-23 00:10)

cheap@viagra.com

# buy viagra (2007-07-28 06:56)

cheap@viagra.com

# generic viagra (2007-07-28 09:14)

cheap@giag.com

# buy online cialis (2007-07-29 12:54)

cheap@cialis.com

# buy cialis (2007-08-14 14:27)

cheap@viagra.com

# purchase cialis (2007-08-16 18:48)

cheap@cialis.com

# viagra uk (2007-08-19 17:11)

cheap@viagra.com

# cialis soft tab (2007-08-20 09:57)

cheap@cialis.com

# wpslr yoaptfcxj (2007-09-04 23:20)

cqaetdy dqoabxkmw bezi yfutcba xqvcyb gfep kjclfd

# xioctf snrp (2007-09-04 23:21)

elnpb pqmjl trehjol ntrjpzaeb ugrsfkt ojgapdik ygsof http://www.btgyrqf.uqtxmbod.com

# Eagles (2007-09-22 08:02)

sale@mp3.com

# HsvsRsvsesv (2008-01-23 05:29)

[URL=http://mh-medicine.blogspot.com]men's helth[/URL]

[]