Multiple record entry – Staff

You are also able to import multiple staff records. This would be useful to do when first setting up the UPLOADS database.  NOTE: Any records imported will be added, not updated. Make sure that you have not already added these records.

  1.  In the Uploads > Import folder you will find a tab delimited file called “Staff.txt”.
  2.  Open “Staff.txt” in Excel:
  • Open Excel
  • File > Open
  • Navigate to UPLOADS > Import
  • Select “See all files”
  • Open “Staff.txt”
  • Excel should now open the Text Import Wizard
  • Step 1: Select “Delimited” and Next
  • Step 2: Check “Tab”, uncheck any other options, and Next
  • Step 3: Select Finish
  1.  Enter the Staff records you want to import. Any column for which the organisation does not have data should be ignored (but not deleted).  No columns should be added to the spreadsheet and the title row names should not be edited.
  2.  After the data has been entered, save the spreadsheet as a tab delimited text file into the Uploads/Import/ folder (i.e. overwriting the original text file). Do not change the name of the file.
  3.  Open the database using the password and username provided
  4.  Back up the database first: File > Backup Database File. This will save a copy of the database into the folder “Backups”
  5.  Within the database navigate to Admin > Import
  6.   Select Import staff

Import staff

%d bloggers like this: