Before you start
- You need Project Management and Add on Projects. To download the template you also need Can export lists.
- Your company's plan is active and has room for the projects.
- One file holds up to 150 projects. It must be
.xlsxor.xlsand under 500 KB.
Steps
-
In the sidebar, select Projects › List.
-
Select Download Template. The message "Template downloaded" shows and the file
projects_template.xlsxis saved.
Step 2. The Download Template and Bulk Upload buttons on the project list. -
Open the file. Row 1 holds the column names and row 2 holds a hint for each column. Keep both rows.
-
Enter one project per row below them.
Field Required What to enter name Yes The project name. projectType No installation, replacement, repair, upgrade or inspection. A blank saves no type; set it later in Edit Project. priority No low, medium or high. unitSystem No Imperial or SI. description No Free text. budget No The estimated project value. manualContractValue No The contract value, if already agreed. estimatedDuration No Duration in days. locationAddress Yes The site's street address. locationCity Yes The site's city. locationState No The site's state. locationZip No The site's ZIP code. landmark No A landmark near the site. clientName Yes An existing client, or a new client's name. clientEmail No The client's email. clientPhone No Required if the client is new. clientCompany No Required if the client is new. clientAddress No Required if the client is new. startDate Yes The start date. endDate No The end date. projectManager No The project manager. requiresPermit No Whether building permits are needed. hasExistingSystem No Whether there is an existing HVAC system. notes No Free text. -
Save the file.
-
On the project list, select Bulk Upload and choose the file.
Result
The message "Bulk upload complete: [number] created." shows, or the message the server sends. Each imported project is in the list with Pending and has its stages ready, as a project added by hand would. See Which stages a new project gets.
If some rows had no project type, a warning says "No project type on [number] row(s): ... Set the type in Edit Project." See Edit a project.
If something is different
- No Download Template or Bulk Upload button: you do not have Add on Projects.
- "You cannot export lists." when you download the template: you do not have Can export lists. Ask your administrator. See Restrict what a role can see and export.
- "Bulk Upload Failed: [number] Error(s) Found": see "Bulk Upload Failed" when I import projects.
- A plan warning or upgrade box opens: see Add Project or Bulk Upload opens a plan warning.
