# Contacts with an attached CV

**URL:** <https://forum.mautic.org/t/contacts-with-an-attached-cv/24814>\
**Category:** General Discussion\
**Tags:** discussion\
**Created:** [July 19, 2022, 9:16pm UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814 "2022-07-19T21:16:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prakashfilippo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/prakashfilippo/32/6465_2.png) [@prakashfilippo](https://forum.mautic.org/u/prakashfilippo)\
**Post date:** [July 19, 2022, 9:16pm UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814/1 "2022-07-19T21:16:08Z")

</div>

Hi everybody,  
I’m still learning how Mautic works, and I found one question that I’m not able to answer.

I’ve 1000 contacts, with CV, and I’d like to create segments from some keywords from the CVs. Imagine I want to search who is a “PHP developer” and passionate about “ecology”, so would be nice to be able to create a segment called “Green PHP”, with all those contacts where in the CV (usually PHP or DOC files) there is “PHP developer” AND “ecology” keywords.

How can I do this in Mautic?

At the moment the 1000 contacts are in Google Sheet, and in one field I’ve the filename (unique), and a folder in Google Drive with all the PDF/DOCX files, so it’s easy for me to run a search in Google Drive to select the CVs with those keywords… but it’s a bit tricky to go back to flag the contacts in Google Sheet, and then how do I create a segment from them…?

Any idea?  
I can also make some small updates to PHP code if needed… (probably, converting PHP/DOCX to TXT for full-text search)

Thank you!  
prakash

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 21, 2022, 6:52am UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814/2 "2022-07-21T06:52:25Z")

</div>

Hi,  
you need to:

1. create a csv file, that includes “ecology” and other characteristics as columns. For example:

id,fname,lname,interest,coding language  
1,mark,zuckerberg,world domination,php  
2,bill,gates,reputation,c  
3,elon,musk,wrecking havoc,typescript

Now you have to create the proper cutom field in Mautic.  
If it’s a one choice option (either/or) then the above format is fine. If you want multiple choices you’ll need to separate the choices with pipe symbol:

id,fname,lname,interest,coding language  
1,mark,zuckerberg,world domination|metaverse,php  
2,bill,gates,reputation|fight malaria,c  
3,elon,musk,wrecking havoc|interstellar travel,typescript|php

1. Upload your files, and create the criterias as a new Mautic segment:

coding language = php  
AND  
interest = metaverse

will filter for the proper contact.

I hope I didn’t misunderstood your question.

---

<div class="post-metadata">

**Author:** ![prakashfilippo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/prakashfilippo/32/6465_2.png) [@prakashfilippo](https://forum.mautic.org/u/prakashfilippo)\
**Post date:** [July 28, 2022, 8:49am UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814/3 "2022-07-28T08:49:24Z")

</div>

Hi Joeyk,  
well, the point is that for each line/user (Mark Zuckerberg, for example) I have a full CV, with 4-5 pages full of experiences, skills, volunteer work, and areas of interest.

Putting a CSV with all the unique words with a | symbol seems not too efficient … or is it? I assume that if for every user there was the possibility to have a “text” field - I could convert PDF2TXT and then use this field for full-text-search…

Do you think this is possible?  
Would be amazing for searches and then manually select candidates to populate segments…

Thank you,  
prakash

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 28, 2022, 1:30pm UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814/4 "2022-07-28T13:30:48Z")

</div>

Hi,  
I don’t know PDF2TXT.  
I’m using excel to do this type of csv magic. It does work for me with using CONCAT.  
Joey

---

<div class="post-metadata">

**Author:** ![cmanas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cmanas/32/6930_2.png) [@cmanas](https://forum.mautic.org/u/cmanas)\
**Post date:** [December 27, 2022, 12:56pm UTC](https://forum.mautic.org/t/contacts-with-an-attached-cv/24814/5 "2022-12-27T12:56:48Z")

</div>

Hi @prakashfilippo , did you manage to solve this inside mautic instead of excel? I’m facing exactly the same situation here 🙂