Another Update

I forgot to mention this in the last post, but I've decided to make a change to my "database" system. It has up to been now done in MS Excel, which is a spreadsheet. While it is allowed within the marking bounds of my project, I have been advised to change it in for a proper database software/ system such as SQL or Access.

Once I have a SQL viewer/ reader installed I will be re-working parts of my program to use a SQlite database rather than a spreadsheet.

User Database

As I have not yet finished a significant enough part of the programming in python for the main program I will (for now) explain a little about the Users database, run using an ms. excel spreadsheet.

Python is able to manipulate cells in the spreadsheet file by using an external module called 'openpyxl'.  Python Library Page

As I am having users and admins, I am using two different sheets in the same file. Both record a name, surname, username, last login and email. The main difference between the two is that the Users sheet also contains a file directory detailing where their files are stored. As the program progresses, they will be given different permissions.

Here are a few images to illustrate the structure.
The subroutine I have created to add a regular user (so-far) looks like this:

 ---

 ---

---

I will make downloads of all the files available once I have completed the project.