Graphics

 View Only
  • 1.  Datalinq Excel update

    Posted 24 days ago

    Hi Dears, 

    now when i use text fill attach to datalinq when ever i update any data in text file and hit Ctrl+S its update on-air directly 

    but

    when i use excel when i update any data i have to save and close excel and take scene offline then online again to see the update 

    is there is a way to make excel update direct ??

    i use excel v2016 

    and mark Live update in data linq option 

     



    ------------------------------
    TAMER ABDELAZIZ
    ONTV
    CAIRO Egypt
    ------------------------------


  • 2.  RE: Datalinq Excel update

    Posted 24 days ago

    Xpression DataLinq Server version problem?

    We are on 11 for DataLing but 9.5 for Xpression.

    The user before me told everyone when you updated excel spreadsheet you needed to restart the server. You don't. When a spreadsheet is updated the queries reflect the change. This might be something that had to be done with versions less than 11? He carried out this policy because he didn't know it no longer required a restart?

    Is this a version centric problem?



    ------------------------------
    Azathoth
    Son of Cthulhu
    ------------------------------



  • 3.  RE: Datalinq Excel update

    Ross Staff
    Posted 24 days ago

    Please post screenshots of your Datalinq configuration for the excel sheet.

    Also, is your Excel workbook shared? 




  • 4.  RE: Datalinq Excel update

    Posted 24 days ago
    i upload the screenshots for datalinq 
    i dont know if it shared or no but i read all data from Excel 
    can i know how workbook shared


    ------------------------------
    TAMER ABDELAZIZ
    ONTV
    CAIRO Egypt
    ------------------------------



  • 5.  RE: Datalinq Excel update

    Posted 23 days ago
      |   view attached

    I've had this issue too. Sharing the Excel Spreadsheet solved it for me.

    You can find this solution by searching google for "Share Excel Spreadsheet"

    Select "Review" tab then click the "Share Workbook" icon on right side of ribbon. Then select check mark, to share with all users, option in the popup window.

    I attached an image found on google, that shows exactly what I did to solve my issue. Hope this helps you.

    Cheers



    ------------------------------
    Steve Szeszycki
    XPresssion Operator
    Los Angeles United States
    ------------------------------



  • 6.  RE: Datalinq Excel update

    Posted 22 days ago

    Just to add to this, if you are using newer versions of Exce, for this sharing menu you will need to to File > Options > Quick Access Toolbar and under "Choose commands from", switch the dropdown to All Commands and then look for Share Workbook (Legacy)



    ------------------------------
    Carlito Chippy
    ------------------------------



  • 7.  RE: Datalinq Excel update

    Ross Staff
    Posted 21 days ago

    Tamer,

    Try setting the Refresh Every: option to 1 Second under the Connection tab in the Datalinq source configuration.



    ------------------------------
    Jeff Mayer
    Ross Video
    ------------------------------