Graphics

 View Only
Back to discussions
Expand all | Collapse all

Datalinq Controlled Crawl

  • 1.  Datalinq Controlled Crawl

    Posted 01-16-2015 15:54
    This is my first dive into making a crawl, so I will apologize in advance of not knowing that feature, pretty much at all.

    We're doing a telethon soon, and will need a continuous crawl on-screen showing donors, amounts, and probably a total amount, as well. I'm going to have an Excel sheet, possibly an xml instead. Either way, the goal is the same.

    My crawl needs to include all data entered into the xml, but I don't know how much it will be at any given point. When we start it might only be 10-20 entries, but by the end of the telethon, there could be several hundred. How do I go about building a crawl that will grow with Datalinq'd information?


  • 2.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 04:24
    Dan,

    The datalinq can loop over an unknown number of rows in the datasource and it will just loop around when it reaches the end..

    Create a scene group, set it to Crawl mode and looping. Turn up the global left/right margins a bit to provide some spacing between each crawl scene.

    Add your text object and configure the datalinq to point to a datalinq element. If using something like a text file or Excel/Adodb you would set the Row element to `""`. Leave the "N Increment" set to 0.

    Now duplicate that child scene several times (you need at least as many as might be onscreen at one time.. 5 to 10 should be plenty).. Now in each scene edit the datalinq object and change `` to ``, `` etc for each scene.

    When you play it back XPression automatically increments the `` value to loop over the datasource regardless of how many rows there are.

    #XPression


  • 3.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 19:36
    Thank you Brian. This looks like it will work. Tweaking the display now.

    Should the first Row element be `` or ``? When I list it as ``, it runs it twice, so I see the first set of data twice before it begins to increment.

    #XPression


  • 4.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 20:23
    Dan, it looks like the Forum eliminated the stuff you had between the quotes.. It doesn't like greater or less than signs unless you surround that region of text by backticks (the backwards apostrophe to the left of the 1 on the keyboard)... So I can't really tell what your question was..

    You might need to post your project and sample data though for me to really answer..

    #XPression


  • 5.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 20:26
    The first one should definitely be `` and the second scene should be ``.

    What type of datalinq source are you using?

    #XPression


  • 6.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 20:41
    Here are the links to the .xpp and the test project I put together. Please don't judge, it's still rough and I haven't done any design work yet. Just testing the practicality of it.

    Text File

    XPP

    #XPression


  • 7.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 21:08
    Dan,

    I believe the issue was due to the scripting you had. It was running OnOnline, but in the case of a crawl the scene can be online before the datalinq has updated the text objects. I moved the script into the OnSetText for each of Text1 to Text3. It has to be in all three so that when any of them change the concatenated Text4 version will be updated.

    Also, note I turned off the "Live Update" checkbox for each datalinq text object because you don't want them changing while they are in the middle of crawling across the screen. They will still update just before the crawl onto the screen.

    Try this project: http://ross.brickftp.com/f/0b6fadc59

    #XPression


  • 8.  RE: Datalinq Controlled Crawl

    Posted 01-21-2015 21:14
    Thank you. That works correctly.

    I was actually going to end up dumping the script, anyway, and the .txt file would have it formatted the way I wanted to display it in the end. Fewer moving parts, easier to not break.

    #XPression


  • 9.  RE: Datalinq Controlled Crawl

    Posted 01-26-2015 16:18
    To close this up, here's what I've gone with (lacking design, still) to use as a proof of concept, in case anyone is looking for more info.

    XPP

    Data Source Sample

    #XPression


  • 10.  RE: Datalinq Controlled Crawl

    Posted 07-22-2016 18:28
    Any chance someone could update the advice given in this thread? I've followed the directions above, and tried to decipher the instructions, but considering the missing pieces referring to the Datalinq row setup, I'm stuck. There should be a Ross Xpression U tutorial on setting up a Crawl that takes it's data feed from an Excel datalinq.
    #XPression


  • 11.  RE: Datalinq Controlled Crawl

    Posted 08-29-2016 00:45
    Hello, I am looking into setting up a crawl with Datalinq. Any chance an example project can be posted?

    Thanks in advance.
    #XPression


  • 12.  RE: Datalinq Controlled Crawl

    Posted 08-30-2016 00:06
    Does anyone know what are the symbols that need to go in row to setup a datalinq crawl? In the previous posts it looks like im supposed to put in quotations "" but it's not working.


    #XPression


  • 13.  RE: Datalinq Controlled Crawl

    Posted 05-02-2017 20:34
    Dan,

    The datalinq can loop over an unknown number of rows in the datasource and it will just loop around when it reaches the end..

    Create a scene group, set it to Crawl mode and looping. Turn up the global left/right margins a bit to provide some spacing between each crawl scene.

    Add your text object and configure the datalinq to point to a datalinq element. If using something like a text file or Excel/Adodb you would set the Row element to `""`. Leave the "N Increment" set to 0.

    Now duplicate that child scene several times (you need at least as many as might be onscreen at one time.. 5 to 10 should be plenty).. Now in each scene edit the datalinq object and change `` to ``, `` etc for each scene.

    When you play it back XPression automatically increments the `` value to loop over the datasource regardless of how many rows there are.


    "
    Add your text object and configure the datalinq to point to a datalinq element. If using something like a text file or Excel/Adodb you would set the Row element to `""`. Leave the "N Increment" set to 0.

    Now duplicate that child scene several times (you need at least as many as might be onscreen at one time.. 5 to 10 should be plenty).. Now in each scene edit the datalinq object and change `` to ``, `` etc for each scene." I didn't understand that.How &What we set for Rows.In excel or in datalinq options?
    #XPression


  • 14.  RE: Datalinq Controlled Crawl

    Posted 05-06-2017 13:01

    crawl solutuion Yesterday
    Hi,i want to ask for crawl.For create crawl
    1-create scene group
    2-create background for text
    3-create text object
    4-cretae logo object
    5-putt al in scene group
    6-change group effects to crawl
    until here if made mistake warn me pls.

    for every line create another scene is killing me.For a smart software you should find something else ;)
    anyway

    now the problem is I linked with datalinkq a excel file.I created scene for text and logo.
    but line count is not static,every times it will change.Some time they write 20 some time more or less.if it happens I have blank lines.and this blank line and logo still appear on air.How to remove or hide this blank line and logo depend to filled lines.
    I Mean I have alrady 50 scene for text and 50 for logo,both linked to excel file,but if I have 25 line in my excel and I want my crawl skip blank lines and go back to start.I couldn't find any solutions.
    I also tried table in excel but stil not working.I see stil empty lines with logo .
    Help me pls.
    Thanks.


    #XPression


  • 15.  RE: Datalinq Controlled Crawl

    Posted 07-27-2017 20:20
    I feel like this would be a great technique to know! Anybody know what is supposed to go between the quotes in the posts above?
    #XPression


  • 16.  RE: Datalinq Controlled Crawl

    Posted 08-22-2017 14:09
    Hello, same problem here. cant do a crawl with datalinq and looping rows. in the above posts, the text between " " was eliminated so we dont know what to type.

    thanks
    Diego

    #XPression


  • 17.  RE: Datalinq Controlled Crawl

    Posted 01-01-2018 17:56
    maybe creating crawl so easy for Ross stuf.
    but for beginners like us its so complicate .Lots of users still waiting for a answer pls.
    #XPression


  • 18.  RE: Datalinq Controlled Crawl

    Posted 01-04-2018 23:44
    Hi Brian,

    Would you mind recapping what codes we should put in the datalinq interface for row. I have a show coming up where they want a continually updating ticker. They will update an excel file with 5 tweets or 50 tweets. I followed your instructions above in this thread, but I think I got some things wrong.

    I've got my crawl created and it loops correctly. I have my 5 scenes in my scene group. All my text objects are datalinqed correctly (row 1, 2, 3 etc...). I tried following your instructions about changing the row to something else but couldn't make it out. Would you mind clarifying again.

    I am using a ADODB Excel file that a producer is manually updating (and saving to my D drive). She may start with 10 but then have 15 next pass, or 7 next pass.. Would you mind explaining again how to set up the datalinq.

    Thank You.
    #XPression


  • 19.  RE: Datalinq Controlled Crawl

    Posted 01-05-2018 20:36

    When you say ticker, are you referring to a "crawl"? If so, you just use

    <n>
    <n+1>

    etc in the row field for each sub scene of the crawl. You would need to make sure that the Table Name that you export from Excel only highlights the number of rows of tweets that actually exist.

    i.e. if you export a named range of 50 rows in excel, but only fill in the first 5 of them, then datalinq will still loop all the way up to row 50 even though those rows are blank.. If you export the Excel as a CSV then you would not have that issue, as the datalinq knows how many rows exist in the CSV file and will automatically loop back to the beginning once you go past the end of the file.

    If you have issues; please post a sample project and I can look at it.


    #XPression