On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login

Table of Contents

OST - 18.02.01 Masters: Importing an Employee List

Views: 808 Last Updated: 07/20/2023 07:10 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

You can import a list of employees into On-Screen Takeoff which makes building the Employees master table a snap. We include a template Excel file, located in the "C:\OCS Documents\OST", named "Sample Employee Import.csv". Open this file in a spreadsheet application to see the various fields you can import.

The image below shows the required fields highlighted in Yellow and the recommended fields in Reddish-Pink - highlighting is not required in the actual CSV file.

All text fields are limited to 50 characters.

Creating an Import List in Excel/CSV File

To create your import list,

Using a spreadsheet program, create a list of all employees formatted exactly as the sample file (the file must include the headers for EmpNo, FirstName, and LastName, all other headers/fields are optional).

Save the file as a CSV document.

Importing CSV Employee List

Launch On-Screen Takeoff.

Click Masters > Employees, the Employees dialog box opens...

Click the Import button, an open file dialog box displays...

Browse to the location of saved CSV file and select it.

Click Open and the employee list is imported into the Employees Master Table.

If you have a spreadsheet program such as Microsoft Excel installed, you can save the sample import file as a template so you can re-use it in future projects. See your spreadsheet application’s Help system for information on creating and saving templates.

Masters: EmployeesMasters: Job Statuses 

Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! Copyright 2023 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.