Using Sage HRMS Link > Importing and Exporting ASCII Files > How the Import Process Works
Related topics

About Sage HRMS Link

How the Import Process Works

When you import data from an ASCII file into a Sage HRMS database, the master files are affected differently than other files.

If you imported the same data three times to a master file, you would only have one set of the data.

If you imported the same data three times to a non-master file, you would have three sets of the same data.

Example:  If you want to import dependent information, you would import to the Employee Dependent file (HDEPEND). Sage HRMS Link adds all the data from your ASCII file to the HDEPEND file. It also adds any new employee numbers to HRPERSNL.

However, if your template only includes fields from the Employee Dependent file, the only information Sage HRMS Link adds for employees not found in HRPERSNL is the employee number and the company code in HRPERSNL. All other information, such as name, address, and birth date, is left blank in Sage HRMS. You need to enter that data manually or create a different template to import it.

Tip: If you don't want duplicate records in HDEPEND, use Sage HRMS Link to import to files other than HRPERSNL only for initial setup of your system, or delete duplicate records after you complete an import. If, on the other hand, you are importing data such as events, you may want duplicate or additional event records because new ones would have different dates and different comments. To keep your event records up to-date, you could import new event data from an ASCII file to the HEVENTS file.