...
Equipment can be imported via an Excel Workbook downloaded from the Customer List.
1. Click on Customers in the Main Navigation.
2. In the Import/Export menu click Download Import Template.
3. There are 3 tabs in the Import Template:
- Customer – useful for helpful in creating additional sites if needed.
- Contacts – enables you to create the Site Supervisors, managers or other Contacts linked to the Customers.
- Equipment – Details of the Equipment or Assets that will be serviced.
See the image below showing the import template and one of the sheets is "Equipment" where you need to enter your equipment details for import. Disregard the other tabs as we're focusing on importing equipment in this user guide.
| Warning | ||
|---|---|---|
| ||
Do not change the template sheet names as well as the column names as that will cause the import process to become unsuccessful. |
4. Enter the Equipment Details:
| Column | Header Name | Description | Required |
|---|---|---|---|
| A | Customer Import ID or Name | Name of the Site Customer or Customer where the Equipment is physically located. | Yes |
| B | Equipment Number | Unique number for the Equipment at this Site. E.g. AC1, EML01 | Yes |
| C | Equipment Name | Descriptive Name of the Equipment | No |
| D | Location | Details of where the Equipment is on site. E.g. Near main stairs | No |
| E | Make | Indicate the make or manufacturer | No |
| F | Model Number | Model Number of the Equipment | No |
| G | Serial Number | Serial Number of the Equipment | No |
| H | Supplier | Related Supplier | No |
| I | Equipment Type | Represents the Type of Equipment. For example, Emergency Lighting. | Yes |
| J | Installation Date | Date on which the Equipment was installed | No |
| K | Commission Date | Commissioning date of the Equipment if applicable. | No |
| L | Warranty Expiry | Date of Warranty Expiry | No |
| M | Service Period Start | This is the equipment field called "First Service In Ascora" |
Date of the first service to be done in Ascora
Yes
This becomes the starting point for calculating the next service interval. For example, if you have Service Period Start or First Service Date as 15/01/2023 and equipment has a monthly service interval, the system calculates the next service date as 15/02/2023. If there is no date entered, Ascora uses the very first job completion date as the First Service Date. | Yes | ||
| N | Service Period End | End of the Service Period. Note: If specified Ascora will not create services automatically after this date. | No |
| O | Notes | Free text describing the Equipment | No |
| P | Barcode | This is optional if you want to easily add equipment to jobs while on site by using the Scan Barcode feature in the app | No |
Notes:
- The Customer and Equipment Number shall be used to determine if the Equipment already exists in Ascora. If an existing Equipment was found it will be updated rather than creating a duplicate.
- Equipment Type determines the frequency at which the Equipment is serviced.
5. Save the populated Excel workbook, then under the Import file and in your Ascora account, navigate to the Customers → Import/Export menu then click the Import option then select the Excel Workbookand select your import file. Ascora will commence importing the specified details.
Ascora will now process the Customers, Contacts and Equipment from the Excel Workbook and created/update the necessary records.
...
Some Equipment only requires a basic Pass/Fail result with comments. This can be enabled under the Administration menu → Defaults.
1. Under the Administration menu, click on Defaults.
2. Scroll down to the Equipment box on the left and tick the Enable Pass/Fail checkbox.
3. Click Save in the top-right corner.
...
Not Tested / Pass / Fail will now be displayed on all Job Equipment in the system on both the Ascora Web and Mobile Apps.
Special Templates for Equipment Record or Equipment Defect Record can be created in Administration → Document Templates area. Any such Templates would be available from the Jobs screen. Both Templates list the Equipment in Equipment Type, then Equipment Number order.
You can also add custom fields per equipment type and edit your template to show the custom fields. Please see How Custom Fields work in Document Templates user guide for more information.
Template Types
Equipment Record – display the Pass/Fail results and details for all Equipment regardless of Test Status.
Equipment Defect Record – will display only those Equipment who have failed the tests.
...
Equipment Types
Equipment Types define the Service Intervals for a particular category of Equipment. An Equipment Type can contain many intervals.For example we can create an Equipment Type of Aircon that has service intervals of Quarterly, Bi-Annual and Annual. can have service intervals created and linked to them and they work like templates. You can also enable or toggle the following setting in Administration → Defaults.
- Use Service Intervals on Equipment Types as defaults for new Equipment
You can create as many service intervals per equipment type as needed.
| Note |
|---|
When the service is being calculated and if the dates overlap, Ascora will choose the least often one. |
Note: Before creating an Equipment Type that has Service Intervals, you will need to create a basic Job Template. This Job Template will be used for creating an Job whether Automatic or Manually created.
When editing an Equipment Type, selecting a Service Interval will display the details below.
.
a. Name - Enter the Service Interval Name such as Monthly Service, Yearly Service, etc.
b. Job Template - select a job template that must have been readily created in the Advanced → Job Templates area.
c. Frequency – How often the Interval occurs.
Start – When the Service Interval should start after the Equipment Start Date – generally this should be set to Immediately after Service Start Date.
End – When the last Service should be created or this Interval afte the Start Date. Generally this should be set to Ongoing. If you need to stop the Services for a piece of Equipment this can be done at the Equipment Level.
d. Create Jobs – Specify whether you want Ascora to automatically create the necessary Jobs based on the Service Interval or if they will be manually created via the Maintenance Planner.
e. Equipment Grouping – Specify if a Job should be created for each piece of Equipment or if the multiple pieces of Equipment for the Customer that have the same Service Date should be grouped onto a single job.
Adding Service Intervals in Equipment Screen
We can add service intervals per equipment and this allows us to add multiple service intervals if needed.
1. Access the Customers menu and search the customer with equipment you need to edit (to add service intervals). Equipment are generally linked to site customers where they are physically located but there might be some cases when you also have equipment linked to parent customers or billing customers.
In this example we are accessing the details of a parent customer called 125 Enterprises.
2. Navigate to the Equipment tab and click on the Pencil icon beside the equipment name to access the details.
Note: If you're trying to access the equipment linked to a site customer, then you either search the site customer name in step 1 or access the parent customer and then click Sites tab then navigate to the Equiment tab.
3. In the Equipment Details screen, click on + Add New to add service intervals.
4. Complete the configurations following steps A - F as detailed below.
a. Name - Enter the Service Interval Name such as Monthly Service, Yearly Service, etc.
b. Job Template - select a job template that must have been readily created in the Advanced → Job Templates area.
c. Frequency – How often the Interval occurs.
d. Create Jobs – Specify whether you want Ascora to automatically create the necessary Jobs based on the Service Interval or if they will be manually created via the Maintenance Planner.
e. Equipment Grouping – Specify if a Job should be created for each piece of Equipment or if the multiple pieces of Equipment for the Customer that have the same Service Date should be grouped onto a single job.
Automatic Job Creation
Ascora allows you to associate a Stock Location with a User. When they are performing inventory actions, the selected location will then be defaulted to the specified one. For example, you will want to set the Stock Location to the Van driven by a particular tradesman.
1. Navigate to the Users under Administration → Users.
2. Select the related User for which we want to set the Stock Location.
3. In the Details area select the Stock Location for the User.
4. Click Save.
Note: When Jobs are being completed on the Mobile Apps, the Stock used on the Job will automatically be taken out of the default Stock Location.
Related articles
| Content by Label | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| hidden | true |
|---|
...
5. After saving the changes, you'll find the service interval created and listed in the lower right part of the equipment details screen.
Note: You can add as many service intervals as needed such as one for monthly, one for quarterly, and one for annual visits.
6. You can adjust the equipment details if necessary. In this example, let's add a First Service in Ascora or basically the equipment First Service Date so that the Last Service and Next Required Service Dates will show.
Note: If you leave the First Service Date field blank and complete the very first job that involves equipment servicing, it will automatically update the Last Service Date based on the job completion date.
Adding Equipment in Customer Screen
1. To add equipment from the customer screen, access the customer details screen and navigate to the Equipment tab and click Create New Equipment.
2. Enter the information in the corresponding fields such as equipment name and equipment number. The rest of the details can be added at a later time.
3. Select an equipment type from the drop-down list and you'll see an option to update service intervals based on the equipment type that you're selecting or just keep the existing service intervals (ones that you've added in the equipment screen using the + Add New button).
4. If you had a service interval linked to equipment and you selected "Update" this will switch to the service intervals for the equipment type.
