SQL Server Import:
You can use the SQL Server Import and Export Wizard to import/append a SQL table from an Excel spreadsheet and this works for HR tables as well. In SQL Server Management Studio, right-click on the company database, and select Tasks and click on Import Data... to open the wizard.
SQL Server Data Transformation Services:
Refer to the KB article below:
Currently an option is to use Table Import to import data into the HR windows. Information on the window may be held in the SDK.
To gather information on importing into Microsoft Dynamics GP, you can reference the below KB article:
KB 856667 - How to use Table Import to import data into Microsoft Dynamics GP
With Microsoft Dynamics GP 2010, you can use eConnect to import limited data into HR using the following Human Resources schemas:
Currently Integration Manager does not support importing information/data directly into the Human Resource module. Within IM, there is no destination available for Human Resource as it is considered a 3rd party add-on within the Microsoft Dynamics GP system. Therefore, IM does not have a supported option to bring in transaction data into HR. However, you could use some of the IM features with Payroll to bring in some of the setup information as follows:
- IM could be used to bring in Employee Master Data directly into Payroll. Human Resources Management reads directly from the Payroll Employee Master data table (UPR00100) from Payroll.
- The main setup for Benefits and Deductions could be brought into Payroll with IM, and then use the HR Reconcile utility in Microsoft Dynamics GP to bring this setup data over to HR. There are HR Reconcile options for 'Update Benefit Setup' and 'Update Benefit Enrollment' to update HR with benefit/deduction setup and enrollment from the corresponding codes in Payroll.
Article ID: 2856302 - Last Review: Mar 8, 2017 - Revision: 2