Updates

Fall 2022 Updates

November 2022

In November, we encountered issues with the overall design of the project. The design language was tricky to manipulate every time we wanted to make a change to borders, sizing, and other elements. We decided it was necessary to restructure the design of the project using a new design language. We were also able to implement several key features. Action items completed this month include:

  • Implemented PDF deletion successfully
  • Redesigned UI for a much cleaner user experience and more polished table view
  • Finalized layout plans for the new pages to add (edit and referral views)
  • Met with sponsor to get approval and feeedback on current state and direction of the project

Current action items we’re working on include:

  • Get dates on referrals
  • Finalize the referral page
  • Finalize the edit page

October 2022

The dependency issues encountered in September have been addressed and solved. There were new difficulties with the resource book going blank when trying to edit resources, and the resource book edit behavior was not uniform across the different platforms among the team. However, these issues have been fixed, and we began focusing on implementing changes according to our list of action items. The action items completed so far include:

  • Links to resource websites are live and clickable
  • Readability and resizing of the resource table improved
    • Column Headings no longer overlap when the window is minimized
  • Functionality of adding a new resource improved
    • Texas is set as the default state when entering a new resource’s address

Current action items we’re working on include:

  • Formatting an edit resource book layout
  • Creating the ability to delete PDFs from a resource

September 2022

In order to start implementing changes, the team needed to have appropriate development environments set up on each of their devices. We made changes to the original project build strategy so that the database was usable and editable on any operating system with less prerequisite software download requirements. Once the project was deployed, we went over a list of ideas for the semester, establishing action items as well as affirming that a server lending would not be beneficial to client or group. Once a list of UX/UI current versus expected behaviors was built, we identified source files of interest for each feature and finalized a timeline for implementing these changes. Entering October, we have just encountered an issue with running the project (due to outdated software) and are currently working to fix it.

August 2022

To ensure the whole team becomes adequate enough to edit the web application, most of the time was spent familiarizing with frameworks and technologies such as NodeJS and MongoDB. Once the team became more familiarized with the technologies, the next phase was coming up with ideas to fix issues the website has originally. We ended the month by visiting the CACCC and discussing potential changes with our project partner Lydia.

Spring 2022 Update

January 2022

To ensure the whole team becomes adequate enough to edit the web application, most of the time was spent familiarizing with frameworks and technologies such as NodeJS, MongoDB, and RESTify API. Once the team became more familiarized with the technologies, the next phase was coming up with ideas to fix issues the website has originally.

February 2022

The first week was used as an “idea phase” where the team came up with tasks that will help the overall functionality of the website. After the first week, the team decided to start implementing and fixing the web application. There are three main goals that the team hopes to accomplish by the end of the semester. Here are all the goals below explained in depth

March 2022

Throughout the whole semester, the team has worked on main goals that could be accomplished for this semester.

1. Rework orchestration: Node code should not be managing the database, nor should it require the user to have a TTY open (running from the bat file) Mongo service should be started via npm script, and the build system should use npm scripts to manage node_modules instead of them being committed to git

2. Asyncify the Website: Instead of using sync operations (e.g. fs.readdirSync), use asynchronous operations to prevent blocking on IO. Look at async/await syntax.

3. RESTify API: Tight coupling between views and API makes it hard to reason about what is happening. Instead of GET requests for everything, those should be limited to the loading of pages. Updates and deletions should be performed as individual requests that do not reload the whole page but instead update small chunks such as displaying a success/error dialog. Possibly look into Vue/Nuxt or a similar framework for the frontend to help with conceptual/organizational separation of frontend/backend. You can go with either a SPA or a static site for the front end.

April 2022

The team was fortunate to finish the main goals and is now making the finishing touches on the website.

1. Clean up syntax: Several areas could use splats instead of manual assignment

2. Safety checks: If something doesn’t exist, the server shouldn’t crash but should instead return a message to the front end.

3.  Fix deployment method: Current deployment and update depend on cloning this repository in its entirety, including the whole node_modules folder. This is generally considered Bad Practice. Ask Taz about Github releases and the proper way to handle dependency

January 2020 Update

We visited the CACCC site for the first time. During the tour, we gained a better understanding of how the facility operates as well as what context the online form will be used in.

Progress:

  • Experimentation and research with formatting of the PDF. Troubleshooting previously unknown issues with saving the PDF files. 
  • Implementing automatic deletion of excessive files (when >1000 files in the PDF folder) in the PDF converter
  • Experimenting with, researching, and editing php file
  • Attempting automation of csv file storage
  • Introduction and familiarization with online form and PDF converter script

December Update

For the month of November and beginning of December, our team focused primarily on making sure the website we designed runs on all of the computers on CACCC. Initially we had issues setting up the website on their network due their firewall not allowing us to connect. We bypassed the firewall by using a router to connect to their computers directly. Then, we were finally able to get the website running on their computers.

Currently, we are working on the user manual to help our partners troubleshoot the website when issues occur and giving them instructions on how to navigate the website. We are also designing a poster containing information about our presentation which we will be presenting soon.

For the front end, we added a sidebar on the left side of the screen that opens and closes on click. When opened, the sidebar displays all the categories that our sponsor uses to categorize their resources. When the user clicks on any one of the categories, the user will be redirected to a page where only resources that fit the category will be displayed.

Update: We presented our work to our audiences and anyone who was curious about our project. Our judges seemed very pleased with our results! We even had a couple workers from different non-profit organizations come up and tell us that they would very much want something like this integrated into their own systems too!

November Update

  • The form is fully functional using the CAC’s computer and mobile devices. However, we are using a personal router. When tested on site, we are unable to locally connect to the CACCC router.
  • Infrastructure:

  • We are looking into whether where we hardwired the CAC PC is isolated from the rest of the building, keeping the mobile devices form connecting to the server.

October Update

As we close in on October, here are the updates for this month:

We finished implementing functionalities such as create, add, update, delete so the user can modify their resource information accordingly. In order to use these functionalities, we need to create the necessary forms. We have two forms designed. The first form shown is our add form. The user would input the necessary data such as the resource type, name, address, hours of operation, phone number, website, and a brief summary about this resource. After they are done filling in the information, they can press the submit button to add the new resource to their records. The user can also choose view all to view all the records they have stored on the website.

The next form we created displays all the information about the resources that are on the record. The user can choose any of the resources and modify its contents as desired, by clicking on the black pen. The user can also delete the resources in a few clicks. The user would have to user can choose any of the resources and modify its contents as desired. The user can also delete the resources in a few clicks. The user would have to click on the red trash can and upon clicking the user would get a pop up message asking them to confirm their action. Once they click yes, the resource is successfully deleted from the website. The user can also sort the city, state, and zip code as necessary.

These are our major updates to the website this month. Everything is going according to plan as we slowly cross out the list of things our partners are asking for.

September Update

This is the beginning of the second semester that this project is being worked on in EPICS.  Here are the improvements we have made since.

We have organized the different resources by putting them into tabs. For the client page, we were able to display one of the client’s information and since almost all of the information in the binder is formatted in the same way, if the backend finishes copying the information from the binder to the database and forward all that information to the website, all the data will be displayed.

 

 

 

 

 

We also began adding functionalities such as the ability to add, delete, and update resources. Currently, only the add functionality works and it wouldn’t be long before the other two are finished since if we can add, then implementing delete will come more naturally.

 

 

 

 

 

For the website, we are primarily focused on making sure everything works first and then coming back later to make everything look pretty.

For the backend we have been setting up the database and was able to connect the database to the server. We are also transferring information from the binder to the database.

 

Final Spring 2019 Semester Update – CIF Team

Within the last month, we updated some of the contents of the form after receiving feedback from Child Advocacy Center. We added CAC logo on each page of the form

We’ve also added Date field on the last page of the form.

Furthermore, we’ve added basic input validation for fields such as zip code and phone number. User cannot input characters in phone number fields.

Following this semester, future teams will tasked with implementing further input validation, data file conversion from .csv to PDF, and further modify the form based on Child Advocacy Center’s feedback.

 

Final Spring Semester Update

We’ve finished the semester!

We have also accomplished all of our goals which were to build a framework for the database within the semester

which included

Login screen
Search bar interface
Zip code
Ability to add resources

and to be able to display the required information of  a resource

Also within the last month, we have added some input validation features to the website’s forms

Implemented the ability to export form data to excel

We have also been able to simplify the process of adding pages to the website by implementing a form to do the process

April – CIF Team

April 11th 2019

We set up SMTP emails so that when ever a form is submitted, a copy of form will be emailed to us. One of the problem with the form’s data is that it is stored as a .csv file and it is very unorganized to work with.

So we want to convert a this file into an organized PDF file. We tried converting directly from excel but the formatting is not readable. So we created a website with PHP background that converts .csv files into formatted PDFs.

This is the how the conversion tool looks like in the website. We can upload a .csv file like the one shown above and it will convert it to a downloadable PDF.

 

This is how the PDF looks like after conversion