12-23-2024, 09:46 AM
m looking for a offline converter , which can separate JSON data into column based CSV file
sample data is as follows :
{"sort": 3010232, "security-clearance": , "experience": {"past-companies": , "past-titles": , "experiences": , "last-company": , "last-title": }, "education": {"schools": , "highest-degree-id": , "highest-category-id": , "highest-degree": , "educations": }, "last-resume-update": , "profile-status": "Approved", "profile-status-id": 5, "professional-summary": "", "mobile-phone": "", "email": "****@bellsouth.net", "last-job-application": , "work-authorization": , "profile-visibility-id": 1, "firstname": "Myra", "job-preferences": {"industries": , "classifications": {"source": "auto", "specialties": {"id": 130, "label": "Systems"}, {"id": 135, "label": "Software Development"}, {"id": 137, "label": "Mobile Development"}, {"id": 136, "label": "Front End Development"}, {"id": 129, "label": "Networks"}, {"id": 127, "label": "IT Project Management"}, {"id": 211, "label": "DevOps"}, "version": 0, "roles": {"id": 104, "label": "Technology"}}, {"source": "auto", "specialties": {"id": 1106, "label": "Software Development"}, {"id": 1107, "label": "System Administration"}, {"id": 1109, "label": "Technical Project Management"}, "version": 1, "roles": {"id": 1101, "label": "Technology"}}, {"source": "auto", "specialties": {"id": 2703, "label": "Technical Project Management"}, {"id": 2410, "label": "Systems & Network Administration"}, {"id": 2409, "label": "Software Development"}, {"id": 2411, "label": "Systems Architecture & Engineering"}, "version": 2, "roles": {"id": 2400, "label": "Technology"}, {"id": 2700, "label": "Project Management"}}, {"source": "auto", "specialties": {"id": 3703, "label": "Technical Project Management"}, {"id": 3410, "label": "System & Network Administration"}, {"id": 3411, "label": "Systems Architecture & Engineering"}, {"id": 3409, "label": "Software Development"}, "version": 3, "roles": {"id": 3400, "label": "Technology"}, {"id": 3700, "label": "Project & Program Management"}}, "desired-title": "", "desired-locations": {"radius": 25, "location": {"city": "Rockledge", "state": "FL", "coords": {"lat": 28.2832, "lon": -80.7652}, "zipcode": "32955"}}, "years-of-experience": , "years-of-experience-id": }, "lastname": "Pope", "optin": {"email-optin-accepted": true}, "work-authorization-id": , "current-compensation": {"lower-limit": 90000, "description": "$90k+"}, "subscribe-date": "2009-03-25T21:01:12+0000", "profile-visibility": "Visible to everyone", "address": {"city": "Rockledge", "state": "FL", "street": "", "coords": {"lat": 28.2832, "lon": -80.7652}, "zipcode": "32955"}, "subscription": {"subscription-status": "U", "premium": false, "unsubscribe-reason": ""}, "skills": , "last-profile-update": "2017-09-30T02:59:06+0000", "profile-create-time": "2011-12-10T12:38:37+0000", "jobseeker-id": 5180857, "last-email-open": "2012-06-16T18:23:09+0000", "gender": , "security-clearance-id": },
any help is greatly appreciated
sample data is as follows :
{"sort": 3010232, "security-clearance": , "experience": {"past-companies": , "past-titles": , "experiences": , "last-company": , "last-title": }, "education": {"schools": , "highest-degree-id": , "highest-category-id": , "highest-degree": , "educations": }, "last-resume-update": , "profile-status": "Approved", "profile-status-id": 5, "professional-summary": "", "mobile-phone": "", "email": "****@bellsouth.net", "last-job-application": , "work-authorization": , "profile-visibility-id": 1, "firstname": "Myra", "job-preferences": {"industries": , "classifications": {"source": "auto", "specialties": {"id": 130, "label": "Systems"}, {"id": 135, "label": "Software Development"}, {"id": 137, "label": "Mobile Development"}, {"id": 136, "label": "Front End Development"}, {"id": 129, "label": "Networks"}, {"id": 127, "label": "IT Project Management"}, {"id": 211, "label": "DevOps"}, "version": 0, "roles": {"id": 104, "label": "Technology"}}, {"source": "auto", "specialties": {"id": 1106, "label": "Software Development"}, {"id": 1107, "label": "System Administration"}, {"id": 1109, "label": "Technical Project Management"}, "version": 1, "roles": {"id": 1101, "label": "Technology"}}, {"source": "auto", "specialties": {"id": 2703, "label": "Technical Project Management"}, {"id": 2410, "label": "Systems & Network Administration"}, {"id": 2409, "label": "Software Development"}, {"id": 2411, "label": "Systems Architecture & Engineering"}, "version": 2, "roles": {"id": 2400, "label": "Technology"}, {"id": 2700, "label": "Project Management"}}, {"source": "auto", "specialties": {"id": 3703, "label": "Technical Project Management"}, {"id": 3410, "label": "System & Network Administration"}, {"id": 3411, "label": "Systems Architecture & Engineering"}, {"id": 3409, "label": "Software Development"}, "version": 3, "roles": {"id": 3400, "label": "Technology"}, {"id": 3700, "label": "Project & Program Management"}}, "desired-title": "", "desired-locations": {"radius": 25, "location": {"city": "Rockledge", "state": "FL", "coords": {"lat": 28.2832, "lon": -80.7652}, "zipcode": "32955"}}, "years-of-experience": , "years-of-experience-id": }, "lastname": "Pope", "optin": {"email-optin-accepted": true}, "work-authorization-id": , "current-compensation": {"lower-limit": 90000, "description": "$90k+"}, "subscribe-date": "2009-03-25T21:01:12+0000", "profile-visibility": "Visible to everyone", "address": {"city": "Rockledge", "state": "FL", "street": "", "coords": {"lat": 28.2832, "lon": -80.7652}, "zipcode": "32955"}, "subscription": {"subscription-status": "U", "premium": false, "unsubscribe-reason": ""}, "skills": , "last-profile-update": "2017-09-30T02:59:06+0000", "profile-create-time": "2011-12-10T12:38:37+0000", "jobseeker-id": 5180857, "last-email-open": "2012-06-16T18:23:09+0000", "gender": , "security-clearance-id": },
any help is greatly appreciated
