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 05-03-2021, 06:21 AM   #21
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Hi Televizora - Thankyou for the information.
I didn’t realise Libre could be used, I will definately look into Libre.
Libre office Base is the open source analogue of Microsoft Access. Essentially self contained database+forms and macros. The simplest way to create viable db and input info in it. More complicated require already ready products or some programming skills.
Quote:
Originally Posted by stj View Post
SQL is obsolete, the author superceded it with Maria DB.
(fully backward compatable)
SQL is a language which you use communitate with the DB. MS SQL is paid, except the free 10gb limited version. MySQL is still alive and kicking.
SQL - structured query language.
__________________
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 06:24 AM..
televizora is offline   Reply With Quote
Old 05-07-2021, 08:03 PM   #22
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Ahh Ok
Ritchie_Uk is offline   Reply With Quote
Old 05-08-2021, 09:59 PM   #23
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Televizora do you use any database successfully?
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 04:07 AM   #24
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Televizora do you use any database successfully?
I have created some databases as a test and intend to use either C# or Microsoft Access if I become too lazy, then jam a barcode scanner into the computer and use it keep track of certain items. MS Access can help you create even monthly reports using the built in functions. It is ideal, if you want something small and used only on a few computers and you don't intend to run corporations using MS Access databases.
televizora is offline   Reply With Quote
Old 05-09-2021, 04:12 AM   #25
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Hi Televizora - I would just like a configurable piece of software, that can also be fully searchable.
I would also like to be able to securely store the data files inline, so when I site, I can check stock levels.


Have you heard of Spiceworks?
Would that be any good, as I know it’s advertised as 100% Free.

Thankyou again ��
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 04:30 AM   #26
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Hi Televizora - I would just like a configurable piece of software, that can also be fully searchable.
So, in fact your initial description is incorrect and you want fully featured CRM.
If you explain correctly what exactly you need, perhaps we can be of more help.
Never used Spiceworks, but it is not free software.
There is a huge difference between "I want to store my client details" and "I want a storage house software to keep track of everything"
First is simple database, second requires realtime and on the fly calculations and keeping track of all changes.

Last edited by televizora; 05-09-2021 at 04:40 AM..
televizora is offline   Reply With Quote
Old 05-09-2021, 04:50 AM   #27
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Hey Televizora

In 2021 I need to be more organised so..
I would like to

1. Store customer details
2. Repair History ( Searchable )
3. Be able to export into different formats, ideally excel
4. Supplier database
5. Procurement ( Stock search )
6. Linux, Windows based
7. That’s just a basic brainstorm

I’m tired of having post it’s everywhere, as now work and stock is coming in, I need to be organised.
I also have a Guy working for me, so maybe different levels of Administration.
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 05:14 AM   #28
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Hey Televizora I’m tired of having post it’s everywhere, as now work and stock is coming in, I need to be organised.
I also have a Guy working for me, so maybe different levels of Administration.
For this, I am afraid, you will need to pay. I doubt that there are any ready free solutions that cover these criteria. Client details, repair history, excel export fine, but storage availability and etc will require logic and algorithms. As well as administration rights. And for this you will need to be way more specific about your enterprise, kind of work, kind of products, kind of components and stock, users required, rights and the current work culture and algorithms.
And entering every single part, component and screw into the system is a tedious task. If you really want to do this and every single small detail to be accounted for, it will require a person that specifically deals with this stuff.
This is accounting and it's nightmare. JIT is nightmare too. And usually storage and clients/repairs are too separate programs, which complement one another. The storage guy deals with storage, the technicians deal with repairs and then the accountant deals with all this....nightmare.
Not to mention that storage and etc software, especially if you want to create invoices, usually must be a software approved by your tax agency/ministry. And revisions by revisers from these agencies....your software must comply with their criteria and must be certified. If you want to go that way.
Otherwise, you can have your clients, repairs and etc, but again you will need to deal with paper, when it comes to accounting.
And we are talking about significant price of the software and subscription, where you pay every month or on yearly basis for support.
So, brainstorm is just a bunch of ideas. Get your priorities straight and make up your mind. What do you want, how you want it and what is required exactly and literally.

Last edited by televizora; 05-09-2021 at 05:28 AM..
televizora is offline   Reply With Quote
Old 05-09-2021, 07:44 AM   #29
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Hey Televizora

Thankyou for helping me focus on what I need.
I don’t mind paying, as money isn’t the issue at the moment.

If you need anything, and I can help, please feel free to message me.
If I can help I will try.

Be Safe
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 08:02 AM   #30
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Ritchie_Uk View Post
Hey Televizora
Thankyou for helping me focus on what I need.
I, specifically, don't usually write software, but sometimes it just happens that I do write some pieces of software or modifications.
But most programmers or IT-s are not accountants, lawyers or financial revisers.
So, think about what you need exactly and how you want it. Then message me. I might be able to recommend something.
televizora is offline   Reply With Quote
Old 05-09-2021, 11:33 AM   #31
Spider1211
Badcaps Veteran
 
Join Date: Oct 2019
City & State: Morcellement
My Country: Mauritius
Line Voltage: 230VAC, 50Hz
I'm a: Knowledge Seeker
Posts: 467
Default Re: Customer Database Software

Check this out as well: https://www.repairshopr.com/
Spider1211 is offline   Reply With Quote
Old 05-09-2021, 12:51 PM   #32
televizora
ghettomodmaster
 
Join Date: Nov 2016
City & State: Bulgaria
My Country: Bulgaria
Line Voltage: 230VAC 50Hz
I'm a: Student Tech
Posts: 913
Default Re: Customer Database Software

Quote:
Originally Posted by Spider1211 View Post
Check this out as well: https://www.repairshopr.com/
Great. 1200USD per year. Why not pay some programmer to write it instead?

Last edited by televizora; 05-09-2021 at 12:52 PM..
televizora is offline   Reply With Quote
Old 05-09-2021, 12:55 PM   #33
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: 25,389
Default Re: Customer Database Software

go look on github
stj is offline   Reply With Quote
Old 05-09-2021, 03:29 PM   #34
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Ok
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 04:38 PM   #35
sndestroy
New Member
 
Join Date: May 2021
City & State: Santiago
My Country: Chile
I'm a: Hobbyist Tech
Posts: 9
Default Re: Customer Database Software

This is the software I use. It's freeware (though not open-source) and regularly updated since 2006, but it's in Spanish only.

https://www.cpimario.com/index5.html

It might show in English on an english Windows system, but I don't know about that. Feel free to test and report back.
sndestroy is offline   Reply With Quote
Old 05-09-2021, 05:44 PM   #36
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Thanks sndestroy
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 05:47 PM   #37
Ritchie_Uk
Prawnography
 
Join Date: Mar 2021
City & State: London
My Country: Uk
Line Voltage: 240VAC 50Hz
I'm a: Knowledge Seeker
Posts: 91
Default Re: Customer Database Software

Do the instructions anywhere allow language changing?
I cant read Spanish

Thanks
Ritchie_Uk is offline   Reply With Quote
Old 05-09-2021, 08:41 PM   #38
sndestroy
New Member
 
Join Date: May 2021
City & State: Santiago
My Country: Chile
I'm a: Hobbyist Tech
Posts: 9
Default Re: Customer Database Software

Not that I know. I was just hoping the program captions appeared in English on your system. There's nothing on the website about multi-language support... perhaps you may ask the author directly.
sndestroy is offline   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 - 2021
Powered by vBulletin ®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
All times are GMT -6. The time now is 06:39 AM.
Did you find this forum helpful?