Make Time Comm depend on MySQL

Importing branch(es) into BC Time

BC Time includes an import feature that allows users to upload multiple branches into the system at once. Once imported, branches become available for selection and can be linked to employee profiles.

As branches are required when creating employee records in BC Time, this functionality provides a faster and more efficient alternative when managing a large number of branches. Rather than adding each individually, users can import them in bulk, reducing administrative effort. 

Step 1: Navigate to the branch(es) menu in BC Time.

Step 2: Once in the branch menu, click the meatballs (3 dots ) to access import option.

Step 3: Once you've clicked the "Import" option, the below window will appear, which will allow the user to "download the list of cities" currently available in BC Time as well as download the template that will be populated with the required branches. 

The sheet with the list of cities will download, with the following information which will be used in the template; city ID (primary key), Country, Province, Name, Time zone. 

Step 4: Once you've downloaded the template, use the information in the cities sheet to update the template with your required branch name and ID (PK). The template below shows the unique cities in Namibia with their respective ID's.

Step 5: Download the template as a csv. file as shown in the image below.

Step 6: Upload the downloaded template, by choosing the file from your saved location.

Step 7: Click Upload data, and the system will validate the data in the template and ready it for import once validation is successful. Click "Import now".

Step 8: Upon successful import, all the branches will then be created in BC Time, with their correct name and city.

For clients using Geofencing, the template allows for the population of the Geofence ID(s), to ensure that the created branches are linked to their required geofence area (if applicable). Step 4 above showed that we had the geofence id for Windhoek and Swakopmund on the sheet, thus when the import was done, these two branches had their geofence areas linked.