Profile

John Corigliano

Contact Details

My Content

1 to 20 of 37 total

RE: datalinq v11 folder with thousand .txt files

Posted By John Corigliano 06-25-2026 12:30
Found In Egroup: Graphics \ view thread
So, I tested with your file. In the Datalinq Server log window I get: ADODB DataLinq Source DataLinq1 Failed opening ADODB dataset. Check connection string, and check compatability settings in ADODB configuration. (Too many fields defined) Apparently, it doesn't like your file - the field limit is ...

RE: datalinq v11 folder with thousand .txt files

Posted By John Corigliano 06-25-2026 11:31
Found In Egroup: Graphics \ view thread
Strange. I guess a work-around would be to load the files in scripting and parse them manually 🤷‍♂️. Dim path As String = Dim lines As String() = System.IO.File.ReadAllLines(path) For Each line As String In Lines Dim columns As String() = line.Split("#") Next ------------------------------ ...

RE: datalinq v11 folder with thousand .txt files

Posted By John Corigliano 06-25-2026 08:53
Found In Egroup: Graphics \ view thread
Note that in my example, I am using the JET db engine and you are using ACE. Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ls210d39a\share\Shared Documents\;Extended Properties="text;HDR=Yes;FMT=Delimited"; This may be an issue because you have a 64-bit version of ACE installed whereas JET is 32 ...

RE: datalinq v11 folder with thousand .txt files

Posted By John Corigliano 06-24-2026 11:18
Found In Egroup: Graphics \ view thread
Must be a permissions issue. I was curious so I tried it and was able to get it to work fine. First, I setup an ADODB Datalinq as you described with this connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\ls210d39a\share\Shared Documents\;Extended Properties="text;HDR=Yes;FMT=Delimited"; ...

RE: Visual Logic for Position with accent marks

Posted By John Corigliano 05-05-2026 11:06
Found In Egroup: Graphics \ view thread
Looks like I posted an answer at the same time as Jeff Mayer (which was very similar) so I'll add a scripting answer instead: Dim hasAccents As Boolean = System.Text.RegularExpressions.Regex.IsMatch(Text, "[ÀÈÏÒÙ]", System.Text.RegularExpressions.RegexOptions.IgnoreCase) Scene.SetObjectPropertyStri ...

RE: Is there a way to check if a Scene is Online through Script?

Posted By John Corigliano 04-17-2026 13:30
Found In Egroup: Graphics \ view thread
By default, GetSceneByID gets a copy of the scene. Public Function GetSceneByID( _ ByVal ID As Long, _ ByRef Scene As xpScene, _ Optional ByVal AsCopy As Boolean = True _ ) As Boolean Set the third parameter to False to get the original. If you have multiple copies of the scene, you might need ...

RE: Xpression Grab Virtual Output

Posted By John Corigliano 04-15-2026 09:12
Found In Egroup: Graphics \ view thread
We run an FTP server (Filezilla works). In the Xpression, we have a RossLinq output set up with credentials for the FTP server. Whatever graphics you send to that output get saved as a .tga file on the FTP server. This way, you can get multiple scenes (on different layers) in one screen grab. ---- ...

RE: L3 with dynamic text length. Need Logo box on left to move on Xpos at text widens/thins

Posted By John Corigliano 11-10-2025 16:59
Found In Egroup: Graphics \ view thread
You can make the text left-justified and set its position to the right of the logo box. Set the pivot on the quad to be on the left so that as the text grows it grows to the right as does the quad. Then a simple Visual Logic can be used to keep everything centered. Also, set the AutoScale on the text. ...

RE: Text splitting

Posted By John Corigliano 08-11-2025 09:24
Found In Egroup: Graphics \ view thread
First, why is the first value expected to be "01", when it is "-1" in the string? I assume that's a typo. Also, I assume you want to do this with scripting and not Visual Logic. You can just use String.Split: Dim s as String = "-1/0/-1/15" Dim parts As String() = s.Split("/") Now the parts array ...

RE: Live sorting of a standings-table

Posted By John Corigliano 01-10-2025 09:17
Found In Egroup: Graphics \ view thread
I just did something like this. It's pretty easy. First, create Animation Controllers for each object you want to move. For simplicity, give them the same name as the group object you want to move. Each Animation Controller has 2 keyframes - one at the start and one at the end. You will also need text ...

RE: Always face the camera

Posted By John Corigliano 10-03-2024 10:39
Found In Egroup: Graphics \ view thread
Thanks. I didn't see that option. I will give it a try. ------------------------------ JohnCorigliano Senior Software Engineer ISC ------------------------------

Always face the camera

Posted By John Corigliano 10-01-2024 09:25
Found In Egroup: Graphics \ view thread
Is there an option or API function to have an object face the camera when using a Perspective Camera? I have a bunch of quads that I want to always face the camera, no matter where it is. For example, the quads are moving around in a circle while at the same time the camera is moving randomly about in ...

C# API - Set Script

Posted By John Corigliano 03-29-2023 08:01
Found In Egroup: Graphics \ view thread
Is it possible to set the scripting code of an object through the API? For example, set the OnSetText script code externally? ------------------------------ JohnCorigliano Senior Software Engineer ISC ------------------------------

RE: C# app wiht datalinq method for Xpression

Posted By John Corigliano 03-07-2023 07:37
Found In Egroup: Graphics \ view thread
async/await does not handle errors. It just lets your program to do stuff in the background, allowing the main program to keep going. It's probably not even necessary here since writing to a file should not take much time. If you want to handle errors, you need use exception handling. try ( Fi ...

RE: C# app wiht datalinq method for Xpression

Posted By John Corigliano 03-03-2023 10:26
Found In Egroup: Graphics \ view thread
We've been using this method for a few years now - except we write JSON files, not XML, but the principal is the same. We write to these files as often as once every 10 seconds (occasionally faster) and collisions with Datalinq reading the file as we are writing them are rare. In the event of a collision, ...

RE: Scene Object Deleted when calling Scene.Project.FontExistsByName from external API

Posted By John Corigliano 02-28-2023 08:32
Found In Egroup: Graphics \ view thread
There doesn't seem to be anything wrong with the code. The problem lies elsewhere. Possibly the project is reloaded or the scene was deleted invalidating your Scene object. FWIW, this snippet works fine for me (Xpression Developer v10.0). private void button2_Click(object sender, EventArgs e) ...

RE: Sort data?

Posted By John Corigliano 12-12-2022 10:45
Found In Egroup: Graphics \ view thread
Since the type of the array is Object, you need to cast to double before calling ToString. Change those 2 lines to: percent.Text = CDbl(data(i - 1)(1)).ToString("N1") & "%" percentch.Text = CDbl(data(i - 1)(2)).ToString("N1") & "%"​ ​ ------------------------------ JohnCorigliano Senior ...

RE: Sort data?

Posted By John Corigliano 12-06-2022 13:22
Found In Egroup: Graphics \ view thread
Things get trickier when sorting data with multiple fields. I would put the data in an array of 3 items. Then put those arrays into a List. You will need to create a custom sorter function. Since Xpression doesn't seem to support Linq or lambda expressions, put this in your global script: Function ...

RE: Read Folder List in Dashboard

Posted By John Corigliano 11-21-2022 10:20
Found In Egroup: Facility Control \ view thread
Thanks. Works great except I had to add the protocol: var files = ogscript.post("file:/D:/Clients/UserGraphics", null).split('\n'); ------------------------------ JohnCorigliano Senior Software Engineer ISC ------------------------------

Read Folder List in Dashboard

Posted By John Corigliano 11-18-2022 09:41
Found In Egroup: Facility Control \ view thread
Is it possible to have Dashboard read a list of files from a folder? For example, we give the clients a folder then can add their homemade graphics to and then let them choose a graphic to put on air (Xpression) from Dashboard. We currently have a work around using custom software that watches a folder ...