Need immediate help with setting up automated process in Excel (using Macros) to do the following:
1. Ask for / accept a JSON file
2. Expand all nested records and lists etc.
3. Edit row 1 heading names, here are some examples:
a. Remove "ResumeParserData." (ie. if title is 'ResumeParserData.SubCategory' change to 'SubCategory')
b. Remove word "Segregated"
c. Remove "Experience.Employer"
d. Remove "Qualification" and add "Edu" before remaining text
e. Remove "Certification" and add "Cert" before remaining text
4. Add "1" after all headings where there may be multiple lines, some of these include:
a. Employer: EmployerName
b. Experience: ExpStartDate, ExpEndDate
c. Education: InstitutionName, City, State, Degree..
5. Eliminate duplicate text (cells) and empty cells from within each column so that all information STARTS in row 2
6. Test data and create new columns as needed:
a. If data in rows below row 2 is different from information in row 2, then create new column next to this row with same heading but add '2' ..... continue to do this until no more new data exists (ie. column "EmployerName1" will now have new column next to it with heading "EmployerName2")
7. Insert default text for columns / headings that have no value, for example:
a. If "EmailAddress" has no value, insert "Email Address"
b. If "Address.City" has no value, insert "City"
Ultimately, this will be built into a process that needs to do the following, but for now, I JUST need a quick tool to help me work with the JSON files and see if the output is accurate
1. Parse original resume through parsing software which delivers JSON file
2. Send / Import JSON file into Excel OR Zoho Analytics (which automatically expands all the nested records and lists)
3. Automatically edit data in file so that information is in only top 2 rows (I think this is necessary but I may be wrong)
4. Save as .csv and send to Zoho Writer for data to merge with template and create reformatted resume
About the recuiterMember since Mar 14, 2020 Karen Wright
from Wakayama, Japan