Badcaps.net Forum
Go Back   Badcaps Forums > General Topics > General Computer & Tech Discussion
Register FAQ Calendar Search Today's Posts Mark Forums Read

 
Thread Tools Display Modes
Old 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: 135
Lightbulb 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
Ritchie_Uk is offline   Reply With Quote
Old 04-22-2021, 07:01 PM   #2
Uranium-235
Comrade Glimmer
 
Uranium-235's Avatar
 
Join Date: Aug 2007
City & State: tehas
My Country: US
Line Voltage: 120VAC 60Hz
I'm a: Professional Tech
Posts: 4,829
Default 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
Uranium-235 is offline   Reply With Quote
Old 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: 135
Default 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?
Ritchie_Uk is offline   Reply With Quote
Old 04-22-2021, 07:07 PM   #4
Topcat
The Boss Stooge
 
Topcat's Avatar
 
Join Date: Oct 2003
City & State: Salem, MO
My Country: United States
Line Voltage: 240V @ 60Hz
I'm a: Professional Tech
Posts: 15,035
Default 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
Topcat is online now   Reply With Quote
Old 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: 135
Default 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
Ritchie_Uk is offline   Reply With Quote
Old 04-22-2021, 08:19 PM   #6
Topcat
The Boss Stooge
 
Topcat's Avatar
 
Join Date: Oct 2003
City & State: Salem, MO
My Country: United States
Line Voltage: 240V @ 60Hz
I'm a: Professional Tech
Posts: 15,035
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
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.
Topcat is online now   Reply With Quote
Old 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: 135
Default Re: Customer Database Software

Thankyou Topcat

Whats PITA?
Ritchie_Uk is offline   Reply With Quote
Old 04-22-2021, 08:39 PM   #8
Topcat
The Boss Stooge
 
Topcat's Avatar
 
Join Date: Oct 2003
City & State: Salem, MO
My Country: United States
Line Voltage: 240V @ 60Hz
I'm a: Professional Tech
Posts: 15,035
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Whats PITA?
Pain In The Arse
Topcat is online now   Reply With Quote
Old 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: 135
Default Re: Customer Database Software

Ohh
Ritchie_Uk is offline   Reply With Quote
Old 04-23-2021, 05:13 AM   #10
stj
Great Sage 齊天大聖
 
stj's Avatar
 
Join Date: Dec 2009
City & State: Europe
My Country: some shithole run by Israeli agents
I'm a: Professional Tech
Posts: 26,675
Default Re: Customer Database Software

there is one used by arcade repair techs that sounds right for you.
https://github.com/rtoumazet/agar
stj is offline   Reply With Quote
Old 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: 135
Default 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
Ritchie_Uk is offline   Reply With Quote
Old 04-23-2021, 10:05 PM   #12
stj
Great Sage 齊天大聖
 
stj's Avatar
 
Join Date: Dec 2009
City & State: Europe
My Country: some shithole run by Israeli agents
I'm a: Professional Tech
Posts: 26,675
Default 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.
stj is offline   Reply With Quote
Old 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: 135
Default Re: Customer Database Software

Hi sto - Sorry for the delayed response

Thankyou ��
Ritchie_Uk is offline   Reply With Quote
Old 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: 940
Default 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..
televizora is offline   Reply With Quote
Old 05-03-2021, 02:33 AM   #15
stj
Great Sage 齊天大聖
 
stj's Avatar
 
Join Date: Dec 2009
City & State: Europe
My Country: some shithole run by Israeli agents
I'm a: Professional Tech
Posts: 26,675
Default Re: Customer Database Software

SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)
stj is offline   Reply With Quote
Old 05-03-2021, 03:59 AM   #16
diif
Badcaps Veteran
 
Join Date: Feb 2014
City & State: Midlands
My Country: England
I'm a: Professional Tech
Posts: 6,034
Default Re: Customer Database Software

Quote:
Originally Posted by stj View Post
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.
diif is online now   Reply With Quote
Old 05-03-2021, 05:28 AM   #17
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 135
Default Re: Customer Database Software

Quote:
Originally Posted by televizora View Post
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 is offline   Reply With Quote
Old 05-03-2021, 05:28 AM   #18
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 135
Default Re: Customer Database Software

Quote:
Originally Posted by stj View Post
SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)
Thanks stj
Ritchie_Uk is offline   Reply With Quote
Old 05-03-2021, 05:29 AM   #19
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 135
Default Re: Customer Database Software

Quote:
Originally Posted by diif View Post
MariaqDB is a fork of MySQL, which are both relational databases.
SQL is a language.

Thatís beyond my knowledge

Thanks
Ritchie_Uk is offline   Reply With Quote
Old 05-03-2021, 05:50 AM   #20
diif
Badcaps Veteran
 
Join Date: Feb 2014
City & State: Midlands
My Country: England
I'm a: Professional Tech
Posts: 6,034
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Thatís beyond my knowledge

Thanks
I was correcting stj, what he wrote was wrong.
diif is online now   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Badcaps.net Technical Forums © 2003 - 2022
Powered by vBulletin ®
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
All times are GMT -6. The time now is 10:25 AM.
Did you find this forum helpful?