Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
shawn urquhart
(1●2●2) 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.

0 votes

Comments
sam detweiler
Nov 18 '13, 8:05 p.m.
Local to who?  Server, eclipse, web?  You could write a jruby script

shawn urquhart
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
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
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
Nov 18 '13, 10:09 p.m.
Nothing easy on this one, other than creating batch tools to do the updates from a client. 

1 answer
5,803 views
0 votes

One answer

Permanent link
N Z
(362●1●21●27) 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.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144

Question asked: Nov 18 '13, 7:24 p.m.

Question was seen: 5,803 times

Last updated: Nov 19 '13, 12:29 a.m.

Confirmation Cancel Confirm