I recently imported employee data from Google Sheets into ERPNext, and everything worked fine. However, after the initial import, new employees have filled out the form in Google Sheets, and their names now appear in the Data Import Page in ERPNext.
My question: How can I push/import these new employees into the Employee List in ERPNext?
Currently, I can see their names in the import page, but I don’t know how to process them so they appear in the system as new employees.
Is there a way to update only the new entries without affecting the existing records?
Employee data is personally identifiable data and if you used the Google Sheets upload method - which requires that it be public - you are currently sharing that with the entire internet.
Don’t push them into ERPNext from Google sheets on an ongoing basis and enter the data directly into ERPNext instead. Let ERPNext/ HRMS be the source of truth for your HR data instead of Google Sheets.
Hi, you need to set public link at Google sheets, if you upload your data with excel, csv or google sheets you have an ID (unique) for each record and an ID for Employee I setup HR Settings with Employee number, so I use the same ID and Employee Number for each record
I would strongly discourage you from broadcasting your employees’ information on the internet. That’s what a public link to a google sheet means. @friveroll While this will work, it’s bad advice.
For most of my customers, an HR User or HR Manager is entering new Employee information and ensuring its compliance with your law and requirements. I am assuming that you have a similar workflow? You need to describe what your goals more completely to get higher quality help.
Thank you so much for your help!
I want to create a form for employee information so that when we fill it out, the data goes to the Employee List, allowing me to have all employee details.
I plan to send this form to the current employees for them to fill out.
So I’m plaining to use web form for this. What do you think?
A Frappe Web Form is quite a bit of effort for this relative to something more streamlined like Google Forms, but it keeps the information secure in your ERPNext instance which is a major advantage. You could design this in a way that it would allow Employees to update some of their information after they are hired, which I would think tips this in favor of using a Frappe Webform. Addresses and emergency contacts don’t necessarily change in concert with other job-related changes, which is why it isn’t included in the current Frappe HR Employee Lifecycle design).
