I had a similar requirement in one of my projects where we needed to publish ~5000 assets. These weren’t in a single folder but scattered across different locations, and the list of assets was provided by the business in an Excel sheet.
Here’s the approach I implemented, which worked well:
-
I created a custom workflow process that reads a CSV file and triggers the publishing workflow (Dynamic Media). Alternatively, you can also use the Replication API directly within the workflow process.
-
Added proper logging and error handling to make the process more reliable and easier to monitor.
To manage the load, I split the data into batches of 250 assets each and processed them sequentially while monitoring the logs. Each batch took around 15–20 minutes.
While it may sound like a lengthy process, it significantly reduced manual effort and saved a lot of time for business users.