Example database

phasel · General User Joined: 15 Jun 2008 Posts: 13

Hello,

Last summer I made a database to be used in my company. It is for a sales department in a company that buys and sells equipment. It is useful in keeping track of the opportunities, and helps making quotations.

It is based on mysql, and I use base to make the forms, and macros.

If you need something similar, take a look at it, as it has quite some features. With a little tuning, it can fit many similar departments.

Inside the zip, you have a README file that will explain how it works and how to install. It is fairly simple, and you can have it up and running in less than 30 minutes.

I have placed it in box.net:

http://www.box.net/shared/fpx2kmqyj7

Thanks to all OpenOffice developpers, and to the people that has shared their knowledge in the forum. I would have never done it without those first steps.

Tested both for linux and Windows (v. 2.3, 2.4 and 3.0).

I hope that it will be useful for someone.

Best regards,

Rodolfo del Moral

phasel · General User Joined: 15 Jun 2008 Posts: 13

Hello, the database has some downloads.
Any feedback?

Regards,

Rodolfo del Moral

phasel · General User Joined: 15 Jun 2008 Posts: 13

87 downloads, and not a single feedback.
I assume that it works without any trouble Smile

Regards,

Rodolfo del Moral

RPG · Posted: Fri Sep 11, 2009 6:28 am Post subject:

Hello

I cannot open it

Romke

phasel · General User Joined: 15 Jun 2008 Posts: 13

Hello,

What exactly can't you open?
The zip file, or the database file?

Regards,

Rodolfo del Moral

RPG · Posted: Mon Sep 14, 2009 12:40 pm Post subject:

Hello

I did not remember exact what it was. But I have looked again.
It is based on MySQL, I don't have that.
When I try to look to the forms It asked a password.
So for me it is not important but I think then most people think like me, next thing.
This reaction is only you asked for it.
I think when you give an example then make it in a way that more people can use it. Special on this site more people who need an example use HSQLDB and not MySQL

Romke

phasel · General User Joined: 15 Jun 2008 Posts: 13

Dear Romke,

Thanks for the comment. Yes, it is based on mysql, and in the readme explains where to find information on installation and connection (really easy on linux, but not too hard on windows anyway).
With respect to the password for the forms, it is on the macro file on top, 1234 if I remember correctly. As it is connected to mysql it asks for the password of the mysql user (in version 2.X you can actually view the forms with a cancel, but not on 3.X).

The fact of using mysql is that it is far better to use it simultaneously by several users. In my case, we were going to be 5 people using it almost full time, and the HSQLDB just did not work. It has quite a few advantages including the fact that you can make frontends in different ways (some people can connect with openoffice, but some others can connect with a php form from the web to check simple things...). It is more robust and flexible.

Anyway, thanks for the comments.

Best regards