[Base] Ready-to-use solutions to manage membership + inventory?

users
#1

Hello

Someone I know heads a non-profit organization, and needs a small database
to manage membership and inventory (stock).

Before building new databases, are there ready-to-use solutions?

Thank you.

#2

Hello

Someone I know heads a non-profit organization, and needs a small database
to manage membership and inventory (stock).

Before building new databases, are there ready-to-use solutions?

Thank you.

--
View this message in context: http://nabble.documentfoundation.org/Base-Ready-to-use-solutions-to-manage-membership-inventory-tp4148774.html
Sent from the Users mailing list archive at Nabble.com.

Hi,

https://forum.openoffice.org/en/forum/search.php?keywords=membership+database&terms=all&author=&sc=1&sf=all&sr=posts&sk=t&sd=d&st=0&ch=300&t=0&submit=Search

Greetings,
A.S.

#3

By Membership, do you mean staff or clients?

Inventory?
What the organization owns (computers, chairs, etc)?
What it gives away (clothes, food, money?
What it sells (like a charity store)?

#4

Also, what OS are you using? Windows, Apple, Linux, Android, iWhatever?

#5

Thanks.

It's a DIY, non-profit bicycle organization.

Stock = parts they buy and must keep track of.

Membership = people must subscribe to a one-year membership to have access
to the location and work on their bikes.

Windows.

#6

Gilles wrote

Thanks.

It's a DIY, non-profit bicycle organization.

Stock = parts they buy and must keep track of.

Membership = people must subscribe to a one-year membership to have access
to the location and work on their bikes.

Windows.

This will easily amount to 20 interrelated tables (10 at least) depending on
many things we don't know.

#7

Which is why I asked about templates so that person can just download,
install, and be on his way.

http://templates.libreoffice.org/template-center

#8

No, there are no Base templates. Database design is development work. There
are too many different real world items to administrate in a database. Any
"template" would be a database but not a Base document. Base is not a
database.

#9

Database templates will almost always have to be modified by the user,
for their specific requirements. Consequently, there is very little
impulse to create and upload generic database templates.

jonathon

#10

But... in Base there are several ready examples of tables and fields when
you go creating a new table via wizard.

Out of LibreOffice, instead, I could suggest CiviCRM.

Google it and give it a try, if you deem it suitable for their
requirements.

#11

Thanks, but the user wants a desktop application, so a web-based CRM won't do
(and is overkill).

The search goes on.

#12

Ok, I didn't know that. Even if you could still install it in his LAN or on
the very same machine he (or she) uses :slight_smile:

Good luck!

#13

Hi,

You could probably adapt the mediatheque database that Robert Grosskopf
provides with the Base Handbook - it has inventory management for media,
like one would have for a library, with users (members), reminders for
unreturned media, etc.

As far as I know, it is currently only in German, but he announced the
other day on the documentation list that he had started to translate it
into English.

Alex

#14

Thanks everyone.

I found an application based on OpenERP that does the job.

http://wiklou.org/index.php/Catégorie:Burette