• Skip to main content
  • Skip to after header navigation
  • Skip to site footer
ERN: Emerging Researchers National Conference in STEM

ERN: Emerging Researchers National Conference in STEM

  • About
    • About AAAS
    • About the NSF
    • About the Conference
    • Partners/Supporters
    • Project Team
  • Conference
  • Abstracts
    • Undergraduate Abstract Locator
    • Graduate Abstract Locator
    • Abstract Submission Process
    • Presentation Schedules
    • Abstract Submission Guidelines
    • Presentation Guidelines
  • Travel Awards
  • Resources
    • Award Winners
    • Code of Conduct-AAAS Meetings
    • Code of Conduct-ERN Conference
    • Conference Agenda
    • Conference Materials
    • Conference Program Books
    • ERN Photo Galleries
    • Events | Opportunities
    • Exhibitor Info
    • HBCU-UP/CREST PI/PD Meeting
    • In the News
    • NSF Harassment Policy
    • Plenary Session Videos
    • Professional Development
    • Science Careers Handbook
    • Additional Resources
    • Archives
  • Engage
    • Webinars
    • ERN 10-Year Anniversary Videos
    • Plenary Session Videos
  • Contact Us
  • Login

Inventory Management Using Snipe It

Undergraduate #227
Discipline: Computer Sciences and Information Management
Subcategory: Computer Science & Information Systems

Zaire Husband - University of Arkansas at Little Rock
Co-Author(s): Tom Coffin, University of Arkansas at Little Rock, Little Rock, AR



Managing inventory is a difficult and important task for any business or organization. ‘Snipe It’ is a database program that allows users to track inventory and usage. Snipe It is an open-source inventory management system that operates on the web, primarily through the script language Hyper Preprocessor (PHP) and Structured Query Language (SQL). When I started, the inventory of the Emerging Analytical Center (EAC) at the University of Arkansas at Little Rock was completely unorganized, with many computer parts scattered across the lab area. My project was to set up and program Snipe It to organize the EAC inventory. I originally tried to create the program environment on a Windows operating system, but found it difficult to run Snipe It on Windows. I found an alternate operating system called Ubuntu that allowed me to directly send commands from the terminal into Snipe It. In order to use Snipe It in Ubuntu, I first downloaded several mini-PHP programs and an SQL program. I then modified the SQL security key so that I could use MySQL to create the database. Once I got the pre-flight and set up working properly, I inputted all of the EAC’s assets into the system. This process required researching acquisition information for over 50 EAC assets. I then added information such as license, purchase date, location, and categories for these assets into the database system. My program resulted in a user interface that was simple to use and easy to understand. Since Snipe It is an open-source software, any user with a bit of knowledge about PHP and SQL can add and improve the system for better management and faster service. A future improvement on this software could be to design it to work on a mobile platform.

References: Snipe-It, Grokability, Inc, snipeitapp.com, v3.0, 2016

Funder Acknowledgement(s): Arkansas Economic Development Commission (Science and Technology Division).

Faculty Advisor: Janet Lanza, jxlanza@ualr.edu

Role: I implemented the entire program from start to finish. I reprogrammed the security key and inputted data for the program's assets. I also tested different features during the pre-flight to ensure there were no bugs.

Sidebar

Abstract Locators

  • Undergraduate Abstract Locator
  • Graduate Abstract Locator

This material is based upon work supported by the National Science Foundation (NSF) under Grant No. DUE-1930047. Any opinions, findings, interpretations, conclusions or recommendations expressed in this material are those of its authors and do not represent the views of the AAAS Board of Directors, the Council of AAAS, AAAS’ membership or the National Science Foundation.

AAAS

1200 New York Ave, NW
Washington,DC 20005
202-326-6400
Contact Us
About Us

  • LinkedIn
  • Facebook
  • Instagram
  • Twitter
  • YouTube

The World’s Largest General Scientific Society

Useful Links

  • Membership
  • Careers at AAAS
  • Privacy Policy
  • Terms of Use

Focus Areas

  • Science Education
  • Science Diplomacy
  • Public Engagement
  • Careers in STEM

Focus Areas

  • Shaping Science Policy
  • Advocacy for Evidence
  • R&D Budget Analysis
  • Human Rights, Ethics & Law

© 2023 American Association for the Advancement of Science