mardi 3 mai 2011

How to insert Employees in Module of HRM and Pay with all details

You find here a class and a job that could help when importing data from CSV or Excel file to AX
http://www.megaupload.com/?d=YG6R2NIZ

To import Employees to HRM Module with their addresses surely you may need these tables:

1.Empltable
2.DirPartyTable
3.HRMVirtualNetworkTable
4.DirPartyAddressRelationshipMapping
5.DirPartyAddressRelationship
6.Address
7.HRMPartyEmployeeRelationship

Import the EmplTable -increment the partyid field
Import the DirParty table - increment the partyid field to match empltable
Import the Address table - the Reference field = Rec ID field on EmplTable
Import the DirPartyAddressRelationship1_1 table - using the partyid
Import the DirPartyAddRelMapping1_1 table - Reference (1st one) = RecID from Address table - Reference (2nd one) = RecID from DIRPartyAddressRelationship
Import the HRMPARTYEMPRELATIONSHIP table - Employee = Employee ID

Aucun commentaire:

Enregistrer un commentaire