Rename files according to CSV (or SQL Workaround)

Advanced Renamer forum
#1 : 12/12-23 08:47
Florian
Florian
Posts: 1
Hello,

I just gave this tool a try and am impressed by it´s functionality and easy handling!

The most of the job is already done, but now I need to merge the name of the image together with article number - like this request https://www.advancedrenamer.com/forum_thread?for um_id=13535

So far so good, but it seems, that the app.parseTags command doesn´t like large CSV files. My file has two columns and around 170000 lines (5,5 MB). When I only use 500 entries it works. When I take the full file it just does nothing. Is there any limit I can adjust?

As a Workaround: Can I connect to a SQL table connected by ODBC?

Thanks,
Florian


12/12-23 08:47
#2 : 13/12-23 15:14
Kim Jensen
Kim Jensen
Administrator
Posts: 883
Reply to #1:
Performing a rename of 170k files will not perform well. Advanced Renamer will validate batches and try predicting potential name collisions, which doesn't scale linear, meaning file number 170k will consume more resources than file 1. When you also combine it with JavaScript, you are really pushing the limits.

I will suggest dividing the batch up into smaller batches of 25k files. That will work much better.


13/12-23 15:14