Aaah I see. Thanks for explaining. I am currently working on Studio v10.5 build 5508 same goes for the datalinq server. And no project server is in use.
Original Message:
Sent: 01-14-2025 17:46
From: Azathoth Son of Cthulhu
Subject: Texts with datalinqs flicker when saving excel file
Yes, I understand. What might be happening is upon save the datalinq server might be sending blanks upon save when the file is locked by the OS. A Ross person would know for sure.
What I suggested would theoretically work because you would never display blank/whitespace data.
What version of Xpression and project server are you dealing with? This will help a Ross employee know if you are dealing with an old or new bug.
------------------------------
Azathoth
Son of Cthulhu
Original Message:
Sent: 01-14-2025 17:31
From: Johannes Pedri
Subject: Texts with datalinqs flicker when saving excel file
Unfortunatly I'm not that deep into scripting yet so I can't judge what exactly that script does, but I also think I did not explain my problem properly.
Let's for example say I have an excel sheet in which cell1 contains a teamname and cell2 contains a talent name. If I now go ahead and change the talents name in cell2, save and then look at the onair graphics that has textfields displaying both the Teamname that has not changed aswell as the talent name that did change, both will flicker regardless of if I changed the content of the cell or if it was empty beforehand. So bascially if I spam crtl+s in the excel sheet, I can make all data displayed on screen flicker even when it did not change. It will just disappear for a second and then reappear as the same or updated data depending on if I made a change or not. So it looks to me like the datalinq clears all it's data and then load everything again.
------------------------------
Best wishes,
Johannes
Original Message:
Sent: 01-14-2025 17:05
From: Azathoth Son of Cthulhu
Subject: Texts with datalinqs flicker when saving excel file
Replace the white space.
Here is a global VB function I use for replacing:
Function RegExpReplace(src as String, rgx as String, rplc as String) Dim rObj as Object Dim rez as String rObj = CreateObject("VBScript.RegExp") rObj.Pattern = rgx rObj.Global = True rez = rObj.Replace(src,rplc) RegExpReplace = rezEnd Function
Now you attach a script to the datalinqed field.
newText = RegExpReplace(linqField.Text, "\s", "")If Len(newText) > 0 Then displayField.Text = linqField.TextEnd If
Of course youneed to declare the objects and find them. Plus the datalinqed field does have a self reference and the incoming text. Forgot what they are. Perhaps someone can cleanup the second script. I just can't hop onto Xpression right now.
------------------------------
Azathoth
Son of Cthulhu
Original Message:
Sent: 01-14-2025 16:49
From: Johannes Pedri
Subject: Texts with datalinqs flicker when saving excel file
I don't think I can fully follow what you're suggesting. Also I had this happen when I swapped the content of the textfield to another text. So the text disappears for a splitsecond and then the new text popps up. The text plopping in and out of existance also happens to textfields that are not touched, so for example if I change the contents of cell1 in excel and save, both cell1 text and cell2 text will flicker, even tho I didn't change cell2s content.
------------------------------
Best wishes,
Johannes
Original Message:
Sent: 01-14-2025 16:41
From: Azathoth Son of Cthulhu
Subject: Texts with datalinqs flicker when saving excel file
The last line:
However, before the text is copied, make sure it is not an empty string.
If it's empty, don't copy it.
You might have to implement regex and replace against whitespaces to make sure a textfield doesn't get filled with whitespaces only.
------------------------------
Azathoth
Son of Cthulhu
Original Message:
Sent: 01-14-2025 16:23
From: Johannes Pedri
Subject: Texts with datalinqs flicker when saving excel file
I think I could get this to work with logos and such, but I can't imagine this being the simplest solution. Also I'm not certain if this would fix the problem I'm having. What I understand for your solution is to basically create a "buffer" for the data to be fill and then load into the textfields that display it. But once the datalinq unloaded all the data, it will also fill the buffer with that empty state thus flicker again or am I missing something?
------------------------------
Best wishes,
Johannes
Original Message:
Sent: 01-14-2025 16:11
From: Azathoth Son of Cthulhu
Subject: Texts with datalinqs flicker when saving excel file
Without having experienced it and trying a simple solution, I have a complicated one.
Make the textfields that are linked to the data invisible and they copy their data to a display when the data changes. However, before the text is copied, make sure it is not an empty string.
------------------------------
Azathoth
Son of Cthulhu
Original Message:
Sent: 01-14-2025 15:49
From: Johannes Pedri
Subject: Texts with datalinqs flicker when saving excel file
I think the title says it all. Sometimes when I save the excel that fills the graphics with stats and logos, before updating everything disappears off screen and then plopps back into existence.
Any help with this would be highly appreciated.
------------------------------
Best wishes,
Johannes
------------------------------