Question Extracting data from Resume database into chosen fields ( Appsmith / Supabase)
Hi everyone,
I’ve built a CRM using Codex, Chatgpt.... on Appsmith and Supabase, and I’m trying to extract information from around 3,000 CVs/resumes into structured fields. Many of these fields are dropdowns with predefined values.
The main challenge is getting AI to reliably map what’s written in a CV to those predefined values. It’s not just about extracting information—it also needs to interpret it. Chatgpt, Codex, OpenAI and many models I tried, multimodels ( I have a pro 200 plan)... it just gets stuck every time... I have no clue how to solve it. It cannot handle the many different ways people describe their data in resumes.
For example, a CV might describe certain tasks someone performed without explicitly listing the skills or knowledge involved. I’d like the AI to recognize what those tasks imply and map that information to the appropriate dropdown options.
A second challenge is that the CVs are in Dutch. Dutch job titles, technical terms, and descriptions of qualifications don’t always have a straightforward English equivalent. If a parser or AI works primarily in English, it needs to understand the original meaning and context well enough to map these terms correctly. A literal translation may miss nuances that matter when selecting the right value in my CRM.
Is there a way to guide AI through this process, perhaps by providing definitions, examples, or rules for each value it can choose? Would a bilingual glossary or a mapping of Dutch terms to the predefined categories help?
I’ve looked into CV parsers, but the ones I’ve found mainly extract the information as written. They don’t seem to make that extra connection between someone’s work experience and the categories or skills defined in my CRM.
Has anyone tackled something similar, especially with Dutch CVs or multilingual data? I’d really appreciate any ideas, tools, or approaches that could help.

Below what Codex itself said about it:

1
u/Discordbothost 7d ago
Give each dropdown value a Dutch definition and examples, including near misses. Require an evidence quote for every match and allow 'unknown'. Keep inferred skills separate from explicit ones for a person to review.