Can a field automatically update based on a value in a local Excel file

shawn urquhart (1●2●2) | asked Nov 18 '13, 7:24 p.m.

Hi Jazz Team

Been looking for some way I can have a field in RTC automatically update based on a stored value in a local Excel file. Seems a simple task and helpful to have that functionality.

Comments

sam detweiler commented Nov 18 '13, 8:04 p.m. | edited Nov 18 '13, 8:05 p.m.

Local to who? Server, eclipse, web?

You could write a jruby script

shawn urquhart commented Nov 18 '13, 8:37 p.m.

Sam.

Thanks for your interest.

I would like to be able to load a field based on a value already calculated locally (local server) and exists in a particular cell in an Excel file.

sam detweiler commented Nov 18 '13, 9:34 p.m.

You will have to write a participant in Java, install it on the server, and of course have read access to the file.

If I were admin of this system I would reject anything like this.

shawn urquhart commented Nov 18 '13, 9:36 p.m.

Thanks for the advice. Just looking for a cheap way of aligning two systems with little associated risk.

sam detweiler commented Nov 18 '13, 10:09 p.m.

Nothing easy on this one, other than creating batch tools to do the updates from a client.

One answer

Most liked answers ↓|Newest answers|Oldest answers

0	permanent link N Z (362●21●26) \| answered Nov 19 '13, 12:29 a.m. I also wouldn't be too keen on this. In principle, it should be straightforward, unfortunately, it's in RTC, it's not as easy as it should be.

It's all about the answers!

Related questions

Can a field automatically update based on a value in a local Excel file

One answer

Your answer