Is there any way my clients can see status if their projects

Question

0.00/5 (No votes)

See more:

Hi We have a startup of about 15 people where we design graphical projects for our clients. we maintain our data using Microsoft excel right now where we can see statues of all running projects. we also use Microsoft teams to maintain our daily works and communication within the team. Is there any way i can do so that our clients can also see the status of their projects.

For example. Client X gave us 4 projects named in our database as AB1, AB2, AB3 and AB4. I want that if i can send a link to my client where he can see all his projects and their status like
AB1-currently designing
AB2-In corrections
AB3-Awating for revert
AB4-completed

What I have tried:

I haven't tried anything right now on this project and open to accept all the ideas around that

Posted 21-Sep-21 6:09am

aakash sharma Sep2021

Updated 21-Sep-21 6:49am

Add a Solution

Comments

PIEBALDconsult 21-Sep-21 12:15pm

First, use a proper database.
Next, create a web service which controls access and exposes only those features which the user ( internal or external ) requires.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-09-21T06:49:00

It's not that simple.
As PIEBALD has said, the first thing to do it dump the spreadsheet - they are fine for tracking small teams, but once you get more than one user editing them, they become a nightmare very, very quickly. A "Proper DB" such as SQL Server or MySQL is a much better idea as they are designed for multiple users, as well as allowing "view only" access to some users (which is a good idea if the clients are external to the company!)

What you can do is expose the DB directly to the internet, but even if you implement reasonable security it's a risk, and one that probably isn't worth taking.

The way I'd do it is to set up a website with a "client area" that requires login and allows them to view the status of their projects (and their projects only - or you are risking both company confidentiality, NDA problems, and quite possibly GDPR breaches as well). The website backend code accesses your DB and server up project status and so forth. You could also include bug reporting / tracking and so forth as a "nice extra" for clients and it shouldn't take too long to add to your existing website provided your web designer / developer knows what he is doing! :laugh: