Graphics

 View Only
Expand all | Collapse all

Datalinq increment

  • 1.  Datalinq increment

    Posted 01-30-2013 14:51
    Hello

    Im trying to import Names from excel to a scene.

    With the Datalinq option no problem, but i want the sequencer to generate as many scenes as there are textrows in the sheet and jump to the next row with every scene. So at the end there schould be so many scenes as rows in excel. is this possible with the Datalinq option so i don't have to link every scene to a different row by hand?

    I thougt the "increment function" should do somthing like this but didn't found out how....


  • 2.  RE: Datalinq increment

    Posted 01-30-2013 18:23
    Linus,

    This functionality exists in upcoming versions of the software.

    Unfortunately this is not released yet, but is coming soon.

    #XPression


  • 3.  RE: Datalinq increment

    Posted 01-31-2013 09:11
    ok, thanks for the answer.

    but what is the purpose of the "increment function" then?

    #XPression


  • 4.  RE: Datalinq increment

    Posted 01-31-2013 13:52
    The increment is used for incrementing data but only in a roll or crawl at the moment, it does not allow for increment on a take item by take item basis.

    Andrew

    #XPression


  • 5.  RE: Datalinq increment

    Posted 01-31-2013 16:30
    ok, thank you. Then i start waiting for the next version :-)

    #XPression


  • 6.  RE: Datalinq increment

    Posted 04-28-2014 12:44
    Has this been added to version v5.4? If so, can somebody give me a quick run through to how it works?

    Thanks!

    #XPression


  • 7.  RE: Datalinq increment

    Posted 09-08-2014 22:52
    Would like to revisit this and see if this is something in v5.5. Anyone?

    #XPression


  • 8.  RE: Datalinq increment

    Posted 09-09-2014 05:53
    What you are trying to implement is there. There are a couple of ways to do this, the simpler way to do this would be to datalinq every field in the sequencer mode and set the row to %relid% (you should be able to right click and go to formula to insert relid as well). What that does is it sets the row to the relative id of the group. so if your group number is 500 and your scene number is 501 then the relative id is 1.

    An alternative approach and how I would probably do it if I were you is using a datalinq key. In layout mode, the top object in your object manager should be named the same thing as the scene you are working on. This is your scene object for the scene. The far right tab of this object is titled "Datalinq Keys". A datalinq key allows a to pass a value in from the sequence into your scene. When you click the datalinq key tab, there is a button in the far right of the window that says "Add". Click this button and then click into the name field of row that just appeared. I would name it something like "row".

    Now that you have that go ahead and start datalinqing your text inside of the layout. When you do this, I would go through and select every field I want, but make sure to select a row other than the front. By doing it like this this, you should have something pop in your row field that has a pair of brackets around a number (kinda like ""). If you selected the top row you would not likely not see this number. every where you see the number in the brackets for your row go through and replace it with "". now you can set the datalinq key in the sequencer to whatever you want and pull that row of information into the scene. With that done, you go back to your sequence and drag your scene into a new group. Once there I would set the datakey rows to "%relid%" and duplicate for however many rows I have in the excel.

    #XPression


  • 9.  RE: Datalinq increment

    Posted 06-02-2015 09:39
    Hey Daniel,

    Sorry for grave-digging this topic, but I'm a bit confused. What do you mean with "a row other than the front". I thought you meant not the first row, but when I select another don't get the number in brackets. I tried to change it anyway to %row% or but it still doesn't work. When I try to get a number between brackets I can't find how. I use a excel datalinq connection and I run the latest version of Xpression Studio, maybe it's changed?

    Can you help me out?

    Kind regards

    #XPression


  • 10.  RE: Datalinq increment

    Posted 06-03-2015 18:41
    Hi Daan,

    I believe Daniel is referring to what happens when using an XML datalinq. You won't see that behavior with the Excel datalinq. I highly recommend using the ADODB datalinq instead of the actual "Excel" datalinq; as the Adodb one provide you with many more features.

    What specifically are you trying to accomplish?

    You might want to watch the Datalinq Part 1,2 and 3 videos here as they will show you lots of ways to use the ADODB datalinq with Excel: http://xpression.rossvideo.com/videos/

    #XPression


  • 11.  RE: Datalinq increment

    Posted 06-05-2015 08:21
    Hey Brian,

    Thanks for the information, it works like a charm. Great video's too, provided me some really nice tricks I didn't know before.

    Kind regards

    #XPression


  • 12.  RE: Datalinq increment

    Posted 07-02-2018 17:17
    @bford you don't happen to have updated version of these videos?
    #XPression