Badcaps Forums

Badcaps Forums (https://www.badcaps.net/forum/index.php)
-   General Computer & Tech Discussion (https://www.badcaps.net/forum/forumdisplay.php?f=16)
-   -   Customer Database Software (https://www.badcaps.net/forum/showthread.php?t=95168)

Ritchie_Uk 04-22-2021 06:48 PM

Customer Database Software
 
Hi there

Can anybody please recommend any software on Linux or Windows that can store customer details, and with that included will be product info of repaired fault?

So for example

Customer info
Faults
Components used

You get the idea.
It needs to be searchable also?

Free would be great, but paid for would be considered.
A tried and tested suggestion, not one you have heard about.

Thanks

Uranium-235 04-22-2021 07:01 PM

Re: Customer Database Software
 
I think there are a few web based ones. But actual windows programs cost, and cost quite a bit

Ritchie_Uk 04-22-2021 07:06 PM

Re: Customer Database Software
 
Hi Uraniam-235

I don’t really want Web based, unless it can be installed on a Local server but don’t mind paying.

I used to use a Database back in 98, but totally forgot it’s name.

Do you use anything?

Topcat 04-22-2021 07:07 PM

Re: Customer Database Software
 
I've used this one for ages...web based....but effective. Yes, it can be installed locally. I haven't seen an effective/efficient windows based repair tracker, ever....

http://pcrepairtracker.com/page/

Ritchie_Uk 04-22-2021 07:20 PM

Re: Customer Database Software
 
Thanks Topcat

Does this software need programming skills, as I am not a programmer or a database Engineer.

Do you run Linux or Windows?

Thanks

Topcat 04-22-2021 08:19 PM

Re: Customer Database Software
 
Quote:

Originally Posted by Ritchie_Uk (Post 1040920)
Thanks Topcat

Does this software need programming skills, as I am not a programmer or a database Engineer.

Do you run Linux or Windows?

Thanks

No, it's pretty cookie cutter....but it's just PHP, easy to modify if you want. It likes Linux.....but if you're crafty enough, will run on IIS.....but it's a PITA and some things don't work.

When you buy it, they send you the source files....install took all of 10 minutes.

Ritchie_Uk 04-22-2021 08:35 PM

Re: Customer Database Software
 
Thankyou Topcat

Whats PITA?

Topcat 04-22-2021 08:39 PM

Re: Customer Database Software
 
Quote:

Originally Posted by Ritchie_Uk (Post 1040929)
Whats PITA?

Pain In The Arse

Ritchie_Uk 04-23-2021 02:45 AM

Re: Customer Database Software
 
Ohh :d

stj 04-23-2021 05:13 AM

Re: Customer Database Software
 
there is one used by arcade repair techs that sounds right for you.
https://github.com/rtoumazet/agar

Ritchie_Uk 04-23-2021 04:01 PM

Re: Customer Database Software
 
Hi stj

Is it software that can be used to store customer records and info?
Thanks, let me check it out

stj 04-23-2021 10:05 PM

Re: Customer Database Software
 
it stores equpment and repair info,
but there is a field for the source you could use for a customer name / number
it's open-source so you could add a field or 2 i imagine.

Ritchie_Uk 04-27-2021 06:38 PM

Re: Customer Database Software
 
Hi sto - Sorry for the delayed response

Thankyou ��

televizora 05-03-2021 02:18 AM

Re: Customer Database Software
 
Libre Office Base - Free and you can make it do what you require.
Microsoft Access - Paid product, not that it cant be found the other way.
Then...C# and Windows Forms with SQL database driver, preferably MySQL.
Reason - MS SQL Express Edition is limited to 10GB of storage. Not that this wont be enough for you at least for several years.
There are quite a few web systems as well. Like OTRS ticket system. I know one Bulgarian that wrote one on delphi too. But for car workshops. Its free

stj 05-03-2021 02:33 AM

Re: Customer Database Software
 
SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)

diif 05-03-2021 03:59 AM

Re: Customer Database Software
 
Quote:

Originally Posted by stj (Post 1043439)
SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)

MariaqDB is a fork of MySQL, which are both relational databases.
SQL is a language.

Ritchie_Uk 05-03-2021 05:28 AM

Re: Customer Database Software
 
Quote:

Originally Posted by televizora (Post 1043434)
Libre Office Base - Free and you can make it do what you require.
Microsoft Access - Paid product, not that it cant be found the other way.
Then...C# and Windows Forms with SQL database driver, preferably MySQL.
Reason - MS SQL Express Edition is limited to 10GB of storage. Not that this wont be enough for you at least for several years.
There are quite a few web systems as well. Like OTRS ticket system. I know one Bulgarian that wrote one on delphi too. But for car workshops. Its free

Hi Televizora - Thankyou for the information.

I didnít realise Libre could be used, I will definately look into Libre.

Have you heard of Spiceworks?
Would that be any good for the job?


Thankyou

Ritchie_Uk 05-03-2021 05:28 AM

Re: Customer Database Software
 
Quote:

Originally Posted by stj (Post 1043439)
SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)

Thanks stj

Ritchie_Uk 05-03-2021 05:29 AM

Re: Customer Database Software
 
Quote:

Originally Posted by diif (Post 1043449)
MariaqDB is a fork of MySQL, which are both relational databases.
SQL is a language.


Thatís beyond my knowledge

Thanks

diif 05-03-2021 05:50 AM

Re: Customer Database Software
 
Quote:

Originally Posted by Ritchie_Uk (Post 1043461)
Thatís beyond my knowledge

Thanks

I was correcting stj, what he wrote was wrong.


All times are GMT -6. The time now is 10:40 AM.

Powered by vBulletin ®
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.