Administration Guide
3.2.2 - Importing Employees from Tab-Delimited Files

If your office does not use the QuickBooks accounting package, you can still import employee records using that application's data format by creating a tab-delimited spreadsheet within Microsoft Excel. To manually create an employee import file, open a new spreadsheet within Microsoft Excel and enter the following table information:

Microsoft Excel employee import format

Or, you can download and save to your computer this pre-made import file, which provides the import example contents shown below.

The first spreadsheet row contains header information which Senomix will use to identify the data items to import, with the following rows containing your office's employee information. Note that the first column of the spreadsheet data rows will always contain the text "EMP" to indicate that it is an employee data row, with the very first row and column containing "!EMP" to indicate that the following lines of data correspond to employee information.

Once you have created this template, employee information can be entered into each row of your spreadsheet under the appropriate column headers. The REFNUM value must be a unique number for each employee record, with the recommended value being a simple numbering 1...n for the individual rows. The MIDINIT and PHONE1 columns can be left blank, but the MIDINIT and PHONE1 headers must be included in your import file.

Once your employee import spreadsheet has been completed in Microsoft Excel, save it as a file type of "Text (Tab delimited) (*.txt)" and import it into your Senomix system by following Step 3 in the import process described above. Your data will then be imported into your Senomix system and be ready for use.

For example, the following spreadsheet data:

Example Excel employee import spreadsheet

Which you can download as an example for your own import from this link.

Would result in these user records imported into Senomix:

user administration screen