Profile

Nathan S.

Contact Details

My Content

1 to 20 of 47 total

non-ascii characters in datalinq

Posted By Nathan S 03-01-2024 09:28
Found In Egroup: Graphics \ view thread
I have a project using ADODB Datalinq sources, where the provider is Microsoft. ACE.OLEDB.12.0 and the datasource is an Excel .xlsx spreadsheet. Each row in the spreadsheet is used to populate the fields of graphics that are then dynamically formatted using VBA script. Typically we copy and paste into ...

Changing Material/Texture URL based on Datalinq

Posted By Nathan S 05-09-2022 12:03
Found In Egroup: Graphics \ view thread
I am looking to change the texture of a material on a quad based on a value from a datalinq. I have a list of names and I'd like to change an image based on those names. The datalinq does not include a filepath for those images. For Example: If I have "JOHNSMITH" as the value from my Datalinq, then ...

RE: Formatting Excel Data for Election

Posted By Nathan S 05-09-2022 11:57
Found In Egroup: Production Workflow \ view thread
I can answer your first question. I put the following code in the OnSetText tab of every text object that needs commas: text=FormatNumber(Text, 0) ------------------------------ Nathan S. ------------------------------

SQL Sort Not Sorting Properly

Posted By Nathan S 10-11-2021 10:45
Found In Egroup: Graphics \ view thread
Please help me sort these using SQL. Column one is the numbers without commas. Column two is a second datalinq with a copy of the data with commas in the numbers. Neither is sorted corrected. Note that in both cases the largest number is at the bottom, when it should be at the top, and 1234 and ...

RE: SQL Query Sort using csv (no/unamed table?)

Posted By Nathan S 09-02-2021 13:16
Found In Egroup: Graphics \ view thread
Thanks, Brian! After some quick tests, I think I'll be able to get this to work. For anyone else trying to do this, I will summarize: The key to making this work is to make sure that you: 1) Have a folder that contains your CSV file, and 2) The datalinq must be configured as so: Provider=Mi ...

RE: SQL Query Sort using csv (no/unamed table?)

Posted By Nathan S 07-14-2021 15:42
Found In Egroup: Graphics \ view thread
Digging around on the forums, it seems that SQL queries only work with ADODB sources. Is this correct? On that track, I opened the csv file in excel and exported it as an .xlsx file, which I used with an ADODB datalinq. This was fine, but I had no table to select in expression so I resorted to creating ...

RE: SQL Query Sort using csv (no/unamed table?)

Posted By Nathan S 07-14-2021 14:19
Found In Egroup: Graphics \ view thread
Shoot! I did a bad job testing this. Turns it it ISN'T working. My table just happened to already be sorted. Could someone please help! ------------------------------ Nathan S. ------------------------------

RE: SQL Query Sort using csv (no/unamed table?)

Posted By Nathan S 07-14-2021 10:30
Found In Egroup: Graphics \ view thread
Solved my own question. In my case the file is saved as CandidateInfo.txt, so it looks like I was able to reference the table by the file name without extension. SELECT * FROM CandidateInfo ORDER BY Votes DESC Let me know if there is a better way to do this, thanks! Edit: This isn't working. ...

SQL Query Sort using csv (no/unamed table?)

Posted By Nathan S 07-14-2021 10:12
Found In Egroup: Graphics \ view thread
Using SQL Queries to Automatically Order External Data Dynamically | Ross Video Hi, I found the preceding video and was hoping to use it as a guide to pre sort some data for graphics. My datalinq is looking at a .txt formatted CSV file with a header row. I hope this is something simple, but I don't ...

Multiple Projects, One Sequence

Posted By Nathan S 01-20-2020 14:11
Found In Egroup: Graphics \ view thread
I would like to be able to have multiple projects in a project group with each representing a different graphics package to display the same information. How can I make each project use the same sequence, so that when a user has one project open the sequence loads one set of graphics, and when they another ...

RE: Make Text with line break fit in set bounding box

Posted By Nathan S 01-20-2020 14:09
Found In Egroup: Graphics \ view thread
Does Trim() remove line breaks? If it does, you could try either setting the text fields to trim(text) in event script, or you could make your actual database trim the entries somehow. #XPression

RE: if Text1=1 then change Text2 text font

Posted By Nathan S 01-20-2020 14:05
Found In Egroup: Graphics \ view thread
Try this? Dim temp as string = "nothing" If Text1.text = "1" then Text2.CurrentFont = NewFont temp = Text2.text Text2.text = "" & temp End If #XPression

RE: Line wrap with limits and auto width control

Posted By Nathan S 01-15-2020 16:38
Found In Egroup: Graphics \ view thread
I hope someone else can help you. I am not a programmer by any stretch and I gave up on using visual logic for basically anything very early on. It's just very clunky/buggy to me. #XPression

RE: Event Script Triggers On Export - Resolved

Posted By Nathan S 01-15-2020 13:18
Found In Egroup: Graphics \ view thread
Hey Steve, Thanks for taking the time to walk me through this. I was able to get that working. You saved me a ton of time clicking boxes in the future! #XPression

RE: Line wrap with limits and auto width control

Posted By Nathan S 01-14-2020 18:02
Found In Egroup: Graphics \ view thread
I've been struggling with the same thing on and off, myself. You can enable Word Wrap with "textobject.WordWrap = true", and "textObject.WordWrapWidth = x" You can control the thing with cases based on "textobject.LineCount" My code is a mess at the moment, but hopefully that will get ...

RE: Event Script Triggers On Export - Resolved

Posted By Nathan S 01-08-2020 00:42
Found In Egroup: Graphics \ view thread
Thanks Steve. I have a few thousand items in my sequence at this point, but I guess that option works if it's not ideal. I'm on 9.0, and I don't think I'm following your suggestion for #2. I don't understand how to set the play range for a selection of items in the sequencer. #XPression

Fast Recall Speed/Setting

Posted By Nathan S 01-07-2020 21:53
Found In Egroup: Graphics \ view thread
Is there a way to make the Fast Recall have a longer input window? Edit: If anyone else had the same trouble, I found an option in preferences to make it wait for take: Disable Fast Recall Input Timeout — select this check box to turn off the user entered input timeout for Take IDs in the ...

RE: Event Script Triggers On Export - Resolved

Posted By Nathan S 01-07-2020 20:37
Found In Egroup: Graphics \ view thread
Thanks Brian, this makes sense. I have two more questions about exporting images. 1) Is it possible to have the file names be based on the content of the sequence item rather than the name. The default graphic name is identical to the scene - so it took me a sec to realize my exports were overwriting ...

Event Script Triggers On Export - Resolved

Posted By Nathan S 01-03-2020 21:28
Found In Egroup: Graphics \ view thread
I want to export graphics from my sequence to PNG. Currently, when I export my graphics none of the OnEvent scripts that I use to position my text fire. Is this is as simple as copying/moving my scripts to a new trigger? Do I need to do something else? I'm trying to avoid making my code any messier ...

RE: Scene Director, Hotkeys, Fade In/Out - Solved

Posted By Nathan S 12-26-2019 16:59
Found In Egroup: Graphics \ view thread
Thanks Malcolm. I'm just a button-pusher in way over his head, and I don't think we're going to use/get dashboard here. To clarify my original question, the "clear" hotkeys/shortcuts do not take things offline by default, they just clear them - so the transition doesn't happen as it does when you ...