I am rather new with XCelsius and I’m trying to upgrade an existing XCelsius file made in XCelsius 4.5 to 2008.
I have a list of web services that are triggered on cell value change and others on “Refresh on Load”.
The swf that is compiled doesn’t work. After having tried to debug for some time now, I noticed that the Web Service trigger doesn’t work for 2 of them. That blocks the other web services as they are tied in a sort of chain of triggers.
Has anyone encountered this problem or know how to solve it?
FYI : I have tried many possible manners to link the trigger cell to the web service. The value of the cell does change, it just doesn’t trigger the web service. Additionally, the web service works, because if I put it on “Refresh on load”, I see that it performs the right action and I have trigger chain working.
Trying to rebuild from scratch leads to the same result, I can’t seem to trigger the web service with the cell value change nor with the option “when value equals”.
I am facing the similar situation but with Live Office as my middleware. I am loading this data from a webi report. It loads fine as long as I choose “Refresh on Load” but it takes a long time to load. I was loading first connection as “refresh on load” and then linking other connections with each other using trigger technique so they can be run sequentialy. Please let me know how you were able to solve this and what kind of trigger technique you are using. I would really appreciate your help.
Horntail, one option would be to set your first webservice to refresh every x seconds (instead of on load), then set the other web service triggers on this change.
Its not the optimal solution as you will run a query on a specified frequency, but it will help trigger the other web services post load.
I’ve already put in a request to the xcelsius product group to add a refresh after x seconds (instead of refresh every).
My problem is that I have to trigger them by cell value change, as my first web service gets me the server name and the URL used for the other ones(as I have different server options), and thus it puts them in cells whose value change should trigger the other web services.
So I can’t really use a refresh on load.
I just can’t understand why they are not triggered if they work as they normally should. I mean if I connect them to a connection refresh button, then if I click it I get the normal http flow and I have the correct response.
I’ve tried that, it doesn’t work.
I suppose that is because the cell value doesn’t change afterwards. It changes only the first time because it goes from NULL to the url of the server to be used afterwards.
So that’s why I suppose there’s a bug with XCelsius 2008 concerning the cell triggering etc.
Thanks Citrix32, I got it to work . Instead of setting my first live office connection, which is a bit large, to load every x seconds, I created a seperate connection that pulls in a three row column with values of A,B,C. It takes a fraction of a second to load and in all my other connections I have made use of “when value becomes” option, this way load performance has increased significantly.
Throw in a Connection Refresh button and bind the relevant queries. Make sure that you select refresh on load in the behaviour tab of the Connection Refresh button.
. Instead of setting my first live office connection, which is a bit large, to load every x seconds, I created a seperate connection that pulls in a three row column with values of A,B,C. It takes a fraction of a second to load and in all my other connections I have made use of “when value becomes” option, this way load performance has increased significantly.
(BOB member since 2008-07-18)