Upload Data File Formats

We require two ASCII comma delimited file uploads (CSV):

1) Employee

2) Client

3) Time Sheet (Optional)

Note-1: Fields that could potentially contain a comma must be contained within double quotes (e.g., "field containing, a comma"). Double quotes around other fields is optional.

Note-2: From Excel do "Save As" CSV.

Note-3: We also support Tab delimited and Fixed Position Field formatted files.

Format specifications for files listed above:

1) Employee File Format:

Each record must contain the following:

Employee#, Client#, SS#, Then whatever else you want displayed on the website. Be sure First and Last names are separate so we can sort on Last Names.

We need a field containing status (Active, Terminated, Cobra, etc. ) in any format, so we can filter on Active and Terminated Employees. (could be A, T, C)

if Employee # is not available then this field can be left blank. (i.e.,, Client#, SS, etc)

if Time import is to be used, all required fields that are needed to populate the time import file must be present in this file (or a separate file, contact sttaffdata technical departament for details).

We can accept two or more lines for each record if necessary, provided each line begins with the three fields listed above.

Field formats are forgiving. We can reformat from just about anything.

2) Client File Format:

Each record is a line containing the following:

Client#:, Fed Tax#, Company Name, Address1, Address2(optional), City, State, Zip, Phone, Fax, (opt) Contact (optional)....Then whatever else you want displayed on the website.

if Fed Tax Id is not to be used or displayed, then it can be left blank (i.e. Client #, company Name, etc)

Field Formats are forgiving. We can reformat from just about anything.

3) Timesheet File Format: (Optional - Includes file Import required fields)

Paylus:
CLIENT#,SS#,LAST_NAME,FIRST_NAME,STATUS... then whatever else you want displayed on timesheet.
-Note: Columns in timesheet for entry must match the Payplus Earning Codes for file import to function.

SLS:
CLIENT#,SS#,EMPLOYEE#,LAST_NAME,FIRST_NAME,STATUS... then whatever else you want displayed on timesheet.

Other Payroll System:
Call

Time-Clock Download File formats (For hours to be automatically imported into your payroll system):
Call

-----------------------------------
Note: Files may be uploaded via FTP to our server or emailed as an attachment. FTP files may be uploaded daily. E-mail attachments are accepted weekly.

Technical Contact:

Len Bryan at lb@lenmark.net

StaffData.com