##Overview## Web application for processing .jpeg or .pdf files for big companies and easier access to their important data like income or expenses. It is based especially for processing receipts and storing them in the cloud. This application will make life a lot easier for accountants and clerks that are dealing with a lot of papers at the moment. Firstly we will make a working project and then publish it and get big companies to use it.
##Project goals## Our mainly focus is setting up an environment that non-IT people can use and making it intuitive to use. This is a big step ahead in removing all paper documentation that is using a lot of space and storage, especially in big companies that deal with a lot of important data. This project will leave finding certain document in a big pile of paper registers in the past. In summary, this application will extract, store and save your valuable data that you can later access with ease when you need it. It will also be able to filter through dates, prices in different currencies and product names displayed on document. You will get a stable web application that can be used over and over again without any problems, bugs and crashes as well.
##Problem solving## ###Functions this project will have###
- Filter through range of dates
- Categorization of documents(expenses, income)
- Cloud storing of documents
- Easy way of finding desired documents
- Removing duplicated files
###What we will get###
- Different languages in documents
- Different currencies
- Dates on the receipts
- Approximately 5GB of data yearly
- .jpeg or .pdf files uploads
- Price labeled is very important
- Products names
##What we need##
-
###Desktop app###
- Only for PCs
- AWS
- Docker environment
- MySQL on AWS
-
###Login form/Authentication###
- Google account
- User privilege - Admin-can access all data - User-can acces only his data
-
###Database###
- Users
- Data
- MySQL
-
###Detection###
- Language detection
- File type detection
- Apache Tika
-
###Search engine###
- Filtering through dates
- Elasticsearch
-
###Upload function###
- Different file types
- What to do with unsupported files
-
Easy access for technical support
-
Intuitive and accessible GUI
##Deliverables##
| Deliverables | About | Expected delivery |
|---|---|---|
| Working Docker Environment | Environment with all services we need | 14.05.2021 |
| AWS RDS database for users | Users/emails are saved in database | 14.05.2021 |
| Google Authenticator/Login form | User can login/sign up with Google account | 14.05.2021 |
| Project Documentation | Overview/summary how everything will work | 14.05.2021 |
| File uploads | .jpeg/.pdf files that we are working on | 21.05.2021 |
| User privileges | Admin/user/database info | 21.05.2021 |
| Cloud storage | Uploaded files storage | 28.05.2021 |
| Filter through dates/Search engine | Way of filtering/searching | 28.05.2021 |
| Apache Tika supported | Language/currency detection | 04.06.2021 |
| Auto-sorting | For expenses/income | 04.06.2021 |
| Final prototype | Final adjusments | 11.06.2021 |
| Hosting on server | Final product | 18.06.2021 |
-
###Creative brief###
- Desktop app
- Cloud storage
- Way of filtering through documents
- Document categorization
- Different languages and currencies supported
- User privilege
- Upload function(.jpeg or .pdf)
-
###Wireframes###
- How the content will be grouped together:
- Data access through cloud storage
- Cloud storage connected with Google account
- How the information will be structured:
- Database MySQL on AWS
- File uploads that will be stored on cloud
- Information based on different users
- A description of how the user will interact with the interface:
- Intuitive GUI
- Authentication
- Uploads
- Exports
- Saved data
- How the information will be structured:
- How the content will be grouped together:
- Data access through cloud storage
- Cloud storage connected with Google account
-
###Mockups###
- Color:
- Fonts:
- Images:
- UI
- Accurately structure the information
- Demonstrate basic functionality
- Visual overview
======= ##What we need##
-
###Desktop app###
- Only for PCs
- AWS
- Docker environment
- MySQL on AWS
-
###Login form/Authentication###
- Google account
- User privilege
- Admin-can access all data
- User-can acces only his data
-
###Database###
- Users
- Data
- MySQL
-
###Detection###
- Language detection
- File type detection
- Apache Tika
-
###Search engine###
- Filtering through dates
- Elasticsearch
-
###Upload function###
- Different file types
- What to do with unsupported files
-
Easy access for technical support
-
Intuitive and accessible GUI
##Deliverables##
-
###Creative brief###
- Desktop app
- Cloud storage
- Way of filtering through documents
- Document categorization
- Different languages and currencies supported
- User privilege
- Upload function(.jpeg or .pdf)
-
###Wireframes###
- How the content will be grouped together:
- Data acces through cloud storage
- Cloud storage connected with Google account
- How the information will be structured:
- Database MySQL on AWS
- File uploads that will be stored on cloud
- Information based on different users
- A description of how the user will interact with the interface:
- Intuitive GUI
- Authentication
- Uploads
- Exports
- Saved data
- How the content will be grouped together:
-
###Mockups###
- Color:
- Fonts:
- Images:
- UI
- Accurately structure the information
- Demonstrate basic functionality
- Visual overview
-
###Final prototype###
#Risk assessments#
- Slow client feedback - LOW
- Ignorance of technologies - LOW
- Default configuration - HIGH
- Session management - HIGH
- Unauthorized access of someone else's data and storage - MID
- Unsupported files - LOW
- Data loss - HIGH
- Application downtime(users unable to communicate with application) - MID
- Legal consequences(data loss) - HIGH
- Interception of data on public networks - HIGH
#Progress reporting#
- Client
- End of the week
- When needed to discuss project related arrangements
- After a stage/milestone is completed
- Video calls
- Meetings
- Messaging
- Working team
- Weekly video calls
- Messaging throughout the week
- Based on doubts about the project
- Daily if needed
======= #Risk assessment#
- Slow client feedback
- Ignorance of technologies
- Access of someone else's data and storage
- Unsupported files
- Deleting important files/documents
- Backup is a must
- Lose of funds/time if not successful
#Progress reporting#
- Client
- End of the week
- When needed to discuss project related arrangements
- After a stage/milestone is completed
- Video calls
- Meetings
- Messaging
- Working team
- Weekly video calls
- Messaging throughout the week
- Based on doubts about the project
- Daily if needed
#Expected delivery#
- End of June 2021
##Stakeholders##
-
Frontend: Mateo Šindija, Darjan Utmar
-
Backend: Nina Šebelja, Fran Grenko
-
System engineer: Daniel Zenzerović
-
Project manager: Darjan Utmar
HEXIS d.o.o. 5/6/2021