ValuAg - Sen, Ara; Toptan, Ayberk; Tufekci, Can
From CS486wiki
Week 1:
Date: 09/25/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- The project was started in a meeting with Professor Jones and Mr. Dutcher.
- Once we get our credentials for AWS Cloud Training, we started to work on that at first.
- In Cloud Guru, first three chapter and almost half of the chapter 4 were completed.
- We found couple of tutorials about WordPress since we do not have any experience on it.
- We learned some fundamentals of WordPress by watching tutorial from freecodecamp.
Problems:
- We could not connect AWS Amazon Console via given link in the email.
- Once we try to log in, the site is redirected to the change password page in order to continue to AWS Console after to do so. However, our accounts are not allowed to change password. We sent an email but we have not been able to get any response yet.
To-Do:
- Our second meeting was planned to be done on 09/28/2022 at 3.20 pm.
- Fix the log in problem on AWS Console.
- Keep working on AWS Cloud training on Cloud Guru.
- After coming somewhere on the fundamentals of WordPress, try to practice them on locally by opening apache server as localhost. Then, learn how to integrate, connect AWS and WordPress.
Week 2:
Date: 10/02/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- Completed weekly meeting with Professor Jones and Mr. Dutcher.
- After we got our credentials we kept working on AWS Cloud architecture on Cloud Guru.
- Searched and studied how to integrate and make WordPress Site as working with AWS.
- Made a couple of examples that we saw in the tutorials on the architecture we created.
Problems:
- No problem occurred this week.
To-Do:
- We will be working on the tutorials on Cloud Guru for AWS Cloud architecture.
- We will be starting to develop the forms in the documents shared with us on the.
- Our main aim next week is to complete as many forms on the WordPress Site besides training of the AWS.
Week 3:
Date: 10/10/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- Completed our weekly meeting with Professor Jones and Mr. Dutcher.
- We kept studying tutorials on AWS Cloud architecture on Cloud Guru.
- Created all necessary components like EC2, S3, and relational database RDS on AWS.
- Build the EC2 as Linux ubuntu operating system and connected it via ssh from our terminals.
- Downloaded necessary packages for WordPress and connected our WordPress Sites with the database that we created on AWS.
- Opened WordPress from the AWS EC2 server and made another post (page) in WordPress as a little demo.
Problems:
- Even if we did everything as same as in the tutorials, we were unable to create an EC2 server as an Amazon Linux instance.
- When we create the EC2 as Amazon Linux, we were not allowed to install the necessary packages for WordPress and even some simple terminal commands like "yum -y update".
To-Do:
- We will be working on the tutorials on Cloud Guru for AWS Cloud architecture.
- We will create a domain from AWS and try to launch our WordPress Sites on that domain.
- We will be starting to develop the decided form while thinking about how to develop it as user-friendly.
- We are aiming to complete at least one form tab, and make sure the fields are usable and possibly the crud operations can be done.
Week 4:
Date: 10/16/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- Completed our weekly meeting with Professor Jones and Mr. Dutcher.
- Worked on how to make form designs.
- Found and plugin and create three pages with data tables for forms.
- Added first three form pages of Pos Harvest Operations.
- Added necessary form input fields to the rows.
Problems:
- Could not figure out how to get entered data into the fields and put them into the database with the page id of the page that they belong
To-Do:
- We will be working on how to solve a problem that I mentioned above in the problems section.
- We will create more form pages once we are able to get data from form fields and able to put them into the AWS RDS database.
Week 5:
Date: 10/23/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- Completed our weekly meeting with Mr. Dutcher.
- Worked on how to fix the problem that occurred the previous week.
- Found a couple of example solutions that can we use with the plug-in we use.
- Tried to implement and execute solutions that we found.
- We informed our problem to Mr. Dutcher and showed what we have tried and gotten as a result of our actions completed so far.
- Mr. Dutcher gave us a comment about using LAMP Stack integrated with AWS in order to perform data transactions outside of WordPress.
Problems:
- We got some errors and could be able to fix the problem that we had the previous week.
To-Do:
- We will be working on how to solve a problem that I mentioned above in the problems section.
- We will work on and learn LAMP Stack.
- We will try to create a solution to our problem using LAMP Stack.
Week 6:
Date: 10/31/2022
Attandence: Ayberk Toptan, Aral Sen, Can Tufekci
Accomplishments:
- Worked on putting HTML codes on WordPress pages in order to create form structure. Give unique IDs for every input field to distinguish them from given texts in the excel form for instance 'P-1.1-AuditComment'.
- We logged in to EC2 and connect our RDS database that we use in WordPress on the command line. Created a sample table called wp-demo-table and give necessary columns that store our test data.
- Made PHP files like create.php that gets post request from the site and separates the values according to column names. Creates SQL query and executes it to save data on the database. Finally, it returns the page the user enters input data.
- We created a file called read.php for demo and test to read requested data from the database and put the proper fields on the page site once the user directs that page or refreshes it or even after submitting entered data.
- We are asked to create a log-in structure therefore we searched some bootstrap libraries and templates to make the visualization better.
- For the login page, we create a table on the database to store users and created PHP files for posts and get requests for users that we use like controllers on the APIs.
- We are trying to detect the user types like admin or regular user in order to give different privileges and use them to check the user has permission to view or edit the form pages.
Problems:
- No problem has occurred yet.
To-Do:
- We will be finishing the log-in page.
- Storing users with their types and giving them different permissions.
- Once we finished the log-in page and code the permission checking for viewing and editing forms, we are aiming for users to open chosen form according to their permissions.
