Brevity Import and Export function
- Anne Pascual (Deactivated)
- Stewart Neale
- Harvey Mediran
Importing the Data
To quickly setup your existing Clients and Employees on the system, Brevity has an import function tab. This allows you to easily upload records for clients and employees. With just a couple of minutes, all records would then be found under the table records. This allows us to save time and allows us to start right away. This guide explains how to import files thru the system.
This can be used for both clients and employees bulk upload. From the clients tab, we would click the Import button on the toolbar to show the Import data section. We can then upload the Excel file and make sure that the required fields are mapped.
You can also click on the Download template file to use as a guide on which information are needed on the system. You can open these template by using 3rd party applications like Microsoft Excel or other spreadsheet programs.
If you cannot download the template, you could click on the links below to download the template from this page.
After choosing the file that will be exported to Brevity, Click on the Upload and continue button.
Brevity will check for the CSV fields from the file you uploaded. You can link the CSV fields to the Brevity fields by choosing the client fields from the drop down menu. After linking the fields, click on the preview data button to go to the next step.
It will show you the Preview of the client's list that will be imported to Brevity. Click on the Import Data button to import the clients list into Brevity.
You will see that the record that it will import is only 10. But this is just a preview and Brevity will import all the records that you have in your import file.
Click on the OK Button to confirm the importing of the data to Brevity
It will show a confirmation window that the records has been imported and it will redirect you to Step 1 wherein you can upload another file to be
Formats in importing the data
You need to format the cell so it will use the data format. If you import these without using a format, it will be defaulted to import default. For example, the date would be set the 1-1-1900 if you don't use the date format.
| Record | Format | Example |
|---|---|---|
| Date | yyyy-mm-dd | 2020-02-27 |
| Time | YYYY-MM-DD HH:MM:SS | 2020-02-27 23:59:00 |
| Boolean | 1 for yes / 0 for No | 1 |
| Dropdown | Name of Selection | Bus |
| Look up Field | Name of the look up | Casual |
Exporting the Data
You can export the list from the table by clicking on the Export Tab. All the information from the table will be generated in the exported file.
After clicking the export button, Brevity will automatically download the file to your computer. You can open the file using 3rd party software like Microsoft excel or other spreadsheet programs.
Creating or Updating the records
If you wanted to create a new record, you need to leave the ID column blank when importing the file. Brevity will create an ID for the records that you will import.
If you wanted to update the record, you need to include the ID of the record. This will edit the record and Brevity will not create a record because it has an ID.
Copyright © 2019 Brevity. All Rights Reserved