Thanks for the reminder.
I got wrapped up in another project like I usually do and completely forgot this.
Here is an excel file with all the data that you need
OK this file lists all the NPCs and the IFO file in which their data is held.
It is
NOT designed to be a tool to put the NPC data into the rose database in a form that is usable by your server.
With a little rewriting of the code it could be though.
Just find the NPC that you are having problems with and look in the "path" column for the full path to the relevant IFO file.
The utility does have the ability to parse the extracted IFO files in your client if you want to use it that way.
Just go to the "config" tab and fill in the path to your extracted MAPS folder then click the "extract npcs" button in the top left corner of the "NPC" tab
It's a bit slow and will probably take 5 to 10 minutes to go through every single file in your maps folder. You can speed it up by deleting everything except IFO files from the folder but that too is a pain in the butt.
I just extract IFO files only when I need to use this utility.
Trouble is I don't think any of the public extractor tools have the ability to do that.
Anyway, hopefully you won't need to extract them and can just use the data that's already there.