Problem Statement:

As part of my work on our staff tools, I was tasked with creating a page that would allow CSV data from trucking companies to be uploaded to our database and later extracted with another staff tool when requested. The goal of this project was to streamline our data entry process and make it easier for our team to manage and access data.

Requirements and Constraints:

The page needed to be user-friendly and intuitive, with clear instructions on how to upload and extract data. It also needed to be secure, with appropriate measures in place to protect sensitive information. Additionally, the project had a tight deadline, which meant that I needed to work efficiently and effectively to deliver the project on time.

Approach:

To start, I researched and identified a suitable typescript library called csv-string that could convert CSV data to string. I then began working on the frontend of the page, designing the layout and user interface to be as intuitive as possible.

Once the frontend was complete, I began working on the backend. I created an API that would connect the converted data to a micro-service that I developed in Golang. This service would handle the processing and storage of the uploaded data, making it accessible to other staff tools when needed.

To ensure that the code was robust and reliable, I wrote comprehensive tests that covered all possible scenarios, including edge cases and error handling. I also implemented appropriate security measures, such as data encryption and authentication, to protect the data and prevent unauthorized access.

Uploading CSV data to the server using jQuery:

Converting CSV data to string using csv-string library:

Testing API endpoint using Jest:

‍

These code snippets are just examples of how I implemented the solution and it not breaking any kind of NDA.

‍

Results:

My approach to the project proved successful, and I was able to deliver a high-quality solution that met all of the requirements and constraints. The page I developed was user-friendly and intuitive, with clear instructions on how to upload and extract data. It was also secure, with appropriate measures in place to protect sensitive information.

Additionally, the project was delivered on time, thanks to my efficient and effective work practices. The pull request was well-received by the team, and the feedback was positive. Overall, this project allowed us to streamline our data entry process and make it easier for our team to manage and access data, which was a significant achievement for the company.