RIGHTBOOTH
  • Home
  • Products
  • Feedback
    • Comments
    • User stories >
      • Mike Ridge
      • Tony Kay
      • Dave Bladen
      • Sue Crossland
      • Luke Dalby
      • McMaster University
      • Hangloose
      • Paul Waterhouse
      • Raf Sauvillers
    • User Videos
    • User Equipment
    • Organisations
  • Help
    • Features
    • Training Videos
    • How To
    • FAQ
    • Blog
    • User Manual
    • Video Settings
    • Webcams
    • Other Equipment
    • Release Notes
    • Terms of use
    • Contact
    • About
  • Try
  • Buy

Opening Event Data in Microsoft Excel

14/2/2017

0 Comments

 
When you run an event, RightBooth will automatically save any user details into the file UserDetails.txt.

​This file can be found along with all the videos, photos and messages in your event file folder within Documents\RightBooth7\Events\Your Event Filename.
The user details file will hold user names, email addresses, dates and times of use, names of the files recorded by each user and also answers to any questions users have provided during the event.  All this information is formatted in the text file as CSV.  CSV stands for Comma Separated Variables which is a fancy way of saying that each piece of information in the file is separated by commas, and this makes it easy to load into spreadsheet applications such as Excel.

This is a typical userdetails file with commas between each data item on each line...

02/09/2016,16:48:08,andrew,smith,[email protected],2016-9-2 16-48-8 photo 1.png
02/09/2016,16:48:22,laura,jones,[email protected],2016-9-2 16-48-22 photo 1.png
02/09/2016,16:49:04,bill,smith,[email protected],2016-9-2 16-49-4 photo 1.png
02/09/2016,17:40:04,jill,smith,[email protected],2016-9-2 17-40-4 message.txt


Now we'll explain the process of loading this data into Excel.
First run Excel and choose to Open a new file.

Also, choose to open Text files from the File Type list:

Browse to your event folder and select the UserDetails.txt file.  Excel will start to open the file and will recognise that it is in CSV format and will then show you the Text Import Wizard

Picture
Wizard Step 1

​Choose Delimited

​Click Next
Picture
Wizard Step 2

​In the Delimiters section, tick the Comma checkbox. 

​Click Next
Picture
Wizard Step 3

Don't change anything at this stage.

Click Finish
Picture
The End Result

Excel will now load the user details into a new spreadsheet for you to continue working.

In this example, column A is the date, B is the time, C is the user's first name, D is the user's last name, E is the user's email addresses, F is the filename created by the user.
Other columns will appear with user's answers to questions if you run a question event.

Picture
0 Comments



Leave a Reply.

    Author

    Nigel Pearce

    View my profile on LinkedIn

    RSS Feed

    Archives

    April 2025
    March 2025
    February 2025
    January 2025
    December 2024
    November 2024
    October 2024
    September 2024
    August 2024
    July 2024
    June 2024
    May 2024
    April 2024
    March 2024
    February 2024
    January 2024
    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013

RightBooth logo
RIGHTBOOTH
​© 2013 - 2025 Aire Valley Software
News
​
Tutorials
​
FAQ
About
​
Contact
​
Terms of use and ​Privacy Policy
  • Home
  • Products
  • Feedback
    • Comments
    • User stories >
      • Mike Ridge
      • Tony Kay
      • Dave Bladen
      • Sue Crossland
      • Luke Dalby
      • McMaster University
      • Hangloose
      • Paul Waterhouse
      • Raf Sauvillers
    • User Videos
    • User Equipment
    • Organisations
  • Help
    • Features
    • Training Videos
    • How To
    • FAQ
    • Blog
    • User Manual
    • Video Settings
    • Webcams
    • Other Equipment
    • Release Notes
    • Terms of use
    • Contact
    • About
  • Try
  • Buy