Customer Database Software

**Ritchie_Uk** · 04-22-2021, 06:48 PM

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

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

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

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

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

Quote:

Originally Posted by Ritchie_Uk

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

Thankyou Topcat

Whats PITA?

**Topcat** · 04-22-2021, 08:39 PM

Quote:

Originally Posted by Ritchie_Uk

Whats PITA?

Pain In The Arse

**Ritchie_Uk** · 04-23-2021, 02:45 AM

**stj** · 04-23-2021, 05:13 AM

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

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

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

Hi sto - Sorry for the delayed response

Thankyou ��

**televizora** · 05-03-2021, 02:18 AM

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

SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)

**diif** · 05-03-2021, 03:59 AM

Quote:

Originally Posted by stj

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

Quote:

Originally Posted by televizora

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

Quote:

Originally Posted by stj

SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)

Thanks stj

**Ritchie_Uk** · 05-03-2021, 05:29 AM

Quote:

Originally Posted by diif

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

Quote:

Originally Posted by Ritchie_Uk

That’s beyond my knowledge

Thanks

I was correcting stj, what he wrote was wrong.

04-22-2021, 06:48 PM	#1
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	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

04-22-2021, 07:01 PM	#2
Uranium-235 Comrade Glimmer Join Date: Aug 2007 City & State: tehas My Country: US Line Voltage: 120VAC 60Hz I'm a: Professional Tech Posts: 4,816	Re: Customer Database Software I think there are a few web based ones. But actual windows programs cost, and cost quite a bit __________________ Cap Datasheet Depot: http://www.paullinebarger.net/DS/ ^If you have datasheets not listed PM me

04-22-2021, 07:06 PM	#3
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	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?

04-22-2021, 07:07 PM	#4
Topcat The Boss Stooge Join Date: Oct 2003 City & State: Salem, MO My Country: United States Line Voltage: 240V @ 60Hz I'm a: Professional Tech Posts: 14,993	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/ __________________ <--- Badcaps.net Founder & Owner Badcaps.net Services: Premade Capacitor Kits Badcaps.net Capacitor Master List Motherboard Repair Services If you've come here in search of replacement capacitors or repair services, please use the links above. ---------------------------------------------- Badcaps.net Forum Members Folding Team http://folding.stanford.edu/ Team : 49813 Join in!! Team Stats

04-22-2021, 07:20 PM	#5
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	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

04-22-2021, 08:35 PM	#7
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	Re: Customer Database Software Thankyou Topcat Whats PITA?

04-23-2021, 02:45 AM	#9
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	Re: Customer Database Software Ohh

04-23-2021, 05:13 AM	#10
stj Great Sage 齊天大聖 Join Date: Dec 2009 City & State: Europe My Country: some shithole run by Israeli agents I'm a: Professional Tech Posts: 26,409	Re: Customer Database Software there is one used by arcade repair techs that sounds right for you. https://github.com/rtoumazet/agar

04-23-2021, 04:01 PM	#11
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	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

04-23-2021, 10:05 PM	#12
stj Great Sage 齊天大聖 Join Date: Dec 2009 City & State: Europe My Country: some shithole run by Israeli agents I'm a: Professional Tech Posts: 26,409	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.

04-27-2021, 06:38 PM	#13
Ritchie_Uk Prawnography Join Date: Mar 2021 City & State: London My Country: Uk Line Voltage: 240VAC 50Hz I'm a: Knowledge Seeker Posts: 107	Re: Customer Database Software Hi sto - Sorry for the delayed response Thankyou ��

05-03-2021, 02:18 AM	#14
televizora ghettomodmaster Join Date: Nov 2016 City & State: Bulgaria My Country: Bulgaria Line Voltage: 230VAC 50Hz I'm a: Student Tech Posts: 937	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 __________________ Useful conversions. I don't "speak" imperial. Please use metric, if you want to address me. 1km=1000m=100000cm, 1inch=2.54cm, 1mile=1609.344meters, 1ft=30.48cm 1gal(US)=3.785liters, 1lb=453grams, 1oz=28.34grams Last edited by televizora; 05-03-2021 at 02:23 AM..

05-03-2021, 02:33 AM	#15
stj Great Sage 齊天大聖 Join Date: Dec 2009 City & State: Europe My Country: some shithole run by Israeli agents I'm a: Professional Tech Posts: 26,409	Re: Customer Database Software SQL is obsolete, the author superceded it with Maria DB. (fully backward compatable)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode