How to succesfully import XML file with subtitle images

At one point the video clearly shows the data being reformatted in excel and a text editor. The only part that isn't realyl clear to me personally is whether they are using AE keyframe data as I explained a few days ago (https://community.adobe.com/t5/after-effects/applying-red-camera-movement-metadata-to-xyz-positions-in-after-effects/td-p/12237635), are creating a MGJSON file or some standard subtitle file format like SRT required by a script they are using. I guess the point is realyl to convert the XML/ strip the tags. Everything else should realyl not be that much of a problam as subtitle scripts or other solutions that create text based on spreadsheet data have exiisted since forever for AE. I'm sure on AEScripts.com you would even be able to find a 15 year old script to that effect...

Mylenium

I see what you mean - it feels like a step has been deliberately missed out.

Could you post the XML file here?  The XML itself will be text-based, with paths referencing images.  It might be simple enough to use Excel or Google Sheets to convert the file into a CSV and then you can import that into AE.

The text apparently gets converted to images, so I'm not specifically sure what use the XML would even be. AE itself can only use JSON and plain text files as data sources for such animation. There may be a specific script at AEScripts.com that can import XML subs as well, but I haven't checked this in a while. Otherwise you can always convert your XML to AE compatible data as shown in the video using text editors and Excel (or any other calc program). I would suggest you start by reading the online help to get a feel for what data-driven animation AE actually supports and then also research on how to get subtitles in AE. This used to be al lthe rage two or three years ago and I'm sure you can find enough discussions and tutorials on it.

Mylenium