Mega Imported Data (MID)

Most of the data in The BOS comes from external systems such as Nookal, Xero, GoHighLevel and other supported platforms that we connect with. 

There is sometimes a need to get data into The BOS which isn't able to be retrieved from a remote system. Reasons include:

• Company data stored in a spreadsheet (IE: not in an online platform)
• Data from a service that The BOS doesn't integrate with (due to not having a connector or the service not offering an API)

In these circumstances you can use the Import Data functionality of The BOS to get this data to display in your reports. 

Disadvantages compared to connected data

The best way to get data into The BOS is to use a proper connection rather than doing an export from one system and importing into The BOS. We will use an example of exporting a list of practitioners from your PMS to demonstrate the advantages:

• Data automatically stays up to date
  If a new practitioner is added or updated in your PMS, it will automatically appear in The BOS
• Data is properly linked
  Each appointment/invoice and other data is correctly related with no 'mapping' required by you. For example you can group clients based on their practitioners profession, expressed as Client.Appointment.Practitioner.Profession which is complicated to express when doing manual imports
• Most BOS Reports are preconfigured
  BOS Mega report will breakdown anything related to a practitioner (EG: hours, revenue) automatically without you needing to configure how the custom data works

You will miss out on these benefits if you are importing data rather than using a connection. 

You may also find in future that data you were previously manually importing is now available via a connection. In that event you should stop importing data and use the proper connected data.

Imported Data Tags

Tag Name

A tag represents a type of data you want to import. You should name these with descriptive names such as Practitioner Leave (Hours) or Location Target Revenue.

Per Practitioner

A tag can optionally be Per Practitioner. Choose this if the data relates to practitioners. For example a 'Practitioner Leave in Hours` or `Practitioner Revenue Target` would be linked to each practitioner, while a `Location Revenue Target` would not be per-practitioner. 

Categories

You can select categories you would like to break the data down by. Note that this will require a more complicated import as each row will need to specify a category

How to Import Data

You must have access to Tenant Settings and be on a supported plan

Each time you import data you must choose a tag that the data will belong to.

You can import data to a tag as often as you like (EG: if performing weekly 'updates' of the data). If you are doing an update you can skip the first two steps below. 

1. Create a Tag

1. User Menu => Tenant Settings => Imported Data, click Add Tag
2. Give the tag a descriptive unique name, per-practitioner and category settings as described above. 
3. Click Save, you will be returned to the main tag list

2. Download template and enter data

1. On the Imported Data screen, find the appropriate tag and press Download Template which will immediately download a Microsoft Excel file
2. Open the file and add/edit as many date columns you want, ensuring you use the same format for the dates. Any dates that appear in this file will be 'cleared' from the existing data before this new file is uploaded. For example: if your import only includes this weeks dates then any data for last week will still remain in The BOS. If your file includes this week and last week then all data for last week will be deleted before this file is uploaded.
3. Add as many rows as you want. The OrgNode,Practitioner,Category columns must be unique and can't be repeated. For example you can have "Gold Coast, Isaac" and "Gold Coast, Toby" but can't have two "Gold Coast, Isaac"
4. Fill out the values. Only numerical values can be processed. 

3. Import file

TODO: Write this bit