Page Comparison

The ability to upload a list of Attendees from a CSV/Excel file for a specific expense chargeWhen the number of attendees is large and the list of these attendees is available in an excel spreadsheet or a csv file, those entries can be imported in the attendee screen directly, rather than manually entering them.

Import Attendees from a file

1. Log into DATABASICS application and open an existing report or start a new expense report.
2. On an expense line item that has the attendees, click on the Attendees tab.
3. Click on IMPORT.Image Added
4. Click on Import from excel file
   Image RemovedImage Added
5. A window will pop up like shown below. Click on TEMPLATE.
   Image RemovedThe system will download a template file on your local computer
   Image Added
6. Open up the file that was downloaded.
   1. Fill in the information as needed. Depending on your configuration fields besides the Name may be required. An easy way to tell which field is required is by looking at the attendee tab and see which fields are marked with an asterisk ( * ).
      
   Image RemovedImage Removed
   1. Image Added   
   2. Attendee Name
   3. Title
   4. Company
   5. Number in the Group
   6. Amount distribution by percentage
   7. Amount distribution by absolute amount
   8. Notes
   9. Employee ID (if staff)                                                                                                                                                                                                         
7. Save the file in your desktop, or somewhere you can easily locate it.
8. From the Import From File screen, click on the computer icon like shown below.
   Image RemovedImage Added
9. Search for your file that you saved then click on Open.
10. If you would like to replace the current attendees, click on check Delete current attendees checkbox.
    Image RemovedImage Added
11. Click on Import.
12. Make sure to click on Apply Changes for your updated attendees to save.
    Image RemovedImage Added