Possible to Populate text from CSV/text/DB?

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Possible to Populate text from CSV/text/DB?

So i have thousands of clips to populate w data (stored in cross linked to the video) from CSV (i can export the data any way i need to) each scene has a few overlay images. I need a text field next to each of them (social media contacts info.)

Is there any way to populate or generate the text fields in the right place and sizes w the corresponding text in Davinchi resolve?

SirEdric
Fusionator
Posts: 1873
Joined: Tue Aug 05, 2014 10:04 am
Real name: Eric Westphal
Been thanked: 112 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

There is a script for Fusion standalone that does exactly that.....
Done about 10 years ago. IIRC I updated it for F9, will have to dig it out.
It would most likely need some adaption to your specific needs, but yes, there is something available to do the job...

Added in 21 minutes 6 seconds:
Found it...
Extract zip to folder of your choice.
Open Sports_Automator_blank.comp.
The rest should work automagically...

You do not have the required permissions to view the files attached to this post.

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

So, i dont know if im a idiot or not but i cant seem to import this in to davinchi resolve at all
am i missing something?
do i need Fusion 9 stand alone and cant use resolve's fusion ?

Movalex
Fusioneer
Posts: 113
Joined: Fri Nov 03, 2017 5:36 am
Been thanked: 27 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

I think you will be successful to use in it Fusion (free version) rather than in Resolve.
By the way, I tested this awesome Sports automator, and it failed to render frames, since the saver in RENDER file did not create missing folders. Here's the version that worked for me. Also I've changed render comps creation to Comp: folder so they could find the assets easily. And I fixed fonts to all Arial - regular, because I haven't got Narrow style.
To start render launch Sports_Automator_blank.comp file and click Ok in script dialogue window.

There's also another old CSV-batch render tool, and it is kind of works (but not entirely) Try it out:

I'm currently looking into creating a batch renderer tool in Python, since Lua does not work natively with Unicode characters (in paths, for instance).
You do not have the required permissions to view the files attached to this post.
Last edited by Movalex on Thu Mar 28, 2019 1:19 pm, edited 1 time in total.

SirEdric
Fusionator
Posts: 1873
Joined: Tue Aug 05, 2014 10:04 am
Real name: Eric Westphal
Been thanked: 112 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

Movalex wrote:
Thu Mar 28, 2019 1:32 am
since the saver in RENDER file did not create mising folders
Damn....thought I fixed that. Apparently not...

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

Movalex wrote:
Thu Mar 28, 2019 1:32 am
I'm currently looking into creating a batch renderer tool in Python, since Lua does not work natively with Unicode characters (in paths, for instance).
for resolve or fusion?

Movalex
Fusioneer
Posts: 113
Joined: Fri Nov 03, 2017 5:36 am
Been thanked: 27 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

Hopefully it will work in both.
I'm currently inspired by this AE tool:
I've rendered more than 18000 assets with it. Would like my Fusion tool to be as robust (and probably more affordable:)

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

that is exactly what i need D:
im just unfamiliar w the standalone fusion for compiling clips to fuller video's, so if you make it for resolve too i would be able to buy a copy asap

Movalex
Fusioneer
Posts: 113
Joined: Fri Nov 03, 2017 5:36 am
Been thanked: 27 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

You can try Fusion in conjunction with Resolve's timeline by adding VFX-Connect to your clips in a Davinci timeline. This will open composition in standalone Fusion, just like you accustomed to with Fusion tab in Resolve. I find this method more error prone and stable, and you will have comp files and versioning.

Actually, after a little bit of think over, I realized that with current implementation of Fusion in Resolve it is impossible to create gazillion versions of the same comp since we have no access to the comp file at all. Batch rendering and network render is nonexisent in Resolve. So, until better times, we have only standalone for csv-based batch rendering.
Last edited by Movalex on Thu Mar 28, 2019 2:25 pm, edited 1 time in total.

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

Movalex wrote:
Thu Mar 28, 2019 1:17 pm
You can try Fusion in conjunction with Resolve's timeline by adding VFX-Connect to your clips in a Davinci timeline. This will open composition in standalone Fusion, just like you accustomed to with Fusion tab in Resolve. I find this method more error prone and stable, and you will have comp files and versioning.

Actually, after a little bit of think over, I realized that with current implementation of Fusion in Resolve it is impossible to create gazillion versions of the same comp since we have no access to the comp file at all. Batch rendering and network render is nonexisent in Resolve. So, until better times, we have only standalone one.
fml...
learning fusion seem like what ill need to do then.
i need a way to stitch all these clips together and add the corresponding data to the right clips w the text

Movalex
Fusioneer
Posts: 113
Joined: Fri Nov 03, 2017 5:36 am
Been thanked: 27 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

With the great places like this forum or Discord chat 'Pirates of ConFusion', learning Fusion's tricks is a joy.
But if you are short of time to dive into scripts provided to do the job you are intended to, better spend some bucks on that ae spreadsheet tool (and on AE itself, obviously). It also has nuances, but the video tutorial covers them all.

By the way, if I get you correctly, you have not one background movie to populate with data, but a lot of clips to overlay with multiple social media info? So how this multiple to multiple has to be correlated? Some random choice?

Igor Ridanovic
Posts: 24
Joined: Mon Apr 16, 2018 11:17 pm
Location: Los Angeles
Been thanked: 3 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

PHaRTnONu wrote:
Wed Mar 27, 2019 5:24 pm
So i have thousands of clips to populate w data (stored in cross linked to the video) from CSV (i can export the data any way i need to) each scene has a few overlay images. I need a text field next to each of them (social media contacts info.)

Is there any way to populate or generate the text fields in the right place and sizes w the corresponding text in Davinchi resolve?
I'm not quite clear on what you need to do. Do you have thousands of clips in Resolve and you need to add metadata to each? Or you need to add on-screen titles to each clip on the timeline? Could you clarify please?

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

Igor Ridanovic wrote:
Fri Mar 29, 2019 6:52 pm

I'm not quite clear on what you need to do. Do you have thousands of clips in Resolve and you need to add metadata to each? Or you need to add on-screen titles to each clip on the timeline? Could you clarify please?
I have thousands of clip's (video's ranging from 15 seconds to 1 minute) that i need to add titles onscreen too
every clip has different text (normally 5 fields but a minimum of 3) The text fields and images are always positioned in the same place same lay out for every clip (when some are missing the data they just remain blank)

I need a way to just add the corresponding data to the text fields, i can export the data any way it needs to be but not as meta data (IE csv, text ect. ect.)
The clips are compiled in batches w a generic transition to fit time or genera but that's alot easier then the text fields that take up most of my time.

Igor Ridanovic
Posts: 24
Joined: Mon Apr 16, 2018 11:17 pm
Location: Los Angeles
Been thanked: 3 times
Contact:

Re: Possible to Populate text from CSV/text/DB?

You could wire your data as as an .SRT file. But I don't think any attributes like size and positioning are supported. I may be wrong though. However, I think Resolve 15 would allow you to globally change font color, size, etc.

Another possible option is to use Fusion titles. You can generate them programatically, see video below, but I'm not sure there is a method in the scripting API that would allow you to drop them on the timeline where you want them.

Another option is to use ffmpeg.

PHaRTnONu
Posts: 7
Joined: Sat Mar 23, 2019 7:45 pm

Re: Possible to Populate text from CSV/text/DB?

Igor Ridanovic wrote:
Wed Apr 03, 2019 5:52 pm
You could wire your data as as an .SRT file. But I don't think any attributes like size and positioning are supported. I may be wrong though. However, I think Resolve 15 would allow you to globally change font color, size, etc.

Another possible option is to use Fusion titles. You can generate them programatically, see video below, but I'm not sure there is a method in the scripting API that would allow you to drop them on the timeline where you want them.

Another option is to use ffmpeg.

I actually watched this already and it still adds almost as many step's right now i have a scene i just import thats 4 images and the 5 text fields in place and i just add the text scene by scene its just SO monotonous i was hoping a solution existed to alleviate the work flow of hours to seconds.
the solution you propose would have me adding multiple text's and resizing that it would i feel add more time then save