Graphics

 View Only

  • 1.  Visual Logic and Datalinq

    Posted 09-06-2023 12:05
      |   view attached

    Hello, i seem to be a little loss on a visual logic task i am trying to accomplish. I have a text element in my scene that i want to have the data pulled from a spreadsheet. In the spreadsheet i want it to pull the data in the "Exit Code" column based on the date. The spreadsheet has a different exit code per date. I have attached the spreadsheet. but there is a column that has the date and a column with the exit code. id like it to pull the exit code date when the date of the computer matches the date in the column. Id prefer to make this fully automatic so the operator does not have to input anything, if possible. Note our unit is a Xpression Prime and can not do scripting.



    ------------------------------
    Chad Loury
    AZUSA PACIFIC UNIVERSITY
    ------------------------------

    Attachment(s)

    xls
    Chapel Exit Codes Fall 2023.xls   29 KB 1 version


  • 2.  RE: Visual Logic and Datalinq

    Posted 09-07-2023 12:25
      |   view attached

    Hi Chad,

    Visual Logic does not have a way to loop through a bunch of cells in a database, so this has to be set up manually.  If you look at the attached scene you will see that I have used a String Compare for 50 DataLinq cells in the spreadsheet you provided.  I am them multiplying each result by the next highest number (1, 2, 3, 4, 5, 6, and so on) to give me a unique number for each positive result.  Finally, I am adding the product of these together to give me a number I can pass into an Input Selector that has each of the Exit Codes in the order of the Dates.  So, when the dates match the correct Exit Code is passed through.

    Give the attached scene a look and feel free to reach out if you have questions.

    robert.mann@rossvideo.com

    Cheers,

    Rob



    ------------------------------
    Rob Blank
    Ross Video
    ------------------------------

    Attachment(s)

    xpp
    AZUSA.xpp   541 KB 1 version


  • 3.  RE: Visual Logic and Datalinq

    Posted 09-11-2023 04:55

    Make a text object for the date and then connect that to a date widget. 

    When you connect to datalink just use a query for the connection that looks at that text object. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 4.  RE: Visual Logic and Datalinq

    Posted 09-11-2023 13:54
      |   view attached

    Thank you, this is what i was looking for. yet im still struggling with my outcome. Here is my querey and yet not sure what i have wrong.

    screenshot


    ------------------------------
    Chad Loury
    AZUSA PACIFIC UNIVERSITY
    ------------------------------

    Original Message


  • 5.  RE: Visual Logic and Datalinq

    Posted 09-11-2023 14:27

    You don't need visual logic, you can just do what you need directly on the text object under the data tab and just click datalinq. 

    You probably need quotes like in my example around @textobject@ because date will be a string not an integer. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------

    Original Message


  • 6.  RE: Visual Logic and Datalinq

    Posted 09-12-2023 13:51

    So i seem to still be strugggling. sorry. thank you for the help.  here is my query in the table line:

    SELECT [Code] FROM [Exit_Code_List] WHERE [Date] = "@DATEHERE@"

    in the spreadsheet the columns are"Code"and"Date"

    currently i have the DATEHERE text object visible in the scene for reference the date is showing correctly. It shows 9/11/2023 and the sheet has a date of 9/11/2023 but the code for that date is not reflecting.

    screenshot


    ------------------------------
    Chad Loury
    AZUSA PACIFIC UNIVERSITY
    ------------------------------

    Original Message


  • 7.  RE: Visual Logic and Datalinq

    Posted 09-14-2023 10:28

    have you tested by putting in a data you know is the the data rather than the macro? 

    That may point you to other issues. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------

    Original Message