It realy annoyed me that there is no way to import any data for amiga games in Launchbox, so I figured out a way to rename all my whdload games. This way, launchbox can at least get some stuff. Maybe other people are looking for a way to do this, so I'll share it here...
How to: Help Launchbox scrap meta data for whdload Amiga games by renaming them with Power Shell + RegEx
It won't work for all games, but for the vast majority, so renaming the remaining ones by hand won't be such a big deal.
Attention: The following commands aim at games stored as .zip files. For .lha format exchange .zip with .lha in the commands. Use seperate folders for both formats when using this method or the extensions will get messed up!
1. Make a backup of the directory containing your whdload games. You don't want to download them all over in case you made changes you can't reverse!
2. Open Power Shell and go to the directory containing your whdload games.
3. Apply the following commands. The -whatif flag at the end of each command means the shell will only simulate the command and show you what would happen if you execute it. To actually perform it you have to remove the flag from the end of the command. You can paste thoose from your clip board to the shell by clicking the right mouse button.
I'm not a regex pro, so i split up the task in several commands.
Apply once: Remove .zip extension:
ls | Rename-Item -newname {$_.name -replace "(.*).zip", '$1' }-whatif
Apply several times: Remove additional information seperated by underscores:
ls | Rename-Item -newname {$_.name -replace "(.*)_.*", '$1' }-whatif
You can repeat a command by pressing the up-arrow-key.
If you get warnings during this step, you possibly have several versions of a game stored. You should rename theese games by hand or just ignore this for now if you don't really need theese versions or if you are just keeping them in case another version is not working (as I do).
Apply several times: Split game name into single words:
ls | Rename-Item -newname {$_.name -creplace "([A-Z].*?)(\S)([A-Z]|&|\d{1}\S*)", '$1$2 $3' }-whatif
Apply once: Reattach .zip extension:
ls | Rename-Item -newname {$_.name + '.zip' }-whatif
Done!