how to csv import employee access in sandbox and maintain password from other environment?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** When you refresh a Sandbox in NetSuite, it takes a copy of your production account. If an employee only exists in the Sandbox and not in the production environment, their record, including their password, will be lost upon refresh. This is because NetSuite uses a global access table for user authentication, and when a user is removed (in this case, through a refresh), their credentials are also removed from this table. If you need to recreate the employee records in the Sandbox after a refresh, they will need to set up their passwords again. The previous passwords are not preserved. However, you can add these users to the refreshed Sandbox and give them access via a CSV update. You can define a generic password and check the "Change Password Upon First Login" field. This way, they will be prompted to create a new password when they first log in after the refresh. As for automatically pushing new employees created in production to Sandbox accounts, this is not directly possible. A refreshed Sandbox would bring the records over, but the access would be determined by your settings. Some admins only bring access to the Sandbox for ADMINs only.