FAQ content

Recording or uploading data to a Gate Count dataset

In this article

Getting there

Via the command bar

To record data to a dataset, click on  Record Data in the command bar. This will take you to the default dataset selected in your account's settings. If you are currently viewing the Analyze page for a dataset, however, it will take you to that same dataset's Record Data page instead.

Navigating to the Record Data page from the command bar

Via the homepage

In the Shortcuts box, select a dataset from the  Record Data To dropdown.

Navigating to the Record Data page via the homepage shortcuts

Via the Datasets page

Click on a dataset's Record Data () button in the Actions column.

Navigating to the Record Data page via the Datasets page

Manually enter data

  1. From the Location dropdown, select the library you want to enter data for. This will automatically update the data entry page for the current date.
    1. To add data for a different date, select it from the Date field.
    2. To change the recording method (Hourly, Daily, or Monthly), select it from the dropdown.
    3. Click the Go button to update the data entry page.
Example of selecting a location, date, and method
  1. Enter your gate readings for each time period.
    • For Bidirectional and Unidirectional libraries, enter the starting value in the Gate Start column and the ending value in the Gate End column. The # of Visitors column will automatically update to reflect the calculated number of visitors.
    • For Manual libraries, enter the total number of visitors in the # of Visitors column.
  2. Click the Save Values button.
Example of recording bidirectional gate count readings

Upload data

  1. To upload a CSV file with your gate readings, click on the  Upload File button.
Screenshot of the Upload File button
  1. Compare your file against the Fields List. The name of each column in your spreadsheet needs to match the name of each field exactly, or your import will fail.
    • For Bidirectional and Unidirectional gate count methods, gate_start and gate_end values must be provided.
    • For Manual gate count methods, only the gate_start column value will be saved as the actual gate count.
  2. Compare your file against the Sample CSV File Format
    • If you are recording hourly counts, make sure times are recorded as HH:MM in 24-hour format (do not include AM or PM). For example, 1pm would be 13:00.
    • For daily counts, you can either enter a specific time (in HH:MM format) or omit the time. If you omit the time, it will be recorded at 00:00:00 on that date (12am).
    • If you are recording monthly counts, use the first day of each month as the date. For example, to record a gate count for January, you would use January 1 as the date.
    • Make sure that your gate readings do not contain any comma separators.
  3. Choose the date format that corresponds to the date format in your upload file. If the wrong date format is selected, your import will fail.
  4. Choose the file you want to upload from your computer.
  5. For the Update Type, you can choose how to handle situations where your dataset already contains data for a date in your import file.
    • ​Select Add to Existing Values if Date Exists to simply add the value from the import file to the value already recorded in your dataset.
    • Select Overwrite Values if Date Exists to overwrite the value recorded in your dataset with the value in your import file.
  6. Click the Upload Data button.
    • A confirmation message will appear if the file was uploaded successfully. Especially large files may take several minutes before the data is fully-added to your dataset (don't worry -- our server will work on this behind the scenes!). Once the data is ready, you'll receive an email confirmation.
    • If there were any issues with your upload, an error message will appear indicating the specific issues. Once you've fixed your upload file, you can try the import again. If you continue to have issues or need any help, contact the Springy Support team.
Example of uploading data

Manage uploaded files

  1. Click on the Uploads List​ tab to view a list of all successfully uploaded files.
    1. Click on the Download File () button in the Action​ column to download a copy of the file.
    2. Click on the Delete​ () button in the Action​ column to delete the file and its data.
      • If the file's Update Type​ is "Add to Existing", the values from the file will be deducted from the totals in your dataset.
      • If the file's​ Update Type​ is "Overwrite if Existing", then the corresponding records from the dataset will be deleted.
Example of managing uploaded files

Widgets & API

Widgets allow you to add data to your dataset from outside of LibInsight. This can be especially helpful for gate count datasets, as you will likely have staff or student employees entering the data. By utilizing a widget, they can enter their gate count readings without having to log into LibInsight itself. You can create a widget as a standalone page that staff can bookmark for easy access; or, you can embed the widget inside of an existing page (such as a staff intranet).

If you have programming prowess, there's even an API available. If you have a gate counter with its own API, you could create a script with both APIs that would allow you to record the data from your gate counter automatically.

Check out our LibInsight Widgets & APIs FAQs for more info on creating gate count widgets and APIs.

Example of a gate count widget