Add work time from API

Hi!
I have separate time keeping software that I developed and allows me to enter time on my phone and sync directly to my database, report on it and export to accounting to generate invoices. The only missing link is with RT’s tickets.

When I export and bill time at the end of the week, I’d also like to export my comments to the RT ticket that’s related to the time record. I figured out how to create the comment record, but since I’m doing this days after the event occurred, the ever is for the date that I export. I’d like to back date my entries into RT to be the same date and time as my time record. Is there a way to do this with the API, or should I just insert into postgresql directly? Anyone else doing anything similar, or have a better idea?

Thanks!
Steve

Hi Steve,

Hi!
I have separate time keeping software that I developed and allows me to enter time on my phone and sync directly to my database, report on it and export to accounting to generate invoices. The only missing link is with RT’s tickets.

When I export and bill time at the end of the week, I’d also like to export my comments to the RT ticket that’s related to the time record. I figured out how to create the comment record, but since I’m doing this days after the event occurred, the ever is for the date that I export. I’d like to back date my entries into RT to be the same date and time as my time record. Is there a way to do this with the API, or should I just insert into postgresql directly? Anyone else doing anything similar, or have a better idea?

Have you seen our relatively new RT::Extension::TimeTracking extension? RT::Extension::TimeTracking - Time Tracking Extension - metacpan.org https://metacpan.org/pod/RT::Extension::TimeTracking

Among other things, this extension lets you backdate time worked (which is guarded using permissions on the “Worked Date” custom field that the extension provides).

Thanks!
Steve

Thanks,
Shawn

signature.asc (801 Bytes)

Can’t say that I have. It looks pretty good, thank you.

2 things I’d like to know before I install it:

* Can I type notes with each entry?
* Can I make entries via an API?

Thank you!

Best regards,

STEPHEN H. SWITZER
VOICE: 585.298.9420 [ x7001 ]
CELL: 585.202.8312
FAX: 585.625.0020
EMAIL: steve@sbsroc.com
Technical Consultant & System Engineer

  • VMware VSP
  • Microsoft MCP, Desktop/Server

SWITZER BUSINESS SOLUTIONS, LLC

WEB: www.SwitzerBusiness.Solutions [1]
FB: Switzer Business Solutions [2]

  • VMware VIP Partner
  • HP Authorized Business Development Partner
  • Xorcom Certified DealerOn 2016-09-15 1:43 pm, Shawn M Moore wrote:

Hi Steve,

On Sep 15, 2016, at 12:36, steve@sbsroc.com wrote:

Hi!
I have separate time keeping software that I developed and allows me to enter time on my phone and sync directly to my database, report on it and export to accounting to generate invoices. The only missing link is with RT’s tickets.

When I export and bill time at the end of the week, I’d also like to export my comments to the RT ticket that’s related to the time record. I figured out how to create the comment record, but since I’m doing this days after the event occurred, the ever is for the date that I export. I’d like to back date my entries into RT to be the same date and time as my time record. Is there a way to do this with the API, or should I just insert into postgresql directly? Anyone else doing anything similar, or have a better idea?

Have you seen our relatively new RT::Extension::TimeTracking extension? RT::Extension::TimeTracking - Time Tracking Extension - metacpan.org

Among other things, this extension lets you backdate time worked (which is guarded using permissions on the “Worked Date” custom field that the extension provides).

Thanks!
Steve

Thanks,
Shawn

Links:
[1] http://www.switzerbusinesssolutions.com/
[2] Switzer Business Solutions